XSQL & MySQL (Solaris/Apache/JServ)

From: Dionysios G. Synodinos <dsin_at_ajax.noc.ntua.gr>
Date: Sat, 21 Apr 2001 22:34:19 +0300
Message-ID: <Pine.GSO.4.10.10104212231550.9444-100000_at_ajax.noc.ntua.gr>

I'm trying to get the Oracle XSQL servlet to work with MySQL (through the mm.mysql.jdbc-1.2c driver) under Solaris but I keep getting the following error message (using the xsql command-line tool):

---

%> sh $XSQL/bin/xsql test.xsql test.htm

Oracle XSQL Command Line Page Processor 1.0.4.1 (Production)         
XSQL-007: Cannot acquire a database connection to process page.      
Cannot disable AUTO_COMMIT                                           
---------------------------------------------------------------

My configuration is:

test.xsql

---

<?xml version="1.0"?>
<DbTest elt="query" xmlns:xsql="urn:oracle-xsql"

        connection="xsqlDsin">

<xsql:query>

        SELECT * AS text
        FROM text

</xsql:query>

</DbTest>

XSQLConfig.xml

---

...
<connection name="xsqlDsin">

      <username>USER_NAME</username>
      <password>PASSWORD</password>
      <dburl>jdbc:mysql://host:3306/xsqlDsinTest</dburl>
      <driver>org.gjt.mm.mysql.Driver</driver>

</connection>
...

jserv.conf

---

ApJServAction .xsql /servlets/oracle.xml.xsql.XSQLServlet

jserv.properties

---

wrapper.classpath=/xsql/mm.mysql.jdbc-1.2c/org/gjt/mm/mysql/ Driver.class Received on Sat Apr 21 2001 - 21:34:19 CEST