dcsimg
Problem to implement scrollable property using Oracle 8i and JDBC 2.0
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Barun_Bairagi
Posted On:   Thursday, February 26, 2004 01:35 AM

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.forNam   More>>

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();
}


}
}

   <<Less
About | Sitemap | Contact