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