Re: Oracle Thin JDBC Driver Problem - Run time

Hello,

saro_77_vlr schrieb:
Hi,
i did the following code:

import java.sql.* ;
import java.lang.*;

class TestCommand {

public static void main(String a[] ) throws SQLException
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection con =

DriverManager.getConnection("jdbc:oracle:thin:@project:1521:proj","project1",
"admission"); Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from admin");
while( rs.next() )
System.out.println( rs.getString("regno")) ;
}
}

please try this (I don't have tested):

public static void main(String a[] ) throws SQLException {
Class.forName(oracle.jdbc.driver.OracleDriver);
Connection con = DriverManager.getConnection(jdbc:oracle:thin:@project:1521:proj","project1","admission");

Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("select * from admin");
System.out.println( rs.getString("regno")) ;
}



Regards
Michael

--
http://www.smurfi.de
German NetBeans-Site
.

Relevant Pages