Postgres nextval error when using JDBC LookUp


Userlevel 4
Badge

ISSUE: 

Error from JDBC Lookup:

com.google.common.util.concurrent.UncheckedExecutionException: com.streamsets.pipeline.api.base.OnRecordErrorException: JDBC_02 - Exception executing query: 'SELECT nextval('ann.seq_fundid') AS fund_id;' - 'ERROR: cannot execute nextval() in a read-only transaction'
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2207)

SOLUTION:

By default, JDBC Lookup is set to Enforce Read-only Connection option to true, as Postgre's nextval requires INSERT operation this value has to be set to false. 

To disable, select Advanced property and uncheck Enforce Read-only Connection. 


0 replies

Be the first to reply!

Reply