topic Re: mapping_Postgres.xml in Talend Studio

mapping_Postgres.xml

vivekjayapalan — Mon, 04 Apr 2016 20:46:50 GMT

Hi,
I am having issues with extracting data from generic database in TOS 6.1. We have a source system which has Denodo Views, the database is Generic and type is Postgres. I was able to establish DB connection under metadata using JDBC URL. I am also able to retrieve schema under the metadata. But in tJDBCInput when i click guess schema, an error message pops out saying "choose correct mapping file. Note: This is normal with JDBC". So i clicked to choose and choose mapping_Postgres.xml file from the list, but i keep an getting error saying "Unsupported Resultset Type".
Any idea why i am getting this error.
Thanks

Re: mapping_Postgres.xml

Anonymous — Tue, 05 Apr 2016 04:08:17 GMT

Hi,
Did you change the data type mapping between Talend type and Postgres type in mapping_Postgres.xml?
Have you already successfully set up Postgres DB connection in metadata? Can you retrieve table schema from the database connection you have just set up?
Best regards
Sabrina

Re: mapping_Postgres.xml

vivekjayapalan — Tue, 05 Apr 2016 13:53:08 GMT

Hi,

No i didn't change anything in mapping_Postgres.xml file, Should i be doing any changes?

i was able to create connection and retrieve views and tables. The problem arise only when i do guess schema, even though i don't change anything in the query part.

Thanks,
Vivek

Re: mapping_Postgres.xml

Anonymous — Wed, 06 Apr 2016 08:40:38 GMT

Hi,
What does your query look like? Are you able to successfully execute your query in sql builder?
Can you run a simple query to see if it works?
Best regards
Sabrina

Re: mapping_Postgres.xml

vivekjayapalan — Wed, 06 Apr 2016 17:59:10 GMT

Hi,
it is just a default query "select <field names> from <table name>". Once you drag the metadata into the job it gives all the components, there i just dragged and drop tJDBCInput in to the job and after that if i press guess schema, i get this message "Please choose the correct mapping file. Note: This is normal when using JDBC component", So i click ok and choose mapping_Postgres.xml file and i get message saying "java.SQL.Exception: Unsupported ResultSet type"

I tried installing new Talend, i still get the same error. Any help on this will be great.