Re: [ogsa-dai-users] Difficulty in CSV To Tuple conversion: UNSUPPORTED_TYPE_CONVERSION : 6, 15

[Ally H. <ah...@st...>]

Please ignore this I replied to the wrong thread.  Sorry.

Ally


On 24/03/2011 14:32, Ally Hume wrote:
> Hi Gowri,
>
> I've been able to reproduce this and I have some idea what is going on
> but I'll need more time to understand the code involved and fix it. I've
> added a ticket for this:
>     https://sourceforge.net/apps/trac/ogsa-dai/ticket/327
>
> I'm not sure when I'll get a chance to look into this any more.  It's
> fair to say I don't think it will be before April.
>
> Regards,
>
> Ally
>
>
> On 18/03/2011 20:39, Nagarjun wrote:
>> Hi,
>>
>> I am working on the OGSA-DAI JDBC driver developed by Mathias Brito. I
>> am trying to provide LOB support to the driver. In this direction, Ally
>> advised me to use WebRowSet instead of the present CSV format. I had
>> some developments and some doubts in this regard.
>>
>> The previous approach was CSVToTuple conversion and then pass to SQL
>> Parameterized Update (For simple types like String and Number).
>> I modified this approach to CSV->Tuple->WebRowSet->Tuple.
>>
>> However, I faced the following error when I executed a workflow based on
>> the modified mechanism. (Error extracted from the server side in DEBUG mode)
>>
>> uk.org.ogsadai.activity.ActivityUserException: [1300478318526:17]
>> uk.org.ogsadai.UNSUPPORTED_TYPE_CONVERSION : 6, 15
>>       at
>> uk.org.ogsadai.activity.transform.CSVToTupleActivity.processIteration(CSVToTupleActivity.java:271)
>>       at
>> uk.org.ogsadai.activity.MatchedIterativeActivity.process(MatchedIterativeActivity.java:90)
>>       at
>> uk.org.ogsadai.activity.event.EventfulActivity.process(EventfulActivity.java:78)
>>       at
>> uk.org.ogsadai.activity.concurrency.ActivityProcessingTask.call(ActivityProcessingTask.java:81)
>>       at
>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>>       at
>> edu.emory.mathcs.backport.java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:431)
>>       at
>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>>       at
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
>>       at
>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
>>       at java.lang.Thread.run(Thread.java:619)
>>
>> My understanding is that the literals String and BLOB which are in CSV
>> format aren't being converted into Tuple format. (In other words,
>> CSVToTuple is incapable of generating tuples when BLOBs are presnt.)
>>
>> Hence, my approach CSV->Tuple->WebRowSet->Tuple failed.
>>
>> Is my understanding correct?
>>
>> If so, I would be glad to know about the possibility in converting a
>> BLOB from *CSV format to a tuple* with the available activities present
>> in the OGSA-DAI. For better rerefence, I am attaching 2 files namely
>> Buggy.java (The workflow where I used CSV->Tuple->WebRowSet->Tuple
>> mechanism) and the 19-3-11 (The server log generated for the workflow in
>> Buggy.java)
>>
>> Awaiting your reply,
>>
>> Thanking you,
>>
>> Regards,
>> B Nagarjun
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Colocation vs. Managed Hosting
>> A question and answer guide to determining the best fit
>> for your organization - today and in the future.
>> http://p.sf.net/sfu/internap-sfd2d
>>
>>
>>
>> _______________________________________________
>> ogsa-dai-users mailing list
>> ogs...@li...
>> https://lists.sourceforge.net/lists/listinfo/ogsa-dai-users
>
>


-- 
-------------------------------------
Ally Hume
Software Architect
EPCC, The University of Edinburgh
Tel: +44 131 651 3397   Skype: ally.hume

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.