[jira] [Created] (ISIS-1789) Metamodel validator thinks SQL query is a JDOQL query and fails

["Gerrie Myburgh (JIRA)" <ji...@apache.org>]

Gerrie Myburgh created ISIS-1789:
------------------------------------

             Summary: 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)