2 Replies Latest reply on Mar 7, 2008 4:56 PM by kharum.kristen.haerum.thrane.com

    SEAMGEN fails to CRUD from Oracle DBs

    kharum.kristen.haerum.thrane.com

      This is a cry for help; please don't delete my request again:


      All attempts to let SEAMGEN reverse engineer application from existing Oracle tables fail.  Testing on various existing legacy DBs yields similar results.  Entities are generated, and a few views and then, stuck.


      The following tools have been used:


      WindowsXP Servicepack 2,
      Sun Java version 1.5.0-12,
      Seam version 2.0.1.GA,
      JDBC from Oracle ojdbc5.jar


      Target is various Oracle databases version 9i and 10g.


      The following is example trace:



      
      [hibernate] 07.mar.2008 11:22:39 org.hibernate.cfg.annotations.CollectionBinder bindOneToManySecondPass
      
      [hibernate] INFO: Mapping collection: com.thrane.aero.classic.AlarmTxt.alarmDatas -> ALARM_DATA
      
      [hibernate] 07.mar.2008 11:22:39 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
      
      [hibernate] INFO: Hibernate Validator not found: ignoring
      
      [hibernate] 07.mar.2008 11:22:54 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
      
      [hibernate] INFO: Hibernate Validator not found: ignoring
      
      [hibernate] 07.mar.2008 11:22:54 freemarker.log.JDK14LoggerFactory$JDK14Logger error
      
      [hibernate] SEVERE:
      
      [hibernate]
      
      [hibernate] Expression propertyName is undefined on line 113, column 37 in view/list.xhtml.ftl.
      
      [hibernate] The problematic instruction:
      
      [hibernate] ----------
      
      [hibernate] ==> ${propertyName} [on line 113, column 35 in view/list.xhtml.ftl]
      
      [hibernate] ----------
      
      [hibernate]
      
      [hibernate] Java backtrace for programmers:
      
      [hibernate] ----------
      
      [hibernate] freemarker.core.InvalidReferenceException: Expression propertyName is undefined on line 113, column 37 in view/list.xhtml.ftl.
      
      [hibernate]     at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124)
      
      [hibernate]     at freemarker.core.Expression.getStringValue(Expression.java:118)
      
      [hibernate]     at freemarker.core.Expression.getStringValue(Expression.java:93)
      
      [hibernate]     at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.MixedContent.accept(MixedContent.java:92)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:351)
      
      [hibernate]     at freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.IfBlock.accept(IfBlock.java:82)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.MixedContent.accept(MixedContent.java:92)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:79)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.MixedContent.accept(MixedContent.java:92)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:351)
      
      [hibernate]     at freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.MixedContent.accept(MixedContent.java:92)
      
      [hibernate]     at freemarker.core.Environment.visit(Environment.java:196)
      
      [hibernate]     at freemarker.core.Environment.process(Environment.java:176)
      
      [hibernate]     at freemarker.template.Template.process(Template.java:232)
      
      [hibernate]     at org.hibernate.tool.hbm2x.TemplateHelper.processTemplate(TemplateHelper.java:251)
      
      [hibernate]     at org.hibernate.tool.hbm2x.TemplateProducer.produceToString(TemplateProducer.java:67)
      
      [hibernate]     at org.hibernate.tool.hbm2x.TemplateProducer.produce(TemplateProducer.java:28)
      
      [hibernate]     at org.hibernate.tool.hbm2x.TemplateProducer.produce(TemplateProducer.java:97)
      
      [hibernate]     at org.hibernate.tool.hbm2x.GenericExporter.exportPOJO(GenericExporter.java:146)
      
      [hibernate]     at org.hibernate.tool.hbm2x.GenericExporter.exportPersistentClass(GenericExporter.java:135)
      
      [hibernate]     at org.hibernate.tool.hbm2x.GenericExporter$2.process(GenericExporter.java:41)
      
      [hibernate]     at org.hibernate.tool.hbm2x.GenericExporter.doStart(GenericExporter.java:126)
      
      [hibernate]     at org.hibernate.tool.hbm2x.AbstractExporter.start(AbstractExporter.java:95)
      
      [hibernate]     at org.hibernate.tool.ant.ExporterTask.execute(ExporterTask.java:40)
      
      [hibernate]     at org.hibernate.tool.ant.HibernateToolTask.execute(HibernateToolTask.java:186)
      
      [hibernate]     at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
      
      [hibernate]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      
      [hibernate]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      
      [hibernate]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      
      [hibernate]     at java.lang.reflect.Method.invoke(Method.java:585)
      
      [hibernate]     at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
      
      [hibernate]     at org.apache.tools.ant.Task.perform(Task.java:348)
      
      [hibernate]     at org.apache.tools.ant.Target.execute(Target.java:357)
      
      [hibernate]     at org.apache.tools.ant.Target.performTasks(Target.java:385)
      
      [hibernate]     at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
      
      [hibernate]     at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
      
      [hibernate]     at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
      
      [hibernate]     at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
      
      [hibernate]     at org.apache.tools.ant.Main.runBuild(Main.java:698)
      
      [hibernate]     at org.apache.tools.ant.Main.startAnt(Main.java:199)
      
      [hibernate]     at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)
      
      [hibernate]     at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)
      
      [hibernate] An exception occurred while running exporter #2:generic exportertemplate: view/list.xhtml.ftl
      
      [hibernate] To get the full stack trace run ant with -verbose
      
      [hibernate] org.hibernate.tool.hbm2x.ExporterException: Error while processing template view/list.xhtml.ftl
      
      [hibernate] freemarker.core.InvalidReferenceException: Expression propertyName is undefined on line 113, column 37 in view/list.xhtml.ftl.
      
      
      BUILD FAILED
      
      C:\jb-seam\jboss-seam-2.1.0.A1\seam-gen\build.xml:1101: org.hibernate.tool.hbm2x.ExporterException: Error while processing template view/list.xhtml.ftl
      
      



      Please advice!