Hi there again,
Thanks for the reply. I am running
Tomcat 4 on Linux Redhat 6. I am not sure how the database administrator set the drivers up or which drivers I am using.
I do know that by
testing the database connection using a normal java program from the command line does work and does return data from the oracle database.
here is the init method where i am specifying the driver name:
public void init() {
try {
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("JDBC driver loaded");
}
catch (ClassNotFoundException e) {
System.out.println(e.toString());
}
catch (SQLException e) {
System.out.println(e.toString());
}
}
and this is how I'm getting my connection:
Connection con = DriverManager.getConnection("jdbc
racle:thin:@192.96.74.6:1521:bndb", "sb", "sb");
I have imported these packages:
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;
I don't know if any of this info will be helpful in determining which drivers I am using though. Someone told me that I needed to add the location of the jdbc drivers to my Java classpath and my Tomcat classpath. Do you know if that is correct?
Thanks.
