AnsweredAssumed Answered

Ingress datasource test successful in JBoss but sql query not working in Policy Xpress

Question asked by varelafpy on Aug 23, 2018
Latest reply on Aug 28, 2018 by varelafpy

I have set a datasource in Jboss for Ingres connectivity and the test is successful but  sql query in the Policy Xpress does not work with the following error:  Invalid procedure call syntax

 

 

this is my datasource:

 

<datasource jndi-name="java:/ingresDS" pool-name="ingresDS">
     <driver-class>com.ingres.jdbc.IngresDriver</driver-class>
     <connection-url>jdbc:ingres://192.168.0.114:II7/demodb</connection-url>
     <driver>iijdbc.jar</driver>
      <pool>
       <prefill>false</prefill>
       <use-strict-min>false</use-strict-min>
       <flush-strategy>FailingConnectionOnly</flush-strategy>
      </pool>
      <security>
       <user-name>ingres</user-name>
       <password>Servicios01</password>
      </security>
     </datasource>

 

Driver definition:

 

<driver name="iijdbc.jar" module="com.ca.iam.jdbc.ingres">
      <xa-datasource-class>com.ingres.jdbc.IngresXADataSource</xa-datasource-class>
     </driver>

 

Jboss connection test:

Outcomes