Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

Criteria API

O. Chorier
2012-09-14
2013-04-25
  • O. Chorier
    O. Chorier
    2012-09-14

    Hello,

    Do you know if P6Spy works fine with JPA Criteria API ? I tried and I got some errors like the following :

    nternal Exception: java.sql.SQLException: Column 'ID' not found.
    Error Code: 0
    Call: SELECT t3.ID AS ID1, …..
    Thrown by class java.sql.SQLException : Column 'ID' not found.

    It seems that Criteria API adds some suffixes to selected fields, but using P6Spy when reading the result set, thos suffixes aren't managed.
    Do you have some information about this ?

    Thanks a lot.