Creating JDBC Connection with Oracle 10g using jsp.

Question

I am able to connect to Oracle 10g (using ojdbc14.jar driver) with java. But when I use the same code in a servlet or file with .jsp extension, I am getting class not found exception. I am not able to understand why this is happening. Do we have different connection strings for JDBC in java and jsp? This is what I use to connect to oracle iwith both, java and jsp:

Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:xe";
//Xe being the database name
String usr = "username";
String pwd = "pwd";

Works fine with java but gives error with jsp.

Answer 1

There should be no real difference between the two. Is the driver jar in your WEB-INF/lib/ subdirectory? A class not found exception typically means your jar wasn't found on the classpath.

Answer 2

If you're using a CLASSPATH environment variable, your app server ignores it. That's probably why it "works" with Java but not with JSPs.

I'd advise you to not rely on CLASSPATH that way. Learn how to set it properly for every situation.

I'd also advise against putting scriptlet code in JSPs. This will grow to be a maintenance nightmare in a short time.

If you must put database calls in a JSP, learn how to use JSTL and its <sql> tags.