Installing Oracle XSQL Servlet on Tomcat 3.2

I saw an article by Brian Duff on
http://www.dubh.org/tech/xml/tomcat33xdk.xml and am trying to do the same thing with tomcat 3.2, rather than tomcat 3.3 because we have to use Borland's AppServer 4.5.1, which ships with tomcat 3.2 by default.

Another major difference between our enviroment and the one in your article is that we use Oracle 8.1.7.3 rather than 9i.

I have deployed the relevant jar files and created the relevant .xsql and XSQLConfig.xml files but all I seem to get is the following:

Oracle XSQL Servlet Page Processor 1.0.1.0 (Production) XSQL-004: Could not acquire a database connection named: demo XSQL-007: Cannot acquire a database connection to process page.

Obviously I have checked that the corresponding connection names match in my 2 xml files...and I've reduced the files down to the simplest form I can get, described below:

my ab.xsql file (so I can use the URL
http://wwetx35:8080/xsql/ab.xsql) contains the following:

<?xml version="1.0"?>

<xsql:query connection="demo" xmlns:xsql="urn:oracle-xsql">

   select to_char(sysdate,'DD/MM/YYYY HH24:MI:SS') PUBLISHED from dual </xsql:query>

and my XSQLConfig.xml file contains the following:

<?xml version="1.0"?>
<connectiondefs dumpallowed="no">
  <connection name="demo">
<username>mrkt_info</username>
<password>rubbish</password>
<dburl>jdbc:oracle:thin:@localhost:1521:EDRP</dburl>
<driver>oracle.jdbc.driver.OracleDriver</driver>
  </connection>
</connectiondefs>

I'm reasonably sure it's picking up the correct version of the XSLConfig file, but even so the others that exist under the $ORACLE_HOME directory also contain a connection name called "demo" too.

Any ideas? I would be grateful if anyone could shed any light on this! Or is it as simple as needing to upgrade to Tomcat 3.3 and/or Oracle 9i?

Regards,
Andrew Received on Thu Mar 14 2002 - 11:31:24 CST