File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP 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
Author

In Access,Oracle8i PE ResultSet is not scrolling

Debashish Das
Greenhorn

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;
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
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8935
    
    9

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]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: In Access,Oracle8i PE ResultSet is not scrolling