-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
WOW! Foreign-Keys are as ass backwards as can be in Druid. Sorry if the author is on here... but geez, relating foreign keys requires you to click on a COLUMN TYPE and then scroll down to see it! makes no sense if you ask me... but hey what ever works.
Now I've got all the pieces of druid figured out.
As to the generation of OJB WHOM ever wrote this module... YOU KICK ASS!
<class-descriptor class="com.test.Cdpcno_user_login_Bean"
proxy="dynamic" table="CDPCNO_USER_LOGIN">
<field-descriptor name="user_id" nullable="false" column="USER_ID"
jdbc-type="INTEGER"/>
<field-descriptor name="username" nullable="false" column="USERNAME"
jdbc-type="VARCHAR"/>
<field-descriptor name="password" nullable="false" column="PASSWORD"
jdbc-type="VARCHAR"/>
<field-descriptor name="reminder_clue" column="REMINDER_CLUE"
jdbc-type="DECIMAL"/>
<field-descriptor name="status_id" column="STATUS_ID" jdbc-type="INTEGER"/>
<field-descriptor name="last_login" nullable="false"
column="LAST_LOGIN" jdbc-type="DATE"/>
<field-descriptor name="base_role" column="BASE_ROLE" jdbc-type="DECIMAL"/>
<reference-descriptor name="cdpcno_user_info"
class="com.test.Cdpcno_user_info_Bean" auto-update="false"
auto-delete="false">
<foreignkey field-ref="user_id" field-id-ref="user_id"/>
</reference-descriptor>
</class-descriptor>This is what it generated for me. Ok I don't like the bean names, but that's just changing the names of my tables to match the bean name... so what? Minimal.
R
Robert S. Sfeir wrote:
| I've figured out how to import existing tables if anyone is interested. | | Setup your jdbc driver | Create a new project | Right click and create a new Database. I created an empty one | Switch to the jdbc tab on the right | Choose the appropriate URL for your DB and fill in the info | Type in Username and password and click connect at the bottom | After you're connected switch to the Structure tab | Right click on Jdbc Database icon | Choose Import Entities | | Check everything | | Import | | Done | | And just figured out how to generate the FULL schema using Druid... VERY | VERY VERY SWEET! | | To do that: | 1- Click on the DB icon | 2- Choose Generation | 3- Right Click Generic | 4- Add Module | 5- Choose Apache OJB | 6- Fill in the information in both tabs | 7- Right click the Apache OJB icon and choose generate... | | DONE! |
- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE/uSAh+cV9vuB27SARAs1KAKDzz9AwugijcGNQA1T5TSO3V9mlDACffxMr aDF2v6vfRxSzUA7zWZRrEuI= =o34O -----END PGP SIGNATURE-----
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
