PDA

View Full Version : CLOB fields don't work with Oracle9i



kettle_anonymous
03-09-2006, 09:54 PM
Hi,


I installed the latest kettle.jar because of a problem with CLOB fields, which was posted elsewhere here in the forum. The problem now is that CLOB field processing seems not to work with Oracle9i.



I have a repository within an Oracle8i database and one in an Oracle9i database. The one within the 8i works fine, but when I save a transformation into the 9i database and I reload it after a restart of Spoon, all my transfer steps are empty, no SQL statements etc. Also the transformation doesn't run from within the 9i database.

kettle_anonymous
03-09-2006, 10:06 PM
I figured something out... If I use the new Oracle JDBC driver ojdbc14.jar, it seems to work with 9i. But I need to access older Oracle Databases (8.0, 8i) which is not possible with the new driver so I need to use the old drivers classes12.zip.


Any idea what I can do now?