Insert data to PostgreSQL tables with int array fields

One Star

Insert data to PostgreSQL tables with int array fields

Hello,
I try to experiment with Talend and for my purposes it is necessary to insert array (integer[]) data to PostgreSQL tables . Is it possible?
I use tPostgresqlOutput component.
I don't see corresponding type in list of DB types for integer[].
Source (Input) field type is List.
Error I've got:
org.postgresql.util.PSQLException:Can't infer the SQL type to use for an instance of java.util.ArrayList. Use setObject() with an explicit Types value to specify the type to use.
I tried to convert it to string and insert like string with same syntax ('{1,2,3}')', but there was error too.
Thanks for help.
Highlighted
Moderator

Re: Insert data to PostgreSQL tables with int array fields

Hi,
Please see this related forum: Forum 28545, hope you will get a light from it.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now