Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Is Postgis schemas are supported ?

Hi,
I try to export Postgis data to ShapeFile.
when my postgis is in the public schema there's no problem but for others schemas I use syntax like this "my_schema.my_table" and I have the following error
org.geotools.data.db2.DB2DataStoreFactory isAvailable
INFO: DB2 driver found: false
Exception in component sPostgisInput_1_PG
org.geotools.data.SchemaNotFoundException: Feature type could not be found for urba.zone_test
at org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getPkColumnInfo(DefaultFIDMapperFactory.java:280)
at org.geotools.data.jdbc.fidmapper.DefaultFIDMapperFactory.getMapper(DefaultFIDMapperFactory.java:98)
at org.geotools.data.postgis.PostgisDataStore.buildFIDMapper(PostgisDataStore.java:984)
at org.geotools.data.jdbc.FeatureTypeHandler.getFIDMapper(FeatureTypeHandler.java:230)
at org.geotools.data.postgis.PostgisDataStore.getFeatureSource(PostgisDataStore.java:1632)
at proj1.job1.job1.sPostgisInput_1_PGProcess(job1.java:480)
at proj1.job1.job1.runJob(job1.java:919)
at proj1.job1.job1.main(job1.java:855)
Then is postgis schemas are supported ? And, in this case, what is the good syntax ?
Thanks..

Labels (3)
2 Replies
Anonymous
Not applicable
Author

Hi,
Current release (1.1) does not support other Postgis schema than public.
We fixed it in trunk and we will probably release soon to correct some small bugs (next week).
Cheers,
Mathieu
Anonymous
Not applicable
Author