This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,
The pipeline sends the record to JDBC INSERT snap, under JDBC INSERT Snap account has auto commit is enabled and batch size is 60. if 180 records are streamed into JDBC INSERT Snap and there w...
Hi All,
We are facing the below error message when we use the JDBC Execute Snap.
Can you please help us out with the error.
We are trying to capture the value in @result. It is not returning t...
Using a Generic JDBC - Execute snap at the beginning of my pipeline with a hard-coded SQL query that has no issues running from any other place (workbench, phpstorm, etc) returns 800 results and an e...
I have a pipeline that reads from Oracle and writes to PGSQL. When inserting to PGSQL, I get this error
Batch entry 0 insert into “pg_temp”.“crmi002b_ut_pprs001” (“end_date”, “opportunity_type”, “s...
Hi, I would like to bring up and highlight an issue that often comes in SnapLogic pipelines where we have 3 or more Generic JDBC Execute snaps - that connects to DB2 which often runs into the issue o...
The schema name of table is dependent on the environments (Dev, QA, Prod) so we wanna parameterize the Schema name in JBDC Select, Insert, Update and Execute Snap. Can you please guide us on how to a...
I have on-prem groundplex. We need to connect mainframe Db2 database. I heard we can do that by using JDBC select snap. In order to use JDBC snaps, do we need JDK installed in our machine?
Hello,
I am seeing a different behavior in Generic JDBC execute or Select snap when it has upstream and downstream.
I have a table with 10000 records and the query used in both snaps is "s...