Is Postgis schemas are supported ?

Anonymous — Sat, 16 Nov 2024 14:27:31 GMT

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..

Re: Is Postgis schemas are supported ?

Anonymous — Fri, 15 Feb 2008 08:28:06 GMT

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

Re: Is Postgis schemas are supported ?

Anonymous — Fri, 15 Feb 2008 09:19:03 GMT

More info on the bugtracker : https://community.talend.com/t5/Archive/tFileInputXML-not-looping-correctly/td-p/168972
Ciao. Francois

topic Is Postgis schemas are supported ? in Talend Studio

Is Postgis schemas are supported ?

Re: Is Postgis schemas are supported ?

Re: Is Postgis schemas are supported ?