Problem connecting to Access

[Ankit Nagpal]

Hi,

I am trying to connect to Access using the following code (IntegratorDB is already there in system DSN):

Connection conn = null;
String url = "jdbc:odbc:IntegratorDB";

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
			
Properties props = new Properties();
props.put("user", "");
props.put("password", "");
			
conn = DriverManager.getConnection(url, props);
conn.setTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED);
} catch (InstantiationException e1) {
	e1.printStackTrace();
} catch (IllegalAccessException e1) {
	e1.printStackTrace();
} catch (ClassNotFoundException e1) {
	e1.printStackTrace();
} catch (SQLException e) {
	e.printStackTrace();
}

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

[Bauke Scholtz]

The driver doesn't support this optional feature. That's all.

That said, you're using the worst of the both worlds (MS Access as database and ODBC bridge driver as JDBC driver). I recommend replacing both to better choices. If the sole purpose is to have an embedded database, look for JavaDB or consorts. Else just use a real RDBMS like MySQL and consorts. Those databases ships with a decent JDBC driver.

[Ankit Nagpal]

Thanks for the prompt response.

I have my limitations though, I cannot change anything and just have to make this work. Is it not possible?

Thanks.

[Bauke Scholtz]

Don't make use of this optional feature then.