I forgot to mention that I have already added: <config-property name="TransactionIsolation" type="java.lang.String">TRANSACTION_SERIALIZABLE</config-property>
in my oracle-service.xml file... Vassilis -----Original Message----- From: saroj kumar [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 4:29 PM To: [EMAIL PROTECTED] Subject: RE: [JBoss-user] SQL Exception Hi Vassilis, I think this post may be of your use: http://p2p.wrox.com/archive/enterprise_java_beans/2002-09/1.asp <snip> Oracle uses optimistic concurrency. As a consequence, even with a setting of TRANSACTION_SERIALIZABLE, Oracle does not detect serialization problems until commit time. Hence the message : java.sql.SQLException: ORA-08177: can't serialize access for this transaction Even if you use the TRANSACTION_SERIALIZABLE setting for an EJB, you may receive exceptions or rollbacks in the EJB client if contention occurs between clients for the same rows. To avoid these problems, make sure that the code in your client application catches and examines the SQL exceptions, and take you take the appropriate action to resolve the exceptions, such as restarting the transaction. </snip> -Saroj -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Mokas Vassilis ([EMAIL PROTECTED]) Sent: Monday, December 16, 2002 7:38 PM To: [EMAIL PROTECTED] Subject: [JBoss-user] SQL Exception Hi all, I am running an application (Session EJB) that adds some entries in an OracleDB through entity beans. When I execute only one client of me application, there is no problem at all. However when I execute 300 clients concurrently for the same application a message "java.sql.SQLException: can't serialize access for this transaction" appears. Any help? Thanks Vassilis ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ########################################### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. ------------------------------------------------------- This sf.net email is sponsored by: With Great Power, Comes Great Responsibility Learn to use your power at OSDN's High Performance Computing Channel http://hpc.devchannel.org/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
