Duplicate entry on token id generator

[tslusser]

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

[tslusser]

Update -- I think we may have solved the problem by reducing the pooled connection to 1 instance. Since making this change we haven't run into the duplicate key problem.

Regards,

Ted

[tslusser]

Update Again ---

This did NOT solve the problem. Does anyone have any idea what I might be doing wrong? I'm using the default SequenceBlockIdGenerator but somehow it gets confused and tries to reissue a used primary key id.

Thanks,

Ted