Subject Making connections with level 4 jdbc driver
Author rbagnoli2002
Hi all,
i'm evaluating the FB level 4 jdbc driver to connect
server-side applications to an Interbase 6.0.1 CS DBMS
installed on a RH 7.2.
I'm using the firebird client-java CVS image downloaded
and built yesterday.
In my test code, using the url:

jdbc:firebirdsql://localhost//opt/interbase/dbdata/cerline/cerline.gdb

connections are created successfully, but when i try to use them
to submit queries, the following exception occur:

in finally block, of executeQuery
Command exception caught:
java.lang.NullPointerException
at
org.firebirdsql.jgds.XdrOutputStream.writeString(XdrOutputStream.java
:106)
at org.firebirdsql.jgds.GDS_Impl.connect(GDS_Impl.java:1282)
at
org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:263)
at
org.firebirdsql.jca.FBManagedConnectionFactory.getDbHandle(FBManagedC
onnectionFactory.java:408)
at
org.firebirdsql.jca.FBManagedConnection.getIscDBHandle(FBManagedConne
ction.java:711)
at
org.firebirdsql.jca.FBManagedConnectionFactory.getCurrentIscTrHandle(
FBManagedConnectionFactory.java:367)
at
org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConn
ection.java:702)
at
org.firebirdsql.jca.FBManagedConnection.start(FBManagedConnection.jav
a:548)
at
org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:
82)
at
org.firebirdsql.jdbc.FBConnection.ensureInTransaction(FBConnection.ja
va:827)
at
org.firebirdsql.jdbc.FBStatement.executeQuery(FBStatement.java:93)
at
it.orion.database.test.JDBCTester.query(JDBCTester.java:114)
at java.lang.reflect.Method.invoke(Native Method)
at
it.orion.utils.test.InteractiveTester.dispatch(InteractiveTester.java
:80)
at
it.orion.utils.test.InteractiveTester.prompt(InteractiveTester.java:1
59)
at it.orion.database.test.JDBCTester.main(JDBCTester.java:90)



the code snippet that that raises the exception is the following:

public void query(String sql) throws Exception
{

Statement stmt = null;
ResultSet rs = null;

try
{
// Connection has been successfully created in another method.
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);

// Format results (method not reported here)
dispResult(rs);
}
finally
{
if (rs != null) rs.close();
if (stmt != null) stmt.close();
}

The test code i'm usign has been previously used to
test other JDBC driver implementation without troubles,
so i don't think the problem is there.
I'm missing something in the connection URL string?
Any suggestion?

Thanks in advance
Roberto Bagnoli