Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class FmTrfUtil {
- static int returnVal;
- public static int insertFmTrfs(List<String> trfs, String source) {
- EntityManager em = Persistence.createEntityManagerFactory("RIStore_FM").createEntityManager();
- Session session = em.unwrap( Session.class );
- final String[] trfArray = trfs.toArray(new String[trfs.size()]);
- final String src = source;
- session.doWork( new Work(){
- public void execute(Connection conn) throws SQLException {
- CallableStatement stmt = null;
- OracleConnection oraCon = conn.unwrap(OracleConnection.class);
- Array array = oraCon.createARRAY("VARCHAR2_TAB_T", trfArray);
- stmt = conn.prepareCall("{? = call FM_TRF_UTIL.process_fm_trf(?,?)}");
- stmt.registerOutParameter(1, Types.INTEGER);
- stmt.setArray(2, array);
- stmt.setString(3, src);
- stmt.execute();
- returnVal = stmt.getInt(1);
- }
- });
- return returnVal;
- }
- public static void main(String[] args) {
- List<String> trfs = new ArrayList<String>();
- trfs.add("TRF000005");
- FmTrfUtil.insertFmTrfs(trfs, "SARC");
- }
- }
- spring.datasource.url=jdbc:oracle:thin:@ldap://xxx:389/risdev3, cn=OracleContext,dc=aaa,dc=bbb,dc=com
- spring.datasource.username=risowner
- spring.datasource.password=risowner987
- spring.datasource.driverClassName=oracle.jdbc.OracleDriver
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement