You get several lightweight connection handles attached to the same ManagedConnection object, which is what the transaction context is attached to.
david jencks On 2003.06.14 08:40 [EMAIL PROTECTED] wrote: > OK, default oracle-ds.xml configures local transacation datasource. But > then I do not understand, how can I get different connections when > calling > SLB with Required TA from another SLB with Required TA - they are > supposed > to be executed in the same transaction context so the same connection > should be restored from Datasource in both SLBs. Or am I wrong ? > > Thank you. > Mark. > > > > > > [EMAIL PROTECTED] > Sent by: [EMAIL PROTECTED] > 13.06.2003 20:49 > Please respond to jboss-user > > > To: [EMAIL PROTECTED] > cc: (bcc: Marek Sedliak/BYS/SOFTIP) > Subject: Re: [JBoss-user] JBoss 3.0.3 Connection > Pooling... > > > > Hi, > excuse me plesae, but I think your connections or statements have stayed > open - we had the same problem before - Oracle, Max open cursors ... and > the problem was the forgotten open connection - good way how to figure > out > this problem is JBoss 3.2 - this version produces warning when the > connection is left open. > > Cheers > Marek > > > > > > "Dayanand Kangala Shanmugham" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 13.06.2003 19:20 > Please respond to jboss-user > > To: <[EMAIL PROTECTED]> > cc: (bcc: Marek Sedliak/BYS/SOFTIP) > Subject: [JBoss-user] JBoss 3.0.3 Connection Pooling... > > > > Hi All, > > We are developing an application using JBoss 3.0.3 and use its connection > > pooling to connect to Oracle database. We are facing an issue where > though > the statement's are closed (and connection closed, to return to the > pool), > the cursors are still not getting released from Oracle. > > After using the system for about a day, either we get a "Maximum open > cursors exceeded" problem (or) the system slows down. > > Has anyone faced similar issues before and solved it?! > > (We use CMPs, Tomcat 4.0.4, Linux 7.3 and have set the MAX CURSOR as 300 > in Oracle) > > Any info on this issue would be great. > > Regards, > Dayanand > > > > > <br><font size=2 face="sans-serif">OK, default oracle-ds.xml configures > local transacation datasource. But then I do not understand, how can I > get different connections when calling SLB with Required TA from another > SLB with Required TA - they are supposed to be executed in the same > transaction context so the same connection should be restored from > Datasource in both SLBs. Or am I wrong ?</font> > <br> > <br><font size=2 face="sans-serif">Thank you.</font> > <br><font size=2 face="sans-serif">Mark.</font> > <br> > <br> > <br> > <br> > <table width=100%> > <tr valign=top> > <td> > <td><font size=1 face="sans-serif"><b>[EMAIL PROTECTED]</b></font> > <br><font size=1 face="sans-serif">Sent by: > [EMAIL PROTECTED]</font> > <p><font size=1 face="sans-serif">13.06.2003 20:49</font> > <br><font size=1 face="sans-serif">Please respond to jboss-user</font> > <br> > <td><font size=1 face="Arial"> </font> > <br><font size=1 face="sans-serif"> To: > [EMAIL PROTECTED]</font> > <br><font size=1 face="sans-serif"> cc: > (bcc: Marek Sedliak/BYS/SOFTIP)</font> > <br><font size=1 face="sans-serif"> Subject: > Re: [JBoss-user] JBoss 3.0.3 Connection > Pooling...</font></table> > <br> > <br> > <br><font size=2 face="sans-serif"><br> > Hi,</font><font size=3 face="Times New Roman"> </font><font size=2 > face="sans-serif"><br> > excuse me plesae, but I think your connections or statements have stayed > open - we had the same problem before - Oracle, Max open cursors ... and > the problem was the forgotten open connection - good way how to figure > out this problem is JBoss 3.2 - this version produces warning when the > connection is left open.</font><font size=3 face="Times New Roman"> <br> > </font><font size=2 face="sans-serif"><br> > Cheers</font><font size=3 face="Times New Roman"> </font><font size=2 > face="sans-serif"><br> > Marek</font><font size=3 face="Times New Roman"> <br> > <br> > <br> > <br> > </font> > <table width=100%> > <tr valign=top> > <td width=1%> > <td width=56%><font size=1 face="sans-serif"><b>"Dayanand Kangala > Shanmugham" <[EMAIL PROTECTED]></b></font><font > size=3 face="Times New Roman"> </font><font size=1 face="sans-serif"><br> > Sent by: [EMAIL PROTECTED]</font><font size=3 > face="Times New Roman"> </font> > <p><font size=1 face="sans-serif">13.06.2003 19:20</font><font size=3 > face="Times New Roman"> </font><font size=1 face="sans-serif"><br> > Please respond to jboss-user</font><font size=3 face="Times New Roman"> > </font> > <td width=41%><font size=1 face="Arial"> > </font><font size=1 face="sans-serif"><br> > To: > <[EMAIL PROTECTED]></font><font size=3 > face="Times New Roman"> </font><font size=1 face="sans-serif"><br> > cc: (bcc: Marek > Sedliak/BYS/SOFTIP)</font><font size=3 face="Times New Roman"> > </font><font size=1 face="sans-serif"><br> > Subject: > [JBoss-user] JBoss 3.0.3 Connection Pooling...</font></table> > <br><font size=3 face="Times New Roman"><br> > <br> > </font><font size=2 face="Arial"><br> > Hi All,</font><font size=3 face="Times New Roman"> <br> > </font><font size=2 face="Arial"><br> > We are developing an application using JBoss 3.0.3 and use its connection > pooling to connect to Oracle database. We are facing an issue where > though the statement's are closed (and connection closed, to return to > the pool), the cursors are still not getting released from > Oracle.</font><font size=3 face="Times New Roman"> <br> > </font><font size=2 face="Arial"><br> > After using the system for about a day, either we get a "Maximum > open cursors exceeded" problem (or) the system slows > down.</font><font size=3 face="Times New Roman"> <br> > </font><font size=2 face="Arial"><br> > Has anyone faced similar issues before and solved it?!</font><font size=3 > face="Times New Roman"> <br> > </font><font size=2 face="Arial"><br> > (We use CMPs, Tomcat 4.0.4, Linux 7.3 and have set the MAX CURSOR as 300 > in Oracle)</font><font size=3 face="Times New Roman"> <br> > </font><font size=2 face="Arial"><br> > Any info on this issue would be great.</font><font size=3 face="Times New > Roman"> <br> > </font><font size=2 face="Arial"><br> > Regards,</font><font size=3 face="Times New Roman"> </font><font size=2 > face="Arial"><br> > Dayanand</font><font size=3 face="Times New Roman"> <br> > </font> > <br> > <br> ------------------------------------------------------- This SF.Net email is sponsored by: INetU Attention Web Developers & Consultants: Become An INetU Hosting Partner. Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commission! INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.php _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
