Subversion Repositories DevTools

Rev

Rev 7176 | Rev 7186 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 7176 Rev 7180
Line 2455... Line 2455...
2455 
                    " AND UPPER(rc.daemon_hostname) = UPPER(?)" +
 2455 
                    " AND UPPER(rc.daemon_hostname) = UPPER(?)" +
2456 
                    " AND rc.DAEMON_MODE != 'M'" +
 2456 
                    " AND rc.DAEMON_MODE != 'M'" +
2457 
                    " AND rc.RCON_ID = rl.rcon_id" +
 2457 
                    " AND rc.RCON_ID = rl.rcon_id" +
2458 
                    " AND CURRENT_BUILD_FILES IS NOT NULL" +
 2458 
                    " AND CURRENT_BUILD_FILES IS NOT NULL" +
2459 
                    " AND rl.pause is null" +
 2459 
                    " AND rl.pause is null" +
2460 
                    " AND rl.rcon_id in (?)"
 2460 
                    " AND rl.rcon_id in (" +
- 
 
 2461 
                        "select regexp_substr(?,'[^,]+', 1, level) from dual connect by regexp_substr(?, '[^,]+', 1, level) is not null" +
- 
 
 2462 
                    ")"
2461 
                    );
 2463 
                    );
2462
2464
- 
 
 2465 
            //  Need some trikery to allow the use of a 'string' in a preparedStatement with an 'in' clause
- 
 
 2466 
            //  jdbc does not allow a simple 'select * from ... where aa in (?)
- 
 
 2467 
            //  So we need to split a comma separated string into something that can be used.
- 
 
 2468 
            //  Thus the 'select regexp ... '
2463 
            stmt.setString(1, mHostname);
 2469 
            stmt.setString(1, mHostname);
2464 
            stmt.setString(2, rconIdList);
 2470 
            stmt.setString(2, rconIdList);
- 
 
 2471 
            stmt.setString(3, rconIdList);
2465 
 
 2472 
 
2466 
            ResultSet rset = stmt.executeQuery();
 2473 
            ResultSet rset = stmt.executeQuery();
2467 
 
 2474 
 
2468 
            while (rset.next()) {
 2475 
            while (rset.next()) {
2469 
                Integer ii = rset.getInt("rcon_id");
 2476 
                Integer ii = rset.getInt("rcon_id");