Revision 45767
| trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.impl/src/main/java/org/gvsig/fmap/dal/impl/DefaultDatabaseWorkspaceManager.java | ||
|---|---|---|
| 276 | 276 |
} |
| 277 | 277 |
|
| 278 | 278 |
public void createTableResources(String tableName) throws RuntimeException {
|
| 279 |
// H2Spatial crea esta table a mano. |
|
| 280 |
// Si tocamos algo aqu? hay que modificar |
|
| 281 |
// la creacion de esta tabla en el helper de H2 |
|
| 282 |
|
|
| 279 | 283 |
DataServerExplorer server = null; |
| 280 | 284 |
try {
|
| 281 | 285 |
server = this.getServerExplorer(); |
| ... | ... | |
| 327 | 331 |
} |
| 328 | 332 |
|
| 329 | 333 |
private void createTableConfiguration() {
|
| 334 |
// H2Spatial crea esta table a mano. |
|
| 335 |
// Si tocamos algo aqu? hay que modificar |
|
| 336 |
// la creacion de esta tabla en el helper de H2 |
|
| 330 | 337 |
String tableName = TABLE_CONFIGURATION_NAME; |
| 331 | 338 |
DataServerExplorer server = null; |
| 332 | 339 |
try {
|
| ... | ... | |
| 336 | 343 |
ft.add(FIELD_CONFIGURATION_NAME, DataTypes.STRING, 200) |
| 337 | 344 |
.setAllowNull(false) |
| 338 | 345 |
.setIsPrimaryKey(true); |
| 339 |
ft.add(FIELD_CONFIGURATION_VALUE, DataTypes.STRING, 200)
|
|
| 346 |
ft.add(FIELD_CONFIGURATION_VALUE, DataTypes.STRING, 10240)
|
|
| 340 | 347 |
.setAllowNull(true); |
| 341 | 348 |
server.add(tableName, params, false); |
| 342 | 349 |
this.existsConfiguration = null; |
| 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 | ||
|---|---|---|
| 440 | 440 |
case java.sql.Types.CHAR: |
| 441 | 441 |
case java.sql.Types.VARCHAR: |
| 442 | 442 |
case java.sql.Types.LONGVARCHAR: |
| 443 |
case java.sql.Types.CLOB: |
|
| 443 | 444 |
return DataTypes.STRING; |
| 444 | 445 |
|
| 445 | 446 |
case java.sql.Types.DATE: |
| 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/JDBCServerExplorerBase.java | ||
|---|---|---|
| 818 | 818 |
config.addResourceMapping(tableName, resourcesTableName); |
| 819 | 819 |
config.setResourcesReadOnly(resourcesTableName,readonly); |
| 820 | 820 |
JDBCStoreParameters params = this.helper.createOpenStoreParameters(this.getParameters()); |
| 821 |
setConfigValue(params, CONFIG_NAME_CUSTOM_RESOURCES, config.toJsonString()); |
|
| 821 |
if(!setConfigValue(params, CONFIG_NAME_CUSTOM_RESOURCES, config.toJsonString())) {
|
|
| 822 |
throw new RuntimeException("Can't save custom resources configuration");
|
|
| 823 |
} |
|
| 822 | 824 |
refreshCustomResourcesConfig(); |
| 823 | 825 |
|
| 824 | 826 |
|
| trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.h2spatial/org.gvsig.h2spatial.h2gis132/org.gvsig.h2spatial.h2gis132.provider/src/main/java/org/gvsig/fmap/dal/store/h2/H2SpatialHelper.java | ||
|---|---|---|
| 299 | 299 |
String[] sqls = new String[] {
|
| 300 | 300 |
"CREATE CACHED TABLE PUBLIC.\""+TABLE_RESOURCES_NAME+"\"(\""+FIELD_RESOURCES_NAME+"\" VARCHAR(150) NOT NULL, \""+FIELD_RESOURCES_RESOURCE+"\" BLOB DEFAULT NULL)", |
| 301 | 301 |
"ALTER TABLE PUBLIC.\""+TABLE_RESOURCES_NAME+"\" ADD CONSTRAINT PUBLIC.CONSTRAINT_E PRIMARY KEY(\""+FIELD_RESOURCES_NAME+"\")", |
| 302 |
"CREATE CACHED TABLE PUBLIC.\""+TABLE_CONFIGURATION_NAME+"\"(\""+FIELD_CONFIGURATION_NAME+"\" VARCHAR(200) NOT NULL, \""+FIELD_CONFIGURATION_VALUE+"\" VARCHAR(200) DEFAULT NULL)",
|
|
| 302 |
"CREATE CACHED TABLE PUBLIC.\""+TABLE_CONFIGURATION_NAME+"\"(\""+FIELD_CONFIGURATION_NAME+"\" VARCHAR(200) NOT NULL, \""+FIELD_CONFIGURATION_VALUE+"\" CLOB DEFAULT NULL)",
|
|
| 303 | 303 |
"ALTER TABLE PUBLIC.\""+TABLE_CONFIGURATION_NAME+"\" ADD CONSTRAINT PUBLIC.CONSTRAINT_2 PRIMARY KEY(\""+FIELD_CONFIGURATION_NAME+"\")" |
| 304 | 304 |
}; |
| 305 | 305 |
for (String sql : sqls) {
|
Also available in: Unified diff