aspose 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
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: 16246
    
  21

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