Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: CLOB fields don't work with Oracle9i

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default CLOB fields don't work with Oracle9i

    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.

  2. #2
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: CLOB fields don't work with Oracle9i

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.