Hi,
I am trying to connect to Access using the following code (IntegratorDB is already there in system DSN):
It's running fine until the line conn.setTransactionIsolation() is reached and throws an SQLException on this line. Here is the stack trace:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(JdbcOdbc.java:5114)
at sun.jdbc.odbc.JdbcOdbcConnection.setTransactionIsolation(JdbcOdbcConnection.java:944)
at net.ibs.framework.lang.ext.Test.main(Test.java:21)
I have a limited knowledge on
JDBC and don't know why this is happening, any ideas?
Thanks in advance.
Ankit