Hello,I can't implement the scrollable property with Oracle 8i(8.1.5 version) using JDk 1.3(JDBC 2.0).If any can solve the porblem,I will be highly obliged.
My email id is: bairagibarun@rediffmail.com
The rs.next() is running smoothly.Sample code is attached here with.
Thanks in Advance.
From Barun Bairagi

import java.util.*;
import java.awt.*;
import java.awt.event.*;
import java.text.*;
import java.sql.*;
import java.io.*;
import javax.swing.*;
public class AWTTest3
{
public static void main(String args[])
{
Retrevedata();
}
public static void Retrevedata()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url=new String("jdbc:odbc:mydatasource");
Connection con=DriverManager.getConnection(url,"scott","tiger");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("SELECT EMPNO,ENAME,JOB from EMP");
System.out.println("-------------------------------");
System.out.println("Emp no:"+" "+"EName:" +" "+"Job:");
System.out.println("-------------------------------");
while(rs.absolute(1))
{
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
}catch(Exception q)
{
q.printStackTrace();
}


}
}