[jboss-user] [jBPM] - How to configure 4.3 the right way?

[Christian Moser]

Christian Moser [http://community.jboss.org/people/Krossi] replied to the discussion

"How to configure 4.3 the right way?"

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

--------------------------------------------------------------
Thank you for your replies!

Huisheng
I took the standard configuration for 4.3. Where can I decrease transaction isolation?

Maciej:
I added your configuration part to jbpm.hibernate.cfg.xml. The results are better, but 70 ms vs. 25 ms is not really good.

jbpm.hibernate.cfg.xml
<?xml version="1.0" encoding="utf-8"?>

<!DOCTYPE hibernate-configuration PUBLIC
          -//Hibernate/Hibernate Configuration DTD 3.0//EN
          http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd>

<hibernate-configuration>
    <session-factory>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpm</property>
        <property name="hibernate.connection.username">username</property>
        <property name="hibernate.connection.password">password</property>
        <property name="hibernate.hbm2ddl.auto">create-drop</property>
        <property name="hibernate.format_sql">true</property>
        <property name="hibernate.use_sql_comments">true</property>
        <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

        <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>
        <property name="hibernate.cache.use_second_level_cache">true</property>
        <property name="hibernate.cache.use_query_cache">true</property>

        <mapping resource="jbpm.repository.hbm.xml" />
        <mapping resource="jbpm.execution.hbm.xml" />
        <mapping resource="jbpm.history.hbm.xml" />
        <mapping resource="jbpm.task.hbm.xml" />
        <mapping resource="jbpm.identity.hbm.xml" />

        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
        <class-cache usage="nonstrict-read-write"/>
    </session-factory>
</hibernate-configuration>


Regards,
Christian

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

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

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/20100409/b7e0a0f2/attachment.html