Timothy Charman [https://community.jboss.org/people/tcharman] created the discussion "Re: Mina/C3P0" To view the discussion, visit: https://community.jboss.org/message/778282#778282 -------------------------------------------------------------- Hi Maciej Here's the stack 2012-11-26 10:24:36,964 1406614 [NioProcessor-1] DEBUG org.hibernate.SQL  - insert into I18NText (language, shortText, text) values (?, ?, ?) 2012-11-26 10:24:36,967 1406617 [NioProcessor-1] DEBUG com.mchange.v2.c3p0.stmt.GooGooStatementCache  - checkinStatement(): com.mchange.v2.c3p0.stmt.GlobalMaxOnlyStatementCache stats -- total size: 50; checked out: 0; num connections: 3; num keys: 50 2012-11-26 10:24:36,967 1406617 [NioProcessor-1] WARN  org.apache.mina.filter.logging.LoggingFilter  - EXCEPTION : java.lang.AbstractMethodError: com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.setCharacterStream(ILjava/io/Reader;J)V         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)         at java.lang.reflect.Method.invoke(Method.java:601)         at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)         at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)         at $Proxy26.setCharacterStream(Unknown Source)         at org.hibernate.type.descriptor.sql.ClobTypeDescriptor$3$1.doBind(ClobTypeDescriptor.java:83)         at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:92)         at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:280)         at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:275)         at org.hibernate.type.AbstractSingleColumnStandardBasicType.nullSafeSet(AbstractSingleColumnStandardBasicType.java:57)         at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2747)         at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2722)         at org.hibernate.persister.entity.AbstractEntityPersister$4.bindValues(AbstractEntityPersister.java:2929)         at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2936)         at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3447)         at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)         at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)         at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203)         at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183)         at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167)         at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:320)         at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:287)         at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:193)         at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)         at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)         at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)         at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)         at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:834)         at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:827)         at org.hibernate.engine.spi.EJB3CascadingAction$1.cascade(EJB3CascadingAction.java:52)         at org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:383)         at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:326)         at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:208)         at org.hibernate.engine.internal.Cascade.cascadeCollectionElements(Cascade.java:412)         at org.hibernate.engine.internal.Cascade.cascadeCollection(Cascade.java:353)         at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:329)         at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:208)         at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:165)         at org.hibernate.event.internal.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:448)         at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:293)         at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:193)         at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126)         at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)         at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)         at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)         at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)         at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:843)         at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:818)         at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:822)         at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:865)         at org.jbpm.task.service.persistence.TaskPersistenceManager.saveEntity(TaskPersistenceManager.java:220)         at org.jbpm.task.service.TaskServiceSession$1.doOperation(TaskServiceSession.java:191)         at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSession.java:1115)         at org.jbpm.task.service.TaskServiceSession.addTask(TaskServiceSession.java:189)         at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:151)         at org.jbpm.task.service.mina.MinaTaskServerHandler.messageReceived(MinaTaskServerHandler.java:41)         at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:716)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)         at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)         at org.apache.mina.filter.codec.ProtocolCodecFilter$ProtocolDecoderOutputImpl.flush(ProtocolCodecFilter.java:427)         at org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:245)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)         at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)         at org.apache.mina.filter.logging.LoggingFilter.messageReceived(LoggingFilter.java:177)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:46)         at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:796)         at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:119)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:434)         at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:426)         at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:692)         at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:645)         at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:634)         at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$400(AbstractPollingIoProcessor.java:66)         at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1078)         at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)         at java.lang.Thread.run(Thread.java:722) As I say, this is only a problem with MySql + c3p0 + Hibernate.  With MySql + Hibernate this works. -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/778282#778282] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Timothy Charman [https://community.jboss.org/people/tcharman] created the discussion "Re: Mina/C3P0" To view the discussion, visit: https://community.jboss.org/message/778294#778294 -------------------------------------------------------------- Hi Maciej Yes, I think you are right, c3p0 does not support this call even in the latest version.  However the query it is failing on was not in 5.4.0.CR1, it was changed due to the shortText field change which happened between 5.4.0.CR1 and 5.4.0.Final. We will try DBCP 1.4, which I think should work.  I wanted to post here in case anyone had a recommendation for which pool to use, and in case anyone else hits this error. -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/778294#778294] Start a new discussion in jBPM at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]