You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@isis.apache.org by "Gerrie Myburgh (JIRA)" <ji...@apache.org> on 2017/12/01 17:37:00 UTC
[jira] [Commented] (ISIS-1789) Metamodel validator thinks SQL query
is a JDOQL query and fails
[ https://issues.apache.org/jira/browse/ISIS-1789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16274668#comment-16274668 ]
Gerrie Myburgh commented on ISIS-1789:
--------------------------------------
quick workaround :
isis.reflector.validator.jdoqlFromClause=false
in isis.properties switches off jdoql from clause validation letting SQL go through.
> Metamodel validator thinks SQL query is a JDOQL query and fails
> ---------------------------------------------------------------
>
> Key: ISIS-1789
> URL: https://issues.apache.org/jira/browse/ISIS-1789
> Project: Isis
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.15.1
> Environment: LINUX
> Reporter: Gerrie Myburgh
> Priority: Minor
>
> the following SQL Query definition :
> {code:java}
> @javax.jdo.annotations.Queries(Array(
> new javax.jdo.annotations.Query(
> name = "findByDescriptiveName",
> value = "SELECT "
> + "FROM domainapp.modules.system.dom.impl.FileObject "
> + "WHERE descriptiveName.indexOf(:descriptiveName) >= 0 "),
> new javax.jdo.annotations.Query(
> name = "findByApplicationComponent",
> language="SQL",
> value = "select fo.* " +
> " from " +
> " FileObject fo, " +
> " Component_File cf, " +
> " ComponentObject co, " +
> " Application_Component ac, " +
> " ApplicationObject ao " +
> " where " +
> " ao.name = :application and " +
> " ao.application_id = ac.application_id and " +
> " co.component_id = ac.component_id and " +
> " co.name = :component and " +
> " co.component_id = cf.component_id and " +
> " cf.file_id = fo.file_id ",
> resultClass=classOf[FileObject] )
> )
> )
> {code}
> makes the metamodel validator fail thinking that the query type is JDOQL.
> {noformat}
> domainapp.modules.system.dom.impl.FileObject: error in JDOQL query, class name for FROM clause not recognized (JDOQL : select fo.* from FileObject fo, Component_File cf, ComponentObject co, Application_Component ac, ApplicationObject ao where ao.name = :application and ao.application_id = ac.application_id and co.component_id = ac.component_id and co.name = :component and co.component_id = cf.component_id and cf.file_id = fo.file_id )
> Please inspect the above messages and correct your domain model.
> {noformat}
> The validator should ignore SQL query types and let DataNucleus handle it.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)