hi all, i m using db2 as a d/b server ,and i m trying to store a row into a table, as i m not too sure about d/b structure(column types) i m using preparedstememnt.setObject(int,object) to set the values in the psmts and then doing executeUpdate.Everything work s fine excep a case when the d/b column is of type integer or long or double and value to be assinged is empty string(0 lenght) I get Error in assignment error from db2 driver.
What may be the reason and solution.actually how will i store a null in numeric column using setObject, becasue in my case a string of 0 lenght means null value.
Previous Topic
