Thursday, May 31, 2001 05:57 AM
I have a program that uses PreparedStatement and does an insert into four different tables. The first three inserts work but for some reason the last one fails. There is no exception thrown and no sql warnings and no rollback because the commit is done at the end and data is inserted into the first three tables.
The strange thing about this is that for one of the fields, if I don't use setString() and I hardcode the value, it works. Does anyone have any ideas?