Can't connect to Oracle database

[Chris Staten]

Hi all, I am having a bit of a problem making a simple database connection. Here is my code:

package com.my.example.model;
 
import java.sql.*;
import java.io.*;
import java.util.*;
import javax.sql.*;
import javax.servlet.http.*;
 
public class OraConn {
 
  public Connection getConn() {
Connection oraConn = null;
try {

                    //load the driver class - this is where my problem is
Class.forName ("oracle.jdbc.OracleDriver");

String sourceURL;
sourceURL =" jdbc  :-o	  racle:thin:@url.to.database:1521  :mrgreen:  ATABASE.WORLD";

//the DriverManager method returns a java.sql.Connection object which 
//oraConn is set to
oraConn = DriverManager.getConnection(sourceURL, "username", "password");


} catch (ClassNotFoundException cnfe) {
String out ="Threw the following exception in com.my.example.OraConn"; 
System.out.println(out + ": " + cnfe.toString());
 
} catch (SQLException sqlE) {
String out ="Threw the following exception in com.my.example.OraConn"; 
System.out.println(out + ":  " + sqlE.toString());

}

return oraConn;

}
}

My original problem was �class not found�, but I moved my ojdbc14.jar file into my apache/tomcat5.5/shared/lib directory. Now I�m getting a �connection refused� error, but I can successfully use the same password and username when logging in through SQL Plus.

Does this have something to do with my tnsnames.ora file?

Did I put the ojdbc14.jar file in the right directory?


-Thanks
[ March 08, 2005: Message edited by: Chris Staten ]

[Chris Staten]

OK, my question as to whether or not the tomcat/shared/lib directory is the right place to put the ojdbc14.jar file has been answered here.

I'll move the .jar file. Now I just need to know why my connection is being refused .
[ March 08, 2005: Message edited by: Chris Staten ]

[Phani Kumar]

Have you double checked the database URL that you are using? In your code, this is the only place it can go wrong I guess.

[Chris Staten]

It was in my URL. The URL for the thin driver has a couple of different formats, but the one I'm using is:

jdbc:-oracle:thin@HOST_NAME:-PORT:SERVICE_NAME

*remove the "-" infront of "oracle" and "PORT" in the URL, I was just trying to remove the emotes.

My service name in the URL above was SERVICE.WORLD. This is also how it looked in my tnsnames.ora file. However, I didn't need the .WORLD portion of the SERVICE_NAME. I made the adjustment by changing SERVICE.WORLD to SERVICE (e.g. TESTDATABASE.WORLD became TESTDATABASE) and it now works.

[ March 08, 2005: Message edited by: Chris Staten ]