FreeTDS Development Group

[Greg <greg AT thecg.com>]

I'm not sure if this list is also for the FreeTDS-JDBC, but....


Are there any known problems with PreparedStatements and the
SybaseDriver. I'm using the free version of Sybase ASE for Linux, which
is 11.0.3 I believe. Here's my code snippet and the SQLException I'm
getting:


        PreparedStatement pstmt = conn.prepareStatement(
          "update property set name = ?, value = ? where id = ?"
        );
        pstmt.setString(1, name);
        pstmt.setString(2, value);
        pstmt.setInt(3, id);
        pstmt.execute();


That code gives me:

java.sql.SQLException: Must declare variable '@P1'.

        at
com.internetcds.jdbc.tds.SqlMessage.toSQLException(SqlMessage.java:85)
        at
com.internetcds.jdbc.tds.PreparedStatement.submitProcedure(PreparedStatement.java:303)

        at
com.internetcds.jdbc.tds.PreparedStatement.execute(PreparedStatement.java:160)

        at
com.internetcds.jdbc.tds.PreparedStatement.executeUpdate(PreparedStatement.java:342)

        at ....


Any ideas?

Greg