FWD » Core Development » Database

-------- Original Message --------
Subject: regression when converting the server sources
Date: Mon, 14 Apr 2014 13:04:10 +0300
From: Constantin Asofiei
To: Greg Shah, "Faulhaber, Eric", Vadim Nebogatov
CC: Lomany, Stanislav

Guys,

There are some problems when converting the server sources with bzr rev 10510.

Vadim: I suspect it is related to your changes in rev 10500, because with 10499 the NPE at P2O Generation phase is no longer raised.

Greg/Eric: I think we should make it standard to conversion-test the server sources and parse-test the GUI sources, at least before releasing a new P2J version to the customer.

Thanks,
Constantin

1st:
------------------------------------------------------------------------------
P2O Generation (database schema files)
------------------------------------------------------------------------------

./data/namespace/<db_name>.schema
...
WARNING: Declared "jlprhtr1.p" schema trigger for WRITE of table 'jlndprhist' could not be located in PROPATH.
java.lang.NullPointerException: null value for annotation 'extent':compositenull [COMPOSITE] @0:0

at com.goldencode.ast.XmlFilePlugin.writeSingleAnnotation(XmlFilePlugin.java:1062)
        at com.goldencode.ast.XmlFilePlugin.writeAnnotations(XmlFilePlugin.java:1023)
        at com.goldencode.ast.XmlFilePlugin.writeAst(XmlFilePlugin.java:984)
        at com.goldencode.ast.XmlFilePlugin.writeAst(XmlFilePlugin.java:990)
        at com.goldencode.ast.XmlFilePlugin.writeAst(XmlFilePlugin.java:990)
        at com.goldencode.ast.XmlFilePlugin.saveTree(XmlFilePlugin.java:425)
        at com.goldencode.ast.AstManager.saveTree(AstManager.java:257)
        at com.goldencode.p2j.schema.DataModelWorker$Library.persistTarget(DataModelWorker.java:709)
        at com.goldencode.expr.CE867.execute(Unknown Source)
        at com.goldencode.expr.Expression.execute(Expression.java:341)
        at com.goldencode.p2j.pattern.Rule.apply(Rule.java:401)
        at com.goldencode.p2j.pattern.Rule.executeActions(Rule.java:640)
        at com.goldencode.p2j.pattern.Rule.coreProcessing(Rule.java:609)
        at com.goldencode.p2j.pattern.Rule.apply(Rule.java:440)
        at com.goldencode.p2j.pattern.RuleContainer.apply(RuleContainer.java:530)
        at com.goldencode.p2j.pattern.RuleSet.apply(RuleSet.java:50)
        at com.goldencode.p2j.pattern.PatternEngine.apply(PatternEngine.java:1519)
        at com.goldencode.p2j.pattern.PatternEngine.processAst(PatternEngine.java:1398)
        at com.goldencode.p2j.pattern.PatternEngine.processAst(PatternEngine.java:1346)
        at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:972)
        at com.goldencode.p2j.convert.ConversionDriver.processTrees(ConversionDriver.java:915)
        at com.goldencode.p2j.convert.ConversionDriver.middle(ConversionDriver.java:578)
        at com.goldencode.p2j.convert.ConversionDriver.main(ConversionDriver.java:1734)
./data/namespace/standard.schema

2nd:
------------------------------------------------------------------------------
Generate Data Model Objects (database DMOs)
------------------------------------------------------------------------------

null
com/something/server/dmo/<db_name>/Aaddress.java.jast

3rd:
Generate base/table DDL scripts for schema '<db_name>' and target DB 'postgresql'
------------------------------------------------------------------------------

Apr 14, 2014 5:33:28 AM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Apr 14, 2014 5:33:28 AM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.1.9-SNAPSHOT}
Apr 14, 2014 5:33:28 AM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Apr 14, 2014 5:33:28 AM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Apr 14, 2014 5:33:28 AM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: com.goldencode.p2j.persist.dialect.P2JPostgreSQLDialect
null

4th:
------------------------------------------------------------------------------
Metadata XML Generation
------------------------------------------------------------------------------

null
java.lang.NullPointerException
at com.goldencode.p2j.schema.DataModelWorker$Library.loadRelatedTree(DataModelWorker.java:661)
at com.goldencode.expr.CE2231.execute(Unknown Source)
at com.goldencode.expr.Expression.execute(Expression.java:341)
at com.goldencode.p2j.pattern.Rule.apply(Rule.java:401)
at com.goldencode.p2j.pattern.RuleContainer.apply(RuleContainer.java:530)
at com.goldencode.p2j.pattern.RuleSet.apply(RuleSet.java:50)
at com.goldencode.p2j.pattern.PatternEngine.apply(PatternEngine.java:1479)
at com.goldencode.p2j.pattern.PatternEngine.processAst(PatternEngine.java:1398)
at com.goldencode.p2j.pattern.PatternEngine.processAst(PatternEngine.java:1346)
at com.goldencode.p2j.pattern.PatternEngine.run(PatternEngine.java:972)
at com.goldencode.p2j.convert.ConversionDriver.processTrees(ConversionDriver.java:915)
at com.goldencode.p2j.convert.ConversionDriver.middle(ConversionDriver.java:656)
at com.goldencode.p2j.convert.ConversionDriver.main(ConversionDriver.java:1734)
Elapsed job time: 00:01:26.559

LE: GES removed the customer name, package and db name from this entry.

Attached vmn_upd20140416a.zip fixes first exception. It is possible some more errors also will be fixed. Attached vmn_upd20140416b.zip is test case. The only change in p2j_test.df is in field schedule (<db_name>.df contains a lot of such VALEXP attributes):

ADD FIELD "schedule" OF "Person" AS character 
  FORMAT "x(64)" 
  INITIAL "" 
  SQL-WIDTH 650
  EXTENT 5
  *VALEXP "CAN-FIND(customer WHERE customer.Name = schedule[0])"*
  *VALMSG "Property Class mandatory."*
  ORDER 160

LE: GES removed the database name in this entry.