Hey guys,
I tried to explore a bit the possibility of hibernate in tomcat, but some things aren't that clear for me.
Before hitting the specific questions, please explain what is hibernate
in Tomcat, when do we want to use it, how do I use it specifically with
the JDBC connection pool (instead of the default DBCP connection pool),
and if misconfiguration of the hibernate can cause disconnections of
users on the application (that uses tomcat).
Now for 2 specific questions, if I may :]
1. in this article, its
states that hibernate can be used for managing the JDBC connection
pool, but the strings are for c3p0 pool-
http://community.jboss.org/wiki/UsingHibernatewithTomcat
why is that?
can I use both c3p0 settings with Datasource pool (JNDI?) ?
2.
Do I have to use hibernate.properties file, or can I rename it to
x.properties and still use the content of the hibernate settings?
Errors in my application when there are disconnections (between
client and app server, that caused by disconnections between app server
and DB), that leads me to think there's a problem with the hibernate
settings:
* ERROR, hibernate.transaction.
JDBCTransaction JDBC begin failed javasql.SQLException: Invalid state, the Connection object is closed.
* org.hibernate.util.JDBCExceptionReporter , Timeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[0 in use]
* WARN, hibernate.util.JDBCExceptionReporter SQL Error: 0, SQLState: 08S01
ERROR, hibernate.util.JDBCExceptionReporter I/O Error: DB server closed connection.
ERROR, error processing request: exception.*appname*Error: .hibernate.exception.JDBCConnectionException: Cannot open connection
Does my hunch is correct, and I need to change hibernate settings
for the disconnections to stop from occuring? or is it something else?
Thanks