Marcelo adn Vadim,
I think youy're both wrong, since my Oracle instance is working properly.
Most probably that is a JDBC error, stating that Oracle can't be reached.
Anyhow, could one of you just send me his/her fragments of configuration
files about connecting Oracle to Cocoon via Tomcat 4.0.1 ?
I've already checked Tomcat documentation, to no avail.
Thanks in advance,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Marcelo F. Ochoa [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 27, 2002 9:42 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Oracle configuration with Tomcat 4.0.1
>
>
> 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</servl
> et-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 - [EMAIL PROTECTED]
> 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: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
