EJB3 entity bean - how to set database schema name at runtime?
Михайлов Кирилл Герм анович <[email protected]> Tue, 4 Jul 2006 08:18:50 +0600
| Newsgroups | gmane.comp.java.sun.ejb.general |
|---|---|
| Message-ID | <[email protected]> |
Hi experts! I need an ejb3 entity which is not "tied" to one database schema (in = Oracle term - Oracle schema). I want to set that database schema at runtime. The reason I need this is the project structure of the database. I have = multiply Oracle DB schema with the same structured tables. Every oracle schema represent a = project (different data, same structure). Can I set schema in ejb3 entityManager* or anywhere in the session = context causing ejb3 persistence manager to generate SQL like: = select|update|insert from|to SPECIFIED_SCHEMA.table? Now I'm using jboss & bmp and wondering upgrade to ejb3 persistence = (jboss 4.0.4). Any help will be appreciated! --- Kirill Mikhailov SurgutNIPIneft Tyumen =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D To unsubscribe, send email to [email protected] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [email protected] and include in the body of the message "help".