FAQ
Hi, hope everyone are well!

Following the "New System"[1] options I could create my data model[2|2a] and
now I'm trying to generate the sql necessary to create database tables.
I've tried with Oracle and Postgresql databases and only basic relationships
are generate.
Is there any other option necessary to generate everything?
Why the necessity of a live database connection? Just now I only need the
sql script!

Regards,

Gilberto Caetano de Andrade
Analista de Sistemas/DBA
www.secad.to.gov.br

[1]http://cayenne.apache.org/doc/new-system.html
[2] http://www.nabble.com/file/p25276867/ParkDataDomainMap.map.xml
ParkDataDomainMap.map.xml
[2a] http://www.nabble.com/file/p25276867/03000001.png 03000001.png
--
View this message in context: http://www.nabble.com/-modeler--Generate-Database-Schema-doesn%27t-generate-every-relationship-tp25276867p25276867.html
Sent from the Cayenne - User mailing list archive at Nabble.com.

Search Discussions

  • Andrus Adamchik at Sep 4, 2009 at 8:57 am

    On Sep 3, 2009, at 5:08 PM, gilbertoca wrote:

    Following the "New System"[1] options I could create my data model[2|
    2a] and
    now I'm trying to generate the sql necessary to create database
    tables.
    I've tried with Oracle and Postgresql databases and only basic
    relationships
    are generate.
    Is there any other option necessary to generate everything?
    Could you clarify what you mean by "everything"?
    Why the necessity of a live database connection? Just now I only
    need the
    sql script!
    This looks like a Modeler bug. Indeed the connection should be checked
    when "generate" is selected.

    Andrus
  • Gilbertoca at Sep 4, 2009 at 1:46 pm

    Andrus Adamchik wrote:
    I've tried with Oracle and Postgresql databases and only basic
    relationships
    Could you clarify what you mean by "everything"?
    It doesn't generate every relationship, just 4 from about 19 one (you can
    see all of them in ParkDataDomainMap.map.xml file)!

    Thanks for help,

    Gilberto

    --
    View this message in context: http://www.nabble.com/-modeler--Generate-Database-Schema-doesn%27t-generate-every-relationship-tp25276867p25294633.html
    Sent from the Cayenne - User mailing list archive at Nabble.com.
  • Gilbertoca at Sep 9, 2009 at 1:18 pm

    gilbertoca wrote:


    Andrus Adamchik wrote:
    I've tried with Oracle and Postgresql databases and only basic
    relationships
    Could you clarify what you mean by "everything"?
    It doesn't generate every relationship, just 4 from about 19 one (you can
    see all of them in ParkDataDomainMap.map.xml file)!

    Thanks for help,

    Gilberto
    I've forgot to mention that [1] the "Uncheck All Tables" option doesn't work
    for me.

    [code]
    gilbert[email protected]:~/dev/eclipse-config/workspace/park-w> uname -a
    Linux SUGEP-DMASI 2.6.25.20-0.5-default #1 SMP 2009-08-14 01:48:11 +0200
    i686 i686 i386 GNU/Linux

    gi[email protected]:~/dev/eclipse-config/workspace/park-w> cat
    /etc/SuSE-release
    openSUSE 11.0 (i586)
    VERSION = 11.0

    [email protected]:~/dev/eclipse-config/workspace/park-w> java -version
    java version "1.5.0_20"
    Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_20-b02)
    Java HotSpot(TM) Server VM (build 1.5.0_20-b02, mixed mode)
    [/code]

    Regards,

    Gilberto

    [1] http://www.nabble.com/file/p25364808/generate-DB%2BSchema%2BOptions.png
    generate-DB+Schema+Options.png

    --
    View this message in context: http://www.nabble.com/-modeler--Generate-Database-Schema-doesn%27t-generate-every-relationship-tp25276867p25364808.html
    Sent from the Cayenne - User mailing list archive at Nabble.com.
  • Andrus Adamchik at Sep 9, 2009 at 2:03 pm

    On Sep 9, 2009, at 9:18 AM, gilbertoca wrote:
    I've forgot to mention that [1] the "Uncheck All Tables" option
    doesn't work
    for me.
    Can't comment on your other problem yet, but this one is a bug that
    was fixed in 3.0M6 if I am not mistaken.

    Andrus
  • Gilbertoca at Sep 9, 2009 at 2:41 pm

    Andrus Adamchik wrote:

    On Sep 9, 2009, at 9:18 AM, gilbertoca wrote:


    I've forgot to mention that [1] the "Uncheck All Tables" option
    doesn't work
    for me.
    Can't comment on your other problem yet, but this one is a bug that
    was fixed in 3.0M6 if I am not mistaken.

    Andrus
    More information:

    [code]
    gi[email protected]:~/dev/eclipse-config/workspace/park-w> mvn
    cayenne-modeler:run -X
    + Error stacktraces are turned on.
    Maven version: 2.0.9
    Java version: 1.5.0_15
    OS name: "linux" version: "2.6.25.20-0.5-default" arch: "i386" Family:
    "unix"
    [DEBUG] Building Maven user-level plugin registry from:
    '/home/gilberto/.m2/plugin-registry.xml'
    [DEBUG] Building Maven global-level plugin registry from:
    '/home/gilberto/bin/maven/conf/plugin-registry.xml'
    [INFO] Scanning for projects...
    [INFO] Searching repository for plugin with prefix: 'cayenne-modeler'.
    [DEBUG] Loading plugin prefixes from group: org.apache.maven.plugins
    [DEBUG] Loading plugin prefixes from group: org.codehaus.mojo
    [DEBUG] Retrieving parent-POM: org.apache.maven.plugins:maven-plugins::8 for
    project: null:maven-compiler-plugin:maven-plugin:2.0.2 from the repository.
    [DEBUG] Retrieving parent-POM: org.apache.maven:maven-parent::5 for project:
    org.apache.maven.plugins:maven-plugins:pom:8 from the repository.
    [DEBUG] Retrieving parent-POM: org.apache:apache::3 for project:
    org.apache.maven:maven-parent:pom:5 from the repository.
    ****************************************** VERSION
    ****************************************
    [DEBUG] Retrieving parent-POM: org.apache.cayenne:cayenne-parent::3.0M6 for
    project:

    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin:maven-plugin:null
    from the repository.
    [DEBUG] Adding managed dependencies for
    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin
    [DEBUG] ant:ant:jar:1.6.5:provided
    [DEBUG] ant:ant-junit:jar:1.6.5:test
    [DEBUG] org.objectstyle.ashwood:ashwood:jar:2.0
    [DEBUG] asm:asm:jar:3.0
    [DEBUG] asm:asm-commons:jar:3.0
    [DEBUG] commons-collections:commons-collections:jar:3.1
    [DEBUG] commons-logging:commons-logging:jar:1.1
    [DEBUG] commons-dbcp:commons-dbcp:jar:1.2.1:provided
    [DEBUG] commons-pool:commons-pool:jar:1.2:provided
    [DEBUG] emma:emma:jar:2.0.5312:test
    [DEBUG] hsqldb:hsqldb:jar:1.8.0.4
    [DEBUG] org.apache.derby:derby:jar:10.3.2.1:test
    [DEBUG] com.caucho:resin-hessian:jar:3.1.6:provided
    [DEBUG] javacc:javacc:jar:3.2:test
    [DEBUG] org.objectstyle:jdbc4-compat:jar:1.0:provided
    [DEBUG] jgoodies:forms:jar:1.0.5
    [DEBUG] jgoodies:looks:jar:1.3.1
    [DEBUG] jgroups:jgroups-all:jar:2.2.7:provided
    [DEBUG] org.apache.geronimo.specs:geronimo-jms_1.1_spec:jar:1.1:provided
    [DEBUG] org.apache.geronimo.specs:geronimo-jpa_3.0_spec:jar:1.0
    [DEBUG] org.apache.geronimo.specs:geronimo-jta_1.1_spec:jar:1.0
    [DEBUG] org.apache.geronimo.components:geronimo-transaction:jar:2.0.1:test
    [DEBUG] org.apache.openejb:openejb-core:jar:3.0:test
    [DEBUG] mockrunner:mockrunner:jar:0.3.7:test
    [DEBUG] oro:oro:jar:2.0.8:test
    [DEBUG] ognl:ognl:jar:2.6.7
    [DEBUG] opensymphony:oscache:jar:2.3.2:provided
    [DEBUG] org.scopemvc:scopemvc:jar:1.0.1
    [DEBUG] javax.servlet:servlet-api:jar:2.4:provided
    [DEBUG] jivesoftware:smack:jar:2.2.1:provided
    [DEBUG] jivesoftware:smackx:jar:2.2.1:provided
    [DEBUG] org.springframework:spring-core:jar:1.2.6:test
    [DEBUG] org.springframework:spring-beans:jar:1.2.6:test
    [DEBUG] velocity:velocity:jar:1.3
    [DEBUG] foundrylogic.vpp:vpp:jar:2.2.1:provided
    [DEBUG] junit:junit:jar:3.8.1:test
    [INFO]
    ------------------------------------------------------------------------
    [INFO] Building park-w Maven Webapp
    [INFO] task-segment: [cayenne-modeler:run]
    [INFO]
    ------------------------------------------------------------------------
    [DEBUG] Plugin dependencies for:

    ****************************************** VERSION
    ****************************************
    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin:3.0M6

    are:

    org.apache.maven:maven-plugin-api:jar:2.0.9:runtime
    org.apache.maven:maven-artifact:jar:2.0.9:runtime
    org.apache.maven:maven-project:jar:2.0.9:runtime
    org.apache.maven:maven-plugin-tools-api:jar:2.0.5:runtime
    org.apache.cayenne:cayenne-modeler:jar:3.0M6:runtime
    org.apache.cayenne:cayenne-server:jar:3.0M6:runtime
    org.codehaus.plexus:plexus-utils:jar:1.1:runtime


    [DEBUG]
    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin:maven-plugin:3.0M6:runtime
    (selected for runtime)
    [DEBUG] Retrieving parent-POM: org.apache.maven:maven::2.0.9 for project:
    null:maven-plugin-api:jar:null from the repository.
    [DEBUG] Retrieving parent-POM: org.apache.maven:maven-parent::8 for project:
    null:maven:pom:2.0.9 from the repository.
    [DEBUG] Retrieving parent-POM: org.apache:apache::4 for project: org.
    [/code]

    Thanks,

    Gilberto
    --
    View this message in context: http://www.nabble.com/-modeler--Generate-Database-Schema-doesn%27t-generate-every-relationship-tp25276867p25366422.html
    Sent from the Cayenne - User mailing list archive at Nabble.com.
  • Andrus Adamchik at Sep 9, 2009 at 2:50 pm
    My bad. Just doublechecked the release notes, and the fix is there
    (committed to trunk), but not yet released. The Jira is CAY-1240.

    Andrus
    On Sep 9, 2009, at 10:40 AM, gilbertoca wrote:

    Andrus Adamchik wrote:
    On Sep 9, 2009, at 9:18 AM, gilbertoca wrote:


    I've forgot to mention that [1] the "Uncheck All Tables" option
    doesn't work
    for me.
    Can't comment on your other problem yet, but this one is a bug that
    was fixed in 3.0M6 if I am not mistaken.

    Andrus
    More information:

    [code]
    gi[email protected]:~/dev/eclipse-config/workspace/park-w> mvn
    cayenne-modeler:run -X
    + Error stacktraces are turned on.
    Maven version: 2.0.9
    Java version: 1.5.0_15
    OS name: "linux" version: "2.6.25.20-0.5-default" arch: "i386" Family:
    "unix"
    [DEBUG] Building Maven user-level plugin registry from:
    '/home/gilberto/.m2/plugin-registry.xml'
    [DEBUG] Building Maven global-level plugin registry from:
    '/home/gilberto/bin/maven/conf/plugin-registry.xml'
    [INFO] Scanning for projects...
    [INFO] Searching repository for plugin with prefix: 'cayenne-modeler'.
    [DEBUG] Loading plugin prefixes from group: org.apache.maven.plugins
    [DEBUG] Loading plugin prefixes from group: org.codehaus.mojo
    [DEBUG] Retrieving parent-POM: org.apache.maven.plugins:maven-
    plugins::8 for
    project: null:maven-compiler-plugin:maven-plugin:2.0.2 from the
    repository.
    [DEBUG] Retrieving parent-POM: org.apache.maven:maven-parent::5 for
    project:
    org.apache.maven.plugins:maven-plugins:pom:8 from the repository.
    [DEBUG] Retrieving parent-POM: org.apache:apache::3 for project:
    org.apache.maven:maven-parent:pom:5 from the repository.
    ****************************************** VERSION
    ****************************************
    [DEBUG] Retrieving parent-POM: org.apache.cayenne:cayenne-parent::
    3.0M6 for
    project:

    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin:maven-
    plugin:null
    from the repository.
    [DEBUG] Adding managed dependencies for
    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin
    [DEBUG] ant:ant:jar:1.6.5:provided
    [DEBUG] ant:ant-junit:jar:1.6.5:test
    [DEBUG] org.objectstyle.ashwood:ashwood:jar:2.0
    [DEBUG] asm:asm:jar:3.0
    [DEBUG] asm:asm-commons:jar:3.0
    [DEBUG] commons-collections:commons-collections:jar:3.1
    [DEBUG] commons-logging:commons-logging:jar:1.1
    [DEBUG] commons-dbcp:commons-dbcp:jar:1.2.1:provided
    [DEBUG] commons-pool:commons-pool:jar:1.2:provided
    [DEBUG] emma:emma:jar:2.0.5312:test
    [DEBUG] hsqldb:hsqldb:jar:1.8.0.4
    [DEBUG] org.apache.derby:derby:jar:10.3.2.1:test
    [DEBUG] com.caucho:resin-hessian:jar:3.1.6:provided
    [DEBUG] javacc:javacc:jar:3.2:test
    [DEBUG] org.objectstyle:jdbc4-compat:jar:1.0:provided
    [DEBUG] jgoodies:forms:jar:1.0.5
    [DEBUG] jgoodies:looks:jar:1.3.1
    [DEBUG] jgroups:jgroups-all:jar:2.2.7:provided
    [DEBUG] org.apache.geronimo.specs:geronimo-jms_1.1_spec:jar:
    1.1:provided
    [DEBUG] org.apache.geronimo.specs:geronimo-jpa_3.0_spec:jar:1.0
    [DEBUG] org.apache.geronimo.specs:geronimo-jta_1.1_spec:jar:1.0
    [DEBUG] org.apache.geronimo.components:geronimo-transaction:jar:
    2.0.1:test
    [DEBUG] org.apache.openejb:openejb-core:jar:3.0:test
    [DEBUG] mockrunner:mockrunner:jar:0.3.7:test
    [DEBUG] oro:oro:jar:2.0.8:test
    [DEBUG] ognl:ognl:jar:2.6.7
    [DEBUG] opensymphony:oscache:jar:2.3.2:provided
    [DEBUG] org.scopemvc:scopemvc:jar:1.0.1
    [DEBUG] javax.servlet:servlet-api:jar:2.4:provided
    [DEBUG] jivesoftware:smack:jar:2.2.1:provided
    [DEBUG] jivesoftware:smackx:jar:2.2.1:provided
    [DEBUG] org.springframework:spring-core:jar:1.2.6:test
    [DEBUG] org.springframework:spring-beans:jar:1.2.6:test
    [DEBUG] velocity:velocity:jar:1.3
    [DEBUG] foundrylogic.vpp:vpp:jar:2.2.1:provided
    [DEBUG] junit:junit:jar:3.8.1:test
    [INFO]
    ------------------------------------------------------------------------
    [INFO] Building park-w Maven Webapp
    [INFO] task-segment: [cayenne-modeler:run]
    [INFO]
    ------------------------------------------------------------------------
    [DEBUG] Plugin dependencies for:

    ****************************************** VERSION
    ****************************************
    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin:3.0M6

    are:

    org.apache.maven:maven-plugin-api:jar:2.0.9:runtime
    org.apache.maven:maven-artifact:jar:2.0.9:runtime
    org.apache.maven:maven-project:jar:2.0.9:runtime
    org.apache.maven:maven-plugin-tools-api:jar:2.0.5:runtime
    org.apache.cayenne:cayenne-modeler:jar:3.0M6:runtime
    org.apache.cayenne:cayenne-server:jar:3.0M6:runtime
    org.codehaus.plexus:plexus-utils:jar:1.1:runtime


    [DEBUG]
    org.apache.cayenne.plugins:maven-cayenne-modeler-plugin:maven-plugin:
    3.0M6:runtime
    (selected for runtime)
    [DEBUG] Retrieving parent-POM: org.apache.maven:maven::2.0.9 for
    project:
    null:maven-plugin-api:jar:null from the repository.
    [DEBUG] Retrieving parent-POM: org.apache.maven:maven-parent::8 for
    project:
    null:maven:pom:2.0.9 from the repository.
    [DEBUG] Retrieving parent-POM: org.apache:apache::4 for project: org.
    [/code]

    Thanks,

    Gilberto
    --
    View this message in context: http://www.nabble.com/-modeler--Generate-Database-Schema-doesn%27t-generate-every-relationship-tp25276867p25366422.html
    Sent from the Cayenne - User mailing list archive at Nabble.com.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categoriescayenne
postedSep 3, '09 at 2:09p
activeSep 9, '09 at 2:50p
posts7
users2
websitecayenne.apache.org

2 users in discussion

Gilbertoca: 4 posts Andrus Adamchik: 3 posts

People

Translate

site design / logo © 2023 Grokbase