[jboss-user] [JBoss jBPM] - jbpm-bpel-1.1.Beta3 + oracle10g

[cocogg]

hi,
I have no problem on run jbpm-bpel-1.1.Beta3's sample(hello) with default db, but I want use Oracle db, I change the hibernate.cfg.xml and jbpm-bpel-ds.xml, when I deploy the jpbm-bpel.sar ,I get a exception.I confused whether I made a mistake, or jbpm-bpel-1.1.Beta3 didn't support other db.I whould appreciate if some on can give me a answer.
----------------------------------------------------------------------------
org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
        at org.hibernate.dialect.Dialect.getTypeName(Dialect.java:241)
        at org.hibernate.mapping.Column.getSqlType(Column.java:181)
        at org.hibernate.mapping.Table.sqlCreateString(Table.java:383)
        at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:879)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
        at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:311)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1213)
        at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
        at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
        at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
        at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:281)
        at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:526)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
        at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
        at org.hibernate.dialect.Dialect.getTypeName(Dialect.java:241)
        at org.hibernate.mapping.Column.getSqlType(Column.java:181)
        at org.hibernate.mapping.Table.sqlCreateString(Table.java:383)
        at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:879)
        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
        at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:311)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1213)
        at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
        at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
        at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
        at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:281)
        at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:526)
        at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
        at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4098178#4098178

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