Is Postgis schemas are supported ?

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

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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads