Announcement Announcement Module
Collapse
No announcement yet.
Debugging Spring JDBC logs Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Debugging Spring JDBC logs

    Hi,
    We have noticed that some DB calls using Spring JDBC have taken long time to execute , I am confused here whether the time is taken for executing query or for releasing connection to Datasource pool . Below are the logs , can someone please suggest on what could be wrong here ?

    ( I am new to the forum so apologies if I have posted this to a wrong Forum) .

    [13/10/11 10:31:38:762 BST] 000023ff JdbcTemplate 1 org.springframework.jdbc.core.JdbcTemplate query Executing prepared SQL query
    [13/10/11 10:31:38:762 BST] 000023ff JdbcTemplate 1 org.springframework.jdbc.core.JdbcTemplate execute Executing prepared SQL statement [SELECT 'LastInvoice' RecType, prev_bill_refno, prev_bill_ref_resets, bill_ref_no, bill_ref_resets FROM bill_invoice bi1, customer_id_acct_map cm WHERE cm.external_id = ? AND cm.external_id_type = ? AND bi1.account_no = cm.account_no AND prep_date = (SELECT MAX (prep_date) FROM bill_invoice bi1, customer_id_acct_map cm WHERE cm.external_id = ? AND cm.external_id_type = ? AND bi1.account_no = cm.account_no AND prep_status = 1 AND prep_error_code IS NULL)]
    [13/10/11 10:31:38:762 BST] 000023ff DataSourceUti 1 org.springframework.jdbc.datasource.DataSourceUtil s doGetConnection Fetching JDBC Connection from DataSource
    [13/10/11 10:31:38:763 BST] 000023ff StatementCrea 3 org.springframework.jdbc.core.StatementCreatorUtil s setParameterValueInternal Setting SQL statement parameter value: column index 1, parameter value [CH60736937S], value class [java.lang.String], SQL type unknown
    [13/10/11 10:31:38:763 BST] 000023ff StatementCrea 3 org.springframework.jdbc.core.StatementCreatorUtil s setParameterValueInternal Setting SQL statement parameter value: column index 2, parameter value [7], value class [java.lang.Integer], SQL type unknown
    [13/10/11 10:31:38:763 BST] 000023ff StatementCrea 3 org.springframework.jdbc.core.StatementCreatorUtil s setParameterValueInternal Setting SQL statement parameter value: column index 3, parameter value [CH60736937S], value class [java.lang.String], SQL type unknown
    [13/10/11 10:31:38:763 BST] 000023ff StatementCrea 3 org.springframework.jdbc.core.StatementCreatorUtil s setParameterValueInternal Setting SQL statement parameter value: column index 4, parameter value [7], value class [java.lang.Integer], SQL type unknown
    [13/10/11 10:31:39:213 BST] 000023ff DataSourceUti 1 org.springframework.jdbc.datasource.DataSourceUtil s doReleaseConnection Returning JDBC Connection to DataSource

    Thanks and Regards,
    Shrey Awasthi

  • #2
    Hi,
    Can anyone please help with this ?

    Thanks,
    Shrey

    Comment


    • #3
      Originally posted by shrey.awasthi View Post
      Hi,
      We have noticed that some DB calls using Spring JDBC have taken long time to execute , I am confused here whether the time is taken for executing query or for releasing connection to Datasource pool . Below are the logs , can someone please suggest on what could be wrong here ?

      ( I am new to the forum so apologies if I have posted this to a wrong Forum) .

      [13/10/11 10:31:38:762 BST] 000023ff JdbcTemplate 1 org.springframework.jdbc.core.JdbcTemplate query Executing prepared SUtils setParameterValueInternal Setting SQL statement parameter value: column index 3, parameter value [CH60736937S], value class [java.lang.String], SQL type unknown
      [13/10/11 10:31:38:763 BST] 000023ff StatementCrea 3 org.springframework.jdbc.core.StatementCreatorUtil s setParameterValueInternal Setting SQL statement parameter value: column index 4, parameter value [7], value class [java.lang.Integer], SQL type unknown
      [13/10/11 10:31:39:213 BST] 000023ff DataSourceUti 1 org.springframework.jdbc.datasource.DataSourceUtil s doReleaseConnection Returning JDBC Connection to DataSource

      Thanks and Regards,
      Shrey Awasthi
      Thanks,
      Shrey
      Last edited by taive; Oct 24th, 2012, 11:04 PM.

      Comment

      Working...
      X