cassandra-jdbc-driver icon indicating copy to clipboard operation
cassandra-jdbc-driver copied to clipboard

Getting error only unlogged batches allowed while trying to insert rows into a table using SSL

Open SubashL opened this issue 2 years ago • 0 comments

Caused by: org.jooq.exception.DataAccessException: SQL [null]; Only UNLOGGED Batches are supported at this time. at org.jooq_3.9.1.DEFAULT.debug(Unknown Source) at org.jooq.impl.Tools.translate(Tools.java:1983) at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:676) at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:125) at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:78) at com.snaplogic.snap.api.sql.operations.JdbcOperationsImpl.executeBatch(JdbcOperationsImpl.java:2018) at com.snaplogic.snap.api.sql.operations.JdbcOperationsImpl.lambda$flushBatch$9(JdbcOperationsImpl.java:1966) at net.jodah.failsafe.Functions$11.call(Functions.java:263) at net.jodah.failsafe.SyncFailsafe.call(SyncFailsafe.java:145) at net.jodah.failsafe.SyncFailsafe.get(SyncFailsafe.java:69) at com.snaplogic.snap.api.sql.operations.JdbcOperationsImpl.flushBatch(JdbcOperationsImpl.java:1943) at com.snaplogic.snap.api.sql.operations.JdbcOperationsImpl.executeStatement(JdbcOperationsImpl.java:696) at com.snaplogic.snaps.sql.SimpleSqlExecuteSnap.processStatement(SimpleSqlExecuteSnap.java:273) ... 17 more Caused by: java.sql.SQLException: Only UNLOGGED Batches are supported at this time. at com.wisecoders.dbschema.cassandra.CassandraBaseStatement.executeBatch(CassandraBaseStatement.java:74) at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) at com.zaxxer.hikari.pool.HikariProxyStatement.executeBatch(HikariProxyStatement.java) at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:93) at org.jooq.tools.jdbc.DefaultStatement.executeBatch(DefaultStatement.java:93) at org.jooq.impl.BatchMultiple.execute(BatchMultiple.java:106) ... 26 more Caused by: com.datastax.oss.driver.api.core.servererrors.InvalidQueryException: Only UNLOGGED Batches are supported at this time. at com.datastax.oss.driver.api.core.servererrors.InvalidQueryException.copy(InvalidQueryException.java:48) at com.datastax.oss.driver.internal.core.util.concurrent.CompletableFutures.getUninterruptibly(CompletableFutures.java:149) at com.datastax.oss.driver.internal.core.cql.CqlRequestSyncProcessor.process(CqlRequestSyncProcessor.java:53) at com.datastax.oss.driver.internal.core.cql.CqlRequestSyncProcessor.process(CqlRequestSyncProcessor.java:30) at com.datastax.oss.driver.internal.core.session.DefaultSession.execute(DefaultSession.java:230) at com.datastax.oss.driver.api.core.cql.SyncCqlSession.execute(SyncCqlSession.java:54) at com.wisecoders.dbschema.cassandra.CassandraBaseStatement.executeBatch(CassandraBaseStatement.java:72) ... 31 more Reason: SQL [null]; Only UNLOGGED Batches are supported at this time.

SubashL avatar Jul 10 '23 12:07 SubashL