On 14 December 2016 at 07:32, Jan Motl <yzan@volny.cz> wrote:Hi,I noticed that getTypeInfo() may not return data in the order specified in Oracle documentation (https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTypeInfo()): Retrieves a description of all the data types supported by this database. They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.With the following code snippet:try (Connection connection = dataSource.getConnection(); ResultSet rs = connection.getMetaData().getTypeInfo()) { while (rs.next()) { System.out.println(rs.getInt("DATA_TYPE")); }} catch (SQLException e) {}I am getting DATA_TYPE in a non-monotonic order: -7 -2 1 12 -5 ...Additional metadata: JDBC driver: PostgreSQL 9.4.1212 Server version: 9.6beta1.0 (9.6beta1.0)What do I do wrong?Nothing, I just looked at the code and there is no order by on thereDave Cramerdavec@postgresintl.comwww.postgresintl.com
Hi,I noticed that getTypeInfo() may not return data in the order specified in Oracle documentation (https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTypeInfo()): Retrieves a description of all the data types supported by this database. They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.With the following code snippet:try (Connection connection = dataSource.getConnection(); ResultSet rs = connection.getMetaData().getTypeInfo()) { while (rs.next()) { System.out.println(rs.getInt("DATA_TYPE")); }} catch (SQLException e) {}I am getting DATA_TYPE in a non-monotonic order: -7 -2 1 12 -5 ...Additional metadata: JDBC driver: PostgreSQL 9.4.1212 Server version: 9.6beta1.0 (9.6beta1.0)What do I do wrong?
try (Connection connection = dataSource.getConnection(); ResultSet rs = connection.getMetaData().getTypeInfo()) { while (rs.next()) { System.out.println(rs.getInt("DATA_TYPE")); }} catch (SQLException e) {}
"SELECT t.typname,t.oid FROM pg_catalog.pg_type t" + " JOIN pg_catalog.pg_namespace n ON (t.typnamespace = n.oid) " + " WHERE n.nspname != 'pg_toast'";
pgsql-jdbc by date:
Соглашаюсь с условиями обработки персональных данных