[Netarchivesuite-users] SQL Exception

[Søren Vejrup Carlsen]

Hi Peter.
I have now looked more into the issue.
It looks like MySQL (unlike embedded Derby) shuts down connections after having been idle for some time.

This problem is currently not addressed by the DBConnect.getDBConnection() method.
I have tried modified the class (the modified class is attached) to address this problem, but I don't know if it solves
the problem.

/Søren
> -----Original Message-----
> From: netarchivesuite-users-bounces at lists.gforge.statsbiblioteket.dk
> [mailto:netarchivesuite-users-bounces at lists.gforge.statsbiblio
> teket.dk]O
> n Behalf Of Peter Moser
> Sent: Friday, May 23, 2008 1:02 PM
> To: netarchivesuite-users at lists.gforge.statsbiblioteket.dk
> Subject: [Netarchivesuite-users] SQL Exception
> 
> 
> >
> > Hi Peter.
> > This looks like a MySQL issue.
> > What version of MySQL and MySQL connector are you using?
> >   
> I am running mysql  Ver 14.12 Distrib 5.0.45 and the 
> mysql-connector-java-5.0.8-bin.jar.
> Are there some known issues with mysql?
> _______________________________________________
> NetarchiveSuite-users mailing list
> NetarchiveSuite-users at lists.gforge.statsbiblioteket.dk
> https://lists.gforge.statsbiblioteket.dk/mailman/listinfo/neta
rchivesuite-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DBConnect.java
Type: application/octet-stream
Size: 35611 bytes
Desc: DBConnect.java
URL: <http://ml.sbforge.org/pipermail/netarchivesuite-users/attachments/20080523/a77357da/attachment-0002.obj>