public int nouvellePalette(LinkedList<Integer> id_colis) {

        if (id_colis == null || id_colis.size() == 0) {
            return -1;
        }

        try {
            PreparedStatement ps
                = co.prepareStatement("INSERT INTO palette DEFAULT VALUES;");
            int result = ps.executeUpdate();
            if (result != 1) {
                return -1;
            }
            ps = co.prepareStatement("SELECT last_value FROM palette_id_seq;");
            ResultSet rs = ps.executeQuery();
            if (!rs.next()) {
                return -1;
            }
            int id_palette = rs.getInt("last_value");

            String q = "INSERT INTO palette_colis VALUES ("+id_palette+",?)";

            for (int i=1; i<id_colis.size(); i++) {
                q += ",("+id_palette+",?)";
            }

            ps = co.prepareStatement(q+";");
            for (int i=0; i<id_colis.size(); i++) {
                ps.setInt(i+1, id_colis.get(i).intValue());
            }
            result = ps.executeUpdate();

            return (result > 0) ? id_palette : -1;
        }
        catch (SQLException e) {
            p_err(e.getMessage());
        }
        return -1;
    }