I have a connection to SqlServer db. I can read data into table fine. I have added sql to addupdatesql method and that sql seems to work (i.e. i tried it independantly in an SQL editor and I get no errors from DBTable when it executes. The displayed data changes but the changes are not propagated back to the database. I have autocomit on and have tried to manually commit data by adding a databaseChangeListener but nothing works. (btw delete doesn't work either)
1) How can I look at the exact sql string that is being executed during the update?
2) What am I missing in order to do updates?
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!