Marcelo and Vadim,
I solved the problem... I had made the mistake of mistyping the
SID... silly, isn't it ?
Unfortunately, I made this error while upgrading to Tomcat 4.0.1,
hence, I thought the error to be related to the different
handling of JDBC connections between Tomcat 3 and Tomcat 4.
Best regards and thanks for your collaboration,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> > -----Original Message-----
> > From: Vadim Gritsenko [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, January 28, 2002 2:25 PM
> > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: RE: Oracle configuration with Tomcat 4.0.1
> >
> >
> > > From: Luca Morandini [mailto:[EMAIL PROTECTED]]
> > >
> > > 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.
> >
> > That's what I told you. Check Oracle documentation for reason and
> > suggestions on how to fix this.
> >
> > Vadim
> >
> > > 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]>
