I would like to find out how to get the following tasks done using EJB 3.0 Java Entity Persistent:
( i ) Create tables in different schemas such as STUDENT under EDUCATION schema and table PATIENT in HOSPITAL schema. We can then reference them in SQL as EDUCATION.STUDENT and HOSPITAL.PATIENT.
( ii ) Reference these tables uniquely once they are created.
There are no pre-existing tables or naming conventions that needs to be adhere to in this situation.
I have no problem creating tables on the current schema in EJB 3.0 Java Entity Persistent.
This question has been posted on http://forums.sun.com/thread.jspa?threadID=5322346 without response so far.
Any suggestions would be appreciated.
22.214.171.124. Defining the table
@Table is set at the class level; it allows you to define the table, catalog, and schema names for your entity bean mapping. If no @Table is defined the default values are used: the unqualified class name of the entity.
This is under the JPA annotations section, not the hibernate extension section.
TopLink seems to have better documentation and it suggests
so I'd try that too...