How to use

appendArray

method

in

org.postgresql.jdbc4.AbstractJdbc4Connection

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('}');
}

public Array createArrayOf(String typeName, Object[] elements) throws SQLException
{
  checkClosed();
  int oid = getTypeInfo().getPGArrayType(typeName);
  if (oid == Oid.UNSPECIFIED)
    throw new PSQLException(GT.tr("Unable to find server array type for provided name {0}.", typeName), PSQLState.INVALID_NAME);
  StringBuffer sb = new StringBuffer();
  appendArray(sb, elements);
  // This will not work once we have a JDBC 5,
  // but it'll do for now.
  return new Jdbc4Array(this, oid, sb.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('}');
}

public Array createArrayOf(String typeName, Object[] elements) throws SQLException
{
  int oid = getTypeInfo().getPGArrayType(typeName);
  if (oid == Oid.UNSPECIFIED)
    throw new PSQLException(GT.tr("Unable to find server array type for provided name {0}.", typeName), PSQLState.INVALID_NAME);
  StringBuffer sb = new StringBuffer();
  appendArray(sb, elements);
  // This will not work once we have a JDBC 5,
  // but it'll do for now.
  return new Jdbc4Array(this, oid, sb.toString());
}

public Array createArrayOf(String typeName, Object[] elements) throws SQLException
{
  checkClosed();
  int oid = getTypeInfo().getPGArrayType(typeName);
  if (oid == Oid.UNSPECIFIED)
    throw new PSQLException(GT.tr("Unable to find server array type for provided name {0}.", typeName), PSQLState.INVALID_NAME);
  StringBuffer sb = new StringBuffer();
  appendArray(sb, elements);
  // This will not work once we have a JDBC 5,
  // but it'll do for now.
  return new Jdbc4Array(this, oid, sb.toString());
}