db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wang, Kevin" <KW...@TMRS.org>
Subject RE: Oracle BLOB
Date Fri, 16 May 2003 14:06:52 GMT
One outstanding issue with Oracle thin driver in Torque is the
'reverse-engineering' of BLOBs. When generating xml schema from existing
Oracle db, BLOBs have undefined type in the schema. 

BTW, is there way to differentiate 'long' from 'BigDecimal' when both are
stored as 'Number' in Oracle?

Thanks,
Kevin
-----Original Message-----
From: Russell Simpkins [mailto:RussellSimpkins@funnygarbage.com]
Sent: Friday, May 16, 2003 8:56 AM
To: Turbine Torque Users List
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

Mime
View raw message