FAQ
Hi Guys,
I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
Here is the ant code and the exception. Can anyone please help??
Thanks in advance.
Cheers,
Parth
From Ant build:
<target name="create-db" description="build the Coffeshop database">
<cdbgen map="${src.dir}/CoffeshopMap.map.xml"
adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
username="coffeshop"
password="password"/>
</target>

Exception
generator options - [dropTables: false, dropPK: false, createTables: true, createPK: true, createFK: true]
[cdbgen] Error generating database

BUILD FAILED
C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-build.xml:293: Error generating database
at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
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:585)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
Caused by: java.lang.NullPointerException
at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
at org.apache.cayenne.access.DbGenerator.(DbGenerator.java:105)
at org.apache.cayenne.access.DbGenerator.(DbGeneratorTask.java:71)
... 16 more
--- Nested Exception ---
java.lang.NullPointerException
at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
at org.apache.cayenne.access.DbGenerator.(DbGenerator.java:105)
at org.apache.cayenne.access.DbGenerator.(DbGeneratorTask.java:71)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
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:585)
at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
at org.apache.tools.ant.Task.perform(Task.java:348)
at org.apache.tools.ant.Target.execute(Target.java:357)
at org.apache.tools.ant.Target.performTasks(Target.java:385)
at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)

Search Discussions

  • Kevin Menard at Mar 2, 2010 at 4:03 am
    I'm seeing the same thing now. In my case it looks like the JDBC
    driver isn't being loaded off the classpath. But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin


    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false, createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-build.xml:293: Error generating database
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)


  • Parth Pandya at Mar 2, 2010 at 4:10 am
    Hi,
    I've double checked that driver loading and that seem to be fine for me. The driver jar is in classpath and I've tried adding classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now. In my case it looks like the JDBC
    driver isn't being loaded off the classpath. But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin


    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false, createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-build.xml:293: Error generating database
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



  • Kevin Menard at Mar 2, 2010 at 4:23 am
    Sorry, I spoke too soon. I'm having issues with the maven task, so a
    completely different classpath/classworld thing. So, we may be seeing
    two separate problems. Apologies for the confusion.

    --
    Kevin


    On Mon, Mar 1, 2010 at 11:10 PM, Parth Pandya wrote:
    Hi,
    I've double checked that driver loading and that seem to be fine for me. The driver jar is in classpath and I've tried adding classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now.  In my case it looks like the JDBC
    driver isn't being loaded off the classpath.  But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin


    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false, createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-build.xml:293: Error generating database
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)


  • Parth Pandya at Mar 2, 2010 at 4:49 am
    Hi Guys,
    I tried with the simplest map and it is working in RC2 against sql server.
    Then I switched to my 'proper' map and it failed.
    What I have is something like this.

    I've two mappings file in a cayenne project. The first map references the other map and its used for few join tables.

    It would be good if someone can confirm that passing one of the map file to cdbgen task will/will not work. I want to generate tables out of the first map and not for the reference map.

    I've a typo in my below mentioned ant code so plz ignore it.
    The corrected ant code looks like this.

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>

    Thanks,
    Parth

    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:23 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Sorry, I spoke too soon. I'm having issues with the maven task, so a
    completely different classpath/classworld thing. So, we may be seeing
    two separate problems. Apologies for the confusion.

    --
    Kevin


    On Mon, Mar 1, 2010 at 11:10 PM, Parth Pandya wrote:
    Hi,
    I've double checked that driver loading and that seem to be fine for me. The driver jar is in classpath and I've tried adding classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now.  In my case it looks like the JDBC
    driver isn't being loaded off the classpath.  But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin


    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false, createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-build.xml:293: Error generating database
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



  • Parth Pandya at Mar 3, 2010 at 4:29 am
    Can anyone help?? Does anyone know if cdbgen task will work with multiple maps or not??

    Regards,
    Parth

    -----Original Message-----
    From: Parth Pandya
    Sent: Tuesday, 2 March 2010 3:48 PM
    To: user@cayenne.apache.org
    Subject: RE: cdbgen problem for SQLServer on RC2

    Hi Guys,
    I tried with the simplest map and it is working in RC2 against sql server.
    Then I switched to my 'proper' map and it failed.
    What I have is something like this.

    I've two mappings file in a cayenne project. The first map references the other map and its used for few join tables.

    It would be good if someone can confirm that passing one of the map file to cdbgen task will/will not work. I want to generate tables out of the first map and not for the reference map.

    I've a typo in my below mentioned ant code so plz ignore it.
    The corrected ant code looks like this.

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>

    Thanks,
    Parth

    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:23 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Sorry, I spoke too soon. I'm having issues with the maven task, so a
    completely different classpath/classworld thing. So, we may be seeing
    two separate problems. Apologies for the confusion.

    --
    Kevin


    On Mon, Mar 1, 2010 at 11:10 PM, Parth Pandya wrote:
    Hi,
    I've double checked that driver loading and that seem to be fine for me. The driver jar is in classpath and I've tried adding classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now.  In my case it looks like the JDBC
    driver isn't being loaded off the classpath.  But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin


    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false, createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-build.xml:293: Error generating database
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



  • Mike Kienenberger at Mar 3, 2010 at 12:47 pm
    Is it because you're not specifying the additional data maps to cgen?
    From one of my 1.2/2.0 projects:
    <cgen map="${template.datamap}"
    additionalMaps="${additional.template.datamaps}"
    version="1.2"
    makepairs="false"
    overwrite="false"
    mode="entity"
    destDir="${dataMapModelPackageDir}/entity"
    superpkg="${dataMapModelPackage}.entity.cayenne.generated"
    template="${template.subclass.interface}"
    usepkgpath="false">
    </cgen>

    On Tue, Mar 2, 2010 at 11:28 PM, Parth Pandya wrote:
    Can anyone help?? Does anyone know if cdbgen task will work with multiple maps or not??

    Regards,
    Parth

    -----Original Message-----
    From: Parth Pandya
    Sent: Tuesday, 2 March 2010 3:48 PM
    To: user@cayenne.apache.org
    Subject: RE: cdbgen problem for SQLServer on RC2

    Hi Guys,
    I tried with the simplest map and it is working in RC2 against sql server.
    Then I switched to my 'proper' map and it failed.
    What I have is something like this.

    I've two mappings file in a cayenne project. The first map references the other map and its used for few join tables.

    It would be good if someone can confirm that passing one of the map file to cdbgen task will/will not work. I want to generate tables out of the first map and not for the reference map.

    I've a typo in my below mentioned ant code so plz ignore it.
    The corrected ant code looks like this.

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>

    Thanks,
    Parth

    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:23 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Sorry, I spoke too soon.  I'm having issues with the maven task, so a
    completely different classpath/classworld thing.  So, we may be seeing
    two separate problems.  Apologies for the confusion.

    --
    Kevin


    On Mon, Mar 1, 2010 at 11:10 PM, Parth Pandya wrote:
    Hi,
    I've double checked that driver loading and that seem to be fine for me. The driver jar is in classpath and I've tried adding classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now.  In my case it looks like the JDBC
    driver isn't being loaded off the classpath.  But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin


    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"
    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false, createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-build.xml:293: Error generating database
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at org.apache.cayenne.map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:264)
    at org.apache.cayenne.map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at org.apache.cayenne.map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:136)
    at org.apache.cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at org.apache.cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)
    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:585)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1298)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.eclipse.ant.internal.ui.antsupport.EclipseDefaultExecutor.executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1181)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at org.eclipse.ant.internal.ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



  • Andrus Adamchik at Mar 3, 2010 at 3:44 pm
    Actually this may be an omission in cdbgen. cgen supports
    "additionalMaps", while "cdbgen" doesn't. We need a Jira for that.

    Andrus
    On Mar 3, 2010, at 7:46 AM, Mike Kienenberger wrote:

    Is it because you're not specifying the additional data maps to cgen?
    From one of my 1.2/2.0 projects:

    <cgen map="${template.datamap}"
    additionalMaps="${additional.template.datamaps}"
    version="1.2"
    makepairs="false"
    overwrite="false"
    mode="entity"
    destDir="${dataMapModelPackageDir}/entity"
    superpkg="${dataMapModelPackage}.entity.cayenne.generated"
    template="${template.subclass.interface}"
    usepkgpath="false">
    </cgen>

    On Tue, Mar 2, 2010 at 11:28 PM, Parth Pandya wrote:
    Can anyone help?? Does anyone know if cdbgen task will work with
    multiple maps or not??

    Regards,
    Parth

    -----Original Message-----
    From: Parth Pandya
    Sent: Tuesday, 2 March 2010 3:48 PM
    To: user@cayenne.apache.org
    Subject: RE: cdbgen problem for SQLServer on RC2

    Hi Guys,
    I tried with the simplest map and it is working in RC2 against sql
    server.
    Then I switched to my 'proper' map and it failed.
    What I have is something like this.

    I've two mappings file in a cayenne project. The first map
    references the other map and its used for few join tables.

    It would be good if someone can confirm that passing one of the map
    file to cdbgen task will/will not work. I want to generate tables
    out of the first map and not for the reference map.

    I've a typo in my below mentioned ant code so plz ignore it.
    The corrected ant code looks like this.

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>

    Thanks,
    Parth

    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:23 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Sorry, I spoke too soon. I'm having issues with the maven task, so a
    completely different classpath/classworld thing. So, we may be
    seeing
    two separate problems. Apologies for the confusion.

    --
    Kevin



    On Mon, Mar 1, 2010 at 11:10 PM, Parth Pandya <ppandya@avoka.com>
    wrote:
    Hi,
    I've double checked that driver loading and that seem to be fine
    for me. The driver jar is in classpath and I've tried adding
    classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne
    tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now. In my case it looks like the JDBC
    driver isn't being loaded off the classpath. But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin



    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya <ppandya@avoka.com>
    wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop
    database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false,
    createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-
    build.xml:293: Error generating database
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at
    org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
    288)
    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:585)
    at
    org
    .apache
    .tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at
    org.apache.tools.ant.Project.executeSortedTargets(Project.java:
    1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:
    1298)
    at
    org
    .apache
    .tools
    .ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at
    org
    .eclipse
    .ant
    .internal
    .ui
    .antsupport
    .EclipseDefaultExecutor
    .executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:
    1181)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:
    264)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:
    136)
    at
    org
    .apache
    .cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:
    264)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:
    136)
    at
    org
    .apache
    .cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at
    org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
    288)
    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:585)
    at
    org
    .apache
    .tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at
    org.apache.tools.ant.Project.executeSortedTargets(Project.java:
    1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:
    1298)
    at
    org
    .apache
    .tools
    .ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at
    org
    .eclipse
    .ant
    .internal
    .ui
    .antsupport
    .EclipseDefaultExecutor
    .executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:
    1181)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



  • Parth Pandya at Mar 3, 2010 at 11:08 pm
    Hi Andrus,
    I'm using cdbgen task and that doesn't have the additionalMaps. I'm trying to generate the database tales and not the entities.
    Thanks,
    Parth

    -----Original Message-----
    From: Andrus Adamchik
    Sent: Thursday, 4 March 2010 2:44 AM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Actually this may be an omission in cdbgen. cgen supports
    "additionalMaps", while "cdbgen" doesn't. We need a Jira for that.

    Andrus
    On Mar 3, 2010, at 7:46 AM, Mike Kienenberger wrote:

    Is it because you're not specifying the additional data maps to cgen?
    From one of my 1.2/2.0 projects:

    <cgen map="${template.datamap}"
    additionalMaps="${additional.template.datamaps}"
    version="1.2"
    makepairs="false"
    overwrite="false"
    mode="entity"
    destDir="${dataMapModelPackageDir}/entity"
    superpkg="${dataMapModelPackage}.entity.cayenne.generated"
    template="${template.subclass.interface}"
    usepkgpath="false">
    </cgen>

    On Tue, Mar 2, 2010 at 11:28 PM, Parth Pandya wrote:
    Can anyone help?? Does anyone know if cdbgen task will work with
    multiple maps or not??

    Regards,
    Parth

    -----Original Message-----
    From: Parth Pandya
    Sent: Tuesday, 2 March 2010 3:48 PM
    To: user@cayenne.apache.org
    Subject: RE: cdbgen problem for SQLServer on RC2

    Hi Guys,
    I tried with the simplest map and it is working in RC2 against sql
    server.
    Then I switched to my 'proper' map and it failed.
    What I have is something like this.

    I've two mappings file in a cayenne project. The first map
    references the other map and its used for few join tables.

    It would be good if someone can confirm that passing one of the map
    file to cdbgen task will/will not work. I want to generate tables
    out of the first map and not for the reference map.

    I've a typo in my below mentioned ant code so plz ignore it.
    The corrected ant code looks like this.

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>

    Thanks,
    Parth

    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:23 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Sorry, I spoke too soon. I'm having issues with the maven task, so a
    completely different classpath/classworld thing. So, we may be
    seeing
    two separate problems. Apologies for the confusion.

    --
    Kevin



    On Mon, Mar 1, 2010 at 11:10 PM, Parth Pandya <ppandya@avoka.com>
    wrote:
    Hi,
    I've double checked that driver loading and that seem to be fine
    for me. The driver jar is in classpath and I've tried adding
    classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne
    tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now. In my case it looks like the JDBC
    driver isn't being loaded off the classpath. But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin



    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya <ppandya@avoka.com>
    wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop
    database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false,
    createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-
    build.xml:293: Error generating database
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at
    org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
    288)
    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:585)
    at
    org
    .apache
    .tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at
    org.apache.tools.ant.Project.executeSortedTargets(Project.java:
    1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:
    1298)
    at
    org
    .apache
    .tools
    .ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at
    org
    .eclipse
    .ant
    .internal
    .ui
    .antsupport
    .EclipseDefaultExecutor
    .executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:
    1181)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:
    264)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:
    136)
    at
    org
    .apache
    .cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:
    264)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:
    136)
    at
    org
    .apache
    .cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at
    org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
    288)
    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:585)
    at
    org
    .apache
    .tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at
    org.apache.tools.ant.Project.executeSortedTargets(Project.java:
    1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:
    1298)
    at
    org
    .apache
    .tools
    .ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at
    org
    .eclipse
    .ant
    .internal
    .ui
    .antsupport
    .EclipseDefaultExecutor
    .executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:
    1181)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



  • Parth Pandya at Mar 4, 2010 at 4:33 am
    Hi Andrus,
    I get what you are saying now.. I spoke too soon..
    Regards,
    Parth

    -----Original Message-----
    From: Parth Pandya
    Sent: Thursday, 4 March 2010 10:07 AM
    To: user@cayenne.apache.org
    Subject: RE: cdbgen problem for SQLServer on RC2

    Hi Andrus,
    I'm using cdbgen task and that doesn't have the additionalMaps. I'm trying to generate the database tales and not the entities.
    Thanks,
    Parth

    -----Original Message-----
    From: Andrus Adamchik
    Sent: Thursday, 4 March 2010 2:44 AM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Actually this may be an omission in cdbgen. cgen supports
    "additionalMaps", while "cdbgen" doesn't. We need a Jira for that.

    Andrus
    On Mar 3, 2010, at 7:46 AM, Mike Kienenberger wrote:

    Is it because you're not specifying the additional data maps to cgen?
    From one of my 1.2/2.0 projects:

    <cgen map="${template.datamap}"
    additionalMaps="${additional.template.datamaps}"
    version="1.2"
    makepairs="false"
    overwrite="false"
    mode="entity"
    destDir="${dataMapModelPackageDir}/entity"
    superpkg="${dataMapModelPackage}.entity.cayenne.generated"
    template="${template.subclass.interface}"
    usepkgpath="false">
    </cgen>

    On Tue, Mar 2, 2010 at 11:28 PM, Parth Pandya wrote:
    Can anyone help?? Does anyone know if cdbgen task will work with
    multiple maps or not??

    Regards,
    Parth

    -----Original Message-----
    From: Parth Pandya
    Sent: Tuesday, 2 March 2010 3:48 PM
    To: user@cayenne.apache.org
    Subject: RE: cdbgen problem for SQLServer on RC2

    Hi Guys,
    I tried with the simplest map and it is working in RC2 against sql
    server.
    Then I switched to my 'proper' map and it failed.
    What I have is something like this.

    I've two mappings file in a cayenne project. The first map
    references the other map and its used for few join tables.

    It would be good if someone can confirm that passing one of the map
    file to cdbgen task will/will not work. I want to generate tables
    out of the first map and not for the reference map.

    I've a typo in my below mentioned ant code so plz ignore it.
    The corrected ant code looks like this.

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>

    Thanks,
    Parth

    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:23 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    Sorry, I spoke too soon. I'm having issues with the maven task, so a
    completely different classpath/classworld thing. So, we may be
    seeing
    two separate problems. Apologies for the confusion.

    --
    Kevin



    On Mon, Mar 1, 2010 at 11:10 PM, Parth Pandya <ppandya@avoka.com>
    wrote:
    Hi,
    I've double checked that driver loading and that seem to be fine
    for me. The driver jar is in classpath and I've tried adding
    classpathref to the task as well but that didn't help.
    With classpathref the ant code looked like this. I've cayenne
    tools and cayenne server jars in the classpath.
    Regards,
    Parth

    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"
    classpathref="${cayenne.build.classpath}"/>


    -----Original Message-----
    From: Kevin Menard
    Sent: Tuesday, 2 March 2010 3:03 PM
    To: user@cayenne.apache.org
    Subject: Re: cdbgen problem for SQLServer on RC2

    I'm seeing the same thing now. In my case it looks like the JDBC
    driver isn't being loaded off the classpath. But I haven't had the
    time to dig into it more to see why that may be or at what point it
    broke.

    --
    Kevin



    On Mon, Mar 1, 2010 at 10:59 PM, Parth Pandya <ppandya@avoka.com>
    wrote:
    Hi Guys,
    I'm trying to use cdbgen task in my Ant script and I'm getting NPE.
    Here is the ant code and the exception. Can anyone please help??
    Thanks in advance.
    Cheers,
    Parth

    From Ant build:
    <target name="create-db" description="build the Coffeshop
    database">
    <cdbgen map="${src.dir}/CoffeshopMap.map.xml"

    adapter="org.apache.cayenne.dba.sqlserver.SQLServerAdapter"
    driver="om.microsoft.jdbc.sqlserver.SQLServerDriver"
    url="jdbc:sqlserver://localhost:
    1433;databaseName=coffeshop;SelectMethod=cursor"
    username="coffeshop"
    password="password"/>
    </target>

    Exception
    generator options - [dropTables: false, dropPK: false,
    createTables: true, createPK: true, createFK: true]
    [cdbgen] Error generating database

    BUILD FAILED
    C:\dev\myEclipseTelstraWorkspace\telstra.all4biz.portal\edge-
    build.xml:293: Error generating database
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:94)
    at
    org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
    288)
    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:585)
    at
    org
    .apache
    .tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at
    org.apache.tools.ant.Project.executeSortedTargets(Project.java:
    1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:
    1298)
    at
    org
    .apache
    .tools
    .ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at
    org
    .eclipse
    .ant
    .internal
    .ui
    .antsupport
    .EclipseDefaultExecutor
    .executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:
    1181)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)
    Caused by: java.lang.NullPointerException
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:
    264)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:
    136)
    at
    org
    .apache
    .cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    ... 16 more
    --- Nested Exception ---
    java.lang.NullPointerException
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.fillInMetadata(AshwoodEntitySorter.java:
    264)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter._indexSorter(AshwoodEntitySorter.java:97)
    at
    org
    .apache
    .cayenne
    .map.AshwoodEntitySorter.sortDbEntities(AshwoodEntitySorter.java:
    136)
    at
    org
    .apache
    .cayenne.access.DbGenerator.prepareDbEntities(DbGenerator.java:582)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:132)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:105)
    at
    org.apache.cayenne.access.DbGenerator.<init>(DbGenerator.java:93)
    at
    org
    .apache
    .cayenne.tools.DbGeneratorTask.execute(DbGeneratorTask.java:71)
    at
    org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
    288)
    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:585)
    at
    org
    .apache
    .tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:357)
    at org.apache.tools.ant.Target.performTasks(Target.java:385)
    at
    org.apache.tools.ant.Project.executeSortedTargets(Project.java:
    1329)
    at org.apache.tools.ant.Project.executeTarget(Project.java:
    1298)
    at
    org
    .apache
    .tools
    .ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at
    org
    .eclipse
    .ant
    .internal
    .ui
    .antsupport
    .EclipseDefaultExecutor
    .executeTargets(EclipseDefaultExecutor.java:32)
    at org.apache.tools.ant.Project.executeTargets(Project.java:
    1181)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.run(InternalAntRunner.java:423)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



    ternalAntRunner.run(InternalAntRunner.java:423)
    at
    org
    .eclipse
    .ant
    .internal
    .ui.antsupport.InternalAntRunner.main(InternalAntRunner.java:137)



Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categoriescayenne
postedMar 2, '10 at 4:00a
activeMar 4, '10 at 4:33a
posts10
users4
websitecayenne.apache.org

People

Translate

site design / logo © 2021 Grokbase