Hello,
I have always the same trouble passing from IB6/interclient to
FirebirdSQL/Jaybird (RC3) on win2000. All worked fine until I switched
from Interbase 6 to firebirdsql. Now Firebird works with simple
queries, but I get GDS exception with preparedStatement.executeUpdate.
I tried also interclient with FBsql but I failed to get the connection
(IOException with socket input stream read).

Here is a sample code:

//firebirdsql.ConnectionTest.java
package firebirdsql;

import java.sql.*;

public class ConnectionTest {

private String driver = "org.firebirdsql.jdbc.FBDriver";
private String url =
"jdbc:firebirdsql:localhost/3050:E:\\DATABASE\\WERSDB.gdb";
private String user = "sysdba";
private String pass = "masterkey";
private String insert = "INSERT INTO Z_SALES_AGENT
(AGENT_ID,AGENT_NAME,PASSWD,LICENSE_KEY) VALUES (?,?,?,?)";

public ConnectionTest() {
}
public static void main(String[] args) {
ConnectionTest connectionTest1 = new ConnectionTest();
connectionTest1.startTest();
}

private void verify(Connection conn)throws SQLException{
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM Z_SALES_AGENT");
while(rs.next()){
System.out.println(rs.getString(1));
}
rs.close();
}

private void startTest(){
//driver = "interbase.interclient.Driver";
//url = "jdbc:interbase://localhost/E:\\DATABASE\\WERSDB.gdb";
try {
Class.forName(driver).newInstance();
}
catch (Exception E) {
System.err.println("Unable to load driver.");
E.printStackTrace();
}
try{
Connection conn = DriverManager.getConnection(url, user, pass);
DatabaseMetaData mdata = conn.getMetaData();
ResultSet rs = mdata.getColumns(null,null,null,null);

verify(conn);
PreparedStatement pr = conn.prepareStatement(insert);
pr.setString(1,"0000011321");
pr.setString(2, "BETA S.R.L.");
pr.setString(3, "PASS");
pr.setString(4, "APVtrialversion");
int res = pr.executeUpdate();
pr.close();
verify(conn);
System.out.println("Successfully connected! :"+res);
} catch (SQLException ex){
System.out.println("*");
ex.printStackTrace();
}
}
}

Here is the sql create instruction:


/* Table: Z_SALES_AGENT, Owner: SYSDBA */

CREATE TABLE Z_SALES_AGENT
(
AGENT_ID CHAR(10) NOT NULL,
AGENT_NAME CHAR(30),
PASSWD CHAR(10),
LICENSE_KEY CHAR(20),
CONSTRAINT PK_Z_SALES_AGENT1 PRIMARY KEY (AGENT_ID)
);


Here is the exception:

org.firebirdsql.jdbc.FBSQLException: GDS Exception. Error reading data
from the connection.
null

at
org.firebirdsql.jdbc.FBConnection.checkEndTransact
ion(FBConnection.java:1008)

at
org.firebirdsql.jdbc.FBPreparedStatement.executeUp
date(FBPreparedStatement.java:143)

at firebirdsql.ConnectionTest.startTest(ConnectionTest.java:50)

*

at firebirdsql.ConnectionTest.main(ConnectionTest.java:17)

at org.firebirdsql.gds.GDSException: Error reading data from the
connection.
null

at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1651)

at
org.firebirdsql.jgds.GDS_Impl.isc_commit_transacti
on(GDS_Impl.java:542)

at
org.firebirdsql.jca.FBManagedConnectionFactory.com
mit(FBManagedConnectionFactory.java:684)

at
org.firebirdsql.jca.FBManagedConnection.internalCo
mmit(FBManagedConnection.java:410)

at
org.firebirdsql.jca.FBLocalTransaction.internalCom
mit(FBLocalTransaction.java:156)

at
org.firebirdsql.jdbc.FBConnection.checkEndTransact
ion(FBConnection.java:1004)

at
org.firebirdsql.jdbc.FBPreparedStatement.executeUp
date(FBPreparedStatement.java:143)

at firebirdsql.ConnectionTest.startTest(ConnectionTest.java:50)

at firebirdsql.ConnectionTest.main(ConnectionTest.java:17)




Help me, please!

Thanks in advance,
Angelo Mariano