cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vadim Gritsenko" <vadim.gritse...@verizon.net>
Subject RE: Oracle configuration with Tomcat 4.0.1
Date Mon, 28 Jan 2002 13:24:39 GMT
> From: Luca Morandini [mailto:l.moran@tin.it]
> 
> 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
>               lmorandini@ieee.org
> http://utenti.tripod.it/lmorandini/index.html
> ---------------------------------------------
> 
> 
> > -----Original Message-----
> > From: Marcelo F. Ochoa [mailto:mochoa@ieee.org]
> > Sent: Sunday, January 27, 2002 9:42 PM
> > To: cocoon-users@xml.apache.org
> > 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 - 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