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-
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
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?