Return-Path: Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 28725 invoked by uid 500); 5 Aug 2003 08:00:20 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 28710 invoked from network); 5 Aug 2003 08:00:19 -0000 Received: from mailhub7.isdnet.net (195.154.209.27) by daedalus.apache.org with SMTP; 5 Aug 2003 08:00:19 -0000 Received: from essi.fr (ppp3021-cwdsl.fr.cw.net [62.210.104.22]) by mailhub7.isdnet.net (8.9.3p2/8.9.3) with ESMTP id KAA82351 for ; Tue, 5 Aug 2003 10:00:30 +0200 (CEST) Message-ID: <3F2F64DF.1030502@essi.fr> Date: Tue, 05 Aug 2003 10:03:43 +0200 From: Samuel Le Berrigaud User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5a) Gecko/20030708 Thunderbird/0.1a X-Accept-Language: en-us, en MIME-Version: 1.0 To: Turbine Torque Users List Subject: Re: Oracle BLOB References: <794AA7B1BE0DB2458F738486D735394318C741@mail.funnygarbage.com> <006d01c31bcb$b29a8d10$1201a8c0@Pavel> In-Reply-To: <006d01c31bcb$b29a8d10$1201a8c0@Pavel> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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" >To: "Turbine Torque Users List" >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" >>To: "Turbine Torque Users List" >>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