You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Giuseppe De Vincenzi <gi...@tiscalinet.it> on 2002/03/01 11:35:24 UTC
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" <lu...@tin.it>
To: <co...@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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Problem1 configure Cocoon2 Oracle8
Posted by yuryx <yu...@mobicomk.donpac.ru>.
Giuseppe De Vincenzi wrote:
>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
>
Hi
see cocoon/WEB-INF/logs/coreXXXXXX.log. If driver or parameters is valid
then must be present following lines:
DEBUG (2002-03-01) 13:47.04:566 [core] (Unknown-URI)
Unknown-thread/LogKitLogger: JdbcConnection object created
You can found error defenition also.
If you founded JdbcConection error then sent me this file.
Regards
Yury
>
>----------------------------------------------------------------------------
>----------
>Thank you very much.
>Giuseppe.
>
>
>----- Original Message -----
>From: "Luca Morandini" <lu...@tin.it>
>To: <co...@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: <co...@xml.apache.org>
>>>For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
>>For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
>For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: Problem1 configure Cocoon2 Oracle8
Posted by Luca Morandini <lu...@tin.it>.
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" <lu...@tin.it>
> To: <co...@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: <co...@xml.apache.org>
> > > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>