JPA Console not working on upgraded project

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:

image

And the Main Data Store is OK too:

image

Project Structure:

image

I think everything is set correctly. What am I missing?

Hi,
You are talking about JPA Console built into IntelliJ IDEA, right?
Which IDEA version do you use?

Yep - sorry, should have mentioned that. I am on version 2019.3.4 Ultimate.

image

Hi,
I’ve tested JPA console on this IDEA version.
I had the same error and need to manually assign the Data Source to the facet:
image

image

Then console started working:
image

Perfect! Thank you very much.