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