[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
Continue the last post... Because, today my transaction DON'T COMMIT THE STATEMENTS CALLS! :'( View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834528#3834528 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834528 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
But, in other application servers like JRun, i could resolve this problem... With JBoss, how can i configure my transaction pool ? So, when my application start a transaction and use, its can COMMIT THE STATEMENTS CALLS!!! HEL!! PEOPLE! View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834527#3834527 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834527 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
I have that same error when a process/user/ejb/... of a Connection of the pool puts a lock on objects (records, pages, whole tables!) in the database, and does not release this lock quickly enough. In the meanwhile, other processes/users/ejbs/... try to access these locked resources, and if they don't get it in time you will receive the error you had. I think the MS SQLServer message isn't quite correct. It is not deadlock, where 2 processes hold reqources that the other needs. It is more like a timeout. However, this situation tends to snowball, having JBoss opening new connections to the DB until the maximum pool size is reached. What I have done until now is rewrite the code (always the first step ;-) )so that the DB is less sollicited, and optimize transactions declaratively so that locks are taken on smaller objects (records rather than tables) and for shorter durations. It's an EJB application. Yours is not, so who is managing YOUR transactions? At this moment we can run 100+ concurrent (i.e. working, not just logged in) users without problems. Another thing to do is optimize your DB: create indexes etc. But start with looking at your code: if you had the same problem on other application servers then JBoss isn't the answer. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834347#3834347 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834347 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
My application doens't have EJBs. The architecture of my application is: Servlet -> Handler(S) -> Components (BO, DAO, JavaBeans-Model). And the DAO use JTA to make a transaction and access the database. when some threads finish up, some tables access are blocked. So, the other threads can't access because tha process in the database is DEADLOCK! Is not my code, because i had the same trouble in other application server... The problem is --> The transaction don't commit JBDC calls statements. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834135#3834135 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834135 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
Hi, when does the lock ocour ? on ejbFind or on the first invokation of an beans getXX / setXXX method ? Stefan View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834120#3834120 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834120 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
And... That's the exception: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 68) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834094#3834094 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834094 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
Th version of JBoss is 3.2.3 My application runs in Oracle, SQL Server, Postgresql...and all i had deadlock. In my mssql-ds.xml: jdbc/XSCXPLAN jdbc:microsoft:sqlserver://xplsvr01:1433;SelectMethod=cursor com.microsoft.jdbc.sqlserver.SQLServerDriver user1 user1 0 TRANSACTION_READ_COMMITTED 1000 View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834086#3834086 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834086 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: JBoss transaction deadlock
Which JBoss version are you using? Which database? I have had a similar situation with some databases but not others. What is in your *-ds.xml for the data source? Have you changed any of the transaction settings in your deployment descriptors? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834084#3834084 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834084 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user