[jboss-user] [JBoss jBPM] - PROBLEMS About the database of jBPM BPEL

[gongdonghui]

hill
    i have a problem when i try to  use the  MySql as a datablase in jBPM BPEL insteadof HSQL database, 
The error information is 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:255)
	at org.hibernate.mapping.Column.getSqlType(Column.java:182)
	at org.hibernate.mapping.Table.sqlCreateString(Table.java:383)
	at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:884)
	at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
	at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:314)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1218)
	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)


and i have set database informatio in jbpm-bpel-ds.xml


 
  | <connection-url>jdbc:mysql://localhost:3306/jbpm-bpel?
  | useUnicode=true&amp;characterEncoding=gb2312</connection-url>
  |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |     <user-name>root</user-name>
  |     <password>571226</password>
  | 
  | 
  | 

i use the JBPM BPEL 1.0.1BETA 3 the jboss is JBOSS 4.0.5 GA
ant the jdk is 1.5.0
      thanks for you help!!

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

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