Query Translator

Last Published: 2012-12-25 | Version: ${project.version}

Built by Maven

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	CrossTable TableA TableB

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.