Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Streamsets JDBC Lookup Can't read postgresql sequence Nextval

Hi All,

I am trying fetch nextval of postgresql sequence in streamsets jdbc lookup stage, But it give mes below error. " 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' "

However I can eliminate this error by unchecking " Enforce read-only connection" option on advanced tab

But I am not sure about the risk of unchecking it . Can anyone address risk of disabling read-only connection or any alternate solution to this ?