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
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:428)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:248)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:249)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(Unk
nown
and so on...
Any suggestion ?
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Nicolas Kessler [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 27, 2002 8:26 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Oracle configuration with Tomcat 4.0.1
>
>
> Hi Luca
>
> From: "Luca Morandini" <[EMAIL PROTECTED]>
> > I have upgraded to Tomcat 4.0.1 fomr Tomcat 3.2.3, but I wasn't able to
> make
> > Cocoon connect to Oracle 8.1.7...
> >
> > Could someone give the EXACT things to put in web.xml, server.xml,
> > cocoon.xconf and the like ?
>
> First, you must have the Oracle JDBC thin driver
> ("classes12.zip") somewhere
> in your classpath.
>
> Second, add
>
> oracle.jdbc.driver.OracleDriver
>
> to web.xml in the
>
> <init-param>
> <param-name>load-class</param-name>
> <param-value>
> ...
>
> section.
>
> That should do it. You only need to modify cocoon.xconf if you want to use
> connection pooling. In that case you would add something like
>
> <jdbc name="scott">
> <pool-controller min="5" max="10" oradb="true"/>
> <auto-commit>false</auto-commit>
> <dburl>jdbc:oracle:thin:@localhost:1521:ORCL</dburl>
> <user>scott</user>
> <password>tiger</password>
> </jdbc>
>
> Regards,
> Nicolas
>
>
>
> ---------------------------------------------------------------------
> 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]>
