we want to use last version of hibernate because we need proxool. We were using dbcp in dev but looking at many posts, it seems to be dangerous to use it in production.

But this exception is thrown using the latest version in one of your use case:
net.sf.hibernate.PropertyValueException: not-null property references a null or transient value: com.xxx.xxx
it wasn't thrown before.

I don't want to talk about the mapping file and code because all the "business" tests have been passed and we want to avoid rework.

So my question is pretty simple: can we use C3P0 without problem or there is some bugs?

Thanks,
Anthony

This exception is not thrown for no reason ... it would be best to just fix it (which should be easy) ...

c3p0 is a good choice, IMO

in fact the problem is that, i'm sure it would not take a lot of time fixing our application but we don't have time to pass all the business test again ;-(

so for the application in production using version 2.0 (or previous) i'm gonna switch to c3p0.

All the recent apps, using hibernate 2.1 and more, are under developpement and will use proxool.... i think that is the best way.


Thanks Gavin