Hello

The Sun JDBC Test Suite licence don't allow to use the software out of the Sun JDBC Test Suite and only allows to use the suite
in private testing without giving publicity to the results, or claiming compliance.

The test I'm using is not Sun JDBC Test but our own driver test that is part of a commercial java data editor/manager tool,
which include also Driver, SQL and performance tests. The idea is that in a very easy way, anyone can test or compare drivers or
databases about standards compliance or performance. To run the Sun suite you need to configure it for the database, deploy it on a
J2EE server and depending on the machine you own wait hours for the test to run, to run our test you only have to define driver and
database parameters in the tool and wait 2 minutes.

The bad news is that because it is a commercial product the code is closed. The good news is that the tool will be available
soon as a free beta version and we plan to give free licences to people working in Open Source Database projects.

Finally about the fixes, we don't have too much time to do that, but we can help fixing some bugs, mainly those related with
JDBC specification and that don't require deep knowledge of the driver internals.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "David Jencks" <davidjencks@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Friday, April 26, 2002 9:05 PM
Subject: Re: [Firebird-Java] Re: JDBC Bug


> Thank you for working on testing the driver with test suite. I haven't
> looked at it, and don't know the license terms. I would really like it if
> there would be some way to get whatever is needed into cvs to make it easy
> for anyone to run these tests. Do you know if this is possible or
> practical? For me, the best would be a way to run from ant, but that is
> not really critical.
>
> Any information you can give on this would be appreciated.
>
> Are you interested in helping to fix some of these bugs you are finding?
>
> Thanks!
> david jencks
>
> On 2002.04.26 14:55:46 -0400 Blas Rodriguez Somoza wrote:
> > Hello
> >
> > It is not very usual but this test is part of the Sun JDBC Test Suite.
> >
> > I'm testing the driver against the TestSuite. I know it is not the first
> > think but is a way to test the driver, and helps me to find
> > another problems that I will report as soon as I analize it.
> >
> > Ignoring the not yet implemented exceptions, there are the following bugs
> > according to the test, some of it trivial to solve.
> >
> > - Connection
> > createStatement(resultSetType,resultSetConcurrency) must return a
> > Statement with the closest possible resultSetType and
> > Concurrency, not null, or exception. To check which is the Type and
> > Concurrency returned in a ResultSet the methods
> > ResultSet.getType and getConcurrency can be used.
> > - DatabaseMetaData
> > getCatalogs must return empty ResultSet if catalogs are not
> > supported.
> > getSchemas must return empty ResultSet if schemas are not supported.
> > - ResultSetMetaData
> > getCatalogName must return empty String if catalogs are not
> > supported.
> > getSchemaName must return empty String if schemas are not supported.
> > - Statement
> > It seems that Statement.close() don't work. ExecuteQuery() must throw
> > SQLException if called after a Statement.close() for the
> > same Statement, but it executes without throwing any exception.
> > getResult must return empty resultSet if the Statement don't return a
> > ResultSet (the bug this mail is about).
> > getUpdateCount must return -1 if the last Statement was a select
> > Statement, but it returns 0.
> > SQLException.getSQLState() must return a String after a
> > Statement.executeQuery with an errorneous query throws it.
> > - PreparedStatement
> > It seems that clearParameters does not work or there is some problem
> > in executeQuery, executeQuery does not throw and exception
> > when executed after a clearParameters, and it must throw it if the
> > parameters was not set.
> >
> > This relation don't include get/set or escape tests.
> >
> > Regards
> > Blas Rodriguez Somoza.
> >
> > ----- Original Message -----
> > From: "rrokytskyy" <rrokytskyy@...>
> > To: <Firebird-Java@yahoogroups.com>
> > Sent: Friday, April 26, 2002 6:10 PM
> > Subject: [Firebird-Java] Re: JDBC Bug
> >
> >
> > > Usually people use stmt.executeUpdate(...), not stmt.execute(...),
> > > but I will check this issue.
> > >
> > > Thanks a lot!
> > >
> > > Roman Rokytskyy
> > >
> > > --- In Firebird-Java@y..., "Blas Rodriguez Somoza" <blas@p...> wrote:
> > > > Hello
> > > >
> > > > I have found the following bug in the driver
> > > >
> > > > When executing the code
> > > >
> > > > stmt=conn.createStatement();
> > > > stmt.execute("update CTSTABLE2 set PRICE=PRICE*20 where
> > > TYPE_ID=1");
> > > > java.sql.ResultSet retResSet=stmt.getResultSet();
> > > > stmt.close();
> > > >
> > > > the getResultSet method throws
> > > >
> > > > java.lang.Error: registerStatement called with no transaction
> > > > at
> > > > org.firebirdsql.jca.FBManagedConnection.registerStatement
> > > (FBManagedConnectio
> > > > n.java:633)
> > > > at
> > > > org.firebirdsql.jdbc.FBResultSet$FBStatementFetcher.<init>
> > > (FBResultSet.java:
> > > > 2519)
> > > > at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:104)
> > > > at org.firebirdsql.jdbc.FBStatement.getResultSet
> > > (FBStatement.java:526)
> > > >
> > > > When, according to the specifications it must return a empty
> > > ResultSet.
> > > >
> > > > Regards
> > > > Blas Rodriguez Somoza
> > >
> > >
> > >
> > > 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/
>
>
>