Revision 43647 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc2/spi/operations/ResultSetForSetProviderOperation.java
ResultSetForSetProviderOperation.java | ||
---|---|---|
99 | 99 |
for(FeatureAttributeDescriptor attr : storeType.getPrimaryKey() ) { |
100 | 100 |
primaryKeys.add(attr.getName()); |
101 | 101 |
} |
102 |
for(String attrName : primaryKeys ) {
|
|
103 |
// Ordenamos siempre por las claves primarias para garantizar
|
|
104 |
// un orden predecible. Ademas se precisa indicar un orden para
|
|
105 |
// usar OFFSET.
|
|
106 |
sqlbuilder.select().order_by().column(sqlbuilder.identifier(attrName)).ascending();
|
|
102 |
if( offset>0 ) {
|
|
103 |
for(String attrName : primaryKeys ) {
|
|
104 |
// Se precisa indicar un orden para usar OFFSET.
|
|
105 |
sqlbuilder.select().order_by().column(sqlbuilder.identifier(attrName)).ascending();
|
|
106 |
}
|
|
107 | 107 |
} |
108 | 108 |
String[] constantsAttributeNames = null; |
109 | 109 |
if(query !=null && query.hasConstantsAttributeNames() ) { |
Also available in: Unified diff