JPQL Query does not work for jakarta.persistence

[euasier]

Apache NetBeans version

Apache NetBeans 26

What happened

The new jdbc driver (org.apache.derby.client.ClientAutoloadedDriver) used in db-derby-10.15.1.3 is not properly loaded when executing a Run JPQL Query. The console displays the following error message:

It works fine when using the old jdbc driver (org.apache.derby.jdbc.ClientDriver) with an older apache derby release (db-derby-10.14.2.0)

Language / Project Type / NetBeans Component

No response

How to reproduce

Install Apache Derby 10.15.1.3: https://archive.apache.org/dist/db/derby/db-derby-10.15.1.3/db-derby-10.15.1.3-bin.zip
Install NetBeans 26
Create DB in Services -> Databases -> JavaDB pointing to the installed Apache Derby version
Create a connection to the toursdb database of the installed Apache Derby Version
Import "test" project and Run JPQL Query

test.zip

Did this work correctly in an earlier version?

No / Don't know

Operating System

Ubuntu 22.04.5 LTS - 64 bit - Wayland

JDK

JDK 11

Apache NetBeans packaging

Apache NetBeans binary zip

Anything else

No response

Are you willing to submit a pull request?

No

[matthiasblaesing]

This works as soon as you switch from hibernate-core-jakarta to hibernate-core and jakarta.persistence.* to javax.persistence. The JPQL runner fails to load the entity manager as it does not expect the jakarta classes.

[euasier]

Hi Matthias,

Thanks for your response.

As you say using hibernate-core works. It seems to me that Netbeans supports Java EE up to version 6 (->JPA 2.0):
https://netbeans.apache.org/tutorial/main/kb/docs/javaee/javaee-gettingstarted/
#5616

I was unable to find a Netbeans 26 page where the supported Java EE/Jakarta EE versions are listed

[euasier]

I could be wrong though:
"Improve support for Jakarta EE 11 by @pepness in #8182"
https://github.com/apache/netbeans/releases/tag/25

[matthiasblaesing]

JakartaEE is partially supported. It still needs work and the JPQL executor is one of the areas.

[euasier]

I installed TomEE 10.1.0 (JakartaEE 10) but as you say JPA 3.0 it's not fully supported yet:

Thank you