How to connect oracle (9i / 10g) as backend to Java program ( JDK 1.4 / J++)?

Question

Hello,

I have written a java program in JDK 1.4 ( Which I have compiled in J++).
I am dont know how to connect oracle ( 9i / 10g) as Backend to my java program.

Please send the code / instructions to connect my backend.

my program includes oracle tables..

Please help me..

thank you
Jayanth

How to display a oracle table as output from a Java program.. Pls post replies..

Answer 1

You have to specify the dsn name, using the following guidelines.

Goto Control Panel
Start > Settings > Control Panel
Double Click the Administrative Tools
Double Click the Data Sources (ODBC)
a window will appear with title as
ODBC Data Source Administrator
Click on the System DSN Tab at the top
then Click on the Add Button
Choose Driver from the list of drivers
Here in your case it is
Microsoft Access Driver (*.mdb)
Then Click Finish

A window appears asking Data Source Name (Type here the data source name)
specify the server, user name and password
then press ok
Your dsn is ready now.

You have to specify it on the programming code.
Here's the code for connectivity.
import java.sql.*;
// code snippet
try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:","","");
Statement stmt=con.createStatement();
// now to execute queries
ResultSet rs=stmt.executeQuery("");
//you can get values by using rs.getString()
int i=stmt.executeUpdate("");
}
catch(Exception exception){
System.out.println("Error"+exception.getMessage());
}

for further clarifications you can contact me

my email:[e-mail]
my mobile number : [phone]

good luck.

Answer 2

Use JDBC. Simple few line code is avail in most the java books with complete set of instructions.

Create a DSN in odbc32 in ur control panel

Then write JDBC

Answer 3

public void CreateConnection(){


try {
Class.forName
("oracle.jdbc.driver.OracleDriver");
} catch (Exception e) {
System.out.println("Failed to load JDBC/ODBC driver.");
return;
}
// get a connection
try {
Connection con = DriverManager.getConnection(
"jdbc:oracle:thin:@servername:1521:orcl",

"test",
"test");
} catch (Exception e) {
System.err.println("problems connecting to server" );
}
}




Hope u make sense out of this ... Some idioting fonting of yahoo ... Some things may get cut out.. Try it