TypeInfoCache

[Daniel Migowski <dmigowski(at)ikoffice(dot)de>]

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)},