Symantec IGA

  • Private Community

  • 1.  Policy Xpress SQL Execution

    Posted Oct 02, 2012 12:21 PM
    I am trying to setup a Policy Xpress policy to run a SQL query to insert information into a Users table.

    I have having issues with the DataSource. I am running JBOSS and put in my SQL information in the userstore-ds.xml in the /deploy directory.

    I get bind error and failed to get connection in the logs when the policy fires.

    Here's the first part of the datsource config in the file for this DB
    <no-tx-datasource>


    <jndi-name>DrewTest</jndi-name>

    <connection-url>jdbc:sqlserver://***.***.***.***:1433;selectMethod=cursor;DatabaseName=DrewTest</connection-url>
    <driver-class>
    ....

    In the DataSource name in the policy I have put just DrewTest and java:DrewTest but get the name bind error.

    Any ideas what I got wrong?


  • 2.  RE: Policy Xpress SQL Execution

    Posted Oct 02, 2012 12:26 PM
    I am going to try to move the datasource out of the userstore-ds into the im-objectstore-ds file.


  • 3.  RE: Policy Xpress SQL Execution

     
    Posted Oct 22, 2012 06:26 PM
    Hi Drew,

    Did you ever get this working? If so and/or Kim's suggestion helped please mark the appropriate post as Accepted Solution.

    Thanks!
    Chris


  • 4.  RE: Policy Xpress SQL Execution
    Best Answer

    Posted Oct 02, 2012 01:34 PM
      |   view attached
    Per Dane Jones here at CA:

    Wrong syntax for the datasource name:

    You needs to use “java:/iam/im/jdbc/jdbc/DrewTest”

    See attached.

    Kim Beauchemin