Hi, it seems that you try to execute an insert/update/delete command as query using Statement.executeQuery()/PreparedStatement.executeQuery(). Due to the JDBC specification this is not allowed and leads to the exception you got. You should use Statement.executeUpdate()/PreparedStatement.executeUpdate().
Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin > -----Original Message----- > From: Michael MacIntyre [mailto:[EMAIL PROTECTED] > Sent: Montag, 30. Juni 2003 02:17 > To: [EMAIL PROTECTED] > Subject: JDBC Exception - Bug? > > > Hello, > I have a very simple insert statement, generating a very vague error: > com.sap.dbtech.jdbc.exceptions.SQLExceptionSapDB: SQL statement would > generate a row count. > This is my insert statement: > insert into > w_carrierMovement(carrierMovement_id,PUFcarrier_id,Notes_id,qt y,weight,weightunit,orderedlength,width,height,lwhUnit,Additionalcharge,costCurrency) > values(55,9,null,11,0,'lbs',1,0,0,'feet',0,'CAD') > > Oddly enough, it only happens on table I created today - all other > inserts work fine. > Any thoughts of words of wisdom would be greatly appreciated. > Thanks in advance. > Michael MacIntyre > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
