Dear All, I am facing a strange problem with jdbc-odbc bridge database driver. Problem is as follows: I wrote a small script to read data from one database table at my local MS SQL server and after that inserting a record in another database.
Now problem is that everything works fine, even executeUpdate() method gives me 1 after running insert query but when i check into database there is nothing in the destination database. Could not understand why is it happening, in fact it happened first time with me.
All java classes being used are as follows: To get Database connection : DatabaseConnection.java
Since this is SQL Server, have you tried using the profiler to watch the actual statements being executed? My suspicion would be that you are doing something like performing both operations on the same database.
Also - why the JDBC-ODBC bridge? Is there some reason you don't use a type 4 driver? [ May 17, 2006: Message edited by: Paul Sturrock ]