JDBC Query Node

Follow

Infogix Support

• May 22, 2018 17:18

Originally posted by: mw9286

How do you create a JDBC Query Node that will read in a file to a sql query.

I have a db execute node, but I don't know how to configure it for a JDBC query. The db execute node has a general tab where the statement reads the following and then actual query on the parameter 1 tab.

General tab:
sqlSelect(1,
"{{^query^}}",
BAN.str().trim())

Parameter 1 tab

select * from xyz where BAN = :1

0

• 

  Infogix Support

  • May 22, 2018 18:28

  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
• 

  Infogix Support

  • June 08, 2018 15:57

  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
• 

  Infogix Support

  • June 08, 2018 16:05

  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
• 

  Infogix Support

  • June 08, 2018 16:12

  Originally posted by: mw9286
  
  That worked..
  
  Thank you

  0

  Comment actions Permalink

Please sign in to leave a comment.