aspose file tools*
The moose likes JDBC and the fly likes Help!  Can't Connect to Oracle Database Using Tomcat Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help!  Can Watch "Help!  Can New topic
Author

Help! Can't Connect to Oracle Database Using Tomcat

Rich Knight
Greenhorn

Joined: Feb 05, 2002
Posts: 14
Hi,
I'm trying to use Tomcat 4's JDBCRealm to authenticate users. When I ran tests with mySQL, everything went fine. However now that I need to move the JSP application to production I have to connect to an Oracle 8i database. I set everthing up the same way by editing the server.xml file, but now Tomcat won't start. I even tested getting the connection and accessing the database in one of my jsp's and it works fine, so I don't believe it's the connectionURL. It gives me the error that I pasted below. Please help, this unforseen dip has placed me behind schedule at work.
Code added to server.xml (worked fine using mySQL):

Error when I attempt to launch Tomcat:

[ February 20, 2002: Message edited by: Rich Knight ]
martin samm
Ranch Hand

Joined: Nov 09, 2000
Posts: 31
i had a similar problem with tomcat 3-3. Are you using classes12.zip (as supplied by Oracle) for the Oracle JDBC classes? Try renaming the file to .jar rather than .zip - seems Tomcat (at least with 3-3) has a mysterious problem with the .zip extension. Hope that helps


martin samm<BR>m_sam@rroom.net
Rich Knight
Greenhorn

Joined: Feb 05, 2002
Posts: 14
Thanks for the reply,
Yes I am using classes12.zip, and I renamed it to .rar. Same results .
Rich Knight
Greenhorn

Joined: Feb 05, 2002
Posts: 14
I'm able to boot up fine now, but when I try to login to my JSP I get the following error generated in my log file. The error is only generated if the user actually exists in the database, so I'm sure I'm connecting and accessing the info. Thanks :

[ February 20, 2002: Message edited by: Rich Knight ]
 
Don't get me started about those stupid light bulbs.
 
subject: Help! Can't Connect to Oracle Database Using Tomcat