This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 8836

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 ]

"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
wood burning stoves
subject: In Access,Oracle8i PE ResultSet is not scrolling
Similar Threads
problem with mysql jdbc connection
error when i run the program
unable to run this program
Problem faced while closing the ResultSet..
Applets + JDBC + MySQL = access denied