# Read from Oracle Database

**URL:** <https://forum.cloverdx.com/t/read-from-oracle-database/158>\
**Category:** CloverDX Platform\
**Created:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/read-from-oracle-database/158 "2007-07-16T00:00:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/read-from-oracle-database/158/1 "2007-07-16T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/read-from-oracle-database/158/2 "2007-07-16T08:23:44Z")

</div>

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

Best regards, Martin.

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/read-from-oracle-database/158/3 "2007-07-16T08:23:45Z")

</div>

It works.

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

Many thanks,  
Wendy

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/read-from-oracle-database/158/4 "2007-07-16T08:23:46Z")

</div>

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