Revision 40948 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/jdbc/JDBCStoreProvider.java
| JDBCStoreProvider.java | ||
|---|---|---|
| 801 | 801 |
long limit, long offset) throws DataException {
|
| 802 | 802 |
StringBuilder sql = new StringBuilder(); |
| 803 | 803 |
JDBCStoreParameters params = getJDBCParameters(); |
| 804 |
if (directSQLMode) {
|
|
| 805 |
sql.append(params.getSQL()); |
|
| 806 |
sql.append(' ');
|
|
| 807 |
} else {
|
|
| 808 | 804 |
FeatureAttributeDescriptor[] fields = type |
| 809 | 805 |
.getAttributeDescriptors(); |
| 810 | 806 |
|
| ... | ... | |
| 841 | 837 |
|
| 842 | 838 |
// table |
| 843 | 839 |
sql.append("from ");
|
| 844 |
sql.append(params.tableID()); |
|
| 840 |
if (directSQLMode) {
|
|
| 841 |
sql.append(" (");
|
|
| 842 |
sql.append(params.getSQL()); |
|
| 843 |
sql.append(") as _subquery_alias_ ");
|
|
| 844 |
} else {
|
|
| 845 |
sql.append(params.tableID()); |
|
| 846 |
} |
|
| 845 | 847 |
sql.append(' ');
|
| 846 | 848 |
|
| 847 | 849 |
// Where |
| ... | ... | |
| 862 | 864 |
} |
| 863 | 865 |
sql.append(' ');
|
| 864 | 866 |
} |
| 865 |
} |
|
| 866 | 867 |
// limit offset |
| 867 | 868 |
if (limit > 0 || offset > 0) {
|
| 868 | 869 |
sql.append(helper.compoundLimitAndOffset(limit,offset)); |
Also available in: Unified diff