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: [EMAIL PROTECTED] | + | Reported By: [EMAIL PROTECTED] | + | 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: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
