You may want to post this under a different subject - it doesn't seem to have anything to do with the JDK1.4 issue and will probably get ignored by people that may be able to answer the question.
Geoff Howard > -----Original Message----- > From: Sam [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 7:17 PM > To: [EMAIL PROTECTED] > Subject: Re: What are the problems with JDK 1.4? > > > Hi, > I've been playing with Cocoon 2 for a while now in my > spare time, it's > quite a piece of work, guys! Anyhow, even using the latest > source from CVS > with JDK1.3 the JDBC Pooling seems to have some strange > behaviour when more > than 1 datasource is involved. > > If I add another jdbc datasource to the cocoon.xconf file, > (in my example > I added a mysql database, using the latest mm Mysql driver) > cocoon seems to be > confused about which database to use when i go to the > forms/employee database > example. If I remove the new datasource, it works fine. The > same problem > exists on a page that I write that uses the new datasource - > for now my > workaround was simply to do away with HSQLdb, but I thought I > might mention it > - I would have thought multiple sources ought to be possible. > > --- snippet from cocoon.xconf --- > <datasources> > <jdbc name="gorb"> > <pool-controller max="10" min="5"/> > <dburl>jdbc:mysql://192.168.0.111/gorb</dburl> > <user>gorb</user> > <password>f1kus</password> > </jdbc> > <jdbc logger="core.datasources.personnel" name="personnel"> > <pool-controller max="10" min="5"/> > <dburl>jdbc:hsqldb:hsql://localhost:9002</dburl> > <user>sa</user> > <password/> > </jdbc> > </datasources> > > -- console errors from tomcat (4.0.1) when navigating to > forms/employee sample > URL -- > DriverManager.getConnection("jdbc:mysql://192.168.0.111/gorb") > trying > driver[className=org.gjt.mm.mysql.Driver,org.gjt.mm.mysql.Driv > er@2bc3f5] > getConnection returning > driver[className=org.gjt.mm.mysql.Driver,org.gjt.mm.mysql.Driv > er@2bc3f5] > DriverManager.getConnection("jdbc:hsqldb:hsql://localhost:9002") > trying > driver[className=org.gjt.mm.mysql.Driver,org.gjt.mm.mysql.Driv > er@2bc3f5] > getConnection: no suitable driver > java.sql.SQLException: No suitable driver > at java.sql.DriverManager.getConnection(DriverManager.java:537) > at java.sql.DriverManager.getConnection(DriverManager.java:177) > at > org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.< > init>(JdbcConnectionFactory.java:98) > > at > org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDat > aSource.configure(ResourceLimitingJdbcDataSource.java:292) > > at > org.apache.avalon.excalibur.component.DefaultComponentFactory. > newInstance(DefaultComponentFactory.java:191) > > at > org.apache.avalon.excalibur.component.ThreadSafeComponentHandl > er.initialize(ThreadSafeComponentHandler.java:104) > > at > org.apache.avalon.excalibur.component.ExcaliburComponentSelect > or.addComponent(ExcaliburComponentSelector.java:507) > > at > org.apache.avalon.excalibur.component.ExcaliburComponentSelect > or.configure(ExcaliburComponentSelector.java:336) > > at > org.apache.avalon.excalibur.component.DefaultComponentFactory. > newInstance(DefaultComponentFactory.java:191) > > at > org.apache.avalon.excalibur.component.ThreadSafeComponentHandl > er.initialize(ThreadSafeComponentHandler.java:104) > > at > org.apache.avalon.excalibur.component.ExcaliburComponentManage > r.initialize(ExcaliburComponentManager.java:157) > > at org.apache.cocoon.Cocoon.initialize(Cocoon.java:274) > at > org.apache.cocoon.servlet.CocoonServlet.createCocoon(CocoonSer > vlet.java:1221) > at > org.apache.cocoon.servlet.CocoonServlet.init(CocoonServlet.java:422) > at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper. > java:852) > at > org.apache.catalina.core.StandardContext.loadOnStartup(Standar > dContext.java:3267) > > at > org.apache.catalina.core.StandardContext.start(StandardContext > .java:3384) > at > org.apache.catalina.core.ContainerBase.addChild(ContainerBase. > java:785) > at > org.apache.catalina.core.StandardHost.addChild(StandardHost.ja > va:454) at > org.apache.catalina.core.StandardHost.install(StandardHost.java:712) > at > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:647) > at org.apache.catalina.startup.HostConfig.start(HostConfig.java:777) > at > org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConf > ig.java:463) > > at > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(L > ifecycleSupport.java:155) > > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.jav > a:1131) at > org.apache.catalina.core.StandardHost.start(StandardHost.java:612) > at > org.apache.catalina.core.ContainerBase.start(ContainerBase.jav > a:1123) at > org.apache.catalina.core.StandardEngine.start(StandardEngine.java:307) > at > org.apache.catalina.core.StandardService.start(StandardService > .java:388) > at > org.apache.catalina.core.StandardServer.start(StandardServer.java:505) > at org.apache.catalina.startup.Catalina.start(Catalina.java:776) > at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) > at org.apache.catalina.startup.Catalina.process(Catalina.java:179) > at java.lang.reflect.Method.invoke(Native Method) > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) > SQLException: SQLState(08001) > > > > > -- > Sam Coward, Systems Engineer, Golden Orb Technologies > http://www.golden-orb.com > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, email: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
