You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by bu...@apache.org on 2001/06/15 00:24:43 UTC
[Bug 2190] New: - unable to use connection pooling in esql
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=2190
*** shadow/2190 Thu Jun 14 15:24:43 2001
--- shadow/2190.tmp.20889 Thu Jun 14 15:24:43 2001
***************
*** 0 ****
--- 1,72 ----
+ +============================================================================+
+ | unable to use connection pooling in esql |
+ +----------------------------------------------------------------------------+
+ | Bug #: 2190 Product: Cocoon 2 |
+ | Status: NEW Version: 2.0alpha CVS |
+ | Resolution: Platform: PC |
+ | Severity: Major OS/Version: Linux |
+ | Priority: Other Component: core |
+ +----------------------------------------------------------------------------+
+ | Assigned To: cocoon-dev@xml.apache.org |
+ | Reported By: karl_hallowell@hp.com |
+ | CC list: Cc: |
+ +----------------------------------------------------------------------------+
+ | URL: |
+ +============================================================================+
+ | DESCRIPTION |
+ The esql.xsp example (which originally worked for me) has the following code for
+ connecting to a database:
+
+ ...
+ <esql:connection>
+ <esql:driver>oracle.jdbc.driver.OracleDriver</esql:driver>
+ <esql:dburl>jdbc:oracle:thin:@xxx.yyy.hp.com:1521:ORCL</esql:dburl>
+ <esql:username>scott</esql:username>
+ <esql:password>tiger</esql:password>
+ <esql:execute-query>
+ ...
+
+ ---------
+
+ I attempted the following:
+ in cocoon.xconf:
+
+ ...
+ <datasources>
+ <jdbc name="personnel">
+ ...
+ <pool-controller min="5" max="10" oradb="true"/>
+ ...
+ <auto-commit>false</auto-commit>
+
+ The default is true.
+ -->
+ <dburl>jdbc:oracle:thin:@dorado.rgv.hp.com:1521:ORCL</dburl>
+ <user>security</user>
+ <password>security</password>
+ </jdbc>
+ </datasources>
+ ...
+
+ Then I replaced the original code in esql.xsp with:
+
+ ...
+ <esql:connection>
+ <esql:pool>personnel</esql:pool>
+ <esql:execute-query>
+ ...
+
+ From what I know, this should work as well. Here's the exception I receive:
+
+ org.apache.cocoon.ProcessingException: Failed to execute
+ pipeline.:org.apache.cocoon.ProcessingException: Failed to execute
+ pipeline.:org.apache.cocoon.ProcessingException: Exception in
+ ServerPagesGenerator.generate():java.lang.RuntimeException:
+ Could not get the datasource java.sql.SQLException: You cannot
+ get a Poolable before the pool is initialized
+ extra info
+
+ From looking in the cocoon logs (cocoon.log) I see the same exception message
+ duplicated several times. I'll attach the cocoon.log (last 1300 or so lines -
+ it's big). This error has been reported in the cocoon-users mailing list. See
+ http://mailman.real-time.com/pipermail/cocoon-users/2001-June/015658.html.
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org