ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Denis Mekhanikov <dmekhani...@gmail.com>
Subject Re: insert into ignite cache from Netezza database using talend
Date Fri, 05 Jan 2018 09:41:36 GMT
Hi Kavin!

Inserts are supported, but transactions are not yet (but they are expected
to be this year).
Make sure, that explicit transactions are not started by Talend.

Denis


пт, 5 янв. 2018 г. в 7:27, Kavin <t3k1panda@gmail.com>:

> Hi,
>
> I am using talend to insert data from netezza database to ignite cache. The
> Netezza SQL query has joins with many tables. I am getting the below error.
> Are inserts supported? The server was started using a java code. The
> attached image contains the connection details.
> *Error:*
>
> [statistics] connecting to socket on port 3343
> [statistics] connected
> Jan 04, 2018 8:35:54 PM java.util.logging.LogManager$RootLogger log
> SEVERE: Failed to resolve default logging config file:
> config/java.util.logging.properties
> Exception in component tJDBCOutput_1 (NzToCache)
> *java.sql.SQLFeatureNotSupportedException: Transactions are not supported.*
>         at
>
> org.apache.ignite.internal.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:170)
>         at
>
> local_project.nztocache_0_1.NzToCache.tNetezzaInput_1Process(NzToCache.java:463)
>         at
> local_project.nztocache_0_1.NzToCache.runJobInTOS(NzToCache.java:1027)
>         at local_project.nztocache_0_1.NzToCache.main(NzToCache.java:876)
> [statistics] disconnected
> Job NzToCache ended at 20:35 04/01/2018. [exit code=1]
> <
> http://apache-ignite-users.70518.x6.nabble.com/file/t1427/ignite_talend.jpg
> >
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Mime
View raw message