Debugging Spring JDBC logs

[shrey.awasthi]

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

[shrey.awasthi]

Hi,
Can anyone please help with this ?

Thanks,
Shrey

[taive]

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