Skip to main content

JDBC Prepared statements - server-side processing and monitoring

  • June 27, 2017
  • 1 reply
  • 3 views

Bryan_H
Forum|alt.badge.img+2

Hello ABDP,

I have a ticket (00068192) from an OEM that appears to be asking whether we implement and/or support server-side prepared statements with JDBC, and if so, is it possible to retrieve the original statement or any details from system tables?

Customer sometimes, but not always finds the original and prepared statements in v_monitor.sessions and v_monitor.transactions but not always and would like to know if there’s a reliable method to track prepared statement processing.

Thanks, Bryan

1 reply

Bryan_H
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • July 24, 2017

Resolution, in case anyone needs it: the prepared statement is in vertica.log but not in the system tables. Substituted queries do appear in system tables.