jdbc connection

[Padma Priya]

hi Everyone,

I have installed oracle 10g XE....and i have written a jdbc program to connect to the database....but my connection fails...I am not able to figure out where i have gone wrong.....

import java.sql.*;

class Demo
{

public static void main(String argv[])
{


try
{


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");


// specify the ODBC data source's URL
//String url = "jdbc:oracle:thin:@localhost:orcl";

// connect
Connection con = DriverManager.getConnection("jdbc:odbc:XE","SYSTEM","saibaba");

System.out.println("Connected "+con.getClass());
}
catch (java.lang.Exception ex)
{

ex.printStackTrace();

}

}

}

Can anyone help me out???

Thanks in advance
Deepthi

[Herman Schelti]

hi Deepthi,

-is your database really up and running
(there's a tutorial at http://download-uk.oracle.com/docs/cd/B25329_01/doc/admin.102/b25610/toc.htm)
-why do you use the jdbc/odbc driver instead of Oracle's Driver?
-did you get any error-message?
-you don't specify any portnumber (probably 1521)

Herman

[Abhishek Bharti]

hi Deepthi,

Is it throwing some exception...if it is then please let us know. that would be easier for us to find out a solution...

Abhishek

[Chengwei Lee]

Hi Deepthi,

I believe you're using Oracle's JDBC library. So the driver class name in your codes need to be changed. Follow this example and you should get it working.

Cheers!