Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Problems refreshing database information

  1. #1
    Join Date
    Jul 2009
    Posts
    18

    Default Problems refreshing database information

    Hi again guys,

    I'm having a very strange problem with the Kettle.

    I have some tables in a Oracle database that I insert data with a Kettle transformation.

    By a fate hit, the customer asked to alter some columns in a table (ohhh, I'm so surprised -.-").

    I have altered the table and opened the transformation to update the table insert, but the Kettle isn't refreshing the database information.

    In the database explorer, the table layout is with the same columns than before my alteration in the table.

    I have already refreshed 10000 times the explorer, closed the Keetle e opened it again, but the columns are the same.

    Looking the table in the SQL Developer, the table is normaly altered.

    Somebody knows what's causing this? =/

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Clear the database cache. (right click on the connection in the left tree)

  3. #3
    Join Date
    Jul 2009
    Posts
    18

    Default

    It works, thank you =D

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.