dbTalk Databases Forums  

Tomcat on Localhost JSP Failure

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss Tomcat on Localhost JSP Failure in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
BikRboy
 
Posts: n/a

Default Tomcat on Localhost JSP Failure - 10-23-2007 , 02:10 PM






Greetings!

My shop recently upgraded to a new box for our Oracle 10g instance.

Since the move, my localhost (WindowsXP Pro) running Tomcat 5.5.17
that came with NetBeans 5.5.1 no longer works with JSP's that need to
connect to Oracle. Other JSP's w/o the need to connect to Oracle run
just fine.

Thankfully, the JSP's work just fine on HP UNIX.

Begin: Tomcat Error Message:

org.apache.jasper.JasperException: Exception in JSP: /gtc_ord.jsp:43

40: ResultSetMetaData rsmd;
41:
42: try {
43: Class.forName("oracle.jdbc.driver.OracleDriver");
44: conn = DriverManager.getConnection(dbConn, "ops
$daemon", "ops$daemon");
45:
46: S = conn.createStatement();

End: Tomcat Error Message.

Some things that I have checked:
-------------------------------------------------
1. Classpath has not changed.
2. Added ORAI18N.JAR to my WEB-IN/lib/ path
3. TNSPING'd the listener from my DOS command line.
4. TOAD works fine and I can browse all the tables I want.
5. The NetBeans SQL Editor also connects to Oracle and I can run SQL
queries as well.

This used to work on my same localhost before we moved Oracle to a
new box.

Does anyone have any ideas?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.