problem creating new openxava project

[Ron King]

Hi All,

I'm trying to create a project from a pretty complicated mysql
database with 32 tables. When running the generated project, I get the
stack trace below when I click on a table. Any advice on how to
correct this? Do I need to include more information? Thanks!


javax.persistence.PersistenceException: [PersistenceUnit: default]
Unable to configure EntityManagerFactory
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:
378)

org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:
56)

javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:
63)

org.openxava.jpa.XPersistence.getEntityManagerFactory(XPersistence.java:
182)
org.openxava.jpa.XPersistence.createManager(XPersistence.java:108)

org.openxava.annotations.parse.AnnotatedClassParser.obtainManagedClassNamesUsingJPA(AnnotatedClassParser.java:
2449)

org.openxava.annotations.parse.AnnotatedClassParser.getManagedClassNames(AnnotatedClassParser.java:
2365)

org.openxava.annotations.parse.AnnotatedClassParser.getClassNameFor(AnnotatedClassParser.java:
2317)

org.openxava.annotations.parse.AnnotatedClassParser.parse(AnnotatedClassParser.java:
66)

org.openxava.component.ComponentParser.parseAnnotatedClass(ComponentParser.java:
47)
org.openxava.component.ComponentParser.parse(ComponentParser.java:36)
org.openxava.component.MetaComponent.get(MetaComponent.java:60)

org.openxava.controller.ModuleManager.setModuleName(ModuleManager.java:
1000)
org.apache.jsp.xava.home_jsp._jspService(home_jsp.java:168)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:
342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

root cause

org.hibernate.AnnotationException: mappedBy reference an unknown
target entity property:
techconf.techconf.domain.techconf.Grouppricingrule.pkId in
techconf.techconf.domain.techconf.Pricingrule.grouppricingrulePricingruleViaPkId

org.hibernate.cfg.annotations.CollectionBinder.bindStarToManySecondPass(CollectionBinder.java:
685)
org.hibernate.cfg.annotations.CollectionBinder
$1.secondPass(CollectionBinder.java:645)

org.hibernate.cfg.CollectionSecondPass.doSecondPass(CollectionSecondPass.java:
65)

org.hibernate.cfg.Configuration.originalSecondPassCompile(Configuration.java:
1716)
org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:
1423)
org.hibernate.cfg.Configuration.buildMappings(Configuration.java:
1375)

org.hibernate.ejb.Ejb3Configuration.buildMappings(Ejb3Configuration.java:
1519)

org.hibernate.ejb.EventListenerConfigurator.configure(EventListenerConfigurator.java:
193)
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:
1100)
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:
282)
org.hibernate.ejb.Ejb3Configuration.configure(Ejb3Configuration.java:
366)

org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:
56)

javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:
63)

org.openxava.jpa.XPersistence.getEntityManagerFactory(XPersistence.java:
182)
org.openxava.jpa.XPersistence.createManager(XPersistence.java:108)

org.openxava.annotations.parse.AnnotatedClassParser.obtainManagedClassNamesUsingJPA(AnnotatedClassParser.java:
2449)

org.openxava.annotations.parse.AnnotatedClassParser.getManagedClassNames(AnnotatedClassParser.java:
2365)

org.openxava.annotations.parse.AnnotatedClassParser.getClassNameFor(AnnotatedClassParser.java:
2317)

org.openxava.annotations.parse.AnnotatedClassParser.parse(AnnotatedClassParser.java:
66)

org.openxava.component.ComponentParser.parseAnnotatedClass(ComponentParser.java:
47)
org.openxava.component.ComponentParser.parse(ComponentParser.java:36)
org.openxava.component.MetaComponent.get(MetaComponent.java:60)

org.openxava.controller.ModuleManager.setModuleName(ModuleManager.java:
1000)
org.apache.jsp.xava.home_jsp._jspService(home_jsp.java:168)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:
374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:
342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

[Florian Adler]

Hi Ron,

From the stack trace, I think you are generating for OpenXava technology; I guess you are using the console where model name and package name to 'techconf'.

Normally this is fine for Mysql, but I prefer run minuteproject via a command line with a configuration file (this allow to have convention such as simplification of foreign key name (ex: grouppricingrulePricingruleViaPkId) when there is no ambiguity).

For your problem a quick overview with the elements I have, there is a issue finding some relationship occuring when Openxava start the hibernate load of the configuration.
It would mean that there is an error in the JPA2 configuration.

It may comes from some limitations on the DB model when generating towards OX or JPA2: Minuteproject does not support yet foreign key on multiple column (except for Many-to-many).

Could you tell me how are made the primary-key and foreign-key on your domain.
You can also open your project in Openxava workspace I guess 'techconf'.

Best regards,

Florian.

2012/8/20 Ron King <ronc...@gmail.com>

[Ron King]

Yes, I'm going for an OpenXava project, and I tried both a config file/command line, and the console method of generating the project.
The sql schema is pretty big, about 500 lines long, so I don't want to post it without asking you first. Should I include
it directly in a post, or email it to you? I appreciate the help on this, and I think it will be a good test of MP on a medium-size schema, thanks!

[Florian Adler]

Yes no problem you can send me the schema. But the schema structure will be public since I may reference it in some mail.
The schema has to be created by a mysql command.

[Ron King]

I think I'm starting out too fast. I want to just learn how to use the tool, so maybe you can help me with a more familiar scenario. The lazuly project doesn't work with MP 0.8.2 , here's the error below. Can you help me to get lazuly to work with MP 0.8.2 and OX 4.5?

;..\..\application\lib\minuteKernel-0.8.2.jar;..\..\application\lib\activation.jar;..\..\application\lib\commons-beanutils-1.7.jar;..\..\application\lib\commons-beanutils-bean-collections-1.7.jar;..\..\application\lib\commons-beanutils-core-1.7.jar;..\..\application\lib\commons-betwixt-0.7.jar;..\..\application\lib\commons-collections-3.1.jar;..\..\application\lib\commons-dbcp-1.2.1.jar;..\..\application\lib\commons-dbutils-1.0.jar;..\..\application\lib\commons-digester-1.6.jar;..\..\application\lib\commons-lang-2.6.jar;..\..\application\lib\commons-logging-1.0.3.jar;..\..\application\lib\commons-logging-api-1.0.3.jar;..\..\application\lib\commons-pool-1.3.jar;..\..\application\lib\DdlUtils-1.0.jar;..\..\application\lib\dom4j-1.6.1.jar;..\..\application\lib\FastInfoset.jar;..\..\application\lib\gmbal-api-only.jar;..\..\application\lib\groovy-all-1.8.0.jar;..\..\application\lib\http.jar;..\..\application\lib\jaxb-api.jar;..\..\application\lib\jaxb-impl.jar;..\..\application\lib\jaxb-xjc.jar;..\..\application\lib\jaxws-api.jar;..\..\application\lib\jaxws-rt.jar;..\..\application\lib\jaxws-tools.jar;..\..\application\lib\jsr173_api.jar;..\..\application\lib\jsr181-api.jar;..\..\application\lib\jsr250-api.jar;..\..\application\lib\junit-4.8.1.jar;..\..\application\lib\junit-dep-4.8.1.jar;..\..\application\lib\log4j-1.2.12.jar;..\..\application\lib\management-api.jar;..\..\application\lib\miglayout-3.7.3.1.jar;..\..\application\lib\mimepull.jar;..\..\application\lib\minuteConsole-0.8.2.jar;..\..\application\lib\minuteFoundation-0.8.2.jar;..\..\application\lib\minuteKernel-0.8.2.jar;..\..\application\lib\policy.jar;..\..\application\lib\resolver.jar;..\..\application\lib\saaj-api.jar;..\..\application\lib\saaj-impl.jar;..\..\application\lib\servlet.jar;..\..\application\lib\stax-ex.jar;..\..\application\lib\streambuffer.jar;..\..\application\lib\velocity-1.6.4-dep.jar;..\..\application\lib\velocity-1.6.4.jar;..\..\application\lib\woodstox.jar;..\..\application\lib\xalan-2.4.1.jar;..\..\application\lib\xerces-2.6.2.jar;..\..\application\lib\xercesImpl.jar;..\..\application\lib\xml-apis.jar;..\..\application\lib\xmlParserAPIs.jar;..\..\application\lib\extra\db2jcc.jar;..\..\application\lib\extra\db2jcc_license_cu.jar;..\..\application\lib\extra\derbyclient.jar;..\..\application\lib\extra\hsqldb-1.8.0.7.jar;..\..\application\lib\extra\mysql.jar;..\..\application\lib\extra\ojdbc14.jar;..\..\application\lib\extra\sqlitejdbc-v056.jar;config\
0    [main] INFO  net.sf.minuteProject.application.ModelGenerator  - start time = Tue Aug 21 11:58:30 CDT 2012
892  [main] INFO  net.sf.minuteProject.application.AbstractGenerator  - >template target set: JPA set in /src
892  [main] INFO  net.sf.minuteProject.application.AbstractGenerator  - >>template: OpenxavaDomainObjectUML in ../../DEV/output/openxava/conference/src
1284 [main] ERROR net.sf.minuteProject.application.ModelGenerator  - ERROR on template OpenxavaDomainObjectUML - on bean conference
org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getListProperties' in  class net.sf.minuteProject.plugin.openxava.OpenXavaUtils threw exception java.lang.NullPointerException at DomainObjectUMLJPAAnnotationOXAnnotationV4.vm[line 301, column 37]
    at org.apache.velocity.runtime.parser.node.ASTMethod.handleInvocationException(ASTMethod.java:337)
    at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:284)
    at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:262)
    at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:507)
    at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71)
    at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142)
    at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
    at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
    at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:106)
    at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
    at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
    at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
    at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:366)
    at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175)
    at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
    at org.apache.velocity.Template.merge(Template.java:328)
    at org.apache.velocity.Template.merge(Template.java:235)
    at net.sf.minuteProject.application.AbstractGenerator.writeFile(AbstractGenerator.java:405)
    at net.sf.minuteProject.application.AbstractGenerator.produce(AbstractGenerator.java:364)
    at net.sf.minuteProject.application.ModelGenerator.writeTemplateResult(ModelGenerator.java:462)
    at net.sf.minuteProject.application.ModelGenerator.generateArtifactsByEntity(ModelGenerator.java:362)
    at net.sf.minuteProject.application.ModelGenerator.generateArtifactsByEntity(ModelGenerator.java:355)
    at net.sf.minuteProject.application.ModelViewGenerator.generateArtifactsByEntity(ModelViewGenerator.java:78)
    at net.sf.minuteProject.application.ModelGenerator.generate(ModelGenerator.java:258)
    at net.sf.minuteProject.application.AbstractGenerator.generate(AbstractGenerator.java:243)
    at net.sf.minuteProject.application.ModelGenerator.applyTargetConventionAndGenerate(ModelGenerator.java:225)
    at net.sf.minuteProject.application.ModelGenerator.loadAndGenerate(ModelGenerator.java:213)
    at net.sf.minuteProject.application.ModelGenerator.generate(ModelGenerator.java:166)
    at net.sf.minuteProject.application.ModelGenerator.generate(ModelGenerator.java:158)
    at net.sf.minuteProject.application.ModelViewGenerator.main(ModelViewGenerator.java:52)
Caused by: java.lang.NullPointerException
    at net.sf.minuteProject.plugin.openxava.OpenXavaUtils.convertChunkToAlias(OpenXavaUtils.java:101)
    at net.sf.minuteProject.plugin.openxava.OpenXavaUtils.getParentSemanticReference(OpenXavaUtils.java:89)
    at net.sf.minuteProject.plugin.openxava.OpenXavaUtils.getParentChildRelativeSemanticReference(OpenXavaUtils.java:144)
    at net.sf.minuteProject.plugin.openxava.OpenXavaUtils.getListProperties(OpenXavaUtils.java:120)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.doInvoke(UberspectImpl.java:389)
    at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:378)
    at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:270)
    ... 28 more
1284 [main] ERROR net.sf.minuteProject.application.AbstractGenerator  - ERROR : Invocation of method 'getListProperties' in  class net.sf.minuteProject.plugin.openxava.OpenXavaUtils threw exception java.lang.NullPointerException at DomainObjectUMLJPAAnnotationOXAnnotationV4.vm[line 301, column 37]
net.sf.minuteProject.exception.MinuteProjectException: Invocation of method 'getListProperties' in  class net.sf.minuteProject.plugin.openxava.OpenXavaUtils threw exception java.lang.NullPointerException at DomainObjectUMLJPAAnnotationOXAnnotationV4.vm[line 301, column 37]
    at net.sf.minuteProject.application.AbstractGenerator.throwException(AbstractGenerator.java:477)
    at net.sf.minuteProject.application.ModelGenerator.writeTemplateResult(ModelGenerator.java:466)
    at net.sf.minuteProject.application.ModelGenerator.generateArtifactsByEntity(ModelGenerator.java:362)
    at net.sf.minuteProject.application.ModelGenerator.generateArtifactsByEntity(ModelGenerator.java:355)
    at net.sf.minuteProject.application.ModelViewGenerator.generateArtifactsByEntity(ModelViewGenerator.java:78)
    at net.sf.minuteProject.application.ModelGenerator.generate(ModelGenerator.java:258)
    at net.sf.minuteProject.application.AbstractGenerator.generate(AbstractGenerator.java:243)
    at net.sf.minuteProject.application.ModelGenerator.applyTargetConventionAndGenerate(ModelGenerator.java:225)
    at net.sf.minuteProject.application.ModelGenerator.loadAndGenerate(ModelGenerator.java:213)
    at net.sf.minuteProject.application.ModelGenerator.generate(ModelGenerator.java:166)
    at net.sf.minuteProject.application.ModelGenerator.generate(ModelGenerator.java:158)
    at net.sf.minuteProject.application.ModelViewGenerator.main(ModelViewGenerator.java:52)
1284 [main] INFO  net.sf.minuteProject.application.ModelGenerator  - time taken : 1s.

[Florian Adler]

Hi Ron,

Thanks for pointing a problem.
In fact there is a error due to some new implementation of navigation defaulting.

To avoid this problem there is the semantic-reference node of entity 'CONFERENCE_MEMBER' to comment.
Openxava Lazuly example was for the last version of 0.5.x.y suite of minuteproject.
Since now there are couple of other target to add in the target node:

• One for caching
• One for ABL (automated business logic) integration.

I put here a version that is 0.8.2 and OX 4.5 compatible:

<!DOCTYPE root>
<generator-config>
    <configuration>
        <model name="conference" version="1.0" package-root="net.sf.mp.demo">
            <data-model>
                <driver name="mysql" version="5.1.16" groupId="mysql" artifactId="mysql-connector-java"></driver>
                <dataSource>
                    <driverClassName>org.gjt.mm.mysql.Driver</driverClassName>
                    <url>jdbc:mysql://127.0.0.1:3306/conference</url>
                    <username>root</username>
                    <password>mysql</password>
                </dataSource>
                <!--
                    for Oracle and DB2 please set the schema <schema> </schema>
                -->
                <primaryKeyPolicy oneGlobal="true">
                    <primaryKeyPolicyPattern name="autoincrementPattern"></primaryKeyPolicyPattern>
                </primaryKeyPolicy>
            </data-model>
            <business-model>
                <!--
                    <generation-condition> <condition type="exclude"
                    startsWith="DUAL"></condition> </generation-condition>
                -->
                <business-package default="conference">
                    <condition type="package" startsWith="STAT" result="statistics"></condition>
                    <condition type="package" startsWith="COUNTRY" result="admin"></condition>
                    <condition type="package" startsWith="ROLE" result="admin"></condition>               
                </business-package>
                <enrichment>
                    <conventions>
                        <column-naming-convention type="apply-strip-column-name-suffix"
                            pattern-to-strip="_ID" />
                        <reference-naming-convention
                            type="apply-referenced-alias-when-no-ambiguity" is-to-plurialize="true" />
                    </conventions>

                    <entity name="COUNTRY" content-type="reference-data">
                        <semantic-reference>
                            <sql-path path="NAME" />
                        </semantic-reference>
                    </entity>
                    <entity name="CONFERENCE_MEMBER">
                        <!--<semantic-reference>
                            <sql-path path="FIRST_NAME" />
                            <sql-path path="LAST_NAME" />
                        </semantic-reference>    -->
                        <field name="STATUS">
                            <property tag="checkconstraint" alias="conference_member_status">
                                <property name="PENDING" value="PENDING" />
                                <property name="ACTIVE" value="ACTIVE" />
                            </property>
                        </field>
                        <field name="EMAIL">
                            <stereotype stereotype="EMAIL" />
                        </field>
                    </entity>
                    <entity name="SPEAKER">
                        <field name="BIO">
                            <stereotype stereotype="HTML_TEXT" />
                        </field>
                        <field name="PHOTO">
                            <stereotype stereotype="PHOTO" />
                        </field>
                        <field name="WEB_SITE_URL">
                            <stereotype stereotype="WEBURL" />
                        </field>
                    </entity>
                    <entity name="PRESENTATION">
                        <field name="STATUS">
                            <property tag="checkconstraint" alias="presentation_status">
                                <property name="PROPOSAL" value="PROPOSAL" />
                                <property name="ACTIVE" value="ACTIVE" />
                            </property>
                        </field>
                    </entity>
                    <entity name="SPONSOR">
                        <field name="STATUS">
                            <property tag="checkconstraint" alias="sponsor_status">
                                <property name="PENDING" value="PENDING" />
                                <property name="ACTIVE" value="ACTIVE" />
                            </property>
                        </field>
                        <field name="PRIVILEGE_TYPE">
                            <property tag="checkconstraint" alias="sponsor_privilege">
                                <property name="GOLDEN" value="Golden" />
                                <property name="SILVER" value="Silver" />
                                <property name="BRONZE" value="Bronze" />
                            </property>
                        </field>
                    </entity>
                    <!-- views -->
                    <entity name="stat_mb_per_ctry_conf" alias="MEMBER_PER_COUNTRY_AND_CONFERENCE">
                        <virtual-primary-key isRealPrimaryKey="true">
                            <property name="virtualPrimaryKey" value="ID" />
                        </virtual-primary-key>
                    </entity>
                    <entity name="stat_mb_by_role" alias="MEMBER_PER_ROLE_COUNTRY_AND_CONFERENCE">
                        <virtual-primary-key isRealPrimaryKey="true">
                            <property name="virtualPrimaryKey" value="id" />
                        </virtual-primary-key>
                        <field name="stat_mb_per_ctry_conf_ID" linkToTargetEntity="stat_mb_per_ctry_conf"
                            linkToTargetField="id"></field>
                    </entity>
                </enrichment>
            </business-model>
        </model>
        <targets>
            <target refname="LIB"
               fileName="mp-template-config-bsla-LIB-features.xml"
               templatedir-root="../../template/framework/bsla">
            </target>
            <target refname="ABL-Openxava"
                outputdir-root="../output/openxava/petshopOpenXava"
                fileName="mp-template-config-ABL-OPENXAVA.xml"
                templatedir-root="../../template/framework/abl">
            </target>
            <target refname="JPA2-LIB"
               fileName="mp-template-config-JPA2-LIB.xml"
               templatedir-root="../../template/framework/jpa">
            </target>                   
            <target refname="OpenXava"
               name="OpenXava"
               fileName="mp-template-config-openxava-last-features.xml"
               outputdir-root="../output/openxava/petshopOpenXava"
               templatedir-root="../../template/framework/openxava">
            </target>        

            <target refname="CACHE-LIB"
               fileName="mp-template-config-CACHE-LIB.xml"
               templatedir-root="../../template/framework/cache">
            </target>
            <target refname="LIB"
               fileName="mp-template-config-bsla-LIB-features.xml"
               templatedir-root="../../template/framework/bsla">
            </target>
        </targets>
    </configuration>
</generator-config>

---

I hope it helped,

Best regards,

Florian

2012/8/21 Ron King <ronc...@gmail.com>

[Ron King]

Thanks Florian, it works now! Why did you have to comment out the
semantic-reference ?

On Aug 21, 4:35 pm, Florian Adler <minuteproj...@gmail.com> wrote:
> Hi Ron,
>
> Thanks for pointing a problem.
> In fact there is a error due to some new implementation of navigation
> defaulting.
>
> To avoid this problem there is the semantic-reference node of entity
> 'CONFERENCE_MEMBER' to comment.
> Openxava Lazuly example was for the last version of 0.5.x.y suite of
> minuteproject.
> Since now there are couple of other target to add in the target node:
>

>    - One for caching
>    - One for ABL (automated business logic) integration.

> 2012/8/21 Ron King <ronck...@gmail.com>

>
>
>
>
>
>
>
> > I think I'm starting out too fast. I want to just learn how to use the
> > tool, so maybe you can help me with a more familiar scenario. The lazuly
> > project doesn't work with MP 0.8.2 , here's the error below. Can you help
> > me to get lazuly to work with MP 0.8.2 and OX 4.5?
>

> ...
>
> read more »
>
>  mp-config-LAZULY-OPENXAVA-mp0.8.2-ox-4.5.xml
> 7KViewDownload

[Florian Adler]

This is a regression that I make when adding a convention to discover automatically semantic reference from your DB queries.

It is fixed (thanks to your feed-back) and from next release on (0.8.3) you should not need to comment this part anymore.

Best regards,

Florian.

2012/8/22 Ron King <ronc...@gmail.com>