Advertisement
Guest User

Untitled

a guest
Nov 3rd, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. public class FmTrfUtil {
  2. static int returnVal;
  3. public static int insertFmTrfs(List<String> trfs, String source) {
  4. EntityManager em = Persistence.createEntityManagerFactory("RIStore_FM").createEntityManager();
  5. Session session = em.unwrap( Session.class );
  6. final String[] trfArray = trfs.toArray(new String[trfs.size()]);
  7. final String src = source;
  8. session.doWork( new Work(){
  9. public void execute(Connection conn) throws SQLException {
  10. CallableStatement stmt = null;
  11. OracleConnection oraCon = conn.unwrap(OracleConnection.class);
  12. Array array = oraCon.createARRAY("VARCHAR2_TAB_T", trfArray);
  13. stmt = conn.prepareCall("{? = call FM_TRF_UTIL.process_fm_trf(?,?)}");
  14. stmt.registerOutParameter(1, Types.INTEGER);
  15. stmt.setArray(2, array);
  16. stmt.setString(3, src);
  17. stmt.execute();
  18. returnVal = stmt.getInt(1);
  19. }
  20. });
  21. return returnVal;
  22. }
  23. public static void main(String[] args) {
  24. List<String> trfs = new ArrayList<String>();
  25. trfs.add("TRF000005");
  26. FmTrfUtil.insertFmTrfs(trfs, "SARC");
  27. }
  28. }
  29.  
  30. spring.datasource.url=jdbc:oracle:thin:@ldap://xxx:389/risdev3, cn=OracleContext,dc=aaa,dc=bbb,dc=com
  31. spring.datasource.username=risowner
  32. spring.datasource.password=risowner987
  33. spring.datasource.driverClassName=oracle.jdbc.OracleDriver
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement