users@glassfish.java.net

RE: Strange Server behaviour

From: Wim Verreycken <wim_at_pizzastop.be>
Date: Tue, 26 Aug 2008 16:28:33 +0200

Don't know if I can help here.
At first I thought when reading this :
Isn't that the whole idea behind transactions??

Then I realized you app probably keeps waiting and waiting even after
sqlplus commits.

No sure if it helps, but you might wanna take a look at :

http://java.sun.com/j2ee/1.4/docs/api/javax/transaction/UserTransaction.html

Wim
-----Original Message-----
From: glassfish_at_javadesktop.org [mailto:glassfish_at_javadesktop.org]
Sent: dinsdag 26 augustus 2008 13:31
To: users_at_glassfish.dev.java.net
Subject: Strange Server behaviour

Hi,
The behavious is related to the DB transaction behaviour. Here is the setup
:

1. Oracle DB
2. Sun App. Server 8.1

There is an application running on App. Server 8.1 which is to update/insert
a record in a table. What I did right now is.

1. Using sqlplus to update a record but not commit.
2. Using the application to update the same record.

The server behaviour is :
1. It starts to wait for the sqlplus to commit I guess
2. The application keeps waiting and displays server busy blue screen
after 10 mins.


I tried to change the different timeout value(Transaction timeout, Retry
timeout, Max Wait Timeout) into shorter interval, but the server still takes
10 mins to display server blue screen.

Please suggest how to shorten the 10 mins interval.


Thanks
Benson
[Message sent by forum member 'bensonfungjava' (bensonfungjava)]

http://forums.java.net/jive/thread.jspa?messageID=295340

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
For additional commands, e-mail: users-help_at_glassfish.dev.java.net