Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Newbie encounters table locking

 
Dennis Noren
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thanks
 
Dennis Noren
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic