Skip to Main Content

Java Programming

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 create a JAVA consumer to update an oracle database

Keith8Jul 29 2018 — edited Jul 30 2018

I will be provided a stream of data that is encoded in XML looking something like this:

<transaction tid='00000000000000001121' ts='2013-06-02 22:14:36.000000' ops='4' commitTs='2013-06-02 22:14:36.000000'>

<operation table='TEST.CUSTOMER' type='INSERT' ts='2013-06-02 22:14:36.000000' pos='00000000000000001121' numCols='4'>

<col name='CODE' index='0'>

   <after><![CDATA[ABCD]]></after>

</col>

<col name='NAME' index='1'>

   <after><![CDATA[JOHNNY APPLEBY]]></after>

</col>

<col name='CITY' index='2'>

   <after><![CDATA[SEATTLE]]></after>

</col>

<col name='STATE' index='3'>

   <after><![CDATA[WA]]></after>

</col>

</operation>

</transaction>

How do set up a consumer to accept this and insert this into an Oracle database?

Sorry I know this is very basic JAVA as I have never done this.

Thanks

Keith

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 27 2018
Added on Jul 29 2018
2 comments
227 views