Daily Archives: July 20, 2011

ea: database model: create index

Posted on July 20, 2011 | Comments Off on ea: database model: create index

and enterprise architect can add indexes… just right-click on the table and select operations… und create the index… its a bit fency, because you need to create it, then select it, then tab to Column, and then you can select the columns, which need to be indexed… its confusing, because you select something on one tab, and then select other things on other tabs…

Comments Off on ea: database model: create index

Posted in Uncategorized

Tagged , ,

ea oracle datatypes

Posted on July 20, 2011 | Comments Off on ea oracle datatypes

as i told you before… working with enterprise architect and creating a database model for an oracle 11g database… and ea doesnt have the “timestamp” datatype… wft? so tried to figure out, if there is an ea update for newer oracle platforms… fail… but found this… exactly the same problem…

and a really simple solution… just define a new datatype:

Menu Settings->Database Datatypes

And define the database type for oracle…

simple… but spooky…

Comments Off on ea oracle datatypes

Posted in Uncategorized

Tagged , ,

database modeling with enterprise architect

Posted on July 20, 2011 | Comments Off on database modeling with enterprise architect

so finally got an Spary Enterprise Architect 🙂 the “:)” is kinda relative, because i really dont care, which program i should use for modeling tables and creating ddl’s… but the project said: use ea… and so i did… installing software in a really big company (as i am working now) can be really a pain… but after a few days, i got it up and runing… finally… so its kinda “:)”

and i think its really good… had a few problems in the beginning, created a table and colums, but couldn’t set columntypes, but master this problem… the table needs to know, which database it is in… kinda clear, but i thought the definition should be somewhere on the project or on the schema… not directly on the table…

so currently “painting” my model 🙂

Comments Off on database modeling with enterprise architect

Posted in Uncategorized

Tagged , ,

dependencies and repositories in maven

Posted on July 20, 2011 | Comments Off on dependencies and repositories in maven

ok actually i didnt get the idea of dependencies and repositories in maven… it just worked… but know i do 🙂

instead of downloading and installing different jar files on your local maschine and on every other server, just tell maven to do it. with dipendencies maven knows which jars it should get and with repositories maven know where to get them… actually the mechanism stores an local copy of the jars in a local repository, and tries first to get it from there… and because of en unique jar version number, updating to new packages in the local repository is maven pom.xml driven.

with this mechanism it is really easy to guarantee the runability of an project… hmm… and when does maven install complete servers?

Comments Off on dependencies and repositories in maven

Posted in developing

Tagged