Skip to main content

JDBC Prepared statements - server-side processing and monitoring

  • Jun 27, 2017 1:51 PM UTC
  • 1 reply
  • 4 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
  • Jul 24, 2017 6:07 PM UTC

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.