You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Felipe Ramos <fr...@tissat.es> on 2003/12/11 17:20:56 UTC

Torque and Oracle CLOBS

Hi!!
        I have had a lot of problems working with Torque and CLOBS 
 (with Oracle 9i)   Are there any special issues about this topic?   Any 
recommendation? Any known bug?

        Is very important to me to give an answer to this questions, you 
know..., this project must be finished before the end of the year.....

Thank you very much for your help.

------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9ª
28020 Madrid
Tel: (+34) 91 4175913 
Fax: (+34) 91 4172914
Mail: framos@tissat.es
------------------------




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Re: Torque and Oracle CLOBS

Posted by Felipe Ramos <fr...@tissat.es>.

Could you send that files to framos@tissat.es please?   It seems that 
this mail-list doesn't allow sending files.


Thank you very much Bill.

Bill Leng wrote:

> To work with blob, unpack the attached village.jar. Modify the 
> oracle.properties. Replace torque's villagexxx.jar with this one. This 
> should work with the Oracle's thin jdbc driver.
>
> Felipe Ramos wrote:
>
>> So I can not use Torque to get Oracle clobs or blobs without using 
>> DataDirect's jdbc driver.......pufff
>>
>> Has somebody given another one solution, please?
>>
>>
>>
>> Bill Leng wrote:
>>
>>> 1. Oracle's thin jdbc driver does not conform jdbc spec, which is 
>>> the root cause with clobs and blobs.
>>> 2. DataDirect's jdbc driver works with blob but I have not tried 
>>> clob. For English, clob is equivalent to blob.
>>>
>>> Felipe Ramos wrote:
>>>
>>>> Hi!!
>>>>        I have had a lot of problems working with Torque and CLOBS 
>>>> (with Oracle 9i)   Are there any special issues about this topic?   
>>>> Any recommendation? Any known bug?
>>>>
>>>>        Is very important to me to give an answer to this questions, 
>>>> you know..., this project must be finished before the end of the 
>>>> year.....
>>>>
>>>> Thank you very much for your help.
>>>>
>>>> ------------------------
>>>> Felipe Ramos
>>>> Tissat SA
>>>> C/ Orense 34-9ª
>>>> 28020 Madrid
>>>> Tel: (+34) 91 4175913 Fax: (+34) 91 4172914
>>>> Mail: framos@tissat.es
>>>> ------------------------
>>>>
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>>
>>>
>>
>
>------------------------------------------------------------------------
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>For additional commands, e-mail: torque-user-help@db.apache.org
>

-- 
------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9ª
28020 Madrid
Tel: (+34) 91 4175913 
Fax: (+34) 91 4172914
Mail: framos@tissat.es
------------------------



Re: Torque and Oracle CLOBS

Posted by Bill Leng <wl...@metatomix.com>.
To work with blob, unpack the attached village.jar. Modify the 
oracle.properties. Replace torque's villagexxx.jar with this one. This 
should work with the Oracle's thin jdbc driver.

Felipe Ramos wrote:

> So I can not use Torque to get Oracle clobs or blobs without using 
> DataDirect's jdbc driver.......pufff
>
> Has somebody given another one solution, please?
>
>
>
> Bill Leng wrote:
>
>> 1. Oracle's thin jdbc driver does not conform jdbc spec, which is the 
>> root cause with clobs and blobs.
>> 2. DataDirect's jdbc driver works with blob but I have not tried 
>> clob. For English, clob is equivalent to blob.
>>
>> Felipe Ramos wrote:
>>
>>> Hi!!
>>>        I have had a lot of problems working with Torque and CLOBS 
>>> (with Oracle 9i)   Are there any special issues about this topic?   
>>> Any recommendation? Any known bug?
>>>
>>>        Is very important to me to give an answer to this questions, 
>>> you know..., this project must be finished before the end of the 
>>> year.....
>>>
>>> Thank you very much for your help.
>>>
>>> ------------------------
>>> Felipe Ramos
>>> Tissat SA
>>> C/ Orense 34-9�
>>> 28020 Madrid
>>> Tel: (+34) 91 4175913 Fax: (+34) 91 4172914
>>> Mail: framos@tissat.es
>>> ------------------------
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>>> For additional commands, e-mail: torque-user-help@db.apache.org
>>>
>>
>

-- 
Bill Leng
Sr. Software Engineer
Metatomix, Inc.
Tel: (901)261-8911
Fax: (901)261-8901



Re: Torque and Oracle CLOBS

Posted by Felipe Ramos <fr...@tissat.es>.
So I can not use Torque to get Oracle clobs or blobs without using 
DataDirect's jdbc driver.......pufff

Has somebody given another one solution, please?



Bill Leng wrote:

> 1. Oracle's thin jdbc driver does not conform jdbc spec, which is the 
> root cause with clobs and blobs.
> 2. DataDirect's jdbc driver works with blob but I have not tried clob. 
> For English, clob is equivalent to blob.
>
> Felipe Ramos wrote:
>
>> Hi!!
>>        I have had a lot of problems working with Torque and CLOBS 
>> (with Oracle 9i)   Are there any special issues about this topic?   
>> Any recommendation? Any known bug?
>>
>>        Is very important to me to give an answer to this questions, 
>> you know..., this project must be finished before the end of the 
>> year.....
>>
>> Thank you very much for your help.
>>
>> ------------------------
>> Felipe Ramos
>> Tissat SA
>> C/ Orense 34-9ª
>> 28020 Madrid
>> Tel: (+34) 91 4175913 Fax: (+34) 91 4172914
>> Mail: framos@tissat.es
>> ------------------------
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>

-- 
------------------------
Felipe Ramos
Tissat SA
C/ Orense 34-9ª
28020 Madrid
Tel: (+34) 91 4175913 
Fax: (+34) 91 4172914
Mail: framos@tissat.es
------------------------




---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Re: Torque and Oracle CLOBS

Posted by Bill Leng <wl...@metatomix.com>.
1. Oracle's thin jdbc driver does not conform jdbc spec, which is the 
root cause with clobs and blobs.
2. DataDirect's jdbc driver works with blob but I have not tried clob. 
For English, clob is equivalent to blob.

Felipe Ramos wrote:

> Hi!!
>        I have had a lot of problems working with Torque and CLOBS 
> (with Oracle 9i)   Are there any special issues about this topic?   
> Any recommendation? Any known bug?
>
>        Is very important to me to give an answer to this questions, 
> you know..., this project must be finished before the end of the 
> year.....
>
> Thank you very much for your help.
>
> ------------------------
> Felipe Ramos
> Tissat SA
> C/ Orense 34-9ª
> 28020 Madrid
> Tel: (+34) 91 4175913 Fax: (+34) 91 4172914
> Mail: framos@tissat.es
> ------------------------
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>

-- 
Bill Leng
Sr. Software Engineer
Metatomix, Inc.
Tel: (901)261-8911
Fax: (901)261-8901



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org