This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Newbie encounters table locking Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Newbie encounters table locking" Watch "Newbie encounters table locking" New topic
Author

Newbie encounters table locking

Dennis Noren
Greenhorn

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.

Thanks


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

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: http://aspose.com/file-tools
 
subject: Newbie encounters table locking
 
Similar Threads
SQL Query Problem
doubt in resultsets and queries in servlets
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
Quering the ResultSet
Netbeans and MS Access