From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Jan Motl <yzan(at)volny(dot)cz> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: getTypeInfo |
Date: | 2016-12-14 13:34:21 |
Message-ID: | CADK3HHL93g0BFLp-W8+1WSiGw9CqS3EZGrvLwMPC58iQXsb1ug@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On 14 December 2016 at 07:32, Jan Motl <yzan(at)volny(dot)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 there
Dave Cramer
davec(at)postgresintl(dot)com
www.postgresintl.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2016-12-14 13:51:09 | Re: getTypeInfo |
Previous Message | Jan Motl | 2016-12-14 12:32:19 | getTypeInfo |