From: | "Kasprzyk Maciej-FHC368" <maciej(dot)kasprzyk(at)motorolasolutions(dot)com> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | feature request: make support for java.sql.Types.DISTINCT optional |
Date: | 2011-04-14 11:10:30 |
Message-ID: | C77DCBAC6AFC2E44A333568C86F16D7702E3098C@zuk35exm66.ds.mot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello,
I have noticed that the driver's method getColumns() returns
java.sql.Types.DISTINCT as DATA_TYPE for columns that are defined
through a domain. According to the JDBC specification, chapter 16.7.3,
support for the DISITNCT type is not obligatory. Current PostgreSQL
driver implementation makes impossible to use tools which doesn't handle
the DISTINCT type properly together with domain types (like Crystal
Reports Java or Hibernate reverse engineering). Since many popular
database systems does not support the DISTINCT type in their JDBC
drivers (e.g. MySQL, MS SQL Server, Oracle), I would suggest to add an
optional connection parameter for PostgreSQL which would allow for
turning off the support for DISTINCT type and cause the getColumns()
method to return base types in the DATA_TYPE field.
Regards,
Maciej Kasprzyk
........................................................................
...
iProtect Message Classification:
[ ] Motorola Solutions Confidential Proprietary
[ ] Internal
[x] Public
________________________________
Motorola Polska Electronics Sp.z.o.o
Bobrzynskiego 46,
30-381 Krakow, Poland
KRS 0000146875 - Poland
VAT No: PL6772135826
Share capital: 4,600,000 PLN
Details of Motorola's subsidiaries in the EU/EEA can be found at: v
www.motorolasolutions.com/XU-EN/About/Subsidiaries
<http://www.motorolasolutions.com/XU-EN/About/Subsidiaries>
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Singer | 2011-04-18 13:32:05 | JDBC connections to 9.1 |
Previous Message | Donald Fraser | 2011-04-13 10:52:13 | Re: [JDBC] Missing documentation for error code: 80S01 |