db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Leng <wl...@metatomix.com>
Subject Re: Oracle BLOB
Date Tue, 05 Aug 2003 13:38:30 GMT
I used datadirect's jdbc driver and it works.

Samuel Le Berrigaud wrote:
> Hi folks,
> 
> I'm quite new at Torque, since April. I need to use BLOBs with an oracle 
> database, and I didn't success as with other datatypes. I read on the 
> list that I'm not alone in this case and that some developpers have 
> found a work around either by changing jdbc driver to a specific one or 
> changing templates to generate specific code.
> 
> Can one help me and be more precise on what to do ?
> 
> Any suggestion appreciated,
> 
> thanks,
> 
> SaM.
> 
> BTW I work with torque 3.0, my oracle is 8.1.7 and my jdbc driver is 
> jdbc-oracle816-jdk12
> 
> Pavel Kusch wrote:
> 
>> Russell,
>>
>> Thank you very much - you are real life saver!
>>
>> With regards,
>>
>> Pavel Kusch
>>
>> ----- Original Message -----
>> From: "Russell Simpkins" <RussellSimpkins@funnygarbage.com>
>> To: "Turbine Torque Users List" <torque-user@db.apache.org>
>> Sent: Friday, May 16, 2003 9:46 AM
>> Subject: RE: Oracle BLOB
>>
>>
>>  
>>
>>> I'm no JDBC expert either.  So far, my experience is that when you do
>>>   
>>
>> BLOB/CLOBs you end up writing platform specific code.  I don't know if 
>> that
>> is a problem for you, but you will be able to write BLOB/CLOB for 
>> Oracle.  I
>> also don't know if that issue is melting away.  The last time I looked at
>> MySQL JDBC drivers for example, it had limits too (just no where near 
>> as bad
>> as Oracle,) and did not seem to handle BLOBs/CLOBS that well too since it
>> was streaming into a byte[] array.  This issue was also present in
>> PostgreSQL drivers in the past also, they too opted to write PostgreSQL
>> specific JDBC routines that enable you to support near limitless sized
>> BLOBs.  So, for my part, I abstracted the BLOB/CLOB methods when I 
>> created
>> an app that intended to support more then one DB.  BLOB/CLOB was the 
>> one BIG
>> letdown for me.  Those templates I sent you will create all the Oracle
>> Specific code for you in your Torque model, just in case the new drivers
>> don't give you the fix you need.
>>  
>>
>>> -----Original Message-----
>>> From: Pavel Kusch [mailto:pavel@icecentric.com]
>>> Sent: Friday, May 16, 2003 10:33 AM
>>> To: Turbine Torque Users List
>>> Subject: Re: Oracle BLOB
>>>
>>>
>>> Russell,
>>>
>>> Thank you for reply!
>>>
>>> Where I am going is that I have application using BLOBs that works fine
>>>   
>>
>> with
>>  
>>
>>> MySQL but for production it will have to be Oracle. It would be great 
>>> just
>>> to change build.properties in Turbine pertinent to database (type, 
>>> driver
>>> ..), get Oracle driver, set up all the things described in the Oracle
>>>   
>>
>> guide
>>  
>>
>>> on Torque web and be ready to go. But it looks it is not gonna be that
>>>   
>>
>> easy.
>>  
>>
>>> I have found in mailing list things like:
>>>
>>> **************From mailing list************************
>>>
>>> Has anyone successfully read and written BLOBs (> 2k bytes) from an 
>>> Oracle
>>> 9i database?
>>>
>>> This is not a torque issue.  Its an issue with Oracle implementation of
>>>   
>>
>> the
>>  
>>
>>> JDBC 2.0 BLOB APIS.  I have
>>> never been able to get the BLOBS to work with anything other than 
>>> Oracle's
>>> implementation of the JDBC interfaces
>>> (OracleConnection, OracleResultSet, OraclePreparedStatement).
>>>
>>> Direct support for LOBs in the Thin driver. The Thin driver now provides
>>> direct support for BFILEs, BLOBs, and       CLOBs. Prior to this release
>>>   
>>
>> it
>>  
>>
>>> supported them via calls to PL/SQL routines.
>>>
>>>   
>>
>> http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc_readme9201.ht 
>>
>>  
>>
>>> ml
>>>
>>> With Oracle, you have to use Oracle specific code to do more than 4k 
>>> bytes
>>> of Clob or Blob.
>>>
>>> *************************************************************
>>>
>>> So, I was thinking that the new driver would make the BLOB size 
>>> limitation
>>> problem go away. It would be only about getting the new driver and not
>>> having special code for BLOB.
>>>
>>> This is gonna be my first Oracle-driven app so I am sorry for
>>>   
>>
>> incompetence.
>>  
>>
>>> Is there anything else to watch out for when migrating to Oracle?
>>>
>>> Thank you.
>>>
>>> With regards,
>>>
>>> Pavel Kusch
>>> iceCentric
>>> 309.685.7900
>>> 309.264.2674
>>> ----- Original Message -----
>>> From: "Russell Simpkins" <RussellSimpkins@funnygarbage.com>
>>> To: "Turbine Torque Users List" <torque-user@db.apache.org>
>>> Sent: Friday, May 16, 2003 8:56 AM
>>> Subject: RE: Oracle BLOB
>>>
>>>
>>>   
>>>
>>>> Pavel,
>>>>
>>>> What issue are you refering to.  Oracle has supported CLOB/BLOB for
>>>>     
>>
>> quite
>>  
>>
>>> some time using it's JDBC drivers, though the code was Oracle specific.
>>>   
>>
>> For
>>  
>>
>>> 2 years now I have had no problem inserting megabytes of BLOB/CLOB 
>>> data to
>>> oracle tables.
>>>   
>>>
>>>> -----Original Message-----
>>>> From: Pavel Kusch [mailto:pavel@icecentric.com]
>>>> Sent: Thursday, May 15, 2003 6:08 PM
>>>> To: Turbine Torque Users List
>>>> Subject: Oracle BLOB
>>>>
>>>>
>>>> Hello,
>>>>
>>>> I found this in mailing list about Oracle:
>>>>
>>>>      Direct support for LOBs in the Thin driver.
>>>>      The Thin driver now provides direct support for BFILEs, BLOBs, and
>>>>      CLOBs. Prior to this release it supported them via calls to PL/SQL
>>>>      routines.
>>>>
>>>>
>>>>     
>>
>> http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc_readme9201.ht 
>>
>>  
>>
>>>> ml
>>>>
>>>> Has anybody tested if BLOB issue disapeared with the new driver?
>>>>
>>>>
>>>> Thank you.
>>>>
>>>> Pavel Kusch
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> ---------------------------------------------------------------------
>>>> 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
>>>>
>>>>     
>>>
>>> ---------------------------------------------------------------------
>>> 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
>>>
>>>   
>>
>>
>>
>> ---------------------------------------------------------------------
>> 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

-- 
Bill Leng
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


Mime
View raw message