ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jambunathan, Akilaprasad \(Cognizant\)" <Akilaprasad.Jambunat...@cognizant.com>
Subject RE: Ibatis Blob Insertion problems
Date Thu, 12 Oct 2006 20:41:01 GMT

With the updated jars we were able to upload until 4KB. Can anybody help
us in telling what has to be done for uploading > 4KB?


From: Jambunathan, Akilaprasad (Cognizant)
Sent: Thursday, October 12, 2006 8:23 PM
To: 'user-java@ibatis.apache.org'
Subject: Ibatis Blob Insertion problems


We are using iBatis (am not sure on the version) along with Oracle for one of our project. We are using BLOBs extensively, when
we are trying to insert into a table which has BLOBs we are facing some
issue. Here are the details you might be looking for.

iBatis XML snipped

                <insert id="insertFile" parameterMap="uploadFile">

                                INSERT INTO

                                FILEUPLOAD ( FILEID , FILENAME ,


                                (#fileId#, #fileName#,TO_DATE(SYSDATE,
'MM/DD/YY'), #fileLink#)  



                <insert id="insertFileEmptyBlob"

                                INSERT INTO

                                FILEUPLOAD ( FILEID , FILENAME ,


                                (#fileId#, #fileName#,TO_DATE(SYSDATE,
'MM/DD/YY'), empty_blob())            



Caused by: java.sql.SQLException: ORA-01858: a non-numeric character was
found where a numeric was expected

Please let me know on what am I doing wrong?

Warm Regards,


This e-mail and any files transmitted with it are for the sole use of the intended recipient(s)
and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of
this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

  Visit us at http://www.cognizant.com
View raw message