You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by gilbertoca <gi...@gmail.com> on 2009/09/03 16:08:53 UTC
[modeler] Generate Database Schema doesn't generate every
relationship
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.
Re: [modeler] Generate Database Schema doesn't generate every relationship
Posted by Andrus Adamchik <an...@objectstyle.org>.
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]
> gilberto@SUGEP-DMASI:~/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.
>
>
Re: [modeler] Generate Database Schema doesn't generate every
relationship
Posted by gilbertoca <gi...@gmail.com>.
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]
gilberto@SUGEP-DMASI:~/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.
Re: [modeler] Generate Database Schema doesn't generate every relationship
Posted by Andrus Adamchik <an...@objectstyle.org>.
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
Re: [modeler] Generate Database Schema doesn't generate every
relationship
Posted by gilbertoca <gi...@gmail.com>.
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]
gilberto@SUGEP-DMASI:~/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
gilberto@SUGEP-DMASI:~/dev/eclipse-config/workspace/park-w> cat
/etc/SuSE-release
openSUSE 11.0 (i586)
VERSION = 11.0
gilberto@SUGEP-DMASI:~/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.
Re: [modeler] Generate Database Schema doesn't generate every
relationship
Posted by gilbertoca <gi...@gmail.com>.
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.
Re: [modeler] Generate Database Schema doesn't generate every relationship
Posted by Andrus Adamchik <an...@objectstyle.org>.
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