trouble with using middlgen for mapping with oracle???

worldcreatxr · **Joined:** Sat Apr 10, 2004 8:39 pm **Posts:** 84

trouble with using middlgen for mapping with oracle???

how must i do ?

>>>>> draf in oracle.xml
<property name="database.userid" value="system"/>
<property name="database.password" value="manager"/>
<property name="database.schema" value=""/> ======= what must i set?
<property name="database.catalog" value=""/> ======= what must i set?

subich · **Joined:** Fri Nov 21, 2003 5:55 am **Posts:** 155

If you use middlegen with Oracle...
Your Schema and your catalog is the same name as your username otherwise you will ask to Hibernate to modelize all your data into your database and you will have a null pointer exception due to a low memory because Middlegen try to map more than 200 tables.

worldcreatxr · **Joined:** Sat Apr 10, 2004 8:39 pm **Posts:** 84

<property name="database.schema" value="system"/>
<property name="database.catalog" value="system"/>

i've setted the values as "system" now.
and if i don't add element "table", middlegen try to read all the tables
include the system tables.
what must i do ?
i only want middlegen mapping all the user created tables.

david · **Posted:** Fri Jun 04, 2004 12:12 am

Using the system owner will show many tables your not interested in.
Have you not created your own schema / tablespace for you database. Use the owner of the schema.

subich · **Joined:** Fri Nov 21, 2003 5:55 am **Posts:** 155

If you use System you ll have a out of memory error:)
Try with your username for Oracle, the schema owner.

kind regards