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]>