Skip to Content
0
Former Member
Sep 27, 2005 at 05:37 AM

Working with JDBC Adapter

11 Views

I have XML

<persons>
  <person>
  </person>
  ....
</persons>

I need to perform UPDATE or INSERT for each <person> in one transacion.

Will this SQL XML work?

<STATEMENT> 
  <TABLE_NAME action="UPDATE_INSERT">
     <table>realDbTableName</table>   
     ... 
  </TABLE_NAME>
  <TABLE_NAME action="UPDATE_INSERT">
     <table>realDbTableName</table>  
     ...  
 </TABLE_NAME>
  ... 
</STATEMENT>

Is it posible to prevent UPDATE if the data in <parson> are the same like in DB TABLE?