cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Luca Morandini" <luca.morandi...@tin.it>
Subject RE: Problem1 configure Cocoon2 Oracle8
Date Fri, 01 Mar 2002 11:00:43 GMT
Giuseppe,

as far as I've understood, you use a different driver (the JDBC-ODBC bridge)
for connecting to Oracle using JSP, is that so ?

Hence, it may be just the driver... could you try to use the JDBC thin
driver for JSP as well ? This would reduce the width of investigation.

By the way, Tomcat 4 doesn't like ZIP as an extension for JAR packages;
hence, if you hadn't already done this: rename classes12.zip in
classes12.jar and put it in $TOMCAT_HOME\common\lib.

Best regards,

---------------------------------------------
               Luca Morandini
               GIS Consultant
              lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------


> -----Original Message-----
> From: Giuseppe De Vincenzi [mailto:giuseppe.devincenzi@tiscalinet.it]
> Sent: Friday, March 01, 2002 11:35 AM
> To: cocoon-users@xml.apache.org; lmorandini@ieee.org
> Subject: Problem1 configure Cocoon2 Oracle8
>
>
> Hello,
>
> 1) First Tomcat4(JSP-Cocoon2) end Oracle on machine1 OK
>
> 2)Now, i use  this parameters(servername, port ,instance) with JSP ...
> [Tomcat 4(JSP) machine1 ]--> [Oracle 2000server]    OK
> [Tomcat4 (Cocoon2) machine1 ]  !NO! [Oracle 2000server] Could not get the
> datasource
> ------------------------------------------------------------------
> ----------
> ----------
> Thank  you very much.
> Giuseppe.
>
>
> ----- Original Message -----
> From: "Luca Morandini" <luca.morandini1@tin.it>
> To: <cocoon-users@xml.apache.org>
> Sent: Friday, March 01, 2002 10:46 AM
> Subject: RE: Problem configure Cocoon2 Oracle8
>
>
> > Giuseppe,
> >
> > you are absolutely sure that:
> >
> > servername is 2000server
> > port is 1521
> > instance name is oras
> >
> > aren't you ?
> >
> > By the way, is 2000server the same server Cocoon runs on... or is it a
> > different machine ?
> >
> > Best regards,
> >
> > ---------------------------------------------
> >                Luca Morandini
> >                GIS Consultant
> >               lmorandini@ieee.org
> > http://utenti.tripod.it/lmorandini/index.html
> > ---------------------------------------------
> >
> >
> > > -----Original Message-----
> > > From: Giuseppe De Vincenzi [mailto:giuseppe.devincenzi@tiscalinet.it]
> > > Sent: Friday, March 01, 2002 10:23 AM
> > > To: cocoon-users@xml.apache.org
> > > Subject: Problem configure Cocoon2 Oracle8
> > >
> > >
> > > Hello,
> > >
> > > Why, when i use this configuration, i connect Oracle
> > >
> > > web.xml (cocoon)
> > >         <init-param>
> > >         <param-name>load-class</param-name>
> > >         <param-value>
> > >          sun.jdbc.odbc.JdbcOdbcDriver
> > >          </param-value>
> > >
> > >  Coccon.xconf
> > >  <datasources>
> > >        <jdbc name="test_oracle_pool"
> logger="core.datasources.personnel">
> > >              <!-- Don't forget the oradb parameter for Oracle!!! -->
> > >        <pool-controller min="5" max="10" oradb="true"/>
> > >      <dburl> jdbc:odbc:PEPPE </dburl>
> > >      <user>dev</user>
> > >      <password>giu</password>
> > >      </jdbc>
> > >  <datasources>
> > > :-)
> > > OK
> > > -----------------------------------------------------------------
> > > bat, if i change in:
> > >
> > > <param-value>
> > >        oracle.jdbc.driver.OracleDriver
> > >       </param-value>
> > >
> > >
> > >  web.xml
> > >         <init-param>
> > >         <param-name>load-class</param-name>
> > >         <param-value>
> > >          oracle.jdbc.driver.OracleDriver
> > >         </param-value>
> > >
> > >  Coccon.xconf
> > >  <datasources>
> > >        <jdbc name="test_oracle_pool"
> logger="core.datasources.personnel">
> > >              <!-- Don't forget the oradb parameter for Oracle!!! -->
> > >       <pool-controller min="5" max="10" oradb="true"/>
> > >      <dburl>jdbc:oracle:thin:@2000server:1521:oras</dburl>
> > >      <user>dev</user>
> > >      <password>giu</password>
> > >      </jdbc>
> > >  <datasources>
> > > ERROR.....
> > > ERROR.....
> > > ERROR.....
> > > ERROR.....
> > > ERROR.....
> > > java.lang.RuntimeException: Could not get the datasource
> > > java.sql.SQLException: You cannot get a Poolable before the pool is
> > > initialized...??????????????????????????????????????????????????????
> > > --------------------------------------------------------------------
> > >  The database driver is classes12.jar and I am able to connect to the
> same
> > >  database with same driver with standalone java application.
> > >  Environment is Tomcat 4,  C2( cocoon.war) & windows2000
> > >
> > > CATALINA_HOME C:\Programmi\Apache Tomcat 4.0;
> > > CLASSPATH C:\Programmi\Apache Tomcat 4.0\webapps\ROOT;
> > > TEMP %USERPROFILE%\Impostazioni locali\Temp
> > > JAVA_HOME C:\jdk1.3.1\bin;
> > > NUMBER_OF_PROCESSORS 1
> > > OS Windows_NT
> > > Os2LibPath %SystemRoot%\system32\os2\dll;
> > > Path
> > > C:\orant\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\
> > > Programmi\
> > > File comuni\Adaptec Shared\System;
> > > PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
> > > PROCESSOR_ARCHITECTURE x86
> > > PROCESSOR_IDENTIFIER x86 Family 6 Model 4 Stepping 2, AuthenticAMD
> > > PROCESSOR_LEVEL 6
> > > PROCESSOR_REVISION 0402
> > > PROMPT $p$g
> > > TEMP %SystemRoot%\TEMP
> > > TMP %SystemRoot%\TEMP
> > > TOMCAT_HOME C:\Programmi\Apache Tomcat 4.0;
> > > windir %SystemRoot%
> > >
> > >  Thank you !
> > > Giuseppe.
> > >
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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: <cocoon-users-unsubscribe@xml.apache.org>
> > > For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> > >
> >
> >
> > ---------------------------------------------------------------------
> > 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: <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> >
> >
>
>
>
>
>
> ---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
>


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message