[Netarchivesuite-devel] ResourcePool

aponb at gmx.at aponb at gmx.at
Wed Apr 13 16:05:10 CEST 2011


The mysql jar was never bundled before (I think due to some rights 
issues ?). I added  it to my classpath and also included it in my 
build.xml. But maybe it is an version issue. Which version did you use. 
I can't see it in the trunk.

> Andreas,
>
> I think the MySQL JDBC driver JAR is not in your classpath. It is not 
> bundled with NAS. I have added it and modified build.xml, then 
> regenerated a fresh NetArchiveSuite.zip and it works fine.
>
> Nicolas
>
> 2011/4/13 <aponb at gmx.at <mailto:aponb at gmx.at>>
>
>     Hi Colin!
>
>     Thx for replying.
>     Yes I can connect to the database. That works fine.
>
>     Regards
>     a.
>
>     > Can you connect to your database from the command line?
>     > Colin
>     >
>     > On 2011-04-13 14:33, aponb at gmx.at <mailto:aponb at gmx.at> wrote:
>     >> Hi!
>     >>
>     >> Any quick hint what the reason is?
>     >> Just checked out, rebuilt and deployed with my
>     deploy_standalone.xml
>     >> settings from last version.
>     >>
>     >> Regards
>     >> a.
>     >>
>     >>
>     >> 13.04.2011 14:11:24
>     >> dk.netarkivet.harvester.datamodel.HarvestDBConnection
>     initDataSource
>     >> INFO: Connection pool initialized with the following values:
>     >> - minPoolSize=5
>     >> - maxPoolSize=10
>     >> - acquireIncrement=5
>     >> - maxStatements=0
>     >> - maxStatementsPerConnection=0
>     >> 13.04.2011 14:11:53
>     >> dk.netarkivet.harvester.datamodel.HarvestDBConnection get
>     >> WARNUNG: Can't connect to database with DBurl:
>     >> 'jdbc:mysql://localhost:3306/fullhddb?user=xxx&password=xxx' using
>     >> driver 'com.mysql.jdbc.Driver'
>     >> SQLException trace:
>     >> SQL State:null
>     >> Error Code:0
>     >> java.sql.SQLException: Connections could not be acquired from the
>     >> underlying database!
>     >>            at
>     com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
>     >>            at
>     >>
>     com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
>     >>            at
>     >>
>     com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
>     >>            at
>     >>
>     dk.netarkivet.harvester.datamodel.HarvestDBConnection.get(HarvestDBConnection.java:103)
>     >>            at
>     >>
>     dk.netarkivet.harvester.datamodel.TemplateDBDAO.<init>(TemplateDBDAO.java:64)
>     >>            at
>     >>
>     dk.netarkivet.harvester.datamodel.TemplateDAO.getInstance(TemplateDAO.java:53)
>     >>            at
>     >>
>     dk.netarkivet.harvester.webinterface.DefinitionsSiteSection.initialize(DefinitionsSiteSection.java:92)
>     >>            at
>     >>
>     dk.netarkivet.common.webinterface.GUIWebServer.addWebApplication(GUIWebServer.java:161)
>     >>            at
>     >>
>     dk.netarkivet.common.webinterface.GUIWebServer.<init>(GUIWebServer.java:102)
>     >>            at
>     >>
>     dk.netarkivet.common.webinterface.GUIWebServer.getInstance(GUIWebServer.java:125)
>     >>            at
>     sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     >>            at
>     >>
>     sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>     >>            at
>     >>
>     sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>     >>            at java.lang.reflect.Method.invoke(Method.java:597)
>     >>            at
>     >>
>     dk.netarkivet.common.utils.ApplicationUtils.startApp(ApplicationUtils.java:170)
>     >>            at
>     >>
>     dk.netarkivet.common.webinterface.GUIApplication.main(GUIApplication.java:39)
>     >> Caused by:
>     com.mchange.v2.resourcepool.CannotAcquireResourceException: A
>     >> ResourcePool could not acquire a resource from its primary
>     factory or
>     >> source.
>     >>            at
>     >>
>     com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
>     >>            at
>     >>
>     com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
>     >>            at
>     >>
>     com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
>     >>            at
>     >>
>     com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
>     >>            ... 14 more
>     >> End of SQLException trace
>     >>
>     >> _______________________________________________
>     >> Netarchivesuite-devel mailing list
>     >> Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
>     <mailto:Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk>
>     >>
>     https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
>     > _______________________________________________
>     > Netarchivesuite-devel mailing list
>     > Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
>     <mailto:Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk>
>     >
>     https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
>     >
>
>     _______________________________________________
>     Netarchivesuite-devel mailing list
>     Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
>     <mailto:Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk>
>     https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel
>
>
>
>
> -- 
> Nicolas Giraud
> ---------------------------------------------------------------------------------------------
> Développeur Archives du Web - Bibliothèque Nationale de France
> Web Archiving Developper - National Library of France
> ---------------------------------------------------------------------------------------------
>
>
> _______________________________________________
> Netarchivesuite-devel mailing list
> Netarchivesuite-devel at lists.gforge.statsbiblioteket.dk
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/netarchivesuite-devel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ml.sbforge.org/pipermail/netarchivesuite-devel/attachments/20110413/93ca42a0/attachment-0002.html>


More information about the Netarchivesuite-devel mailing list