openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Guillaume Chauvet (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (OPENJPA-2259) SQL generation error for the JPQL IN statement
Date Thu, 06 Sep 2012 09:06:07 GMT

     [ https://issues.apache.org/jira/browse/OPENJPA-2259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Guillaume Chauvet updated OPENJPA-2259:
---------------------------------------

      Priority: Minor  (was: Major)
    Issue Type: Improvement  (was: Bug)

Well it's not a bug, but more a message issue : I obtained NULL because my MaintenanceModule
entites are not persisted : they don't have id. Is it possible to check entities have an Id
and emit a more user friendly message ?
                
> SQL generation error for the JPQL IN statement
> ----------------------------------------------
>
>                 Key: OPENJPA-2259
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2259
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: query, sql
>    Affects Versions: 2.2.0
>            Reporter: Guillaume Chauvet
>            Priority: Minor
>
> Dear OpenJPA Team,
> We have created a JPQL query for finding all (newest) "GuidedMaintenance" entity who
contains at least one "MaintenanceModule" entity from a MaintenanceModule list parameter :
> =========================
> SELECT M FROM GUIDEDMAINTENANCE AS M WHERE (M.previous IS NULL AND M.next IS NULL) OR
(M.previous IS NOT NULL AND M.next IS NULL) AND M.modules IN (?1)
> The Java query snippet :
> =========================
> TypedQuery<GuidedMaintenance> query = em.createNamedQuery("guidedmaintenance.contains.module",
GuidedMaintenance.class);
> query.setParameter(1, Arrays.asList(modules));	// ModuleMaintenance[] modules, white
one entity
> We obtains this SQL exception :
> =========================
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Syntax error: Encountered
"NULL" at line 1, column 1369. {SELECT t0.ID, t0.DTYPE, t0.ATTRIBUTION, t0.COMPULSORY, t0.DESCRIPTION,
t0.FREQUENCY, t0.KEEPORDER, t2.ID, t2.LABEL, t0.TITLE, t0.TYPE, t0.WORKABLE, t4.ID, t3.ID,
t4.EMAIL, t4.ENABLE, t4.NAME, t4.SURNAME, t4.TELEPHONE, t3.ETP, t3.ETPMAINT, t3.LOGIN, t3.PASSWORD,
t3.QLQLEVEL, t3.QLXLEVEL, t3.STOCKLEVEL, t5.ID, t5.DTYPE, t5.ATTRIBUTION, t5.COMPULSORY, t5.DESCRIPTION,
t5.FREQUENCY, t5.KEEPORDER, t5.TITLE, t5.TYPE, t5.WORKABLE, t5.TOLERANCE, t5.TRACABILITY,
t6.ID, t6.DTYPE, t6.ATTRIBUTION, t6.COMPULSORY, t6.DESCRIPTION, t6.FREQUENCY, t6.KEEPORDER,
t6.TITLE, t6.TYPE, t6.WORKABLE, t6.TOLERANCE, t6.TRACABILITY, t0.TOLERANCE, t0.TRACABILITY
FROM "CMP-MAINT".MAINTENANCES t0 LEFT OUTER JOIN "CMP-MAINT".MAINTENANCES_MODULEMAINTENANCES
t1 ON t0.ID = t1.MAINTENANCE_ID LEFT OUTER JOIN QUALINAX.ROLES t2 ON t0.REQUIRED_ID = t2.ID
INNER JOIN QUALINAX.INTERNALUSERS t3 ON t0.EDITOR_ID = t3.ID LEFT OUTER JOIN "CMP-MAINT".MAINTENANCES
t5 ON t0.ID = t5.PREVIOUS_ID LEFT OUTER JOIN "CMP-MAINT".MAINTENANCES t6 ON t0.PREVIOUS_ID
= t6.ID INNER JOIN QUALINAX.USERS t4 ON t3.ID = t4.ID WHERE (t0.PREVIOUS_ID IS NULL AND 0
= (SELECT COUNT(*) FROM "CMP-MAINT".MAINTENANCES WHERE "CMP-MAINT".MAINTENANCES.PREVIOUS_ID
= t0.ID) OR t0.PREVIOUS_ID IS NOT NULL AND 0 = (SELECT COUNT(*) FROM "CMP-MAINT".MAINTENANCES
WHERE "CMP-MAINT".MAINTENANCES.PREVIOUS_ID = t0.ID) AND t1.MODULES_ID IN (NULL)) AND t0.DTYPE
= ? AND (t5.DTYPE IS NULL OR t5.DTYPE IN (?)) AND (t6.DTYPE IS NULL OR t6.DTYPE IN (?))} [code=30000,
state=42X01]
> I think it's a bug because our modules list isn't empty and we obtains SQL statement
"t1.MODULES_ID IN (NULL)".

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message