File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Servlets and the fly likes Help! Can't Connect to Oracle USing Tomcat 4 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Help! Can Watch "Help! Can New topic
Author

Help! Can't Connect to Oracle USing Tomcat 4

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:
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 15961
    
  19

Nothing obvious here. All it says was that there was allegedly something wrong with an SQL request.
I'd double-check the URL connection string and see if I could get a log of the actual SQL requests being made at the time of failure.


Customer surveys are for companies who didn't pay proper attention to begin with.
Mike Curwen
Ranch Hand

Joined: Feb 20, 2001
Posts: 3695

Have you tried the following? (this works for me)
[ February 20, 2002: Message edited by: Mike Curwen ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help! Can't Connect to Oracle USing Tomcat 4
 
Similar Threads
Help! Can't Connect to Oracle Database Using Tomcat
Tomcat newbie
Please help correct error in localost_log
Help! Can't Connect to Oracle USing Tomcat 4
jdbc problems with tomcat 4.0