2 Replies Latest reply on Aug 11, 2005 7:17 AM by Ted Slusser

    Duplicate entry on token id generator

    Ted Slusser Newbie

      Hello,

      I'm getting intermittent problems when assigning ids for new states / process instances. I am using jBPM 2.0 and JBoss 3.2.7.

      I've configured the file jbpm-id-gen.properties to use c3p0 connection pool as follows:

      hibernate.connection.driver_class=com.mysql.jdbc.Driver
      hibernate.connection.username=user
      hibernate.connection.password=pw
      hibernate.connection.url=jdbc:mysql://localhost:3306/vero_app
      hibernate.c3p0.min_size=2
      hibernate.c3p0.max_size=5
      hibernate.c3p0.timeout=1800
      hibernate.c3p0.max_statements=50
      hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
      hibernate.show_sql=false
      hibernate.use_outer_join=true


      However, sometimes when moving a process instance thru the process or creating a new instance of the process I get an error regarding Duplicate Entry, and I suspect the id generation and it's interaction with transactions managed by JBoss.

      Has anyone experienced this problem in the past?

      Thanks,

      Ted Slusser