Hi, I'm an Apache Forrest newbie. I'm trying to setup forrest so I can perform queries against a MySQL database. I have searched for a "how-to", found various bits and pieces, but nothing seems to work.
I am running Apache Forrest 0.9-dev on Ubuntu 8.10. I read: http://wiki.apache.org/cocoon/MySQL http://wiki.apache.org/cocoon/MySQL and http://cocoon.apache.org/2.1/developing/datasources.html http://cocoon.apache.org/2.1/developing/datasources.html . I attempted to apply what I read from the above links to my Apache Forrest install. These are the steps I performed: 1. Installed JDBC driver: sudo apt-get install libmysql-java. 2. Copied the JDBC driver to the lib directory: cp /usr/share/java/mysql-connector-java-5.1.6.jar $FORREST_HOME/lib/ (I do not have a $COCOON_LIB/WEB-INF/lib directory as mentioned in the Cocoon Wiki doc). 3. Modified my $FORREST_HOME/main/webapp/WEB-INF/web.xml file as follows: <init-param> <param-name>load-class</param-name> <param-value> com.mysql.jdbc.Driver </param-value> </init-param> 4. Created a MySQL user for testing purposes. 5. Added the following to $FORREST_HOME/main/webapp/WEB-INF/cocoon.xconf: <datasources> <jdbc name="TestConnectionPool"> <pool-controller min="5" max="10"/> <dburl>jdbc:mysql://localhost:3306/test?autoReconnect=true</dburl> <user>TestUser</user> <password>TestPassword</password> </jdbc> </datasources> >From here I saved everything and tried to run forrest to build the included forrest seed example. I get this error: ------------------------------------------------------------------------ cocoon 2.1.12-dev Copyright (c) 1999-2007 Apache Software Foundation. All rights reserved. ------------------------------------------------------------------------ Exception in thread "main" org.apache.avalon.framework.configuration.ConfigurationException: Could not load class org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource for component named 'TestConnectionPool' at file:/home/syd/kcdocs/forrest/main/webapp/WEB-INF/cocoon.xconf:1070:37 at org.apache.cocoon.components.ExtendedComponentSelector.configure(ExtendedComponentSelector.java:236) at org.apache.avalon.framework.container.ContainerUtil.configure(ContainerUtil.java:201) at org.apache.avalon.excalibur.component.DefaultComponentFactory.newInstance(DefaultComponentFactory.java:289) at org.apache.avalon.excalibur.component.ThreadSafeComponentHandler.initialize(ThreadSafeComponentHandler.java:108) at org.apache.avalon.excalibur.component.ExcaliburComponentManager.initialize(ExcaliburComponentManager.java:524) at org.apache.cocoon.components.CocoonComponentManager.initialize(CocoonComponentManager.java:583) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244) at org.apache.cocoon.Cocoon.initialize(Cocoon.java:345) at org.apache.avalon.framework.container.ContainerUtil.initialize(ContainerUtil.java:244) at org.apache.cocoon.bean.CocoonWrapper.initialize(CocoonWrapper.java:177) at org.apache.cocoon.bean.CocoonBean.initialize(CocoonBean.java:102) at org.apache.cocoon.Main.main(Main.java:320) Caused by: java.lang.ClassNotFoundException: org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at org.apache.cocoon.components.ExtendedComponentSelector.configure(ExtendedComponentSelector.java:228) ... 11 more Do I need to install an "excalibur" package of some sort? I tried to install some Java connection pooling libraries, but this did not solve my problem. Is there a simple easy to follow "how-to" somewhere? Any help would be really appreciated. Thanks, Syd -- View this message in context: http://www.nabble.com/Apache-Forrest-and-MySQL-tp21687540p21687540.html Sent from the Apache Forrest - Users mailing list archive at Nabble.com.
