Hi,
I am using the jdbcodbc bridge with an Access DB. My main connection class is a static class, which is used by all other classes for db interaction. It all works fine, but when I perform a DB INSERT/UPDATE, the results do NOT get written to the DB until I explicitly call conn.close() In my case, this may not happen for a long time, until the program exits, but till then the other classes are not aware of the newly inserted data.
Any ideas would be highly appreciated.
Thanks in advance,
Anoop
I am using the jdbcodbc bridge with an Access DB. My main connection class is a static class, which is used by all other classes for db interaction. It all works fine, but when I perform a DB INSERT/UPDATE, the results do NOT get written to the DB until I explicitly call conn.close() In my case, this may not happen for a long time, until the program exits, but till then the other classes are not aware of the newly inserted data.
Any ideas would be highly appreciated.
Thanks in advance,
Anoop