Hi,
Trying to connect into the demos using the latest release
of 9.2 XML however I am getting the following errors.
XSQL-004: Could not acquire a database connection named: demo
XSQL-007: Cannot acquire a database connection to process page.
Ok I thought I will change the connection from demo to the
ORACLE_SID however when I changed this I was presented with..
Oracle XSQL Servlet Page Processor 9.0.1.1.0 (Prod)
XSQL-007: Cannot acquire a database connection to process page.
Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Ok I thought I will change this...
XSQLConfig.xml with the following
<connectiondefs>
<connection name="<ORACLE_SID>">
<username>scott</username>
<password>tiger</password>
<dburl>jdbc:oracle:thin:@<hostname>:1521:ORCL</dburl>
<driver>oracle.jdbc.driver.OracleDriver</driver>
</connection>
<connection name="xmlbook">
<username>xmlbook</username>
<password>xmlbook</password>
<dburl>jdbc:oracle:thin:@<hostname>:1521:ORCL</dburl>
<driver>oracle.jdbc.driver.OracleDriver</driver>
</connection>
<connection name="lite">
<username>system</username>
<password>manager</password>
<dburl>jdbc:Polite:POlite</dburl>
<driver>oracle.lite.poljdbc.POLJDBCDriver</driver>
</connection>
</connectiondefs>
I also created a user called xmlbook too.
However I still get these errors when I restart the httpd server.
http://<hostname>:7777/xsql/helloworld/helloworld.xsql
XSQL-007: Cannot acquire a database connection to process page.
Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=150999296)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
Any help would be great..
Cheers