Hello dear developers,
I just updated the TypeInfoCache to return LONGVARCHAR for the
PostgreSQL Type text. Currently VARCHAR(0) is returned, which seems not
correct in my eyes, and confuses some major software packets like
Chrystal Reports.
Patch attached,
with best regards,
Daniel Migowski
--
|¯¯|¯¯| *IKOffice GmbH Daniel Migowski*
| | |/| Mail: dmigowski ÄT ikoffice.de
| | // | Nordstr. 10 Tel.: +49 (441) 21 98 89 52
| | \\ | 26135 Oldenburg Fax.: +49 (441) 21 98 89 55
|__|__|\| http://www.ikoffice.de Mob.: +49 (176) 22 31 20 76
Geschäftsführer: Ingo Kuhlmann, Daniel Migowski
Amtsgericht Oldenburg, HRB 201467
Steuernummer: 64/211/01864
Index: TypeInfoCache.java
===================================================================
RCS file: /cvsroot/jdbc/pgjdbc/org/postgresql/jdbc2/TypeInfoCache.java,v
retrieving revision 1.11
diff -u -r1.11 TypeInfoCache.java
--- TypeInfoCache.java 2 Dec 2007 06:48:43 -0000 1.11
+++ TypeInfoCache.java 19 Dec 2007 14:36:22 -0000
@@ -71,7 +71,7 @@
{"char", new Integer(Oid.CHAR), new Integer(Types.CHAR), "java.lang.String", new Integer(Oid.CHAR_ARRAY)},
{"bpchar", new Integer(Oid.BPCHAR), new Integer(Types.CHAR), "java.lang.String", new
Integer(Oid.BPCHAR_ARRAY)},
{"varchar", new Integer(Oid.VARCHAR), new Integer(Types.VARCHAR), "java.lang.String", new
Integer(Oid.VARCHAR_ARRAY)},
- {"text", new Integer(Oid.TEXT), new Integer(Types.VARCHAR), "java.lang.String", new Integer(Oid.TEXT_ARRAY)},
+ {"text", new Integer(Oid.TEXT), new Integer(Types.LONGVARCHAR), "java.lang.String", new
Integer(Oid.TEXT_ARRAY)},
{"name", new Integer(Oid.NAME), new Integer(Types.VARCHAR), "java.lang.String", new Integer(Oid.NAME_ARRAY)},
{"bytea", new Integer(Oid.BYTEA), new Integer(Types.BINARY), "[B", new Integer(Oid.BYTEA_ARRAY)},
{"bool", new Integer(Oid.BOOL), new Integer(Types.BIT), "java.lang.Boolean", new Integer(Oid.BOOL_ARRAY)},