Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @Component
- @Transactional
- public class FmTrfUtil {
- static int returnVal;
- @PersistenceContext
- private EntityManager em;
- public int insertFmTrfs(List<String> trfs, String source) {
- 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;
- }
- }
- <?xml version="1.0" encoding="UTF-8"?>
- <Context crossContext="true">
- <WatchedResource>WEB-INF/web.xml</WatchedResource>
- <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" maxActive="10" maxIdle="10" maxWait="-1"
- name="jdbc/ristoredb" password="ristoreowner987" type="javax.sql.DataSource" username="ristore_owner"
- url="jdbc:oracle:thin:@ldap://mdaoid.xxx.org:389/risdev3,cn=OracleContext,dc=ac,,dc=org"
- />
- </Context>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement