You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by "Phil Steitz (JIRA)" <ji...@apache.org> on 2006/07/10 07:20:32 UTC

[jira] Updated: (DBCP-168) [dbcp] add/enhance toString() Method to DelegatingCallableStatement for sql debugging

     [ http://issues.apache.org/jira/browse/DBCP-168?page=all ]

Phil Steitz updated DBCP-168:
-----------------------------

    Bugzilla Id:   (was: 33983)
    Fix Version: 1.3

> [dbcp] add/enhance toString() Method to DelegatingCallableStatement for sql debugging
> -------------------------------------------------------------------------------------
>
>          Key: DBCP-168
>          URL: http://issues.apache.org/jira/browse/DBCP-168
>      Project: Commons Dbcp
>         Type: Improvement

>  Environment: Operating System: All
> Platform: PC
>     Reporter: Ralf Hauser
>     Priority: Minor
>      Fix For: 1.3

>
> one of the beauties of mysql connector-J is that a stmt.toString() not just
> produces the object reference string but also the sql-statement that will be
> executed on the RDBMS server. (Thanks Mark Matthews!)
> Recently, I went through the excercise of porting a larger jdbc code-base from
> mysql to oracle. There may be many reasons to do this, but error handling in
> ojdbc14.jar is not one of it  :(   {the usual laziness of programmers when
> throwing an error: not saying which of the parameters caused it, not citing
> offending values, string positions of invalid characters, ... - it would cost
> them a few minutes to do better and save the developers using their jar days if
> not weeks!}
> Therefore the RFE:
> Not only directly pass on all values in DelegatingCallableStatement and
> DelegatingPreparedStatement to the delegate, but in the set*() methods gather
> enough information to be able to do something along the lines of
> com.mysql.jdbc.PreparedStatement.asSql()
> Sure one might say that this causes unneccessary overhead for production
> environments - o.k. perhaps there needs to be a configuration flag to set
> whether dbcp shall do this or operate as is.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org