I have upgraded a project from 6.10 to 7.2.4. As the JPA Console is supported on 7.1+, I’m trying to make it work. My database is Oracle and the application runs just fine. But I can’t get any queries to work in the JPA Console. Here’s what I get:
jpa-ql> select e from schweitzer$SchMlg e
[2020-05-15 12:13:38] javax.persistence.PersistenceException: Exception [EclipseLink-4021] (Eclipse Persistence Services - 2.7.3.6-cuba): org.eclipse.persistence.exceptions.DatabaseException
[2020-05-15 12:13:38] Exception Description: Unable to acquire a connection from driver [null], user [null] and URL [null]. Verify that you have set the expected driver class and URL. Check your login, persistence.xml or sessions.xml resource. The jdbc.driver property should be set to a class that is compatible with your database platform
[2020-05-15 12:13:38] java.lang.RuntimeException: Exception [EclipseLink-4021] (Eclipse Persistence Services - 2.7.3.6-cuba): org.eclipse.persistence.exceptions.DatabaseException
[2020-05-15 12:13:38] Exception Description: Unable to acquire a connection from driver [null], user [null] and URL [null]. Verify that you have set the expected driver class and URL. Check your login, persistence.xml or sessions.xml resource. The jdbc.driver property should be set to a class that is compatible with your database platform
[2020-05-15 12:13:38] at org.eclipse.persistence.exceptions.DatabaseException.unableToAcquireConnectionFromDriverException(DatabaseException.java:385)
[2020-05-15 12:13:38] at org.eclipse.persistence.sessions.DefaultConnector.connect(DefaultConnector.java:93)
[2020-05-15 12:13:38] at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:172)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.setOrDetectDatasource(DatabaseSessionImpl.java:233)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:815)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:256)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:767)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getAbstractSession(EntityManagerFactoryDelegate.java:219)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:327)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:350)
[2020-05-15 12:13:38] at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:313)
[2020-05-15 12:13:38] in RemoteEntityManagerFactoryImpl.createEntityManager(RemoteEntityManagerFactoryImpl.java:35) (no stack trace)
It works fine through the Database Panel:
And the Main Data Store is OK too:
Project Structure:
I think everything is set correctly. What am I missing?