Hi
I'm using Oracle as a backend database for a project I'm currently working on. I
don't know Oracle all that well, maybe somebody
could help me with this, please.
The project requires that a certain field must be able to hold a text value of 6000
characters of text. I tried to create a
VARCHAR2, but it has a max of 4000 characters. I changed it to a LONG, but when I
insert values longer that 4000 characters I get:
java.sql.SQLException: Data size bigger than max size for this type
I checked the Peer and Village code to try to find a fix. If I changed the
stmt.setString() to stmt.setBytes() in Village I got
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG
column
The same happened when I changed the field datatype to BLOB. Finally I changed the
field type from LONG to LONG RAW which seemed to
work.
Is there somebody out there that knows Oracle well enough to help me with this? Does
this mean I need to handle long strings (>4000
characters) as blocks of raw binary data? If this is the case how do go about using
BasePeer? The only time BasePeer actually adds
a byte-array is when the Database Map has a field of type Hashtable. Maybe we can add
a type StringBuffer that gets written out as
a byte-array.
~ Leon
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
