Skip to Main Content

Portuguese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to load data from Excel to Database Table through Job Automation??

User_Q1VLJJun 15 2022

Hi, I've been asked by my manager to load data from Excel to Database Table through Job Automation. I'm using Oracle DB 19c and SQL Dev. Is there any other application that I need to install ?? Also, please specify the steps for this task.
Thanks.

Comments

Greybird-Oracle

Hello,

From the stack trace, it looks like you have a field of type HashSet that is persistent, and the HashSet is being changed in one thread of your app, and written (PrimaryIndex.put) by another thread in your app.  In other words, one HashSet instance, or the entity object that contains it, is being accessed by multiple threads, and one thread is changing it while another is reading it.

Note that this has nothing to do with database access or record locking. It only involves access to the HashSet (or entity object) instance. Normally, entity objects are not shared between threads. Are you sharing them explicitly between threads?

--mark

1 - 1

Post Details

Added on Jun 15 2022
0 comments
344 views