ProtocolConfusion....

Sven Duzont sduzont at sygnos.com
Mon Feb 14 11:03:20 EST 2000


Hello...

Finally, the FREETDS JDBC Driver Works fine with NT40 SP6a...
But now, i have a new problem... :)
Trying to access a Stored Procedure with a PreparedStatement via a jsp page,
i get this error :

java.sql.SQLException: Protocol confusionFound a
com.internetcds.jdbc.tds.PacketErrorResult (packet type 0xaa)
 at
com.internetcds.jdbc.tds.PreparedStatement_base.executeCall(PreparedStatemen
t_base.java:259)
 at
com.internetcds.jdbc.tds.CallableStatement_base.execute(CallableStatement_ba
se.java:394)
 at pagecompile._candidat._search_xjsp._jspService(_search_xjsp.java:163)
 at newatlanta.servletexec.JSP10HttpJspPage.service(JSP10HttpJspPage.java)
 at newatlanta.servletexec.JSP10Servlet.service(JSP10Servlet.java)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
 at
newatlanta.servletexec.ServletExec.processServletRequest(ServletExec.java)
 at newatlanta.servletexec.ServletExec.processServletAlias(ServletExec.java)
 at newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java)
 at newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java)

This is my code :
    try
    {
        CallableStatement stmt = con.prepareCall("search ?,?,?,?,?,? ");
        stmt.setInt(1,deb);
        stmt.setInt(2,fin);
        stmt.setString(3,conditions);
        stmt.setString(4,conditionsite);
        stmt.setString(5,col);
        stmt.setInt(6,parsite);
        stmt.execute();
        ResultSet rs = stmt.getResultSet();
        rs.next();
......
        stmt.close();
        rs.close();
    }
    catch (SQLException e)
    {
        e.printStackTrace(System.out);
    }
I'm running it with the HotSpot on JDK1.2.2....
Thanks in advance

Sven






More information about the FreeTDS mailing list