Forum Discussion

cesar_bolanos's avatar
cesar_bolanos
New Contributor
6 years ago

Insert error with JDBC insert and PGSQL

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...
tstack's avatar
tstack
Former Employee
7 years ago

You should be able to reference the other library through the lib variable. Is that not working?

For example, if you this as the library helper.expr:

{
    chefify: x => x + ' bork! bork! bork!'
}

You should be able to reference it from another library, like so:

{
    msg: () => lib.helper.chefify('Hello, World!')
}

Note that if the references are not in functions, but directly in the top-level expression, you’ll need to ensure the libraries are listed in the right order in the pipeline properties.