[jboss-user] [JBoss jBPM] - BPEL error: varbinary is incompatible with text
Hello,
When I run my BPEL process, I get this error -
| 13:26:03,481 ERROR [StartListener] request delivery failed due to non-recoverable
exception, giving up
| org.jbpm.JbpmException: problem closing services
{persistence=org.hibernate.exception.DataException: could not insert co
| llection: [org.jbpm.bpel.variable.exe.MessageValue.parts#76]}
| at org.jbpm.svc.Services.close(Services.java:245)
| at org.jbpm.JbpmContext.close(JbpmContext.java:139)
| at
org.jbpm.bpel.integration.jms.StartListener.deliverRequest(StartListener.java:237)
| at
org.jbpm.bpel.integration.jms.StartListener.onMessage(StartListener.java:168)
| at org.jboss.mq.SpyMessageConsumer.run(SpyMessageConsumer.java:696)
| at java.lang.Thread.run(Thread.java:595)
|
root cause -
| Caused by: java.sql.SQLException: Operand type clash: varbinary is incompatible with
text
| at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
| at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
| at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
| at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
| at
net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
| at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
| at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:421)
| at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:251)
| at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
| at
org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1146
| )
|
Searching on the web about this error didn't provide me much useful information. Can
someone please help me understand what this means and where could it be coming from?
Thank you,
Meghana.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4129268#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...