View Full Version : Bigger type length than maximum (FIXED/WORKAROUND)
12-09-2005, 04: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?
12-09-2005, 04: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.
12-12-2005, 12: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 :)
12-12-2005, 12: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.
01-29-2006, 05:11 AM
ditto - got the error in 1.4 when return a ref cursor. switched to the classes12.zip and it works fine.
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.