<transaction-isolation>
<isolation-level></isolation-level>
<method>
<description><![CDATA[]]></description>
<ejb-name>SSBFacade</ejb-name>
<method-intf>Remote</method-intf>
<method-name>loadAll</method-name>
<method-params>
</method-params>
</method>
</transaction-isolation>
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
/**
* @ejb.bean
* type="Stateless"
* name="SSBFacade"
* jndi-name="ejb/SSBFacade"
* transaction-type="Container"
*
* @weblogic.transaction-isolation
TRANSACTION_READ_COMMITTED
*/
/**
* make sure method call is in a transaction context
*/
public class SSBFacadeBean implements SessionBean {
private static final String SELECT_ALL_SQL = "SELECT account_id, holder_name, balance FROM UserAccount";
private static final String SELECT_SQL = "SELECT account_id, holder_name, balance FROM UserAccount WHERE account_id = ?";
private static final String dsName = "oracleDS";
/**
* @ejb.interface-method
* view-type="remote"
* @ejb.transaction
* type="Required"
* @weblogic.transaction-isolation TRANSACTION_READ_COMMITTED
*/
public Collection loadAll() {
log("loadAll()...");
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
ArrayList result = new ArrayList();