[jboss-user] [jBPM] - jBPM 4.4 on sybase

[Aldo A]

Aldo A [http://community.jboss.org/people/rotsoft] created the discussion

"jBPM 4.4 on sybase"

To view the discussion, visit: http://community.jboss.org/message/557138#557138

--------------------------------------------------------------
I get this error when I´m deploying a process definition on sybase 12.5.2


ADVERTENCIA: SQL Error: 0, SQLState: JZ006
GRAVE: JZ006: Se ha detectado IOException: java.io.IOException: JZ0SL: Tipo SQL no admitido: 2005.
GRAVE: Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.pvm.internal.repository.DeploymentImpl]
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2295)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2688)
    at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
    at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
    at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1141)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.jbpm.pvm.internal.query.AbstractQuery.execute(AbstractQuery.java:93)
    at org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.execute(ProcessDefinitionQueryImpl.java:67)
    at org.jbpm.pvm.internal.query.AbstractQuery.untypedList(AbstractQuery.java:67)
    at org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.list(ProcessDefinitionQueryImpl.java:157)
    at org.jbpm.pvm.internal.repository.ProcessDeployer.checkKey(ProcessDeployer.java:133)
    at org.jbpm.pvm.internal.repository.ProcessDeployer.deploy(ProcessDeployer.java:92)
    at org.jbpm.pvm.internal.repository.DeployerManager.deploy(DeployerManager.java:46)
    at org.jbpm.pvm.internal.repository.RepositorySessionImpl.deploy(RepositorySessionImpl.java:62)
    at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:47)
    at org.jbpm.pvm.internal.cmd.DeployCmd.execute(DeployCmd.java:33)
    at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
    at org.jbpm.pvm.internal.tx.SpringCommandCallback.doInTransaction(SpringCommandCallback.java:45)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
    at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49)
    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
    at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
    at org.jbpm.pvm.internal.repository.DeploymentImpl.deploy(DeploymentImpl.java:90)


Caused by: java.sql.SQLException: JZ006: Se ha detectado IOException: java.io.IOException: JZ0SL: Tipo SQL no admitido: 2005.
    at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
    at com.sybase.jdbc3.jdbc.ErrorMessage.raiseErrorCheckDead(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.language(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybStatement.sendQuery(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybPreparedStatement.sendQuery(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeUpdate(Unknown Source)
    at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2275)
    ... 113 more


GRAVE: JDBC rollback failed
com.sybase.jdbc3.jdbc.SybSQLException: A wrong datastream has been sent to the server. The server was expecting token 32 but got the token 33. This is an internal error.
    at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.new(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.doCommand(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.endTransaction(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybConnection.rollback(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybConnectionProxy.rollback(Unknown Source)
    at com.sun.gjc.spi.base.ConnectionHolder.rollback(ConnectionHolder.java:603)
    at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:217)
    at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:196)
    at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:676)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:845)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822)
    at org.springframework.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:161)
    at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:134)
    at org.jbpm.pvm.internal.tx.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:49)
    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
    at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
    at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
    at org.jbpm.pvm.internal.repository.DeploymentImpl.deploy(DeploymentImpl.java:90)

It is necesary to change hibernate mappings ?

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/557138#557138]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100812/16913929/attachment-0001.html