Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help! Can't Connect to Oracle USing Tomcat 4

 
Rich Knight
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 18276
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Mike Curwen
Ranch Hand
Posts: 3695
IntelliJ IDE Java Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you tried the following? (this works for me)
[ February 20, 2002: Message edited by: Mike Curwen ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic