Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Stored procedure and SQL message

  1. #1
    Join Date
    Jun 2007
    Posts
    9

    Default Stored procedure and SQL message

    Hello,

    I am using stored procedure in transformation and job, and also SQL command.

    I have noticied that the message given by the sql statement are not present in the log file.

    For example, a print command does not appears in Kettle log.

    How to do to get such message ?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Probably not.

    Sven

  3. #3
    Join Date
    Jun 2007
    Posts
    9

    Default

    Is it the same for a select stament ?

    Do I have a possibility to see the result of a select in the job's log ?

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    If you run any SQL statement, this is done via the JDBC interface. And JDBC does not care what some stored procedure wants to print to the screen. So Kettle doesn't even realize that something is printed.

    So no print statements will appear in the log file, if you want to see the output of a select I would suggest to set logging to rowlevel.

    Regards,
    Sven

  5. #5
    Join Date
    Jun 2007
    Posts
    9

    Default

    Thanks Sven, I think that we are going to get the data we want with another way of doing.

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.