Having problem with connecting to ORACLE databse with JDBC

[vmk]

Im trying to establish connection between ORACLE database and java program thru JDBC driver.
I copied classes111.zip to the lib folder in jdbc at ORACLE_HOME. Then i changed the listener to add the SID_DESC and ADDRESS_LIST where i specified SID_NAME , PROTOCOL, HOST ,PORT. what should be the GLOBAL_DBNAME. I assigned the database name im using to GLOBAL_DBNAME. When i tried to execute it it gave me error message "connection refused" .Run time error was in the statement
Connection conn =
DriverManager.getConnection ("jdbcracle:thin:localhost:1521:testdb",
"SYSTEM"....
Can anybody help me in this regard.I appreciate their help

Thanks

[DaPi]

Originally posted by vmk
"jdbc:oracle:thin:localhost:1521:testdb"

The 4th parameter should resolve to the IP address of the server - so this will only work if you run it on the server. AFAIK it also needs a @ preceding it.

I suggest you also test that you can connect to "testdb" using SQL*Plus (to make sure your listener config is OK) before you add the complication of this horrid JDBC stuff.

[vmk]

thanks dude ill give it a try.