Your stack trace points out a problem with fatal errors that occur in the
middle of a transaction. I think I've fixed it, could you check? You
should not get an IllegalStateException.

Also, is the underlying exception really serious enough to warrant
destroying the connection?

thanks
david jencks

On 2003.04.10 16:13 Robert DiFalco wrote:
> I take that back. There is some sort of subtle error going on with MY
> CODE, I will try to see if I can track it down but the test does seem to
> pass.
>
> R.
>
> -----Original Message-----
> From: Robert DiFalco
> Sent: Thursday, April 10, 2003 12:27 PM
> To: Firebird-Java@yahoogroups.com
> Subject: [Firebird-Java] Re: Failure on PreparedStatement
>
>
> Roman,
>
> Hmmm...I ran your TestFBBlobParams test with the JayBird from
> CVS
> (two days ago I think) and Firbired 1.0 and 1.5 beta 4, and I
> still
> get the following exception.
>
> java.lang.IllegalStateException: Can't destroy managed
> connection
> with active transaction
> at org.firebirdsql.jca.FBManagedConnection.destroy
> (FBManagedConnection.java:334)
> at
>
> org.firebirdsql.jca.FBStandAloneConnectionManager.connectionErrorOccu
> rred(FBStandAloneConnectionManager.java:84)
> at org.firebirdsql.jca.FBManagedConnection$1.notify
> (FBManagedConnection.java:1150)
> at org.firebirdsql.jca.FBManagedConnection.notify
> (FBManagedConnection.java:1123)
> at org.firebirdsql.jca.FBManagedConnection.checkFatal
> (FBManagedConnection.java:727)
> at org.firebirdsql.jca.FBManagedConnection.fetch
> (FBManagedConnection.java:809)
> at org.firebirdsql.jdbc.FBConnection.fetch
> (FBConnection.java:1116)
> at org.firebirdsql.jdbc.FBStatementFetcher.fetch
> (FBStatementFetcher.java:113)
> at org.firebirdsql.jdbc.FBStatementFetcher.<init>
> (FBStatementFetcher.java:55)
> at org.firebirdsql.jdbc.FBResultSet.<init>
> (FBResultSet.java:103)
> at org.firebirdsql.jdbc.FBStatement.getResultSet
> (FBStatement.java:550)
> at org.firebirdsql.jdbc.FBPreparedStatement.executeQuery
> (FBPreparedStatement.java:111)
> at
>
> com.tripwire.space.core.persistence.TestPersistent.testPreparedStatem
> ent(TestPersistent.java:114)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke
> (NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke
> (DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at junit.framework.TestCase.runTest(TestCase.java:154)
> at com.tripwire.util.AbstractTestCase.runTest
> (AbstractTestCase.java:193)
> at junit.framework.TestCase.runBare(TestCase.java:127)
> at com.tripwire.util.AbstractTestCase.doRunBare
> (AbstractTestCase.java:178)
> at com.tripwire.util.AbstractTestCase.runBare
> (AbstractTestCase.java:148)
> at
> junit.framework.TestResult$1.protect(TestResult.java:106)
> at junit.framework.TestResult.runProtected
> (TestResult.java:124)
> at junit.framework.TestResult.run(TestResult.java:109)
> at junit.framework.TestCase.run(TestCase.java:118)
> at junit.framework.TestSuite.runTest(TestSuite.java:208)
> at junit.framework.TestSuite.run(TestSuite.java:203)
> at junit.textui.TestRunner.doRun(TestRunner.java:116)
> at junit.textui.TestRunner.start(TestRunner.java:172)
> at junit.textui.TestRunner.main(TestRunner.java:138)
> at com.tripwire.util.Tester.main(Tester.java:80)
>
> --- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
> <rrokytskyy@a...> wrote:
> > > Where you able to reproduce this?
> >
> > No, at least not with JayBird from CVS and Firebird 1.0, build
> 794.
> > See class org.firebirdsql.jdbc.TestFBBlobParams. I would be
> very
> > grateful if you can check if it works for you.
> >
> > Best regards,
> > Roman Rokytskyy
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> <http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1705
> 006764:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei>
>
>
> <http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egrou
> pmail/S=:HM/A=1457554/rand=870665329>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD><TITLE>Message</TITLE>
> <META http-equiv=Content-Type content="text/html; charset=us-ascii">
> <META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
> <BODY>
>
>
> <DIV><SPAN class=039321220-10042003><FONT face=Arial color=#0000ff
> size=2>I take
> that back. There is some sort of subtle error going on with MY CODE, I
> will try
> to see if I can track it down but the test does seem to
> pass.</FONT></SPAN></DIV>
> <DIV><SPAN class=039321220-10042003><FONT face=Arial color=#0000ff
> size=2></FONT></SPAN> </DIV>
> <DIV><SPAN class=039321220-10042003><FONT face=Arial color=#0000ff
> size=2>R.</FONT></SPAN></DIV>
> <BLOCKQUOTE style="MARGIN-RIGHT: 0px">
> <DIV></DIV>
> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
> face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Robert
> DiFalco
> <BR><B>Sent:</B> Thursday, April 10, 2003 12:27 PM<BR><B>To:</B>
> Firebird-Java@yahoogroups.com<BR><B>Subject:</B> [Firebird-Java] Re:
> Failure
> on PreparedStatement<BR><BR></FONT></DIV><TT>Roman, <BR><BR>Hmmm...I
> ran your
> TestFBBlobParams test with the JayBird from CVS <BR>(two days ago I
> think) and
> Firbired 1.0 and 1.5 beta 4, and I still <BR>get the following
> exception.<BR><BR>java.lang.IllegalStateException: Can't destroy
> managed
> connection  <BR>with active
> transaction<BR>        at
> org.firebirdsql.jca.FBManagedConnection.destroy<BR>(FBManagedConnection.java:334)<BR>       
>
> at
> <BR>org.firebirdsql.jca.FBStandAloneConnectionManager.connectionErrorOccu<BR>rred(FBStandAloneConnectionManager.java:84)<BR>       
>
> at
> org.firebirdsql.jca.FBManagedConnection$1.notify<BR>(FBManagedConnection.java:1150)<BR>       
>
> at
> org.firebirdsql.jca.FBManagedConnection.notify<BR>(FBManagedConnection.java:1123)<BR>       
>
> at
> org.firebirdsql.jca.FBManagedConnection.checkFatal<BR>(FBManagedConnection.java:727)<BR>       
>
> at
> org.firebirdsql.jca.FBManagedConnection.fetch<BR>(FBManagedConnection.java:809)<BR>       
>
> at
> org.firebirdsql.jdbc.FBConnection.fetch<BR>(FBConnection.java:1116)<BR>       
>
> at
> org.firebirdsql.jdbc.FBStatementFetcher.fetch<BR>(FBStatementFetcher.java:113)<BR>       
>
> at
> org.firebirdsql.jdbc.FBStatementFetcher.<init><BR>(FBStatementFetcher.java:55)<BR>       
>
> at
> org.firebirdsql.jdbc.FBResultSet.<init><BR>(FBResultSet.java:103)<BR>       
>
> at
> org.firebirdsql.jdbc.FBStatement.getResultSet<BR>(FBStatement.java:550)<BR>       
>
> at
> org.firebirdsql.jdbc.FBPreparedStatement.executeQuery<BR>(FBPreparedStatement.java:111)<BR>       
>
> at
> <BR>com.tripwire.space.core.persistence.TestPersistent.testPreparedStatem<BR>ent(TestPersistent.java:114)<BR>       
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> <BR>Method)<BR>        at
> sun.reflect.NativeMethodAccessorImpl.invoke<BR>(NativeMethodAccessorImpl.java:39)<BR>       
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke<BR>(DelegatingMethodAccessorImpl.java:25)<BR>       
>
> at
> java.lang.reflect.Method.invoke(Method.java:324)<BR>       
>
> at
> junit.framework.TestCase.runTest(TestCase.java:154)<BR>       
>
> at
> com.tripwire.util.AbstractTestCase.runTest<BR>(AbstractTestCase.java:193)<BR>       
>
> at
> junit.framework.TestCase.runBare(TestCase.java:127)<BR>       
>
> at
> com.tripwire.util.AbstractTestCase.doRunBare<BR>(AbstractTestCase.java:178)<BR>       
>
> at
> com.tripwire.util.AbstractTestCase.runBare<BR>(AbstractTestCase.java:148)<BR>       
>
> at
> junit.framework.TestResult$1.protect(TestResult.java:106)<BR>       
>
> at
> junit.framework.TestResult.runProtected<BR>(TestResult.java:124)<BR>       
>
> at
> junit.framework.TestResult.run(TestResult.java:109)<BR>       
>
> at
> junit.framework.TestCase.run(TestCase.java:118)<BR>       
>
> at
> junit.framework.TestSuite.runTest(TestSuite.java:208)<BR>       
>
> at
> junit.framework.TestSuite.run(TestSuite.java:203)<BR>       
>
> at
> junit.textui.TestRunner.doRun(TestRunner.java:116)<BR>       
>
> at
> junit.textui.TestRunner.start(TestRunner.java:172)<BR>       
>
> at
> junit.textui.TestRunner.main(TestRunner.java:138)<BR>       
>
> at com.tripwire.util.Tester.main(Tester.java:80)<BR><BR>--- In
> Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
> <BR><rrokytskyy@a...>
> wrote:<BR>> > Where you able to reproduce this?<BR>> <BR>>
> No, at
> least not with JayBird from CVS and Firebird 1.0, build 794.<BR>>
> See class
> org.firebirdsql.jdbc.TestFBBlobParams. I would be very<BR>> grateful
> if you
> can check if it works for you.<BR>> <BR>> Best regards,<BR>>
> Roman
> Rokytskyy<BR><BR></TT><BR><BR><TT>To
> unsubscribe from this group, send an email
> to:<BR>Firebird-Java-unsubscribe@yahoogroups.com<BR><BR></TT><BR><BR><TT>Your
>
> use of Yahoo! Groups is subject to the <A
> href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of
> Service</A>.</TT>
> <BR></BLOCKQUOTE>
> <br>
>
> <!-- |**|begin egp html banner|**| -->
>
> <table border=0 cellspacing=0 cellpadding=2>
> <tr bgcolor=#FFFFCC>
> <td align=center><font size="-1" color=#003399><b>Yahoo! Groups
> Sponsor</b></font></td>
> </tr>
> <tr bgcolor=#FFFFFF>
> <td align=center width=470><table border=0 cellpadding=0 cellspacing=0>
> <tr> <td align=center><font face=arial size=-2>ADVERTISEMENT</font><br><a
> href="http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1705006764:HM/A=1457554/R=0/*http://ipunda.com/clk/beibunmaisuiyuiwabei"><img
> src="http://us.a1.yimg.com/us.yimg.com/a/qu/quinstreet/uofpoff_300_250_0001.gif"
> alt="" width="300" height="250" border="0"></a></td></tr></table></td>
> </tr>
> <tr><td><img alt="" width=1 height=1
> src="http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egroupmail/S=:HM/A=1457554/rand=295781456"></td></tr>
> </table>
>
> <!-- |**|end egp html banner|**| -->
>
>
> <br>
> <tt>
> To unsubscribe from this group, send an email to:<BR>
> Firebird-Java-unsubscribe@yahoogroups.com<BR>
> <BR>
> </tt>
> <br>
>
> <br>
> <tt>Your use of Yahoo! Groups is subject to the <a
> href="http://docs.yahoo.com/info/terms/">Yahoo! Terms of
> Service</a>.</tt>
> </br>
>
> </BODY></HTML>
>