PDA

View Full Version : Bigger type length than maximum (FIXED/WORKAROUND)



MattCasters
12-09-2005, 05:46 AM
Actually, we use Oracle all the time, versions 8 through the latest 10.1. and it works fine.


So I looked it up on meta-link... (http://metalink.oracle.com)



8173 Bug 1798042 JDBC Thin gets "Bigger type length than maximum" using DBLink with character set conversion



--> "BIGGER TYPE LENGTH THAN MAXIMUM" OCCURS WHEN SELECT VARCHAR2 DATA VIA DB LINK



Are you using a DB link to read?



Thanks,



Matt

MattCasters
12-09-2005, 05:51 AM
Oh, the workaround mentioned (if you can't read the bug description) is to use the OCI8 driver.
For this to work, you need to have ocijdbc10 in your path, with the oracle 10 client installed. (sorry about that)
Or you can keep your 8i installation and install the 8i jdbc driver in the kettle libext/ directory. Make sure to edit the classpath in the .bat and/or .sh files.


Please tell how you're fairing.



Thanks,



Matt

kettle_anonymous
12-12-2005, 01:17 AM
I replaced the packaged oracle jdbc driver (the one for java 1.4) with the old one "classes12.zip" for java 1.2 and this one works fine with our databases :)

MattCasters
12-12-2005, 01:24 AM
When I try to access our ERP database (Oracle 8), every time I try to access a table I get an exception saying "Bigger type length than maximum".


As far as I know this is caused if a field in a select statement is bigger than 2000 chars I think. The error message appears on every action I try to do with the database, even if I want to just explore the available table names.



This is a serious issue because it makes kettle unusable for us.

kettle_anonymous
01-29-2006, 06:11 AM
ditto - got the error in 1.4 when return a ref cursor. switched to the classes12.zip and it works fine.
thanks

tmohanachandran
03-27-2007, 01:12 AM
I too was getting the same error 'Bigger Type length than maximum' while connecting to Oracle 8i.Repalced the ojdbc driver in kettle libtext directory with the one of oracle 9i and it works fine.