How to use Java connect to Oracle

[drakman]

I need to use java connect to Oracle database. Please tell me how to use and I want script to connect, Thank you. :eek:

[drakman]

Good idea

[Khalid Ali]

Good idea

?????what is good idea..:-)

[Ozi]

well first of all you need to import the java.sql.*; statement at the beginning of your source code before the class decleration.

here is the java api
http://java.sun.com/j2se/1.4.2/docs/api/

try looking for it on there, its very helpful

[Khalid Ali]

to connect to oracle he first needs to put oracle driver files in the path, and then do the imports..:-)

[BigDog]

It is just like for any other JDBC connection. Here is an example:

String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);
// Create a connection to the database
String serverName = "machine_name";
String portNumber = "1521";
String sid = "oracle_sid";
String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid;
String username = "user/schema name";
Connection connection = DriverManager.getConnection(url, username, password);
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("select * from some_table");