0

I am using EclipseLink with Oralce DB and would like to get database name, schema version and url via EntityManager. I have already tried solution mentioned in following question

Getting a JDBC connection from EclipseLink

But this approach is not working for me and I have mentioned the problem in following question:

Getting sql connection via EclipseLink

I would like to know how can I get the required data directly via native query. I have an instance of entityManager and using it, I can execute native queries and get what I want

Community
  • 1
  • 1
user1107888
  • 1,481
  • 5
  • 34
  • 55
  • What is a "schema version?" Which url? The one you connected with? – OldProgrammer Nov 11 '16 at 17:23
  • For what purposes? EclipseLink logs this information when it logs in to the database at the right log level. Otherwise, unless you are going to unwrap the connection as you are having problems with in your other questions, you are looking at a more Oracle SQL type answer, not EclipseLink or JPA. see http://stackoverflow.com/questions/22298005/how-to-find-schema-name-in-oracle-when-you-are-connected-in-sql-session-using for instance – Chris Nov 11 '16 at 20:08

0 Answers0