替代oracle connect by prior

Connection conn = null;
try
{
//select * from vfnd_3001@LINK_QD start with chn_id = '10000072' connect by prior parent_chn_id = chn_id


//
conn = DataSourceConfigUtil.getConnection();
StringBuilder sql = new StringBuilder();
sql.append("select ");
sql.append(" a.*,");
sql.append(" (select count(*) from lmss2_depot where district_id = ?) hasDepot ");
sql.append("from ");
sql.append(" vfnd_3001@LINK_QD a ");
sql.append("where ");
sql.append(" a.CHN_ID = ?");
PreparedStatement pstmt = conn.prepareStatement(sql.toString());

//ID()
while (channel.getParentChnId() != null && !channel.getParentChnId().trim().equals(""))
{
//--
log.info("SQL:" + sql);

pstmt.setString(1, channel.getParentChnId());
pstmt.setString(2, channel.getParentChnId());
//
ResultSet rs = pstmt.executeQuery();
if (rs.next())
{
channel = new Channel();
channel.setChnId(rs.getString("CHN_ID"));
channel.setChnName(rs.getString("CHN_NAME"));
channel.setChnNumber(rs.getString("CHN_NUMBER"));
channel.setClassType(rs.getString("CLASS_TYPE"));
channel.setClassCode(rs.getString("CLASS_CODE"));
channel.setRootDistance(rs.getInt("ROOT_DISTANCE"));
channel.setParentChnId(rs.getString("PARENT_CHN_ID"));
channel.setHasChild(rs.getString("HAS_CHILD").equals("Y") ? true : false);
channel.setHasDepot(rs.getInt("hasDepot") > 0 ? true : false);

//
retList.add(0, channel);
}
}