[jboss-user] [JBoss jBPM] - BPEL error: varbinary is incompatible with text

meghanai_99 do-not-reply at jboss.com
Wed Feb 13 17:48:57 EST 2008


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#4129268

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4129268



More information about the jboss-user mailing list