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");