cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcelo F. Ochoa" <moc...@ieee.org>
Subject Re: Oracle configuration with Tomcat 4.0.1
Date Sun, 27 Jan 2002 20:42:05 GMT
Luca Morandini wrote:

>Nicolas,
>
>not quite there...
>
>1) I've put classes12.jar (.zip won't work, since Tomcat 4 doesn't recognize
>this extension) in $TOMCAT_HOME/common/lib
>
>2) I've modified web.xml, adding the loading of the oracle JDBC driver,
>hence having the default servlet looks like:
>
>  <servlet>
>    <servlet-name>default</servlet-name>
>
><servlet-class>org.apache.catalina.servlets.DefaultServlet</servlet-class>
>    <init-param>
>      <param-name>debug</param-name>
>      <param-value>0</param-value>
>    </init-param>
>    <init-param>
>      <param-name>listings</param-name>
>      <param-value>true</param-value>
>    </init-param>
>
>    <!-- Oracle JDBC -->
>    <init-param>
>      <param-name>load-class</param-name>
>      <param-value>oracle.jdbc.driver.OracleDriver</param-value>
>    </init-param>
>
>    <load-on-startup>1</load-on-startup>
>  </servlet>
>
>3) Added the following datasource in cocoon.xconf
>
>  <datasources>
>	<jdbc name="noria">
>		<pool-controller min="5" max="10" oradb="true"/>
>	    <dburl>jdbc:oracle:thin:@localhost:1521:ORCL2</dburl>
>		<user>noria</user>
>		<password>noria</password>
>	</jdbc>
>  </datasources>
>
>But cocoon refuses to cooperate, stating:
>
>DEBUG   (2002-01-27) 21:23.28:977   [cocoon  ] (Unknown-URI)
>Unknown-thread/AbstractPool:
>org.apache.avalon.excalibur.datasource.JdbcConnection: could not be
>instantiated.
>java.sql.SQLException: ORA-01034: ORACLE not available
>ORA-27101: shared memory realm does not exist
>
 Check your Oracle SID, this error means that the instance ORCL2 is not 
available.
 Cocoon and the Oracle jdbc driver are working properly here.
 Best regards, Marcelo.

-- 
Marcelo F. Ochoa - mochoa@ieee.org
Do you Know DB Prism? Look @ http://www.plenix.com/dbprism/
More info?
Chapter 21 of the book "Professional XML Databases" (Wrox Press 
http://www.wrox.com/)
Chapter 8 of the book "Oracle & Open Source" (O'Reilly 
http://www.oreilly.com/catalog/oracleopen/)
-----------------------------------------------
Lab. de Sistemas - Fac. de Cs. Exactas - UNICEN
Paraje Arroyo Seco - Campus Universitario
(7000) Tandil - Bs. AS. - Argentina
Te: +54-2293-444430 Fax: +54-2293-444431




---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message