0 Replies Latest reply on Jul 5, 2015 3:55 PM by Frank Adcock

    Losing + sign in switchyard native JPA query

    Frank Adcock Newbie

      I have a native sql query in a switchyard project (portion in error shown)

      (select sysdate + interval '720' minute from dual)

      However, when the jboss server executes the query the plus sign has disappeared from the trace

      (select sysdate interval '720' minute from dual)

      This gives the following error:

      Caused by: java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected

       

      I can get the same error if I also remove the + sign from the sql and run it in a separate sql tool.

       

      Removing this portion of the query rfrom the remainder of the query results in a successfully executing query through switchyard.

       

      How can I escape the plus sign so it appears as part of my native query?

       

      I am using JBoss EAP 6.1 with switchyard libraries 1.1.1-p5-redhat-1.