Hi Antony,
look in web-inf/web.xml and search for <param-name>load-class</param-name>. The text entry org.hsqldb.jdbcDriver must exist in the <param-value> element. This loads the HSQLDB driver. Then look in cocoon.xconf and search for <datasources>. The name <jdbc name="personnel"> must match the connection name appearing in the ESQL connection elements in the example stylesheets. Further more, the <dburl> should look like the following:

      <dburl>jdbc:hsqldb:<path-to-cocoon>\cocoon\WEB-INF\db\cocoondb</dburl>

I am not a Cocoon nor a Java expert but this configuration works on my PC.

Regards, Mario



Antony Stace wrote:
[EMAIL PROTECTED]">
I have installed Tomcat-4.0 and Cocoon-2.0B2.  I have compiled and run
the example webapp which comes with the Cocoon distribution. All the
examples on this page which have SQL access in them seem to fail, all
the other examples I run fine. Is this happening to anyone else? Or is
it a problem with how I have installed it. Here is part of the error
log which I think is relevant to this problem.

[snip]
/webapps/cocoon/stylesheets/dynamic-page2html.xsl'
DEBUG 10010 [cocoon ] (HttpProcessor[8080][3]): Using stylesheet:
'file:/va
r/tomcat/webapps/cocoon/stylesheets/dynamic-page2html.xsl' in
org.apache.cocoon.
transformation.TraxTransformer@4b1fda, last modified: 1001053991000
DEBUG 10010 [cocoon ] (HttpProcessor[8080][3]): MRUMemoryStore
getting obje
ct from memory. Key:
file:/var/tomcat/webapps/cocoon/stylesheets/dynamic-page2ht
ml.xsl
DEBUG 10010 [cocoon ] (HttpProcessor[8080][3]): Reusing Templates
in org.ap
ache.cocoon.transformation.TraxTransformer@4b1fda for
file:/var/tomcat/webapps/c
ocoon/stylesheets/dynamic-page2html.xsl
ERROR 10010 [cocoon ] (HttpProcessor[8080][3]): Could not return
Connection
java.lang.IllegalStateException: You cannot get a Poolable before the
pool is in
itialized
at
org.apache.avalon.excalibur.pool.DefaultPool.get(DefaultPool.java:107
)
at
org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcCon
nectionPool.java:70)
at
o rg.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(J
dbcDataSource.java:112)
[snip]



Cheers

Tony

giacomo wrote:
On Wed, 19 Sep 2001, Morrison, John wrote:

It works - you've just got to watch out for xml parsers and substitute
xerces/xalan where required.
I have the latest CVS version running WITHOUT any modification
concerning jars. Just followed the BUILDING.txt doc and preparing a
build.properties file with all the jars needed to build TC4.

---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>





---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>



Reply via email to