Revision 46277 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/FetchFeatureTypeOperation.java
| FetchFeatureTypeOperation.java | ||
|---|---|---|
| 131 | 131 |
} |
| 132 | 132 |
st = conn.createStatement(); |
| 133 | 133 |
st.setFetchSize(1); |
| 134 |
rs = JDBCUtils.executeQuery(st, this.getSQLToRetrieveFirstRowOfTable());
|
|
| 134 |
rs = JDBCUtils.executeQuery(st, this.getSQLToRetrieveMetadataOfTable());
|
|
| 135 | 135 |
ResultSetMetaData rsMetadata = rs.getMetaData(); |
| 136 | 136 |
|
| 137 | 137 |
fetchFeatureTypeFromMetadata(conn, rsMetadata, pks); |
| ... | ... | |
| 144 | 144 |
} |
| 145 | 145 |
} |
| 146 | 146 |
|
| 147 |
public String getSQLToRetrieveFirstRowOfTable() {
|
|
| 147 |
public String getSQLToRetrieveMetadataOfTable() {
|
|
| 148 | 148 |
JDBCSQLBuilderBase sqlbuilder = this.createSQLBuilder(); |
| 149 | 149 |
sqlbuilder.select().column().all(); |
| 150 | 150 |
sqlbuilder.select().from().table() |
| ... | ... | |
| 152 | 152 |
.schema(this.table.getSchema()) |
| 153 | 153 |
.name(this.table.getTable()); |
| 154 | 154 |
// sqlbuilder.select().from().subquery(this.table.getSubquery()); |
| 155 |
sqlbuilder.select().limit(1);
|
|
| 155 |
sqlbuilder.select().limit(0);
|
|
| 156 | 156 |
|
| 157 | 157 |
String sql = sqlbuilder.toString(); |
| 158 | 158 |
return sql; |
Also available in: Unified diff