xsql connection failure from browser
Date: 5 Oct 2001 04:43:13 -0700
Message-ID: <d0bb6654.0110050343.4a1eecf2_at_posting.google.com>
I have entered an xsql example from the book "Building Oracle XML applications". I can get it to run from the command line using the xsql script, but it fails with the following from a browser:
Oracle XSQL Servlet Page Processor 1.0.0.0 (Production) XSQL-004: Could not acquire a database connection named: TSTDB XSQL-007: Cannot acquire a database connection to process page.
I have an XSQLConfig.xml file with the proper connection data in the same directory as the FAQ-List.xsql file (Apache's htdocs directory). I also have it in a directory defined in the xsql classpath. I have modified the xsql script so that it will execute for a user who has not Oracle environment set up:
#!/bin/ksh
export ORACLE_HOME=${ORACLE_HOME:-/dev_tools/oracle/product/9.0.1/}
export JDK_HOME=${JDK_HOME:-/usr/java1.2/}
export XSQL=~/xsql
java -classpath /tmp/:./:$JDK_HOME/lib/classes.zip:$ORACLE_HOME/jdbc/lib/classes12.zip:$ORACLE_HOME/jlib/sax2.jar:$ORACLE_HOME/rdbms/jlib/xsu12.jar:$ORACLE_HOME/lib/xmlparserv2.jar:$ORACLE_HOME/lib/oraclexsql.jar:$ORACLE_HOME/lib:$ORACLE_HOME/lib/oraclexsql.jar
oracle.xml.xsql.XSQLCommandLine $*
The Browser is running on a Win 2000 workstation and the the xsql file is on a solaris box.
What am I missing? As you can see, I am not an expert on browsers or webservers... is it something to do with that?
Any ideas would be great.
Carl
cmercer_at_vibrant-1.com
PS
Here is the connection stuff from XSQLConfig.xml:
<connection name="TSTDB">
<username>cam</username>
<password>morgan</password>
<dburl>jdbc:oracle:thin:_at_ivserv5:1521:TSTDB</dburl>
<driver>oracle.jdbc.driver.OracleDriver</driver>
</connection>
Received on Fri Oct 05 2001 - 13:43:13 CEST