public CmsPublishList readPublishList(CmsDbContext dbc, CmsUUID publishHistoryId) throws CmsDataAccessException {

        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet res = null;
        CmsPublishList publishList = null;

        try {
            conn = m_sqlManager.getConnection(dbc);
            stmt = m_sqlManager.getPreparedStatement(conn, "C_PUBLISHJOB_READ_PUBLISHLIST");
            stmt.setString(1, publishHistoryId.toString());
            res = stmt.executeQuery();

            if (res.next()) {
                byte[] bytes = m_sqlManager.getBytes(res, "PUBLISH_LIST");
                publishList = internalDeserializePublishList(bytes);
                while (res.next()) {
                    // do nothing only move through all rows because of mssql odbc driver
                }
            } else {
                throw new CmsDataAccessException(
                    Messages.get().container(Messages.ERR_READ_PUBLISH_JOB_1, publishHistoryId.toString()));
            }
        } catch (SQLException e) {
            throw new CmsDbSqlException(
                Messages.get().container(Messages.ERR_GENERIC_SQL_1, CmsDbSqlException.getErrorQuery(stmt)),
                e);
        } catch (Exception e) {
            throw new CmsDataAccessException(
                Messages.get().container(Messages.ERR_PUBLISHLIST_DESERIALIZATION_FAILED_1, publishHistoryId),
                e);
        } finally {
            m_sqlManager.closeAll(dbc, conn, stmt, res);
        }

        return publishList;
    }
public CmsPublishList readPublishList ( CmsDbContext dbc , CmsUUID publishHistoryId ) throws CmsDataAccessException { Connection conn = null ; PreparedStatement stmt = null ; ResultSet res = null ; CmsPublishList publishList = null ; try { conn = m_sqlManager . getConnection ( dbc ) ; stmt = m_sqlManager . getPreparedStatement ( conn , "C_PUBLISHJOB_READ_PUBLISHLIST" ) ; stmt . setString ( 1 , publishHistoryId . toString ( ) ) ; res = stmt . executeQuery ( ) ; if ( res . next ( ) ) { byte [ ] bytes = m_sqlManager . getBytes ( res , "PUBLISH_LIST" ) ; publishList = internalDeserializePublishList ( bytes ) ; while ( res . next ( ) ) { } } else { throw new CmsDataAccessException ( Messages . get ( ) . container ( Messages . ERR_READ_PUBLISH_JOB_1 , publishHistoryId . toString ( ) ) ) ; } } catch ( SQLException e ) { throw new CmsDbSqlException ( Messages . get ( ) . container ( Messages . ERR_GENERIC_SQL_1 , CmsDbSqlException . getErrorQuery ( stmt ) ) , e ) ; } catch ( Exception e ) { throw new CmsDataAccessException ( Messages . get ( ) . container ( Messages . ERR_PUBLISHLIST_DESERIALIZATION_FAILED_1 , publishHistoryId ) , e ) ; } finally { m_sqlManager . closeAll ( dbc , conn , stmt , res ) ; } return publishList ; }
@see org.opencms.db.I_CmsProjectDriver#readPublishList(org.opencms.db.CmsDbContext, org.opencms.util.CmsUUID)