Skip to main content

JDBC-ODBC compatibility problem...

1 reply [Last post]
Joined: 2003-09-30

hi! my problem is this, i'm using JDBCODBC driver to access MS Acces, its works in the program after the user login and acces the main program, but it shows some error in the command line, like this.


java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(
at sun.jdbc.odbc.JdbcOdbc.standardError(
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(
at sun.jdbc.odbc.JdbcOdbcDriver.connect(
at java.sql.DriverManager.getConnection(
at java.sql.DriverManager.getConnection(
at LoginFrm.jbInit(
at LoginFrm.(
at LoginFrm$2.display(
at LoginFrm$2.actionPerformed(
at javax.swing.AbstractButton.fireActionPerformed(
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(
at javax.swing.DefaultButtonModel.fireActionPerformed(
at javax.swing.DefaultButtonModel.setPressed(
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(
at java.awt.Component.processMouseEvent(
at java.awt.Component.processEvent(
at java.awt.Container.processEvent(
at java.awt.Component.dispatchEventImpl(
at java.awt.Container.dispatchEventImpl(
at java.awt.Component.dispatchEvent(
at java.awt.LightweightDispatcher.retargetMouseEvent(
at java.awt.LightweightDispatcher.processMouseEvent(
at java.awt.LightweightDispatcher.dispatchEvent(
at java.awt.Container.dispatchEventImpl(
at java.awt.Window.dispatchEventImpl(
at java.awt.Component.dispatchEvent(
at java.awt.EventQueue.dispatchEvent(
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(
at java.awt.EventDispatchThread.pumpEventsForHierarchy(
at java.awt.EventDispatchThread.pumpEvents(
at java.awt.EventDispatchThread.pumpEvents(


my program still working even this error shows up in command line, is Java 1.4 compatible with JDBCODBC driver or JDBC 1.0 API version? i think i'm using JDBC 1.0, coz if i build my class it say that:
Note: C:\JavaCourseware\ uses or overrides a deprecated API.
Note: Recompile with -deprecation for details.
Finished LoginFrm.
how can i solve this problem? thanks for all memebers and non members for reading my problem. i can post a code for the program. if anyone like to see it.

Reply viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Krishna Prasad
Joined: 2006-02-17


Check that, Database Connection Object is not closed before it is opened for 2nd time. So, This is the result of trying to open the Database Connection which is already opened.