# DB Loader not working with Oracle Connection **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [May 23, 2024, 11:55am UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692 "2024-05-23T11:55:55Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![dhruv\_saarthee](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/eb9ed0/32.png) [@dhruv\_saarthee](https://forum.knime.com/u/dhruv_saarthee)\ **Post date:** [May 23, 2024, 11:55am UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/1 "2024-05-23T11:55:56Z")
I am continuously getting this error while using DB Loader node to load data from a CSV file to an Oracle Database - ```auto Configure failed (NullPointerException): Cannot invoke "org.knime.database.node.io.load.DBLoaderNode2Factory.get()" because the return value of "java.util.Map.get(Object)" is null ``` Knime Version - 5.2.3 Here is the image of the workflow - ![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/b/fb860a078036305201db707f12182f6519d466ee.png) ---
**Author:** ![k10shetty1](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/c57346/32.png) [@k10shetty1](https://forum.knime.com/u/k10shetty1)\ **Post date:** [May 29, 2024, 2:44pm UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/2 "2024-05-29T14:44:59Z")
Hi @dhruv_saarthee, This DB Loader uses database specific bulk loading functionality that only some databases (e.g. Hive, MySQL, PostgreSQL and H2) support to load large amounts of data into an existing database table. KNIME Analytics Platform does not support bulk insertion into Oracle. Can you try replacing the DB Loader node with the [DB Writer](https://hub.knime.com/knime/extensions/org.knime.features.database/latest/org.knime.database.node.io.write.DBWriteNodeFactory/) node and check if it works. Best, Keerthan ---
**Author:** ![dhruv\_saarthee](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/eb9ed0/32.png) [@dhruv\_saarthee](https://forum.knime.com/u/dhruv_saarthee)\ **Post date:** [May 29, 2024, 3:00pm UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/3 "2024-05-29T15:00:07Z")
Hey k10shetty1, Thanks for your reply. DB Writer works fine. But my objective was to load bulk data (nearly 40 million records) in the Oracle database. DB Writer was very slow in this respect. That’s why I turned towards DB Loader node. Any other solution? ---
**Author:** ![k10shetty1](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/k/c57346/32.png) [@k10shetty1](https://forum.knime.com/u/k10shetty1)\ **Post date:** [May 29, 2024, 3:11pm UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/4 "2024-05-29T15:11:22Z")
Hi @dhruv_saarthee, I found this [thread](https://forum.knime.com/t/how-to-do-a-bulk-insert-into-a-oracle/64520) explaing the issue discussed here. I hope this helps. Best, Keerthan ---
**Author:** ![dhruv\_saarthee](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/eb9ed0/32.png) [@dhruv\_saarthee](https://forum.knime.com/u/dhruv_saarthee)\ **Post date:** [May 29, 2024, 3:50pm UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/5 "2024-05-29T15:50:53Z")
Thanks Keerthan. You will be surprised to know that for me, when I tried to load bulk data using SQL_Loader in the Oracle Database it took longer than DB Writer node. LOL. 😆 Also the tutorial mentioned in the post didn’t work for me. But a video tutorial on SQL_Loader on YouTube surely worked. Thanks again for your time. ---
**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\ **Post date:** [May 29, 2024, 3:51pm UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/6 "2024-05-29T15:51:03Z")
Hi @dhruv_saarthee and @k10shetty1 , I can see why the DB Loader won’t necessarily work with Oracle SQL Loader, but I’m surprised at the information in that post, saying that this is because _Oracle SQL_Loader must run on the Database Server machine\*, rather than on a client. I haven’t used it in a few years, but that never used to be the case. I used to load data from my local machine. However, unless it has been installed on the client machine, it won’t be available. I unfortunately am not in a position to test out the theory, but I would expect that a solution similar to the one mentioned in that post could be achieved on a client machine if SQL Loader installed, without the need to transfer the files to the db server. (i.e. write a file locally containing the data to be loaded, and then execute an instruction to call SQL Loader to actually perform the upload). It obviously wouldn’t be using the DB Loader node though. I’m not in a position to test this out (currently no writeable Oracle database available to me, although I could try installing one at home later) but @dhruv_saarthee , do you have Oracle SQL Loader installed on your client? If so, can you try out using it directly (outside of KNIME) from your client machine for performing a _small_ bulk load? If it can be done, it should be possible to integrate calling it from the KNIME workflow, by executing a command line script. What OS are you using? ---
**Author:** ![dhruv\_saarthee](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/eb9ed0/32.png) [@dhruv\_saarthee](https://forum.knime.com/u/dhruv_saarthee)\ **Post date:** [May 29, 2024, 3:56pm UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/7 "2024-05-29T15:56:13Z")
Hi takbb, I am using Windows OS and I have tried SQL\*Loader. It is also slow as well. ---
**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\ **Post date:** [May 29, 2024, 4:13pm UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/8 "2024-05-29T16:13:14Z")
OK. Unfortunately SQL\*Loader is likely to be the fastest option since it is Oracle’s bulk-load utility, so even if KNIME could use DB Loader with Oracle, it is not likely to outperform Oracle’s product. How slow is “slow”, as a matter of interest? Do you have a gauge for rows/minute? Thinking this through, if it were possible to call sql\*loader from KNIME, as far as I can see, it would have to pass the connection details (user/password) in clear text which probably wouldn’t be desirable in most circumstances! ---
**Author:** ![dhruv\_saarthee](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/eb9ed0/32.png) [@dhruv\_saarthee](https://forum.knime.com/u/dhruv_saarthee)\ **Post date:** [May 30, 2024, 4:19am UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/9 "2024-05-30T04:19:52Z")
Yes I measured the time taken by SQL\*Loader. It was approx. 700K to 800K rows per minute. ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [August 28, 2024, 4:20am UTC](https://forum.knime.com/t/db-loader-not-working-with-oracle-connection/79692/10 "2024-08-28T04:20:16Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.