One Star

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

2 REPLIES
One Star

Re: Is Postgis schemas are supported ?

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
One Star Fxp
One Star

Re: Is Postgis schemas are supported ?

More info on the bugtracker : http://www.talendforge.org/bugs/view.php?id=3088
Ciao. Francois