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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
