Advertisement
Guest User

Untitled

a guest
Nov 9th, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.51 KB | None | 0 0
  1. @Component
  2. @Transactional
  3. public class FmTrfUtil {
  4. static int returnVal;
  5.  
  6. @PersistenceContext
  7. private EntityManager em;
  8. public int insertFmTrfs(List<String> trfs, String source) {
  9. Session session = em.unwrap( Session.class );
  10. final String[] trfArray = trfs.toArray(new String[trfs.size()]);
  11. final String src = source;
  12. session.doWork( new Work(){
  13. public void execute(Connection conn) throws SQLException {
  14. CallableStatement stmt = null;
  15. OracleConnection oraCon = conn.unwrap(OracleConnection.class);
  16. Array array = oraCon.createARRAY("VARCHAR2_TAB_T", trfArray);
  17. stmt = conn.prepareCall("{? = call FM_TRF_UTIL.process_fm_trf(?,?)}");
  18. stmt.registerOutParameter(1, Types.INTEGER);
  19. stmt.setArray(2, array);
  20. stmt.setString(3, src);
  21. stmt.execute();
  22. returnVal = stmt.getInt(1);
  23. }
  24. });
  25. return returnVal;
  26. }
  27. }
  28.  
  29. <?xml version="1.0" encoding="UTF-8"?>
  30. <Context crossContext="true">
  31. <WatchedResource>WEB-INF/web.xml</WatchedResource>
  32. <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" maxActive="10" maxIdle="10" maxWait="-1"
  33. name="jdbc/ristoredb" password="ristoreowner987" type="javax.sql.DataSource" username="ristore_owner"
  34. url="jdbc:oracle:thin:@ldap://mdaoid.xxx.org:389/risdev3,cn=OracleContext,dc=ac,,dc=org"
  35. />
  36. </Context>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement