I have tried to connect Access by using JdbcOdbc bridge and as well as Oracle.I am getting the connection and as well as data but when trying to make the Scrollable ResultSet,I am getting the runtime Error from an application .
The code is
import java.sql.*;
public class scrolltest
{
public static void main(
String ar[])
{
Connection con;
Statement stmt;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("Jdbc
dbc:myacc");
//myacc is a dsn to Access
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery("select id,name from stDetails");
rs.absolute(2);
System.out.println(rs.getString(2));
}
catch(Exception ex)
{
ex.printStackTrace();
}
}
}
Error is
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
at scrolltest.main(scrolltest.java:15)
please help me soon
