I have been trying to discover answers in this list for some of my questions and have been successful so far. However, there is one (logical perhaps) issue that I am facing at the moment, for which I havent discovered an answer.
I am trying to insert a BLOB data into an Oracle Database.
One of my colleagues suggested that I may use the Java way of doing things which is:
Step 1) Insert into the table with BLOB column reading empty_blob()
Step 2) Lock the row by selecting the BLOB column for update
Step 3) Setting the BLOB column value (as java.sql.BLOB object) with the desired bytes
Step 4) Update the desired row with the BLOB data.
Whilst the above can be done in a Java based service, is there any way of doing the needful using built in web Methods services?
Can you give me pointers on making this generic?
Could the same be done with jdbc adaptors?
Finally, is there a way to use connections from a pool (possibly that used by the webMethods adapters) to perform JDBC SQL manipulations?