I'm still stuck trying to use Oracle 8.0.6 instead of HSQLDB. I've got a basic sample (using xsp-esql), wich work Ok if I use the HSQL connection, and retour the attached error (NoValidConnectionException) when used with the Oracle connection.
Oracle works fine when accessed with the Oracle Client.
I use nls_*12.jar ans classes12.jar provided by oracle (in web-inf/lib), I
followed the install instructio (path).
If you have any hint...
----------------------------------------------------------------------------
-----
------------
in Web.XML :
------------
<init-param>
<param-name>load-class</param-name>
<param-value>
oracle.jdbc.driver.OracleDriver
org.hsqldb.jdbcDriver
</param-value>
</init-param>
----------------
in Cocoon.XCONF:
----------------
<datasources>
<!-- this one is working fine -->
<jdbc logger="core.datasources.personnel" name="personnel">
<dburl>jdbc:hsqldb:hsql://localhost:9002</dburl>
<user>sa</user>
<password/>
</jdbc>
<!-- this one does'nt work -->
<jdbc logger="core.datasources.fusionoracle" name="fusionoracle">
<pool-controller min="5" max="10" oradb="true"/>
<dburl>jdbc:oracle:thin:@carlos:1521:FUSION</dburl>
<user>dba</user>
<password>dba</password>
</jdbc>
</datasources>
------------
In the XSP :
------------
<esql:connection>
<!-- using "personel" here works fine... but with HSQLDB :)
-->
<esql:pool>fusionoracle</esql:pool>
<esql:execute-query>
<esql:query>
SELECT * from serveur
</esql:query>
<esql:results>
<esql:row-results>
<option>
<xsp:attribute name="value">
<esql:get-string
column="id_serveur"/>
</xsp:attribute>
<esql:get-string
column="id_serveur"/>
</option>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
logs.zip
Description: Binary data
--------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
