File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes In Access,Oracle8i PE ResultSet is not scrolling Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "In Access,Oracle8i PE ResultSet is not scrolling " Watch "In Access,Oracle8i PE ResultSet is not scrolling " New topic

In Access,Oracle8i PE ResultSet is not scrolling

Debashish Das

Joined: Nov 11, 2003
Posts: 1
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;
con=DriverManager.getConnection("Jdbc dbc:myacc");
//myacc is a dsn to Access
rs=stmt.executeQuery("select id,name from stDetails");

catch(Exception ex)
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(
please help me soon
Joe Ess

Joined: Oct 29, 2001
Posts: 9189

So what part of "Optional feature not implemented" are you having problems understanding? The JDBC-ODBC bridge is not ment for "real" applications so it will not have all the functionality a real JDBC driver has. From the Java 1.4 Documentation:
The JDBC-ODBC Bridge driver is recommended only for experimental use or when no other alternative is available.

I don't understand what you mean when you say that you are connecting to Access through Oracle. The Oracle database drivers should work as advertised on an Oracle database.
[ November 11, 2003: Message edited by: Joe Ess ]

[How To Ask Questions On JavaRanch]
I agree. Here's the link:
subject: In Access,Oracle8i PE ResultSet is not scrolling
jQuery in Action, 3rd edition