Re: Oracle configuration with Tomcat 4.0.1
On Monday 28 January 2002 07:37 am, you wrote: 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. 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. You set cocoon fine, but Oracle is problem. Have You Oracle instance ORCL2 and SQL*Net ? regards peco - 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]
FW: Oracle configuration with Tomcat 4.0.1
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-namedefault/servlet-name servlet-classorg.apache.catalina.servlets.DefaultServlet/servl et-class init-param param-namedebug/param-name param-value0/param-value /init-param init-param param-namelistings/param-name param-valuetrue/param-value /init-param !-- Oracle JDBC -- init-param param-nameload-class/param-name param-valueoracle.jdbc.driver.OracleDriver/param-value /init-param load-on-startup1/load-on-startup /servlet 3) Added the following datasource in cocoon.xconf datasources jdbc name=noria pool-controller min=5 max=10 oradb=true/ dburljdbc:oracle:thin:@localhost:1521:ORCL2/dburl usernoria/user passwordnoria/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-30 Fax: +54-2293-31 - 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]
Oracle configuration with Tomcat 4.0.1
Folks, 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 ? Thanks in advance, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html - - 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]
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-namedefault/servlet-name servlet-classorg.apache.catalina.servlets.DefaultServlet/servlet-class init-param param-namedebug/param-name param-value0/param-value /init-param init-param param-namelistings/param-name param-valuetrue/param-value /init-param !-- Oracle JDBC -- init-param param-nameload-class/param-name param-valueoracle.jdbc.driver.OracleDriver/param-value /init-param load-on-startup1/load-on-startup /servlet 3) Added the following datasource in cocoon.xconf datasources jdbc name=noria pool-controller min=5 max=10 oradb=true/ dburljdbc:oracle:thin:@localhost:1521:ORCL2/dburl usernoria/user passwordnoria/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-30 Fax: +54-2293-31 - 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]
RE: Oracle configuration with Tomcat 4.0.1
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. 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-namedefault/servlet-name servlet-classorg.apache.catalina.servlets.DefaultServlet/servl et-class init-param param-namedebug/param-name param-value0/param-value /init-param init-param param-namelistings/param-name param-valuetrue/param-value /init-param !-- Oracle JDBC -- init-param param-nameload-class/param-name param-valueoracle.jdbc.driver.OracleDriver/param-value /init-param load-on-startup1/load-on-startup /servlet 3) Added the following datasource in cocoon.xconf datasources jdbc name=noria pool-controller min=5 max=10 oradb=true/ dburljdbc:oracle:thin:@localhost:1521:ORCL2/dburl usernoria/user passwordnoria/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-30 Fax: +54-2293-31 - 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]