cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 2190] New: - unable to use connection pooling in esql
Date Thu, 14 Jun 2001 22:24:43 GMT
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


Mime
View raw message