This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: 17151
    
  27

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.


An IDE is no substitute for an Intelligent Developer.
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
 
It's not a secret anymore!