Hi folks
i try to update a mssql-database using the following code
PreparedStatement prstmt=connection.prepareStatement("INSERT INTO
GCP_IMAGE VALUES(?,?,?,?,?,?,?,?");
prstmt.setLong(1,11);
prstmt.setInt(2,4);
prstmt.setBinaryStream(3,fis,(int)file.length());
//fis=FileInputStream
prstmt.setString(4,"11_DRAWING.jpg");
prstmt.setLong(5,file.length());
prstmt.setString(6,"image/pjpeg");
prstmt.setLong(7,1000);
prstmt.setLong(8,1000);
prstmt.execute();
running this code results in the following error:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Line 1: Incorrect syntax near '@P8'.
what is this error telling me?? how can i view the syntax of the
statement that is sent to the database to find the error?
best regards
Gerd Nachtsheim - 26 Jul 2004 11:33 GMT
Georg Andersson wrote, On 26.07.2004 11:07:
> Hi folks
>
> i try to update a mssql-database using the following code
>
> PreparedStatement prstmt=connection.prepareStatement("INSERT INTO
> GCP_IMAGE VALUES(?,?,?,?,?,?,?,?");
prstmt.prepareStatement
("INSERT INTO GCP_IMAGE VALUES(?,?,?,?,?,?,?,?)");
HTH
Gerd