[
https://issues.apache.org/jira/browse/DERBY-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13085007#comment-13085007
]
Tiago R. Espinha commented on DERBY-3676:
-----------------------------------------
For this new method, the ? would be reserved for fields that have not yet been
replaced with values. With that in mind, leaving the LOBs with this marker
could induce confusion in the users. We can also assume that a user would
resort to this method to try and identify which fields have not been replaced
with values, and in this case, when faced with a ? for a LOB, it would be
impossible to tell whether there should be a value there or not.
I think having the type name, length and hash code would be nice. Maybe
something like <CLOB:3026:43289723188> where the first "column" is the type,
second represents length and the last one is the hash code. Just an idea.
I haven't looked at these two test classes, but what's the main difference
between then? Do you think we could (and would it make sense to) merge them in
one class?
> Make the toString() method of Derby PreparedStatements print out SQL text
> with ? parameters replaced by the values that have been set so far
> --------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3676
> URL: https://issues.apache.org/jira/browse/DERBY-3676
> Project: Derby
> Issue Type: Improvement
> Components: JDBC
> Reporter: Rick Hillegas
> Assignee: Siddharth Srivastava
> Attachments: humanstringprepared.txt, humanstringprepared.txt,
> humanstringprepared.txt, humanstringprepared.txt, humanstringprepared.txt,
> humanstringprepared.txt, humanstringprepared.txt, ick.txt, ick.txt,
> prepared.diff, statementCacheVTI.sql
>
>
> This topic came up in the following email thread on the user list:
> http://www.nabble.com/PreparedStatement.toString%28%29---nice-formatting-td17250811.html#a17250811
> Here's what the thread requests:
> "In mysql, a toString() on a PreparedStatement will do this, eg "select x
> from foo where x.a = ?" will become "select x from foo where x.a = 1" with
> the appropriate setValue() call."
> At first blush, this seems like it might be a simple project for a newcomer.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
