RE: Cocoon and Oracle 8 - more informations.

[TREGAN Fabien <fa...@airbus.com>]

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>