Hi All:
My custom java client subscribes the specified Broker Events. I have converted Broker Events to Binary Array Data using webMethods API. Then I inserted this Binary Array Data into Oracle Database as BLOB using setBinaryStream.
In order to Re-Publish certain events I have retreived the BLOB using getBLOB. I also used an input stream to read data from the table using blob.getBinaryStream.
Does any one has done something similar or have any suggestions please.
Thanks in advance.
I did the same.
I’ve an ILA that converts the event in its binary rappresentation (toBinData) and then I put it on a blob Oracle field.
When I want to replublish it I read it from the blob and the I call the fromBinData method.
I’m using Oracle 8.1.7.2, so to insert the data on a blob stream using Oracle JDBC API, I used :
INSERT EMPTY_BLOB() …
dbBlob=(oracle.sql.BLOB)result.getBlob(1);
dbBlob.putBytes(1,event);
prstmt= conn.prepareStatement(“UPDATE EAI_DBSCARTI SET EAI_EVENT= ? WHERE EAI_ID= ?”);
prstmt.setBlob(1,dbBlob);
prstmt.setInt(2,MaxId);
That’s all.