ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alvaro Prieto Martinez" <apri...@azertia.com>
Subject CLOB on Oracle
Date Wed, 15 Dec 2004 10:32:53 GMT

> Hi!!
> To use Clob/Blob with IBATIS i use OracleClobTypeHandlerCallback.java from
> ibatisCLOB.zip in http://www.ibatis.com/,
> At last i get insert a clob column in my database using ibatis but with
> restrictions:
> To resolve the problem i read some people have (Cause:
> java.sql.SQLException: Data size bigger than max size for this type: 5650];
> nested exception is) is becouse you are using thin driver, you have to use
> other driver becouse the thin driver only supports less than 4KB, i use OCI
> and works fine.
> when i upload to my db a file less than 64KB and after i download
> OracleClobTypeHandlerCallback works fine and the file has been downloaded
> without problems. But when the file is bigger than 64KB (for example 100)
> the file downloaded only has 100 -64 KB,i mean 36 KB.
> if i upload a 200kb file the downloaded file only has 8KB (200-64*3).
> Every thing are multipart of 64KB
> I don´t know if the problem is in the upload or at download. Can anyone
> help me?
> Thanks

----------------------------------------------------------------------- Este mensaje y los
documentos, que en su caso, lleve anexos, pueden contener informacion confidencial y atañe
exclusivamente a las personas a las que va dirigido. Cualquier opinion en el contenida, es
exclusiva de su autor y no representa necesariamente la opinion de AZERTIA. Si usted no es
el destinatario de este mensaje, considerese advertido de que lo ha recibido por error y que
cualquier uso, difusion o copia estan prohibidos legalmente. Si ha recibido este mensaje por
error, le rogamos que nos lo comunique por la misma via o al telefono 93 207 55 11 y proceda
a destruirlo inmediatamente.

This email is confidential and intended solely for the use of the individual to whom it is
addressed. Any views or opinions presented are solely those of the author and do not necessarily
represent those of AZERTIA. If you are not the intended recipient, be advised that you have
received this email in error and that any use, dissemination, forwarding, printing, or copying
of this email is strictly prohibited. If you have received this email in error please notify
it to AZERTIA by telephone on number +34 93 207 55 11. -----------------------------------------------------------------------

View raw message