What is the best practice in order to obtain the underlying jdbc connection in Seam?

Issue

• So we can execute CallableStatements (PL/SQL procedures) in Seam what would be the best way to get a JDBC connection handle (using the pooled connections defined in the datasource descriptor file). There are two options I can think of:

  • via JNDI-lookup

    InitialContext ctx = new InitialContext();
    dataSource = (DataSource)ctx.lookup("java:comp/env/jdbc/OracleDB");
    conn = dataSource.getConnection();
    cstmt = conn.prepareCall("{? = call DAC_VBH_1.check_something(?)}");
    ...
    

• via the entityManager's delegate:

  Object someDelegate = entityManager.getDelegate();
  conManager = ((HibernateSessionProxy) someDelegate).getJDBCContext().getConnectionManager();
  conn = conManager.borrowConnection();
  cstmt = conn.prepareCall("{? = call DAC_VBH_1.check_something(?)}");
  ...