How to use

escapeArrayElement

method

in

org.postgresql.jdbc2.AbstractJdbc2Array

private static void appendArray(StringBuffer sb, Object elements)
{
  sb.append('{');
  int nElements = java.lang.reflect.Array.getLength(elements);
  for (int i=0; i<nElements; i++) {
    if (i > 0) {
      sb.append(',');
    }
    Object o = java.lang.reflect.Array.get(elements, i);
    if (o == null) {
      sb.append("NULL");
    } else if (o.getClass().isArray()) {
      appendArray(sb, o);
    } else {
      String s = o.toString();
      AbstractJdbc2Array.escapeArrayElement(sb, s);
    }
  }
  sb.append('}');
}

/**
 * Convert array list to PG String representation (e.g. {0,1,2}).
 */
private String toString(PgArrayList list) throws SQLException
{
  StringBuffer b = new StringBuffer().append('{');
  char delim = connection.getTypeInfo().getArrayDelimiter(oid);
  for (int i = 0; i < list.size(); i++)
  {
    Object v = list.get(i);
    if (i > 0)
      b.append(delim);
    if (v == null)
      b.append("NULL");
    else if (v instanceof PgArrayList)
      b.append(toString((PgArrayList) v));
    else
      escapeArrayElement(b, (String)v);
  }
  b.append('}');
  return b.toString();
}

private static void appendArray(StringBuffer sb, Object elements)
{
  sb.append('{');
  int nElements = java.lang.reflect.Array.getLength(elements);
  for (int i=0; i<nElements; i++) {
    if (i > 0) {
      sb.append(',');
    }
    Object o = java.lang.reflect.Array.get(elements, i);
    if (o == null) {
      sb.append("NULL");
    } else if (o.getClass().isArray()) {
      appendArray(sb, o);
    } else {
      String s = o.toString();
      AbstractJdbc2Array.escapeArrayElement(sb, s);
    }
  }
  sb.append('}');
}

private static void appendArray(StringBuffer sb, Object elements)
{
  sb.append('{');
  int nElements = java.lang.reflect.Array.getLength(elements);
  for (int i=0; i<nElements; i++) {
    if (i > 0) {
      sb.append(',');
    }
    Object o = java.lang.reflect.Array.get(elements, i);
    if (o == null) {
      sb.append("NULL");
    } else if (o.getClass().isArray()) {
      appendArray(sb, o);
    } else {
      String s = o.toString();
      AbstractJdbc2Array.escapeArrayElement(sb, s);
    }
  }
  sb.append('}');
}

/**
 * Convert array list to PG String representation (e.g. {0,1,2}).
 */
private String toString(PgArrayList list) throws SQLException
{
  StringBuffer b = new StringBuffer().append('{');
  char delim = connection.getTypeInfo().getArrayDelimiter(oid);
  for (int i = 0; i < list.size(); i++)
  {
    Object v = list.get(i);
    if (i > 0)
      b.append(delim);
    if (v == null)
      b.append("NULL");
    else if (v instanceof PgArrayList)
      b.append(toString((PgArrayList) v));
    else
      escapeArrayElement(b, (String)v);
  }
  b.append('}');
  return b.toString();
}

/**
 * Convert array list to PG String representation (e.g. {0,1,2}).
 */
private String toString(PgArrayList list) throws SQLException
{
  StringBuffer b = new StringBuffer().append('{');
  char delim = connection.getTypeInfo().getArrayDelimiter(oid);
  for (int i = 0; i < list.size(); i++)
  {
    Object v = list.get(i);
    if (i > 0)
      b.append(delim);
    if (v == null)
      b.append("NULL");
    else if (v instanceof PgArrayList)
      b.append(toString((PgArrayList) v));
    else
      escapeArrayElement(b, (String)v);
  }
  b.append('}');
  return b.toString();
}