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