db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jean T. Anderson" <...@bristowhill.com>
Subject Re: How to execute optimizer overrides in a java app
Date Mon, 12 Mar 2007 15:54:01 GMT
Daniel John Debrunner wrote:
> Jean T. Anderson wrote:
> 
>>> ResultSet rs = s.executeQuery(
>>>   "SELECT num, addr FROM derbyDB --derby-properties index=IDX1 \r
> order by num");
> 
>> Is there any feedback on using the "\r" ? In the back of my mind I'm
>> thinking that won't be portable between Windows and Unix.
>  
> \n is the unicode newline character in Java.
> 
> There is no portability concerns here, this code is creating a newline
> in a Java unicode string which is then passed to Derby's unicode parser.
> The string constant will be stored in the class file which is platform
> independent.

excellent, thanks.

I agree with Mamta and Bernt that /* ... */ comment blocks would be nice
(DERBY-1749). In the meantime, we can at least provide solid instructions.

 -jean

Mime
View raw message