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):
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.