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>
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>
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!
--
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
-~----------~----~----~----~------~----~------~--~---
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!
>
>
--
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
-~----------~----~----~----~------~----~------~--~---
Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.