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 <t3k1pa...@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/ >