How do I use Oracle's thin Driver ?

[Jose Campana]

Hiya there !

I'm trying to establish a connection to an Oracle Database from a main method in a Java Class, but I just can't quite get it to work.
I'm having trouble understanding the URL syntax.

Here's what I'm doing:

public class OracleConnectionTester {

    static public void main(String... args) {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "jdbc:oracle:thin:@jose";
            Connection con = DriverManager.getConnection(url, "jose", "password");
        } catch (Exception ex) {
            System.out.println("An Error ocurred");
            ex.printStackTrace();
        }

    }

}

But I'm getting the following Exception..

java.sql.SQLException: No suitable driver found for jdbcracle:thin:@jose
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.jose.OracleConnectionTester.main(OracleConnectionTester.java:19)

I'll see what I can do about this, But I hope somebody can help me out with this problem. I know it's probably something silly, and that's that, right?

Thanks in advance,

Jose

[Jose Campana]

A'ight.... You may just close this thread, I figured it out on my own....

This was useful...

http://www.orafaq.com/wiki/JDBC

ANyways, always a sincere pleasure to post here in the ranch

Jose