Deployed App not connecting to Database

[Sara Tracy]

Hi,

I'm using this code to connect to an Oracle databse

OracleDataSource ds = new OracleDataSource();
    ds.setDriverType("thin");
    ds.setServerName("dssw2k01");
    ds.setPortNumber(1521);
    ds.setDatabaseName("orcl"); // sid
    ds.setUser("sss");
    ds.setPassword("ppp");
 
    Connection conn = ds.getConnection();     
 
Statement stmt = conn.createStatement();
    ResultSet rset = stmt.executeQuery("select pwd from from dual where name='sss'");
    if (rset.next())
      System.out.println(rset.getString(1));
    rset.close();
    stmt.close();
    conn.close();
 

When I run this program on my local machine, it works fine, and gets me the result.

However when I deploy this application, and call a servlet (Say X) accessing this class (say Y), it throws an internal server error, and displays "connection close"

Now in class 'Y', even if I'm not calling the method (having the above database connection code), it still throws the error ! Only if I have this code commented, then the rest of the deployed application works properly without any errors.

Any suggestions appreciated.

[Naseem Khan]

Do SOP for all the objects. Check for which object you are getting null..

System.out.println("Connection object>>>>>" + conn);
System.out.println("Statement object>>>>>" + stmt);
System.out.println("ResultSet object>>>>>" + rset);

Second thing,

Can you show us the stacktrace of the thread?


Thanks


Naseem