[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread [EMAIL PROTECTED]
Quote: Is it possible to make the DDL generate a separate goal unto itself? (end of quote) Sure...easily done: file a JIRA issue for the andromdapp maven plugin and I'll make it a seperate goal as well as have it called during "create-schema" and "drop-schema" -- Chad Brandon - [EMAIL PROTE

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread joelkoz
[EMAIL PROTECTED] wrote: How about making it part of the create-schema and drop-schema goals (end of quote) Yup - that will probably do it! Once I saw the DDL files were NOT created with maven mda, my next step was to try maven create-schema. That seemed like a reasonable assumption. IF t

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread [EMAIL PROTECTED]
hi joelkoz, thanks for your post, I'll take a closer look at it later today and I'll keep it in mind when writing new docs or updating existing ones -- Wouter -- Wouter Zoons - [EMAIL PROTECTED] http://www.andromda.org/ _ Reply to the

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread [EMAIL PROTECTED]
Quote: One last suggestion: how about making the DDL generation part of the maven mda goal? (end of quote) How about making it part of the create-schema and drop-schema goals (like you thought it was initially)? The mda just does the andromda generation, and I kind of prefer it that way (

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread joelkoz
[EMAIL PROTECTED] wrote: if you can find the time, could you very briefly summarize a few issues you had trouble with ? I would like to know if the were genuine issues that have now been fixed, if the documentation wasn't clear or if it's something else.. (end of quote) Wouter - My previ

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread joelkoz
[EMAIL PROTECTED] wrote: The thing is: I've never considered this a bug (those error messages). I would assume most users know what happens when a SQL script is executed therefore they could safetly assume things have worked. (end of quote) Chad, you are correct, and in hind site, I recogn

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread [EMAIL PROTECTED]
Quote: If there is a known bug with a simple fix, I vote for fixing it so that learning curve gets a little shallower. (end of quote) The thing is: I've never considered this a bug (those error messages). I would assume most users know what happens when a SQL script is executed therefore

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread [EMAIL PROTECTED]
[quote="joelkoz"] [EMAIL PROTECTED] wrote: I've been at the point of "giving up" numerous times (end of quote) this feeling is what we're trying to avoid, AndroMDA covers a lot of ground and it can be frustrating to get to know the way we're doing things, we're trying hard to make it easy, b

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread joelkoz
[EMAIL PROTECTED] wrote: if we make it easier people complain it does not support enough features, all in all I noticed people don't want to invest time and expect things to just happen without realizing what is going on (I'm not saying you're like that, just something I noticed in general)

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL] More info on the JBoss site

2005-07-13 Thread mattes3
Hi, I found this link quite helpful to make JBoss talk to MySQL: http://www.jboss.org/?module=bb&op=viewtopic&t=55844 Cheers... Matthias -- Matthias Bohlen "Consulting that helps project teams to succeed..." Internet: http://www.andromda.com [EMAIL PROTECTED] __

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL] General installation instructions for MySQL and JDBC

2005-07-13 Thread mattes3
can be found here: http://www.developer.com/java/data/article.php/3417381 But I think you are already beyond that point. Cheers... Matthias -- Matthias Bohlen "Consulting that helps project teams to succeed..." Internet: http://www.andromda.com [EMAIL PROTECTED] ___

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread gehel
There is the same kind of problem with PostgreSQL. The "DROP SEQUENCE ..." isnt commented out, which means I have to create a sequence named "hibernate_sequence" before the first time I run "create-schema". The main problem is that all the script is run in one transaction, so if the first "DROP

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-13 Thread [EMAIL PROTECTED]
joelkoz wrote: I've found AndroMDA to have a VERY steep learning curve (end of quote) if we make it easier people complain it does not support enough features, all in all I noticed people don't want to invest time and expect things to just happen without realizing what is going on (I'm not

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread joelkoz
[EMAIL PROTECTED] wrote: I wasn't saying you did :) (end of quote) And I wasn't saying you were saying I did :D Just mentioning that ANY error could cause someone to loose some hair, and the cleaner the project, the more it will be adopted. I've found AndroMDA to have a VERY steep l

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread [EMAIL PROTECTED]
Quote: Believe it or not, I DON'T run to this forum and ask a question for every quesiton I have. (end of quote) I wasn't saying you did :) Feel free to submit a patch that handles it in a "cleaner" way, I really haven't had anyone else complain about it so I didn't know was an issue. --

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread joelkoz
Yes, technically I got my tables OK, but as a newbie, I was thrown by the error messages. Believe it or not, I DON'T run to this forum and ask a question for every quesiton I have. Instead, I TRY to figure things out for myself. All in all, I spent probably an hour on this one issue, only to

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread [EMAIL PROTECTED]
Quote: BTW - is the "process" of using AndroMDA really that one should run maven drop-schema before ever "re-creating" it? If so, dis-regard the "one could comment out" comment above. (end of quote) Yep...its assumed you would run "drop-schema" before running "create-schema" again. It

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread joelkoz
Chad - I think I know what is going on now. This may be a small bug. If the maven andromdapp:generate cartridge were modified so that the above section had this instead match="^(alter table .* drop constraint|alter table .* drop foreign key|drop table)" (notice I added |alter tab

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread joelkoz
I just did, and it looks like AndroMDA is the culprit! From core/maven.xml: So, it looks like the "DROP TABLE" is getting commented out on purpose. Anyone know the reason? _ Reply to the post : http://galaxy.andromda.org/forum/v

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread [EMAIL PROTECTED]
By Hibernate: take a look at the core/maven.xml -- Chad Brandon - [EMAIL PROTECTED] http://www.andromda.org _ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=2466#2466 Posting to http://forum.andromda.org/ is preferred o

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL]

2005-07-12 Thread joelkoz
Problem solved (I think)... It appears that the FIRST ENTRIES in the schema-create.sql lines are ALTER TABLE ... DROP FOREIGN KEY...[i]. If the database is being created for the first time, the tables obviously don't exist, thus the errors. Running maven create-schema a SECOND time result

[Andromda-user] [Newbie corner] [Configuring AndroMDA project to use mySQL] Configuring AndroMDA project to use mySQL

2005-07-12 Thread joelkoz
OK - I've been trying to get a demo project created with AndroMDA using mySQL, and was getting stuck at maven create-schema. For the benefit of others, here is what I had to do... FIRST thing I learned: you have to install the mySQL JDBC driver on JBoss according to these directions (http:/