Hi:
I am using the hibernate-search 3.2.1,everything went well until this morning.

Since my application is now to be tested,so the app was started yesterday afternoon,it works well at first. But when I check it this morning,I got some exceptions:



After googling it,it is said that this is caused by the mysql connection pool.(the connection has been closed when it is checked out from the pool).

And in my hibernate.cfg.xml,I intended to use the c3p0,so this is the fragment:



But I am surprised when I check the hibernate-core-3.5.4.jar,there is no "C3P0ConnectionProvider" under the package:"org.hibernate.connection", also,in the log of my application,I have not found any c3p0 words.so I am confused:

1> Does the hibernate-search support connection pool? If so,is it mean I have add the ConnectionProvider manually?

2> If support,how to config the c3p0?
I know the basic config(in the above exmaple),but how about if I want to add some other c3p0 config properties? In my requirement,I need the following two properties:

Hibernate Search supports connection pooling, because it relies on Core which provides pooling. And yes you have to add the connection pool provider yourself. Connection pooling is a pluggable extension where you for example can chose between c3p0 and proxool. If you want to use the c3p0 you need to add the right dependency - https://repository.jboss.org/nexus/cont ... rnate-c3p0


The configuration is via the properties you have in your configuration file. That should be fine.

You mean I do not need extra work? The config I list is all?

But how about if I want to make c3p0 validate the connection when a connection is called?

There is a property named "testbeforecheckin" in c3p0,but I did not found the accoring property like "hibernate.c3p0.testbeforecheckin"? Where to add it?

Since the connection will closed when it is not alive for 8 hours.

All properties prefixed with hibernate.c3p0 will be passed on to c3p0