Report
Entities per packages
List of NamedQueries per entity
List of JPQL queries
List of SQL Queries
List of Faulty Queries
Entities per packages
| Package | Entities |
|---|
| net.sf.oqt.test.model | |
List of NamedQueries per entity
| Entity | Named Query |
|---|
| CrossTable | - CROSS_TABLE_FIND_BY_A
- CROSS_TABLE_FIND_BY_B
- CROSS_TABLE_FIND_BY_A_B
- DELETE_ALL_BY_A
|
| TableA | - findByNameAndSurname
- faultyQuery
|
| TableB | |
List of JPQL queries
| Name | JPQL Query |
|---|
| CROSS_TABLE_FIND_BY_A | select ent from CrossTable ent where ent.a.id = :id |
| CROSS_TABLE_FIND_BY_A_B | select ent from CrossTable ent where ent.a.id = :id and ent.b.code = :code |
| CROSS_TABLE_FIND_BY_B | select ent from CrossTable ent where ent.b.code = :code |
| DELETE_ALL_BY_A | delete from CrossTable ent where ent.a.id = :id |
| faultyQuery | select ent from TableA where lower(ent.name) = lower(:name) and lower(ent.surname) = lower(:surname) |
| findByNameAndSurname | select ent from TableA ent where lower(ent.name) = lower(:name) and lower(ent.surname) = lower(:surname) |
List of SQL Queries
| Name | SQL Query |
|---|
| CROSS_TABLE_FIND_BY_A | - SELECT t0.id, t1.ID, t1.AGE, t1.COMMENT, t1.FAV, t1.NAME, t1.SURNAME, t2.CODE, t2.DESCRIPTION, t2.CREAT, t0.CREATION, t0.MODIFCATION FROM CROSS_TABLE t0 LEFT OUTER JOIN TABLE_A t1 ON t0.TABLE_A = t1.ID LEFT OUTER JOIN TABLE_B t2 ON t0.TABLE_B = t2.CODE WHERE (t0.TABLE_A = ?)
|
| CROSS_TABLE_FIND_BY_A_B | - SELECT t0.id, t1.ID, t1.AGE, t1.COMMENT, t1.FAV, t1.NAME, t1.SURNAME, t2.CODE, t2.DESCRIPTION, t2.CREAT, t0.CREATION, t0.MODIFCATION FROM CROSS_TABLE t0 LEFT OUTER JOIN TABLE_A t1 ON t0.TABLE_A = t1.ID LEFT OUTER JOIN TABLE_B t2 ON t0.TABLE_B = t2.CODE WHERE (t0.TABLE_A = ? AND t0.TABLE_B = ?)
|
| CROSS_TABLE_FIND_BY_B | - SELECT t0.id, t1.ID, t1.AGE, t1.COMMENT, t1.FAV, t1.NAME, t1.SURNAME, t2.CODE, t2.DESCRIPTION, t2.CREAT, t0.CREATION, t0.MODIFCATION FROM CROSS_TABLE t0 LEFT OUTER JOIN TABLE_A t1 ON t0.TABLE_A = t1.ID LEFT OUTER JOIN TABLE_B t2 ON t0.TABLE_B = t2.CODE WHERE (t0.TABLE_B = ?)
|
| DELETE_ALL_BY_A | - DELETE FROM CROSS_TABLE WHERE id IN (SELECT DISTINCT t0.id FROM CROSS_TABLE t0 WHERE (t0.TABLE_A = ?))
|
| findByNameAndSurname | - SELECT t0.ID, t0.AGE, t0.COMMENT, t0.FAV, t0.NAME, t0.SURNAME FROM TABLE_A t0 WHERE (LOWER(CAST(t0.NAME AS VARCHAR(1000))) = LOWER(CAST(? AS VARCHAR(1000))) AND LOWER(CAST(t0.SURNAME AS VARCHAR(1000))) = LOWER(CAST(? AS VARCHAR(1000))))
|
List of Faulty Queries
| Name | SQL Query |
|---|
| faultyQuery | Exception: ArgumentException: An error occurred while parsing the query filter "select ent from TableA where lower(ent.name) = lower(:name) and lower(ent.surname) = lower(:surname)". Error message: An alias is required for the schema name "net.sf.oqt.test.model.TableA" in the expression. |
