conn = instance.getProcessTransactionContext().getConnection();
DAOFactory daoFactory = DAOFactory.getInstance(instance.getProcessTransactionContext());
Timestamp now = new Timestamp(daoFactory.getNow().getTimeInMillis());
KeyGeneratorDAO kgd = daoFactory.createKeyGenerator("DOC_COMMENTS", new HashMap());
kgd.select();
kgd.next();
Number seqresult = kgd.getKeyNumber();
sql = (
"INSERT INTO doc_comments ("
+ "id, instance_id, contents, opt_type, empno, empname, emptitle, "
+ "tracingtag, created_date, created_by, updated_date, updated_by, apprtitle"