TEIID 8.2 JDBC metadata varchar COLUMN_SIZE always returns 4000

chiefumpire Apr 11, 2013 4:55 AM

I use DatabaseMetaData.getColumns then Resultset.getInt("COLUMN_SIZE"). The value is always 4000 for varchar column.

I checked that those columns length is not 4000 in vdb.

Would anyone tell me if this is a bug, expected or any option need to be set?

Thanks

1. Re: TEIID 8.2 JDBC metadata varchar COLUMN_SIZE always returns 4000

shawkins Apr 11, 2013 7:26 AM (in response to chiefumpire)

Yes, I believe that is a bug that was introduced by https://issues.jboss.org/browse/TEIID-1834 which caused the driver to always report the default size. Can you log an issue?

Steve
Actions
2. Re: TEIID 8.2 JDBC metadata varchar COLUMN_SIZE always returns 4000

shawkins Apr 11, 2013 11:49 AM (in response to shawkins)

I went ahead and logged/worked this as https://issues.jboss.org/browse/TEIID-2466 You can use the 8.4 alpha2 jdbc driver to confirm the fix.

Steve
Actions
3. Re: TEIID 8.2 JDBC metadata varchar COLUMN_SIZE always returns 4000

chiefumpire Apr 11, 2013 10:29 PM (in response to shawkins)

Thanks Steve!

I can only find the 8.4 alpha1 at http://www.jboss.org/teiid/downloads
Please advise the download URL or Do I need to build it from source ?
Actions
4. Re: TEIID 8.2 JDBC metadata varchar COLUMN_SIZE always returns 4000

rareddy Apr 12, 2013 8:20 AM (in response to chiefumpire)

alpha2 should be released sometime next week, if you want you can build from source until then. The instructions are on wiki page.
1 of 1 people found this helpful
Actions