StringBuffer sqlUpdate = new StringBuffer(
"update DO_Code_MaxSequence SET max_sequence=max_sequence+1")
.append(" WHERE upper(code_ItemUid)=?");
Connection con = null;
PreparedStatement stmt = null;
DOBO bo = DOBO.getDOBOByName("do_authorization");
DODataSource dss = bo.getDataBase();
try {
// query
con = dss.getContextConnection();
stmt = con.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,