> > I'm trying to use the TDK (Turbine 2.1) to create an application that
> > hits an Oracle 8i db.  One of my fields is a CLOB...
> >   <column name="VALUE" type="CLOB"/> When I try to do a doSelect() on
> > this Table I get this Exception... java.lang.NumberFormatException:
> > 4294967295

> My assumption also is, that village can't handle BLOBs/CLOBs.
> If anyone uses these successfully, it would be of interest!
> 
> My solution now was mapping the Turbine-BLOB to LONG RAW in
> db.props. As I understand it, the only difference is that BLOBs
> can have max. 4GB, LONG RAWs only 2GB. Should be enough :)
> Hope it really works in the long run.

Thanks Florian!  I thought about using a LONG but I need to be able to 
use a WHERE clause against it and LONGs don't support WHERE clauses.
Right now I'm using a Varchar2 while I'm developing the rest of the 
app but before it goes into production I'll have to find a way to store it 
in a larger field.

My next step is to look at the Village code to see if I can make it 
support CLOBS.  Unfortunately I can't get to working-dogs.com.  Is anybody 
else having this problem?   Is there a mirror site/CVS?

Thanks,
-madison




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

Reply via email to