Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 5th, 2012  |  syntax: None  |  size: 0.95 KB  |  hits: 20  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Is there some trick to update an Oracle CLOB with Mybatis 3?
  2. <update id="updateRSA103RequestData" parameterType="com.company.domain.RSA103XMLData" flushCache="true">
  3.         update
  4.         RSA_SUBMIT_DATA
  5.         set TXLIFE_REQUEST = #{request}
  6.         where RSA_SUBMIT_QUEUE_ID = #{id}
  7. </update>
  8.        
  9. select *
  10. from RSA_SUBMIT_DATA
  11. where RSA_SUBMIT_QUEUE_ID = 51
  12.  
  13. RSA_SUBMIT_QUEUE_ID | TXLIFE_REQUEST  | TXLIFE_RESPONSE
  14. 51             | originalString   | resultString
  15.        
  16. SqlSession sqlSession = sqlSessionFactory.openSession();
  17. try {
  18.     log.debug("autoCommit: " + sqlSessionFactory.getConfiguration().getEnvironment().getDataSource().getConnection().getAutoCommit());
  19.     PolicyTransactionMapper policyTransactionDAO = sqlSession
  20.                 .getMapper(PolicyTransactionMapper.class);
  21.     RSA103XMLData xmlData = new RSA103XMLData();
  22.     xmlData.setId(rsaSubmitQueueID);
  23.     xmlData.setRequest(request);
  24.     policyTransactionDAO.updateRSA103RequestData(xmlData);