Read from Oracle Database

CloverDX Platform
1

I’m currently evaluating different solutions for ETL and Clover looks like a good option.
I installed successfully and was able to create and run the GraphSimpleCopy.

I could create a new graph which copying data from one database table to another dtaabase table. But when I run it, I got the following error messages:

INFO [WatchDog] - Sucessfully started all nodes in phase!
FATAL [WatchDog] - !!! Fatal Error !!! - graph execution is aborting
ERROR [WatchDog] - Node DB_OUTPUT_TABLE0 finished with status: ERROR caused by: null
DEBUG [WatchDog] - Node DB_OUTPUT_TABLE0 error details:
java.lang.NullPointerException
at org.jetel.connection.SQLUtil.getFieldTypes(SQLUtil.java:321)
at org.jetel.component.DBOutputTable.execute(DBOutputTable.java:340)
at org.jetel.graph.Node.run(Node.java:364)
at java.lang.Thread.run(Unknown Source)
WARN [WatchDog] - Interrupted node: DB_INPUT_TABLE0
WARN [WatchDog] - Interrupted node: DB_OUTPUT_TABLE0
WARN [WatchDog] - Interrupted node: SIMPLE_COPY0

I’m wondering whether CloverETL can perform this kind task. If it can, what’s wrong with my graph.

Here is my graph:

<?xml version="1.0" encoding="UTF-8"?>

Thanks,
wendy

2

We didn’t appoint the exact release date, nevertheless this bugfix will be covered by 2.1.2 clover release.

Best regards, Martin.

3

It works.

By the way, do you know when the next build will be released?

Many thanks,
Wendy

4

Hello Wendy,

try to add an attribute cloverFields=“CLOVER_NAME1, …” into db output table node that provides mapping between clover fields and db attributes. This (automatic) mapping will be fixed in next build. Thanks.

ja