Re: Oracle BLOB

Tue, 05 Aug 2003 22:45:06 -0700

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" <[EMAIL PROTECTED]>
To: "Turbine Torque Users List" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: "Turbine Torque Users List" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]







---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to