topic Re: Oracle to Postgres - XML_TYPE and CLOB conversion in Talend Studio

Oracle to Postgres - XML_TYPE and CLOB conversion

Anonymous — Wed, 21 May 2014 22:58:00 GMT

Hi, I am currently trying to migrate an existing Oracle DB (with data already in it) to a new Postgresql DB. Each table I am migrating over has at least one field of XML_TYPE or CLOB type. I would like to convert these two types to the existing corresponding types in Postgres, but I am having a hard time doing this. I understand there is an "XML" type and "TEXT" type in Postgres, and I am trying to us the tMap component to map these values to each other, but I am not sure how to do it. Any help is greatly appreciated! Thanks!

Re: Oracle to Postgres - XML_TYPE and CLOB conversion

Anonymous — Thu, 22 May 2014 05:43:28 GMT

Hi,
Have you tried tConvertType?
Vaibhav

Re: Oracle to Postgres - XML_TYPE and CLOB conversion

Anonymous — Thu, 22 May 2014 16:47:32 GMT

Yes I have tried but I'm having trouble - if I have a CLOB or XML type they start out as "Object" types and then to write them to another database type, which type do I want to convert them to? I try mapping an Object to a String but it fails when I try to run it...
Looks like this when failing (and nothing gets added to the table):
Batch entry 0 INSERT INTO "TABLE1" ("XML_FILE") VALUES (oracle.sql.CLOB@386ac2) was aborted. Call getNextException to see the cause.