Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Re : Simply stupid

  1. #1
    samatar hassan Guest

    Default Re : Simply stupid

    Hi Matt,

    Seem that this one is not working for Oracle (tested with 10g).


    Rgds


    Samatar HASSAN

    Fixe: 02-35-63-03-45
    GSM: 06-68-28-68-02



    ----- Message d'origine ----
    De : Matt Casters <mattcasters (AT) gmail (DOT) com>

  2. #2
    Matt Casters Guest

    Default Re: Simply stupid

    Hi Samatar,

    I think I just fixed the issue as part of
    http://jira.pentaho.org/browse/PDI-481

    If you can test too, that would be great.

    TIA,

    Matt


    On Thursday 29 November 2007 14:41:08 samatar hassan wrote:
    > Hi Matt,
    >
    > Seem that this one is not working for Oracle (tested with 10g).
    >
    >
    > Rgds
    >
    >
    > Samatar HASSAN
    >
    > Fixe: 02-35-63-03-45
    > GSM: 06-68-28-68-02
    >
    >
    >
    > ----- Message d'origine ----
    > De : Matt Casters <mattcasters (AT) gmail (DOT) com>
    > � : kettle-developers <kettle-developers (AT) googlegroups (DOT) com>
    > Envoy� le : Lundi, 19 Novembre 2007, 10h01mn 34s
    > Objet : Simply stupid
    >
    >
    >
    > Hi Devs,
    >
    > We've been struggling with a problem for a while now: how do you determine
    > the output of a SQL query without actually running it?
    >
    > Turns out that the JDBC spec of PreparedStatement has a getMetaData()
    > method that allows you to do just that.
    >
    > I can't for the life of me think of a reason why this has managed to escape
    > my attention, but it's simply stupid. It even seems to handle parameters
    > etc correctly.
    >
    > Do me a big favor folks, and give the latest trunk a try in which I made a
    > patch for PDI-481 in revision 5827.
    >
    > Thanks,
    >
    > Matt
    > ____________________________________________
    > Matt Casters
    > Chief Data Integration - Kettle founder
    > Pentaho, Open Source Business Intelligence
    > http://www.pentaho.org -- mcasters (AT) pentaho (DOT) org
    > Tel. +32 (0) 486 97 29 37
    >
    >
    >
    >
    > ___________________________________________________________________________
    >__ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo!
    > Mail



    --
    Matt
    ____________________________________________
    Matt Casters
    Chief Data Integration - Kettle founder
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters (AT) pentaho (DOT) org
    Tel. +32 (0) 486 97 29 37

    --~--~---------~--~----~------------~-------~--~----~
    You received this message because you are subscribed to the Google Groups "kettle-developers" group.
    To post to this group, send email to kettle-developers (AT) googlegroups (DOT) com
    To unsubscribe from this group, send email to kettle-developers-unsubscribe (AT) g...oups (DOT) com
    For more options, visit this group at http://groups.google.com/group/kettle-developers?hl=en
    -~----------~----~----~----~------~----~------~--~---

  3. #3
    Jens Bleuel Guest

    Default Re: Simply stupid

    With MySQL all went well and I just tested this with the hole Kettle
    class in Frankfurt. Especially when you have prepared statements with
    parameters coming from another step: Now you will get all output fields
    and this helps a lot with the rest of the transformation design.

    Great work!

    Cheers,
    Jens

    Matt Casters schrieb:
    >
    > Hi Samatar,
    >
    > I think I just fixed the issue as part of
    > http://jira.pentaho.org/browse/PDI-481
    >
    > If you can test too, that would be great.
    >
    > TIA,
    >
    > Matt
    >
    >
    > On Thursday 29 November 2007 14:41:08 samatar hassan wrote:
    >> Hi Matt,
    >>
    >> Seem that this one is not working for Oracle (tested with 10g).
    >>
    >>
    >> Rgds
    >>
    >>
    >> Samatar HASSAN
    >>
    >> Fixe: 02-35-63-03-45
    >> GSM: 06-68-28-68-02
    >>
    >>
    >>
    >> ----- Message d'origine ----
    >> De : Matt Casters <mattcasters (AT) gmail (DOT) com>
    >> � : kettle-developers <kettle-developers (AT) googlegroups (DOT) com>
    >> Envoy� le : Lundi, 19 Novembre 2007, 10h01mn 34s
    >> Objet : Simply stupid
    >>
    >>
    >>
    >> Hi Devs,
    >>
    >> We've been struggling with a problem for a while now: how do you determine
    >> the output of a SQL query without actually running it?
    >>
    >> Turns out that the JDBC spec of PreparedStatement has a getMetaData()
    >> method that allows you to do just that.
    >>
    >> I can't for the life of me think of a reason why this has managed to escape
    >> my attention, but it's simply stupid. It even seems to handle parameters
    >> etc correctly.
    >>
    >> Do me a big favor folks, and give the latest trunk a try in which I made a
    >> patch for PDI-481 in revision 5827.
    >>
    >> Thanks,
    >>
    >> Matt
    >> ____________________________________________
    >> Matt Casters
    >> Chief Data Integration - Kettle founder
    >> Pentaho, Open Source Business Intelligence
    >> http://www.pentaho.org -- mcasters (AT) pentaho (DOT) org
    >> Tel. +32 (0) 486 97 29 37
    >>
    >>
    >>
    >>
    >> ___________________________________________________________________________
    >> __ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo!
    >> Mail

    >
    >


    --
    Jens Bleuel



    --~--~---------~--~----~------------~-------~--~----~
    You received this message because you are subscribed to the Google Groups "kettle-developers" group.
    To post to this group, send email to kettle-developers (AT) googlegroups (DOT) com
    To unsubscribe from this group, send email to kettle-developers-unsubscribe (AT) g...oups (DOT) com
    For more options, visit this group at http://groups.google.com/group/kettle-developers?hl=en
    -~----------~----~----~----~------~----~------~--~---

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.