File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Newbie encounters table locking Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Newbie encounters table locking" Watch "Newbie encounters table locking" New topic

Newbie encounters table locking

Dennis Noren

Joined: Jan 07, 2005
Posts: 15
This is a JDBC newbie question. Where is a good description of locking tables & access with JDBC? I am using JDBC/ODBC with MS Access. I get the run-time error when doing a select statement for a join:
SQLException ... [ODBC MS Access Driver]
The database engine could not lock table 'college' because it is already in use by another person or process.

I need to have access to the tables in my database -- I am not concerned at present with controlling access.

I am just trying to do normal table creation, update & display.


Java novice, J2SE 1.4.2<br />Some C, some OOA/OOD
Dennis Noren

Joined: Jan 07, 2005
Posts: 15
OK, found the problem. I just needed to find the magic setAutoCommit method. The courseware I am using and the other sources I consulted didn't talk about committing data.
I agree. Here's the link:
subject: Newbie encounters table locking
jQuery in Action, 3rd edition