Subject Re: [Firebird-Java] Re: New JDBC driver keep throwing Dynamic SQL Error exception
Author David Jencks
Post date 2002-03-20T16:58:21Z
I should have warned everyone -- the TestPoolingConnectionManager is
somewhat nondeterministic and fails occasionally. If it fails, try a few
more times and see if it succeeds. Anyone with an idea how to make it more
deterministic -- let me know.

thanks
david jencks

On 2002.03.20 09:22:33 -0500 Kenneth Foo wrote:
> Found out the problem. I was using a form of URL that worked in previous
> releases, but not in the new release.
> (I previously omitted the port number)
>
> Anyway, I ran the test, and found 1 failure with
> TestPoolingConnectionManager.
> Attached is the html report.
>
> Regards
> Kenneth
>
>
> ----- Original Message -----
> From: "David Jencks" <davidjencks@...>
> To: <Firebird-Java@yahoogroups.com>
> Sent: Wednesday, March 20, 2002 9:33 PM
> Subject: Re: [Firebird-Java] Re: New JDBC driver keep throwing Dynamic
> SQL
> Error exception
>
>
> > What happens if you run the tests? On my machine they all pass. (this
> > generates a little website with the results)
> >
> > ./build.sh clean tests-report-html
> >
> > david jencks
> >
> > On 2002.03.20 05:09:03 -0500 Kenneth Foo wrote:
> > > Hi
> > >
> > > Thank, but that didn't help.
> > > I'm still getting the same error over here!
> > >
> > > Regards
> > > Kenneth
> > >
> > > ----- Original Message -----
> > > From: "llafranc78" <luca.lafranchi@...>
> > > To: <Firebird-Java@yahoogroups.com>
> > > Sent: Wednesday, March 20, 2002 6:00 PM
> > > Subject: [Firebird-Java] Re: New JDBC driver keep throwing Dynamic
> SQL
> > > Error
> > > exception
> > >
> > >
> > > > Hi!!
> > > >
> > > > You have to remove the semicolon at the end of your select string:
> > > >
> > > > ResultSet rs = statement.executeQuery("SELECT * FROM
> > > > MESSAGES;");
> > > >
> > > > must become
> > > >
> > > > ResultSet rs = statement.executeQuery("SELECT * FROM
> > > > MESSAGES");
> > > >
> > > >
> > > > When using jdbc you must not add the semicolon at the end of any
> sql
> > > > statements!
> > > >
> > > > Ciao
> > > > Luca
> > > >
> > > >
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > Firebird-Java-unsubscribe@yahoogroups.com
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > Firebird-Java-unsubscribe@yahoogroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> > >
> > >
> >
> >
> > To unsubscribe from this group, send an email to:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> <html>
> <head>
> <META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
> <link title="Style" type="text/css" rel="stylesheet"
> href="../../../stylesheet.css">
> </head>
> <body>
> <h1>Unit Test Results</h1>
> <table width="100%">
> <tr>
> <td align="left"></td><td align="right">Designed for use with <a
> href="http://www.junit.org">JUnit</a> and <a
> href="http://jakarta.apache.org">Ant</a>.
> Generated on March 20 2002.
> </td>
> </tr>
> </table>
> <hr size="1">
> <h3>Class org.firebirdsql.jca.TestPoolingConnectionManager</h3>
> <table width="95%" cellspacing="2" cellpadding="5" border="0">
> <tr valign="top" bgcolor="#A6CAF0">
> <td width="80%"><strong>Name</strong></td><td><strong>Tests</strong></td><td><strong>Errors</strong></td><td><strong>Failures</strong></td><td
> nowrap="nowrap"><strong>Time(s)</strong></td>
> </tr>
> <tr valign="top" bgcolor="#FF0000" class="Failure">
> <td><a href="TestPoolingConnectionManager.html">TestPoolingConnectionManager</a></td><td>4</td><td>0</td><td>1</td><td>4.716</td>
> </tr>
> </table>
> <h2>Tests</h2>
> <p>
> <table width="95%" cellspacing="2" cellpadding="5" border="0">
> <tr valign="top" bgcolor="#A6CAF0">
> <td><strong>Name</strong></td><td><strong>Status</strong></td><td
> width="80%"><strong>Type</strong></td><td
> nowrap="nowrap"><strong>Time(s)</strong></td>
> </tr>
> <tr valign="top" bgcolor="#FFEBCD" class="TableRowColor">
> <td>testFillToMin</td><td>Success</td><td></td><td>0.922</td>
> </tr>
> <tr valign="top" bgcolor="#FFEBCD" class="TableRowColor">
> <td>testGetManagedConnections</td><td>Success</td><td></td><td>0.440</td>
> </tr>
> <tr valign="top" bgcolor="#FFEBCD" class="TableRowColor">
> <td>testIdleTimeout</td><td>Success</td><td></td><td>2.344</td>
> </tr>
> <tr valign="top" bgcolor="#FFEBCD" class="FailureDetail">
> <td>testShortBlocking</td><td>Failure</td><td>Wrong number of connections
> counted: 0<code>
> <p></p>junit.framework.AssertionFailedError: Wrong number of connections
> counted: 0<br> at junit.framework.Assert.fail(Assert.java:51)<br> at
> junit.framework.Assert.assertTrue(Assert.java:38)<br> at
> org.firebirdsql.jca.TestPoolingConnectionManager.testShortBlocking(TestPoolingConnectionManager.java:149)<br> at
> java.lang.reflect.Method.invoke(Native Method)<br> at
> junit.framework.TestCase.runTest(TestCase.java:166)<br> at
> junit.framework.TestCase.runBare(TestCase.java:140)<br> at
> junit.framework.TestResult$1.protect(TestResult.java:106)<br> at
> junit.framework.TestResult.runProtected(TestResult.java:124)<br> at
> junit.framework.TestResult.run(TestResult.java:109)<br> at
> junit.framework.TestCase.run(TestCase.java:131)<br> at
> junit.framework.TestSuite.runTest(TestSuite.java:173)<br> at
> junit.framework.TestSuite.run(TestSuite.java:168)<br> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:231)<br> at
> org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:409)<br>
> </code></td><td>0.390</td>
> </tr>
> </table>
> </p>
> <p></p>
> <hr size="1">
> <p></p>
> <table class="Info">
> <tr>
> <td>Java Version</td><td>1.3.1_01</td>
> </tr>
> <tr>
> <td>Java Vendor</td><td>Sun Microsystems Inc.</td>
> </tr>
> <tr>
> <td>Java VM Name</td><td>Java HotSpot(TM) Client VM</td>
> </tr>
> <tr>
> <td>Java VM Version</td><td>1.3.1_01</td>
> </tr>
> <tr>
> <td>Java VM Info</td><td>mixed mode</td>
> </tr>
> <tr>
> <td>OS Name</td><td>Windows 2000</td>
> </tr>
> <tr>
> <td>OS Version</td><td>5.0</td>
> </tr>
> <tr>
> <td>OS Arch</td><td>x86</td>
> </tr>
> </table>
> </body>
> </html>
>