FW: Oracle configuration with Tomcat 4.0.1

2002-01-29 Thread Luca Morandini 

 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:
> > > > >
> > > > >  
> > > > >default
> > > > >
> > > > >org.apache.catalina.servlets.DefaultServlet > > > et-class>
> > > > >
> > > > >  debug
> > > > >  0
> > > > >
> > > > >
> > > > >  listings
> > > > >  true
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >  load-class
> > > > >  oracle.jdbc.driver.OracleDriver
> > > > >
> > > > >
> > > > >1
> > > > >  
> > > > >
> > > > >3) Added the following datasource in cocoon.xconf
> > > > >
> > > > >  
> > > > >   
> > > > >   
> > > > >   jdbc:oracle:thin:@localhost:1521:ORCL2
> > > > >   noria
> > > > >   noria
> > > > >   
> > > > >  
> > > > >
> > > > >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

2002-01-29 Thread snpe 

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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

RE: Oracle configuration with Tomcat 4.0.1

2002-01-28 Thread Vadim Gritsenko 

> 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:
> > >
> > >  
> > >default
> > >
> > >org.apache.catalina.servlets.DefaultServlet > et-class>
> > >
> > >  debug
> > >  0
> > >
> > >
> > >  listings
> > >  true
> > >
> > >
> > >
> > >
> > >  load-class
> > >  oracle.jdbc.driver.OracleDriver
> > >
> > >
> > >1
> > >  
> > >
> > >3) Added the following datasource in cocoon.xconf
> > >
> > >  
> > >   
> > >   
> > >   jdbc:oracle:thin:@localhost:1521:ORCL2
> > >   noria
> > >   noria
> > >   
> > >  
> > >
> > >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

2002-01-27 Thread Luca Morandini 

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:
> >
> >  
> >default
> >
> >org.apache.catalina.servlets.DefaultServlet et-class>
> >
> >  debug
> >  0
> >
> >
> >  listings
> >  true
> >
> >
> >
> >
> >  load-class
> >  oracle.jdbc.driver.OracleDriver
> >
> >
> >1
> >  
> >
> >3) Added the following datasource in cocoon.xconf
> >
> >  
> > 
> > 
> > jdbc:oracle:thin:@localhost:1521:ORCL2
> > noria
> > noria
> > 
> >  
> >
> >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]>

Re: Oracle configuration with Tomcat 4.0.1

2002-01-27 Thread Marcelo F. Ochoa 

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:
>
>  
>default
>
>org.apache.catalina.servlets.DefaultServlet
>
>  debug
>  0
>
>
>  listings
>  true
>
>
>
>
>  load-class
>  oracle.jdbc.driver.OracleDriver
>
>
>1
>  
>
>3) Added the following datasource in cocoon.xconf
>
>  
>   
>   
>   jdbc:oracle:thin:@localhost:1521:ORCL2
>   noria
>   noria
>   
>  
>
>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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

RE: Oracle configuration with Tomcat 4.0.1

2002-01-27 Thread Vadim Gritsenko 

> From: Luca Morandini [mailto:[EMAIL PROTECTED]]
> 
> But cocoon refuses to cooperate, stating:

AFAIU, this has nothing to do with Cocoon...


> 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
>
> Any suggestion ?

technet.oracle.com have all required documentation about Oracle,
including translation of ORA-X into English. I highly recommend you
to go there and find out what all this means.

Vadim



-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

RE: Oracle configuration with Tomcat 4.0.1

2002-01-27 Thread Luca Morandini 

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:

  
default

org.apache.catalina.servlets.DefaultServlet

  debug
  0


  listings
  true




  load-class
  oracle.jdbc.driver.OracleDriver


1
  

3) Added the following datasource in cocoon.xconf

  


jdbc:oracle:thin:@localhost:1521:ORCL2
noria
noria

  

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.(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
>
> 
> load-class
> 
> ...
>
> 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
>
> 
> 
> false
> jdbc:oracle:thin:@localhost:1521:ORCL
> scott
> tiger
> 
>
> 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]>

Re: Oracle configuration with Tomcat 4.0.1

2002-01-27 Thread Nicolas Kessler 

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


load-class

...

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



false
jdbc:oracle:thin:@localhost:1521:ORCL
scott
tiger


Regards,
Nicolas



-
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Oracle configuration with Tomcat 4.0.1

2002-01-27 Thread Luca Morandini 

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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>