return false;
}
InitialContext ctx = new InitialContext();
TransactionManager mgr = (TransactionManager)ctx.lookup(TransactionManagerService.JNDI_NAME);
DataSource ds = (DataSource)ctx.lookup("java:/DefaultDS");
javax.transaction.Transaction txOld = mgr.suspend();
mgr.begin();
java.sql.Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try
{
conn = ds.getConnection();
String sql = "SELECT * FROM JBM_MSG_REF";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
boolean exists = rs.next();
if (!exists)
{
rs.close();
ps.close();
ps = conn.prepareStatement("SELECT * FROM JBM_MSG");
rs = ps.executeQuery();
exists = rs.next();
}
return exists;
}
finally
{
if (rs != null) rs.close();
if (ps != null) ps.close();
if (conn != null) conn.close();
mgr.commit();
if (txOld != null)
{
mgr.resume(txOld);
}
}
}