https://community.qlik.com/t5/Talend-Studio/Insert-data-to-PostgreSQL-tables-with-int-array-fields/m-p/2330649#M99709 Hello, <BR />I try to experiment with Talend and for my purposes it is necessary to insert array (integer[]) data to PostgreSQL tables . Is it possible? <BR />I use tPostgresqlOutput component. <BR />I don't see corresponding type in list of DB types for integer[]. <BR />Source (Input) field type is List. <BR />Error I've got: <BR />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. <BR />I tried to convert it to string and insert like string with same syntax ('{1,2,3}')', but there was error too. <BR />Thanks for help. Sat, 16 Nov 2024 12:04:39 GMT Anonymous 2024-11-16T12:04:39Z https://community.qlik.com/t5/Talend-Studio/Insert-data-to-PostgreSQL-tables-with-int-array-fields/m-p/2330649#M99709 Hello, <BR />I try to experiment with Talend and for my purposes it is necessary to insert array (integer[]) data to PostgreSQL tables . Is it possible? <BR />I use tPostgresqlOutput component. <BR />I don't see corresponding type in list of DB types for integer[]. <BR />Source (Input) field type is List. <BR />Error I've got: <BR />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. <BR />I tried to convert it to string and insert like string with same syntax ('{1,2,3}')', but there was error too. <BR />Thanks for help. Sat, 16 Nov 2024 12:04:39 GMT https://community.qlik.com/t5/Talend-Studio/Insert-data-to-PostgreSQL-tables-with-int-array-fields/m-p/2330649#M99709 Anonymous 2024-11-16T12:04:39Z https://community.qlik.com/t5/Talend-Studio/Insert-data-to-PostgreSQL-tables-with-int-array-fields/m-p/2330650#M99710 Hi, <BR />Please see this related forum: <A href="https://community.qlik.com/s/feed/0D53p00007vCpAyCAK" target="_blank" rel="nofollow noopener noreferrer">https://community.talend.com/t5/Design-and-Development/resolved-creating-and-using-Arraylists-in-Talend/td-p/100161</A>, hope you will get a light from it. <BR />Best regards <BR />Sabrina Wed, 20 Mar 2013 04:00:28 GMT https://community.qlik.com/t5/Talend-Studio/Insert-data-to-PostgreSQL-tables-with-int-array-fields/m-p/2330650#M99710 Anonymous 2013-03-20T04:00:28Z