not sure why it was submitted as an discussion, but that is how I like
feature requests! :)
-------- Original-Nachricht --------
Betreff: [jump-pilot:discussion] Schema problem in new Driver with
Read/Write capabilities for PostGIS
Datum: Sat, 14 Jun 2014 05:50:17 +0000
Von: Francisco Avalos <fjavalo...@users.sf.net>
Antwort an: [jump-pilot:discussion]
<729...@discussion.jump-pilot.p.re.sf.net>
An: [jump-pilot:discussion] <729...@discussion.jump-pilot.p.re.sf.net>
The driver does not allow tables in other schemas only in the public scheme.
Throws the following error:
2014-06-13 20:27:34,545 INFO java.lang.Error: Error : SELECT "geom"
FROM "otherschema.table" WHERE true LIMIT 2147483647;
ERROR: no existe la relación «otherschema.table»
Position: 20
at
com.vividsolutions.jump.datastore.postgis.PostgisFeatureInputStream.getFeatureSchema(PostgisFeatureInputStream.java:106)
at
com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.executeAdhocQuery(PostgisDSConnection.java:69)
at
com.vividsolutions.jump.datastore.postgis.PostgisDSConnection.execute(PostgisDSConnection.java:39)
at
org.openjump.core.ui.plugin.datastore.postgis2.PostGISDataStoreDataSource.createFeatureCollection(PostGISDataStoreDataSource.java:85)
at
org.openjump.core.ui.plugin.datastore.WritableDataStoreDataSource.access$000(WritableDataStoreDataSource.java:42)
at
org.openjump.core.ui.plugin.datastore.WritableDataStoreDataSource$1.executeQuery(WritableDataStoreDataSource.java:144)
at
org.openjump.core.ui.plugin.datastore.WritableDataStoreDataSource$1.executeQuery(WritableDataStoreDataSource.java:154)
at
org.openjump.core.ui.plugin.datastore.AddWritableDataStoreLayerWizard.executeQuery(AddWritableDataStoreLayerWizard.java:172)
at
org.openjump.core.ui.plugin.datastore.AddWritableDataStoreLayerWizard.load(AddWritableDataStoreLayerWizard.java:160)
at
org.openjump.core.ui.plugin.datastore.AddWritableDataStoreLayerWizard.createLayer(AddWritableDataStoreLayerWizard.java:138)
at
org.openjump.core.ui.plugin.datastore.AddWritableDataStoreLayerWizard.run(AddWritableDataStoreLayerWizard.java:70)
at
org.openjump.core.ui.plugin.file.OpenWizardPlugIn.run(OpenWizardPlugIn.java:108)
at
com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:152)
at java.lang.Thread.run(Thread.java:745)
I modified the following in the source code of the class
PostGISDataStoreDataSource.java
I changed the code in createFeatureCollection and buildQueryString methods:
line 135:
sb.append(" FROM \"")
.append(schemaName)
.append("\".\"")
.append(tableName)
.append("\" WHERE ")
.append(whereClause)
.append(extent)
.append(" LIMIT " + max_features)
.append(";");
and line 115:
String[] columns =
((PostgisDSMetadata)pgConnection.getMetadata()).getColumnNames(PostGISQueryUtil.unquote(schemaName
+ "." + tableName));
And now I can load the layer.
---
[ Schema problem in new Driver with Read/Write capabilities for
PostGIS](https://sourceforge.net/p/jump-pilot/discussion/729479/thread/4c5d6c77/?limit=25#c585)
---
Sent from sourceforge.net because you indicated interest in
<https://sourceforge.net/p/jump-pilot/discussion/729479/>
To unsubscribe from further messages, please visit
<https://sourceforge.net/auth/subscriptions/>
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://p.sf.net/sfu/hpccsystems
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
