aspose file tools*
The moose likes JForum and the fly likes Exception after clickin on recent topics link Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Exception after clickin on recent topics link" Watch "Exception after clickin on recent topics link" New topic
Author

Exception after clickin on recent topics link

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi all,

another thing, that probably could not be called problem, but...

If I click on the recent topics link, everything works OK, I see these topics. But there is an exception in the log file:



This happens as DBUtils tries to close the statement and clear warnings. Could anyone help?

Thanks in advance

August
[originally posted on jforum.net by August]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
You might be using an older version of the c3p0*.jar file. There are some reports of this happening with older versions.

Alternatively, it could be the result of "stale" connections in the pool. DB servers (and occationally JDBC drivers) have connection timeout rules. This means that the c3p0 pool might have connections that have been closed remotely. Generally this type of error will be logged but the the pool just gets a new connection and everthing works.

To get rid of errors like this you may need to play with the C3P0 settings in the jforum config file. One to start with is: database.ping.delay This defines the number of seconds between "checks" of idle connections. This needs to be less than your jdbc/server connection time out.

In addition, there are a bunch of c3p0 specific initialization parameters that can be used here. See:

http://www.mchange.com/projects/c3p0/index.html

These can be added via the jforum config file property: c3p0.extra.params. The value of this is a string of c3po settings separated by semi-colons (;). E.g, p1=v1;p2=v2;..

data
[originally posted on jforum.net by monroe]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exception after clickin on recent topics link