Getting sql connection via EclipseLink

Asked Nov 11 '16 at 14:17

Active Nov 11 '16 at 14:17

Viewed 717 times

I am trying to obtain a reference to sql connection as mentioned in the following question :

Here is the actual code: Connection con = entityManager.unwrap(Connection.class); This is also mentioned in EclipseLink documentation.

I keep getting following error from EclipseIDE:

The method unwrap(Class<Connection>) is undefined for the type EntityManager

1 Quickfix Add cast to 'entityManager'

If I apply the quickfix suggested by Eclipse, the code looks like this:

Connection con = ((java.sql.Wrapper) entityManager).unwrap(Connection.class);

Now, the code compiles and I can deploy my application but as soon the method is called, following error occurs:

 java.lang.ClassCastException: com.sun.proxy.$Proxy427 cannot be cast to java.sql.Wrapper

How can I solve this problem. I have an entityManager instance and using it, I want to get the dbname, db url and db schema verion

edited May 23 '17 at 12:06

Community

asked Nov 11 '16 at 14:17

user1107888

Which version of EclipseLink are you using? – Simon Martinelli Nov 11 '16 at 14:27
I am using version 2.6 – user1107888 Nov 11 '16 at 14:38
This will help http://stackoverflow.com/questions/6046491/jpa-is-there-a-way-method-to-retrieve-persistence-unit-information – Simon Martinelli Nov 11 '16 at 14:45
I have deleted it Sir, thank you very much for your time . And if you care to spend a little more time, you would know that the suggested solutions didn,t work and thats why I am asking again! – user1107888 Nov 11 '16 at 14:51
which jpa version are using? – mhasan Nov 11 '16 at 14:52
JPA version 2.0 – user1107888 Nov 11 '16 at 14:54
2

As I told you on the previous post https://docs.oracle.com/javaee/6/api/javax/persistence/EntityManager.html#unwrap%28java.lang.Class%29 that method exists. If your compiler says no then you are NOT using JPA 2.0 – Neil Stockton Nov 11 '16 at 15:08

0 Answers0