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 Samuel Le Berrigaud <le...@essi.fr> on 2003/08/05 10:03:43 UTC
Re: Oracle BLOB
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" <Ru...@funnygarbage.com>
>To: "Turbine Torque Users List" <to...@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" <Ru...@funnygarbage.com>
>>To: "Turbine Torque Users List" <to...@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
Re: Oracle BLOB
Posted by Bill Leng <wl...@metatomix.com>.
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" <Ru...@funnygarbage.com>
>> To: "Turbine Torque Users List" <to...@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" <Ru...@funnygarbage.com>
>>> To: "Turbine Torque Users List" <to...@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