db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wbecker <wbec...@gmail.com>
Subject Re: PreparedStatement.toString() - nice formatting
Date Fri, 16 May 2008 08:16:24 GMT

Hi,

I have half coded this anyway, so I might as well. I'll check out the code
and see how hard it is to write up a patch.

Cheers,
Will


Rick Hillegas-2 wrote:
> 
> Hi Will,
> 
> Thanks for bringing this up. I have logged DERBY-3676 to track this 
> request. At first blush this looks like a straightforward project for a 
> newcomer. If you want to implement this yourself, I would be happy to 
> coach you through the code.
> 
> Regards,
> -Rick
> 
> wbecker wrote:
>> Is there a way to get a PreparedStatement to tell you what it is going to
>> give as a query to the db?
>>
>> 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. Is there a way to get a similar result
>> with
>> Derby? All I seem to get is a string of gibberish, eg:
>> :54b48415-0119-ec3b-91d2-000001bca0c8"
>>
>> Cheers,
>> Will
>>   
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/PreparedStatement.toString%28%29---nice-formatting-tp17250811p17269729.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message