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.