I have a problem configuring Tomcat4.0 with the XSQLServlet shipped with the XDK (Java API for Oracle).
I was able to configure it with Tomcat 3.2 but NOT with 4.0. My configuration is as follows: in TOMCAT_HOME/common/lib I have placed xsu12.jar oraclexsql.jar xmlparserv2.jar Now I had problems with the classes12.zip file which I had to extract into TOMCAT_HOME/common/classes in order to avoid the "ClassNotFoundException" about the Oracle JDBC. Instead the tomcat can now find the JDBC drivers in the classes directory unzipped. ok that worked but..... Now the last thing I needed to do was to place the XSQLConfig.xml file into Tomcat classpath. So I put it in TOMCAT_HOME/common/classes. But after extracting the jdbc driver package into that directory this xml file cannot be foud anymore by Tomcat??, (no problem when the jdbc cdrivers where not there!!???) I have also edited catalina.bat and setclasspath.bat (using Windows for this one) so that it can search for this xml file but without any luck. So if anyone have been able to properly set up XSQLServlet with Tomcat4.0 can you please help me out with this one??? I got this up running with tomcat 3.2 but the configuration is not the same for Tomcat4.0. It also works with JServ but that too is another story. This is strange and Oracle themselves is silent about it, also I have not found one single developer that was able to make it run correcty. So anyone out there who can solve this? Thanks /Antonios