home list archives users mailing list
 

Subject: RE: CSV file Access - What data resource driver to specify? And what configuration files?

Date view Thread view Subject view Author view Attachment view

From: Amy Krause (amrey@epcc.ed.ac.uk)
Date: Dec 13, 2005 15:24

Hi Larry,

The CSVQueryStatementActivity was developed quite a while ago and hasn't
been updated much since then. Prepared statements weren't supported by the
CSV driver version we used when we developed the activity.
You can test the SQLQueryStatementActivity with the latest CSV driver and,
if it supports prepared statements, there shouldn't be any problems with
using SQL parameters.
Just keep in mind that there the SQLQueryStatementActivity might use other
JDBC operations that are (yet) unsupported by the CSV driver.

            Amy

On Tue, 13 Dec 2005, Larry Tan wrote:

> Hi Mike,
> I see. So does that imply that the parameterized sql activity is not
> supported if i were to use
> uk.org.ogsadai.activity.sql.csv.CSVQueryStatementActivity? I've downloaded
> the latest csvJDBC library and it does support prepareStatement hence i
> think
>
> 1) I can leave my CSV data resource activity configuration as
> uk.org.ogsadai.activity.sql.SQLQueryStatementActivity
> 2) The parameterized sql activity might work for for CSV data resource
>
> Best Regards,
> Larry Tan
>
>> -----Original Message-----
>> From: Mike Jackson [mailto:michaelj@epcc.ed.ac.uk]
>> Sent: Tuesday, December 13, 2005 2:26 PM
>> To: Larry Tan
>> Cc: OGSA-DAI Users
>> Subject: RE: CSV file Access - What data resource driver to specify? And
>> what configuration files?
>>
>>
>>
>> Hi Larry,
>>
>> You're right. I've just looked at the source for that class. The class
>> just derives from the SQLQueryStatementActivity. The only difference is
>> that there is no support for prepared statements.
>>
>> Cheers,
>>
>> mike
>>
>> On Tue, 13 Dec 2005, Larry Tan wrote:
>>
>>> Hi Mike,
>>> What is the purpose of specifying
>>> uk.org.ogsadai.activity.sql.csv.CSVQueryStatementActivity in the
>>> activityConfig.xml replacing
>>> uk.org.ogsadai.activity.sql.SQLQueryStatementActivity. The
>> reason i asked is
>>> because i've tried accessing my CSV data resource when the
>>> sqlQueryStatementActivity of activityConfig.xml is left as
>>> uk.org.ogsadai.activity.sql.SQLQueryStatementActivity and it still
>>> functions.
>>>
>>> Best Regards,
>>> Larry Tan
>>>
>>>> -----Original Message-----
>>>> From: Mike Jackson [mailto:michaelj@epcc.ed.ac.uk]
>>>> Sent: Monday, December 12, 2005 1:58 PM
>>>> To: Larry Tan
>>>> Cc: OGSA-DAI Users
>>>> Subject: Re: CSV file Access - What data resource driver to
>> specify? And
>>>> what configuration files?
>>>>
>>>>
>>>>
>>>> Hi Larry,
>>>>
>>>> On Mon, 12 Dec 2005, Larry Tan wrote:
>>>>
>>>>> I've saw that there are CSV file access Perform examples, which
>>>>> are using sqlQueryStatement, and I've seen the clients for setting up
>>>>> CSV files from littleblackbook. However, what is the driver for this
>>>>> data resource? I have found no documentation under the Support Data
>>>>> Resources. Thankful for any advice.
>>>>
>>>> The CSV driver we have experimented with was from:
>>>>
>>>> http://octopus.objectweb.org/doc/2.8/extras/Csvjdbc_readme.html
>>>>
>>>> We do not officially support CSV resources at this time.
>> However to use a
>>>> CSV resource you should:
>>>>
>>>> 1-Get the CSV driver.
>>>> 2-Follow the instructions for deploying a relational data service
>>>> resource (if using the GUI installer select "DB2" as the
>> data resource
>>>> type)
>>>> -Ensure you provide the CSV driver URL e.g.
>>>> jdbc:relique:csv:/path/to/csv</uri>
>>>> -Ensure you provide the CSV driver class e.g.
>>>> org.relique.jdbc.csv.CsvDriver
>>>> 3-After the resource has been deployed into Tomcat you need to edit
>>>> the ResourceName/activityConfig.xml file.
>>>> -Change the value of the "implementation" attribute of
>>>> sqlQueryStatementActivity to:
>>>> uk.org.ogsadai.activity.sql.csv.CSVQueryStatementActivity
>>>>
>>>> Alternatively you can edit the configuration files of an existing
>>>> relational resource that you have deployed:
>>>>
>>>> 1-Edit ResourceName/activityConfig.xml file:
>>>> -Change the value of the "implementation" attribute of
>>>> sqlQueryStatementActivity to:
>>>> uk.org.ogsadai.activity.sql.csv.CSVQueryStatementActivity
>>>> 2-Edit ResourceName/dataResourceConfig.xml file:
>>>> -Change the "implementation" attribute of the dataResource driver
>>>> "implementation" attribute to the driver class e.g.:
>>>> org.relique.jdbc.csv.CsvDriver
>>>> -Change the value of the "uri" element to the URI e.g.:
>>>> jdbc:relique:csv:/path/to/csv
>>>> 3-Edit ResourceName/DatabaseRoles.xml:
>>>> -Change the value of the "name" attribute to the URI e.g.:
>>>> jdbc:relique:csv:/path/to/csv
>>>>
>>>> Cheers,
>>>>
>>>> mike
>>>>
>>>
>>>
>>> --
>>> The University of Stirling is a university established in Scotland by
>>> charter at Stirling, FK9 4LA. Privileged/Confidential Information may
>>> be contained in this message. If you are not the addressee indicated
>>> in this message (or responsible for delivery of the message to such
>>> person), you may not disclose, copy or deliver this message to anyone
>>> and any action taken or omitted to be taken in reliance on it, is
>>> prohibited and may be unlawful. In such case, you should destroy this
>>> message and kindly notify the sender by reply email. Please advise
>>> immediately if you or your employer do not consent to Internet email
>>> for messages of this kind.
>>>
>>>
>>
>>
>> -------------------------------------------------------------------
>> Dr. Michael (Mike) Jackson E-mail: m.jackson@epcc.ed.ac.uk
>> EPCC Tel: +(44)-0131-650-5141
>> WWW: http://www.epcc.ed.ac.uk Fax: +(44)-0131-650-6555
>>
>> "There will be no questions." - The Parallax View (1974)
>>
>>
>
>
> --
> The University of Stirling is a university established in Scotland by
> charter at Stirling, FK9 4LA. Privileged/Confidential Information may
> be contained in this message. If you are not the addressee indicated
> in this message (or responsible for delivery of the message to such
> person), you may not disclose, copy or deliver this message to anyone
> and any action taken or omitted to be taken in reliance on it, is
> prohibited and may be unlawful. In such case, you should destroy this
> message and kindly notify the sender by reply email. Please advise
> immediately if you or your employer do not consent to Internet email
> for messages of this kind.
>
> 

--
   ------------------------------------------------------------
  | Dr Amy Krause                      Applications Consultant |
  |                        |epcc|, The University of Edinburgh |
  |     King's Buildings, Mayfield Road, Edinburgh EH9 3JZ, UK |
  | Tel: +44 (0)131 650 6718 --- email: a.krause@epcc.ed.ac.uk |
   ------------------------------------------------------------
Date view Thread view Subject view Author view Attachment view