Hi, It was some time ago, ie using UML2EJB (we haven't got around to upgrading yet!), so the version *may* not work anymore.
It deals with tables, join tables, foreign keys, primary keys, indices &
comments.....for Oracle only.
There are also some bugs (to do with foreign keys)....and some special stuff
such as:
no way to distinguish between pre-existing tables (ie ones that should not
have a 'create' statement produced) and new ones [but it has the advantage
of containing all the needed foreign keys so can be imported in DB tools as
a complete picture w/o error, such as ERWin]
we have an attribute 'uml2ejb:notNull' in the model for columns that are,
erm, not null...primary keys also assumed to be not null
we alternate Oracle tablespaces between tables as Entities are found
can't find it in the code but I'm sure we also had a uml2ejb:tableName and
uml2ejb:columnName tagged attribute as well for where tables/columns needed
a different name to that in the model (we did include it in the XDoclet
Entity tags though)
we have always a Sequence table (taken from the ServerSide & database
independent sequences through an entity bean & session bean)
we also have an AUDIT_LOG table always included
we pass in some variables such as: 'DATABASE_NAME_SEPARATOR' (usually an
underscore) and 'FOREIGN_KEY_SUFFIX' (usually '_FK') and
'PRIMARY_KEY_SUFFIX' - see below for more info
typemapping was taken from JBoss
Happy to receive back an AndroMDA and/or improved/revised version.
Chris
-=-=-=
PS - I did suggest some kind of repository for such templates but nothing
ever came of it.
Properties and stuff
typeMappings="${conf.dir}/uml2ejb/db/TypeMapping.xml">
<userProperty name="RELATION_NAME_SEPARATOR" value="-"/>
<userProperty name="PRIMARY_KEY_SUFFIX" value="_PK"/>
<userProperty name="FOREIGN_KEY_SUFFIX" value="_FK"/>
<userProperty name="DATABASE_NAME_SEPARATOR" value="_"/>
<userProperty name="DATA_TABLESPACE" value="TS_DATA"/>
<userProperty name="INDEX_TABLESPACE" value="TS_INDEX"/>
<userProperty name="PCTFREE" value="10"/>
<userProperty name="INITRANS" value="2"/>
<userProperty name="MAXTRANS" value="255"/>
<userProperty name="STORAGE_INITIAL" value="1K"/>
<userProperty name="STORAGE_NEXT" value="1K"/>
<userProperty name="STORAGE_MINEXTENTS" value="1"/>
<userProperty name="STORAGE_MAXEXTENTS" value="120"/>
<userProperty name="STORAGE_PCTINCREASE" value="0"/>
-----Original Message-----
From: Matthias Bohlen [mailto:[EMAIL PROTECTED]
Sent: Tuesday 15 July 2003 23:33
To: 'Jan Kester'; [EMAIL PROTECTED]
Subject: RE: [Andromda-user] Databasescript.vsl
Hi Jan,
please ask Chris Shaw [EMAIL PROTECTED], I think he has written a
template like that.
Cheers...
Matthias
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf
> Of Jan Kester
> Sent: Tuesday, July 15, 2003 9:35 PM
> To: [EMAIL PROTECTED]
> Subject: [Andromda-user] Databasescript.vsl
>
>
> Hello
>
> I saw on the website some reference to a databasescript.vsl
> script. Does
> this exist? And where?
> I would like to generate my tables myself, and not by ejb
> container so
> that I can control the identity of new records.
> Therefore it would be extremely handy to get create-sql scripts.
>
> Regards, Jan
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Parasoft
> Error proof Web apps, automate testing & more.
> Download & eval WebKing and get a free book.
www.parasoft.com/bulletproofapps1
_______________________________________________
Andromda-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/andromda-user
-------------------------------------------------------
This SF.net email is sponsored by: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
same time. Free trial click here: http://www.vmware.com/wl/offer/345/0
_______________________________________________
Andromda-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/andromda-user
Any e-mail message from the European Central Bank (ECB) is sent in good faith but
shall neither be binding nor construed as constituting a commitment by the ECB except
where provided for in a written agreement.
This e-mail is intended only for the use of the recipient(s) named above. Any
unauthorised disclosure, use or dissemination, either in whole or in part, is
prohibited.
If you have received this e-mail in error, please notify the sender immediately via
e-mail and delete this e-mail from your system.
TypeMapping.xml
Description: Binary data
OracleSchema.vsl
Description: Binary data
