db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: How to execute optimizer overrides in a java app
Date Sat, 10 Mar 2007 18:01:25 GMT
I think this discussion is another arument for
https://issues.apache.org/jira/browse/DERBY-1749

Then an  example could be
   ResultSet rs = s.executeQuery(
   "SELECT num, addr FROM derbyDB /*derby-properties index=IDX1*/ order by num");

while
   "SELECT num, addr FROM derbyDB /*derby-properties index=IDX1 order by num");

should give a syntax error.

-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message