topic activiti 5.0rc1 JPA Examples in Alfresco Archive

activiti 5.0rc1 JPA Examples

parul_vipparthi — Thu, 25 Nov 2010 04:03:15 GMT

HelloI get an exception when running JPAVariableTest included in the examples20:48:36,250 INF | ProcessEngine default created [org.activiti.engine.impl.ProcessEngineImpl]20:48:36,250 SEV | [org.activiti.e

Re: activiti 5.0rc1 JPA Examples

frederikherema1 — Thu, 25 Nov 2010 08:56:20 GMT

Hi parul,

Thanks for pointing that out! A file wasn't shipped with the distro examples, which causes this error you reported. In the next release which ships next week somewhere, this will be fixed.

For now, you can just add persistence.xml file manually to the /src/ folder in engine-examples, in folder 'META-INF':
/src/META-INF/persistence.xml

containing the folowing:

<persistence xmlns="http://java.sun.com/xml/ns/persistence"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
     version="1.0"
>
  <persistence-unit name="activiti-jpa-pu">
    <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
    
    <class>org.activiti.examples.variables.jpa.FieldAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.PropertyAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.SubclassFieldAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.SubclassPropertyAccessJPAEntity</class>
    <!– Mapped superclasses –>
    <class>org.activiti.examples.variables.jpa.MappedSuperClassFieldAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.MappedSuperClassPropertyAccessJPAEntity</class>
    
    <!– Variable types –>
    <class>org.activiti.examples.variables.jpa.ByteIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.ShortIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.IntegerIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.LongIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.FloatIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.DoubleIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.CharIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.StringIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.DateIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.SQLDateIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.BigIntegerIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.BigDecimalIdJPAEntity</class>
    
    <!– Exceptional entities –>
    <class>org.activiti.examples.variables.jpa.CompoundIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.EmbeddableCompoundId</class>
    
    <exclude-unlisted-classes>true</exclude-unlisted-classes>
    <properties>
      <property name="openjpa.ConnectionURL" value="jdbc:h2:mem:activiti-jpa;DB_CLOSE_DELAY=1000"/>
      <property name="openjpa.ConnectionDriverName" value="org.h2.Driver"/>
      <property name="openjpa.ConnectionUserName" value="sa"/>
      <property name="openjpa.ConnectionPassword" value=""/>
      <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
      <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction='add,deleteTableContents')"/>
    </properties>
  </persistence-unit>
</persistence>

Re: activiti 5.0rc1 JPA Examples

parul_vipparthi — Thu, 25 Nov 2010 11:12:47 GMT

Thanks for your reply.

I copied the code to persistence.xml in src directory., but i still get the same error.
Please help

parul

Re: activiti 5.0rc1 JPA Examples

frederikherema1 — Thu, 25 Nov 2010 11:14:51 GMT

Is it in the /src/META-INF/ folder? Are you running the tests from eclipse? Make sure the META-INF is included on test-classpatch when running the test.

Re: activiti 5.0rc1 JPA Examples

parul_vipparthi — Thu, 25 Nov 2010 11:20:45 GMT

ok my mistake., now i placed in src/META-INF folder. now i get another exception.

yes i am running examples from eclipse. i have attached console logs.
thanks
parul

Re: activiti 5.0rc1 JPA Examples

frederikherema1 — Thu, 25 Nov 2010 11:51:40 GMT

Looks like the test for a primary key of type BigDecimal goes wrong, value too large… Strange, because open JPA creates the table itself, should be big enough.

I see you are using MySQL, right? Did you alter the configuration for the datasource used by the entitymanager? If so, can you post it?

Re: activiti 5.0rc1 JPA Examples

parul_vipparthi — Thu, 25 Nov 2010 12:01:11 GMT

persistence.xml code


<persistence xmlns="http://java.sun.com/xml/ns/persistence"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
     version="1.0">
  <persistence-unit name="activiti-jpa-pu">
    <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
    
    <class>org.activiti.examples.variables.jpa.FieldAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.PropertyAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.SubclassFieldAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.SubclassPropertyAccessJPAEntity</class>
    <!– Mapped superclasses –>
    <class>org.activiti.examples.variables.jpa.MappedSuperClassFieldAccessJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.MappedSuperClassPropertyAccessJPAEntity</class>
    
    <!– Variable types –>
    <class>org.activiti.examples.variables.jpa.ByteIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.ShortIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.IntegerIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.LongIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.FloatIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.DoubleIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.CharIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.StringIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.DateIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.SQLDateIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.BigIntegerIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.BigDecimalIdJPAEntity</class>
    
    <!– Exceptional entities –>
    <class>org.activiti.examples.variables.jpa.CompoundIdJPAEntity</class>
    <class>org.activiti.examples.variables.jpa.EmbeddableCompoundId</class>
    
    <exclude-unlisted-classes>true</exclude-unlisted-classes>
    <properties>
      <property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/activiti"/>
      <property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
      <property name="openjpa.ConnectionUserName" value="activiti"/>
      <property name="openjpa.ConnectionPassword" value="activiti"/>
      <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
      <property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction='add,deleteTableContents')"/>
    </properties>
  </persistence-unit>
</persistence>

Thank u

Re: activiti 5.0rc1 JPA Examples

parul_vipparthi — Thu, 25 Nov 2010 12:04:11 GMT

apart from persistence.xml, i have not changed any other code from examples.

I see many entity tables are created in the db.

thanks

Re: activiti 5.0rc1 JPA Examples

parul_vipparthi — Thu, 25 Nov 2010 12:31:12 GMT

Even If I set the value of bigdecimal to a small one

    bigDecimalIdJPAEntity = new BigDecimalIdJPAEntity();
    bigDecimalIdJPAEntity.setBigDecimalId(new BigDecimal("123456789.12345"));
    manager.persist(bigDecimalIdJPAEntity);

It gave me many exceptions
console log is attached., pl help

Thank you
parul

Re: activiti 5.0rc1 JPA Examples

parul_vipparthi — Tue, 30 Nov 2010 04:20:49 GMT

Hello again,

Is this a bug or i made a mistake somewhere?
Please help.

Thank you
–
parul

Re: activiti 5.0rc1 JPA Examples

frederikherema1 — Tue, 30 Nov 2010 06:39:58 GMT

Parul,

The tables for all the entities in the JPAVariableTest are generated by OpenJPA. It seems like the BigDecimal primary key has a column that isn't big enough to fit the values.
Since MySQL is capable of storing BigDecimals without any problem, I presume it's because it's the primary key. The unique index that is being created for primary-keys has a limited size (I think it's about 700 bytes or something).

Our QA runs there tests on H2, MySQL, Postgres and Oracle on each commit. Guessing it might have something to do with encoding. Which type of DB are you using (InnoDB?).

Not sure if I can think of a quick solution. However, it is not a very big deal if this test doesn't run, since it's no issue in Activiti but more a OpenJPA-issue. The test is there to validate of we can use all kinds of entities with different types of id's in our variables. BigDecimals aren't commonly used as primary key, the test is just there because the JPA-spec allows this type.

Re: activiti 5.0rc1 JPA Examples

parul_vipparthi — Tue, 30 Nov 2010 08:29:41 GMT

That is so right.
Thank you for a reply.

–
parul