DB-connect

[VijaySrrie]

Hi, I am trying to connect to Database using DB connect. When I choose Input type as Batch --> I am able to fetch the database and able to see the logs But when I choose as Raising --> with raising column --> access_timestamp I am getting this error --> org.postgresql.util.PSQLException: No value specified for parameter 1. Please let me know how to proceed further.

[anilchaithu]

@VijaySrrie 

you should use initial check point value (part of the query) for this field "access_timestamp ". Then the query uses this as checkpoint and fetches the data after that.

[anilchaithu]

@VijaySrrie 

The query looks good. what about the settings? 

I assume you are using access_timestamp as rising column. Did you set up the initial check point value for this field ? 

[VijaySrrie]

@anilchaithu  - I used access_timestamp but the query was not working with rising column, so we have added one more select statement in the start of the query. Now it is working fine.