tags:

views:

19

answers:

1
Q: 

How to read the schema used by a JPA implementation.

My EntityManager is using a persistence unit that uses a data source provided by our Websphere configuration. The DS configuration includes an environment specific DB to use.

The EM successfully uses this schema, but I can't figure out a way to log or display the schema being used. I was thing something like em.getCurrentSchema would be available..

Any help would be great, thanks.

+1  A: 

No API to do this (in JPA). You could do it via JDBC and use of DatabaseMetaData.

JPA is to provide an object view of the data and ease persistence of those objects, not to just present datastore specifics to the user.

DataNucleus  2010-10-02 10:12:27
Fair enough. Is there also no way to coax that info from the Persitence Unit or even the Persitence.xml file?
Eddie  2010-10-04 21:15:31
By "schema" you just mean the schema name ? or information about the RDBMS schema ? There is no JPA way for either; JDO is the only persistence API that provides access to the metadata information. For the schema name, you would have to do it in an implementation-specific way; DataNucleus certainly provides access to it, and I'm sure others do to.
DataNucleus  2010-10-05 05:46:08

related questions

Can I specify a JPA compliant persistence.xml file on the java command line?
What is a good design for a query "layer" for Java JPA
Fix for Hibernate error "Use of the same entity name twice"
JPA and inheritance
Again with JPA not making sense
JPA and 2 simple tables
JPA - Unknown entity bean class
Hibernate.initialize() and second-level cache
JPA annotations and Interfaces
Another JPA Question
Enterprise App and the Enterprise App Client
When to use Hibernate/JPA/Toplink?
Can Seam 2.0.2sp1 apps run on Tomcat 5.5.9 with JBoss Embedded?
JPA 1 is not good enough
Which EJB 3 persisent provider should I use?
What are the best books for Hibernate & JPA?
Compound keys in JPA
Is there a Problem with JPA Entities, Oracle 10g and Calendar Type properties?
persistence.xml not found during maven testing
JPA Multiple Transaction Managers
Hibernate (JPA) how to do an eager query, loading all child objects
JEE SqlResultSetMapping Syntax problem?
Batch insert using JPA/Toplink
Enabling Hibernate second-level cache with JPA on JBoss 4.2
Detach an entity from JPA/EJB3 persistence context