db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Schneider <bschnei...@vecna.com>
Subject Re: LOBs, Torque, Oracle > 4K data
Date Tue, 25 Feb 2003 13:28:25 GMT
"LONGVARBINARY" is the JDBC type.  You want to use the "LONG RAW" type in
Oracle which does not have a 4K limit.

-- Bill
----- Original Message -----
From: "Jim Schneider" <jschneider@kjinteractive.com>
To: "Turbine Torque Users List" <torque-user@db.apache.org>
Sent: Tuesday, February 25, 2003 7:16 AM
Subject: Re: LOBs, Torque, Oracle > 4K data


> Yes, soryy, that is happening with me too. At the time, I was only
> concerned with the insert/update. When I changed the "type" to
> LONGVARBINARY, all is well except for the 4K limit. Any way to get
> around this with Torque?? How have other people solved this problem?
>
> Thx,
>
> Jim
>
> Geoff Fortytwo wrote:
>
> > You can use BLOBs in torque with oracle? AFAIK, everyone else just
> > gets null returned when they use CLOBs or BLOBs in torque with an
> > oracle driver.
> >
> > At 04:10 PM 2/24/2003, Jim Schneider wrote:
> >
> >> What is the preferred method (Torque data type) for LOBs that are > 4K?
> >>
> >> If I use BLOB with a file that is smaller than 4K, everything is
> >> fine. With > 4K, I get an error indicating that the size is too big.
> >>
> >> Thanks in advance.
> >>
> >> Jim
> >>
> >>
> >> --
> >> Jim Schneider
> >> KJ Interactive, Inc.
> >> 303-765-1357
> >> www.kjinteractive.com
> >>
> >>
> >>
> >>
> >> ---------------------------------------------------------------------
> >> 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
> >
> >
>
> --
> Jim Schneider
> KJ Interactive, Inc.
> 303-765-1357
> www.kjinteractive.com
>
>
>
>
>
> ---------------------------------------------------------------------
> 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