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/