Convert a Result Set from SQL Array to Array of Strings

by

Use:

Array a = rs.getArray("is_nullable");
String[] nullable = (String[])a.getArray();

As explained here

Array is SQL type, getArray() returns an object to cast to java array.

More Related Contents:

  1. How do I get the size of a java.sql.ResultSet?
  2. Is it possible to specify the schema when connecting to postgres with JDBC?
  3. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  4. How to map a PostgreSQL array with Hibernate
  5. When to close Connection, Statement, PreparedStatement and ResultSet in JDBC
  6. How to get a value from the last inserted row? [duplicate]
  7. JDBC driver throws “ResultSet Closed” exception on empty ResultSet
  8. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  9. What is the most recommended way to store time in PostgreSQL using Java?
  10. JDBC ResultSet get columns with table alias
  11. How to read all rows from huge table?
  12. Execute anonymous pl/sql block and get resultset in java
  13. ResultSet: Retrieving column values by index versus retrieving by label
  14. Driver JDBC PostgreSQL with Android [duplicate]
  15. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  16. Java JDBC ignores setFetchSize?
  17. Hibernate, Postgres & Array Type
  18. ResultSet.getString(1) throws java.sql.SQLException: Invalid operation at current cursor position
  19. how to copy data from file to PostgreSQL using JDBC?
  20. How to get row count using ResultSet in Java?
  21. How to get the number of columns from a JDBC ResultSet?
  22. How do I get the row count in JDBC?
  23. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  24. Postgres UUID JDBC not working
  25. Array with UserType in Hibernate and PostgreSQL –> MappingException
  26. How to convert Java String into byte[]?
  27. Sort a two dimensional array based on one column
  28. Grab a segment of an array in Java without creating a new array on heap
  29. How to convert a Byte Array to an Int Array
  30. Array of function pointers in Java [duplicate]

Leave a Comment