Connect to Local Oracle 9i Database

[DougP]

I want to connect to Local install of an Oracle 9i database for testing. Newbie to Java.
I just downloaded NetBeans IDE 3.6 and see the JDBC ODBC Bridge

I have Oracle installed and can connect to it using SQL> in DOS and also Access using the ODBC driver.

It wants a database URL. Can this be done locally?

http://localhost

... does not work
the ODBC name used in Access Oracle9

DougP, MCP, A+

 

[sedj]

In its most simple form, below is how to connect to Oracle.
You must have the classes12.jar in your CLASSPATH.
Do not use the JDBC-ODBC bridge, as it is slower than using Oracle's JDBC driver.
"SID" is your database SID (database name).

Connection conn = null;
try {
  Class.forName("oracle.jdbc.driver.OracleDriver");
  conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:SID, "userName", "password");
} catch (Exception e) {
  e.printStackTrace(System.err);
}

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[sedj]

typo, change :

conn = DriverManager.getConnection("jdbcracle:thinlocalhost:1521:SID, "userName", "password");


to :

conn = DriverManager.getConnection("jdbcracle:thinlocalhost:1521:SID", "userName", "password");


--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[DougP]

I have not tried it yet anyway

After I connect how do it pass a SQL statement like

Select * From MyTable;

And return the results in a recordset ???

DougP, MCP, A+

 

[sedj]

please read a turorial on JDBC first :

http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[DougP]

newbie question
Since I have Netbeans 3.6 do I have this already JDK1.2?

http://java.sun.com/docs/books/tutorial/jdbc/basics/gettingstarted.html

Or do I need it too?

DougP, MCP, A+

 

[sedj]

You probably have JDK/SDK 1.4. You have everything you need to do JDBC, trust me.

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[DougP]

Error missing Class. I'm trying this in the DOS prompt
here is a dump of that:

C:\Java\HelloWorld>javac or.java
or.java:1: 'class' or 'interface' expected
Connection conn = null;
^
or.java:2: 'class' or 'interface' expected
try {
^
2 errors

Do I need to add a CLASS PATH somewhere?

DougP, MCP, A+

 

[sedj]

Errmmm - you cannot just cut'n'paste some code, slap it in a file called "or.java" and hope it works.

I would seriously recommend you take a basic Java tutorial - you will have no chance with JDBC if you don't know how to build a basic class.

This is a bit close to what you should have :

import java.sql.*;
public class TestConnection {

  public void test() {
    Connection conn = null;
    try {
      Class.forName("oracle.jdbc.driver.OracleDriver");
      conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:SID", "userName", "password");
      System.out.println("Got connection : " +conn);
     } catch (Exception e) {
      e.printStackTrace(System.err);
     }
  }

  public static void main(String args[]) {
     TestConnection tc = new TestConnection();
     tc.test();
  }

}

I would really take a tutorial though - here is one :

http://java.sun.com/docs/books/tutorial/

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk