We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

JDBC Query Node

Comments

4 comments

  • Avatar
    Infogix Support
    Originally posted by: stonysmith

    The DB_Execute node will not talk to JDBC. You would use the JDBC_Query (or JDBC_Execute) node instead.

    In the query you'd put

    select * from xyz where BAN = :1

    and in the BIND_FIELDS parameter (at the bottom), just put
    BAN

    You'll most likely have to do the .str().trim() functions in a filter before this node.
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: mw9286

    Hi Stoney: I am getting the following error.

    oa.customer_id = :1". Cause: Unable to parse query text: unexpected char: ':'. On line 1, column 697. [parser-2904201] [Log ID: 739ed662-6330-413a-98c6-55f4543421b6] [jdbc-1906510]
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: stonysmith

    The exact syntax depends entirely upon the database driver.

    Try this next:
    select * from xyz where BAN = ?
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: mw9286

    That worked..

    Thank you
    0
    Comment actions Permalink

Please sign in to leave a comment.