Accessing a JDBC Resource
If you create a property named jdbcr of type JDBC Resource Template, TIBCO Business Studio - BPM Edition adds the following to the abstract implementation class:
import org.osoa.sca.annotations.Property; import javax.sql.DataSource; private DataSource jdbcr; @Property(name = "jdbcr") public void setDbr(DataSource jdbcr) { this.jdbcr = jdbcr; } public DataSource getJdbcr() { return jdbcr; }
- Procedure
- Invoke the accessor methods in your component implementation.
import javax.sql.DataSource; DataSource ds = getJdbcr(); Connection connection = null; try { connection = ds.getConnection(); ensureTablesExist(connection); Statement stmt = connection.createStatement(); ResultSet rs = stmt.executeQuery(sqlString); PhoneEntryType entry = null; while(rs.next()) { entry = resp.addNewOut(); entry.setEntryId(rs.getString("id")); entry.setFirstName(rs.getString("firstName")); entry.setLastName(rs.getString("lastName")); entry.setPhone(rs.getString("phone")); } } catch(SQLException e) { e.printStackTrace(); } finally { try{ connection.close(); }catch(Exception e){}; ... } }