Can anyone shed some light on persisting large blobs (~1.5MB) with c3p0 version 0.9.0.2? My problem is this, if the database server and Tomcat server reside on the same machine there is no problem, but if they are on two separate machines connected through intranet my transaction seems to rollback intermittently. I've added SQL and JDBC debugging to my log4j settings and yet it tells me nothing except that it was marked for rollback.
I'm using Spring's JDO transaction management and the database is on a Microsoft SQL server. Is there perhaps a latency issue, is there some sort of timeout I can set. I've looked for a configuration property here:
But I cannot seem to find a fitting property.