boolean flag = true;
while (flag) {
stmt
.executeQuery("delete from WORKBOOK_REPOSITORY where NAME = '"
+ name + "' and diff_id = 'a0'" );
stmt
.executeQuery("insert into WORKBOOK_REPOSITORY(name,diff_id,content,Update_Time) values('"
+ name
+ "','a0',empty_blob(),"
+ "SYSDATE"
+ ")");
rset = stmt
.executeQuery("select CONTENT from WORKBOOK_REPOSITORY where NAME = '"
+ name + "' and diff_id ='a0'");
if (rset.next()) {
blob = (BLOB) rset.getBlob("CONTENT");
flag = false;
}
}
OutputStream outToPage = blob.getBinaryOutputStream();
outToPage.write(content.getBytes());
while (flag) {
stmt
.executeQuery("delete from WORKBOOK_REPOSITORY where NAME = '"
+ name + "' and diff_id = 'a0'" );
stmt
.executeQuery("insert into WORKBOOK_REPOSITORY(name,diff_id,content,Update_Time) values('"
+ name
+ "','a0',empty_blob(),"
+ "SYSDATE"
+ ")");
rset = stmt
.executeQuery("select CONTENT from WORKBOOK_REPOSITORY where NAME = '"
+ name + "' and diff_id ='a0'");
if (rset.next()) {
blob = (BLOB) rset.getBlob("CONTENT");
flag = false;
}
}
OutputStream outToPage = blob.getBinaryOutputStream();
outToPage.write(content.getBytes());