Re: FW: Facing problem with iBatis BLOB

[Larry Meadors <la...@gmail.com>]

Please send support messages to the mailing lists.

Larry


On 10/12/06, Jambunathan, Akilaprasad (Cognizant) <
Akilaprasad.Jambunathan@cognizant.com> wrote:
>
>  Greetings!!!
>
>
>
> We were looking at the Mailing list archives for solutions for our
> problem, that's where we could get your email id.  We are using iBatis (am
> not sure on the version) along with Oracle 10.1.0.2.0 for one of our
> project. We are using BLOBs extensively, while we are able to get the BLOB
> as byte[] from Oracle, we are facing problems when we are trying to insert
> BLOB into the same table. Here are the details you might be looking for.
>
>
>
> *iBatis XML snipped*
>
>
>
>                 <insert id="insertFile" parameterMap="uploadFile">
>
>                                 INSERT INTO
>
>                                 FILEUPLOAD ( FILEID , FILENAME ,
> UPLOADDATE, FILELOCATION)
>
>                                 VALUES
>
>                                 (#fileId#, #fileName#,TO_DATE(SYSDATE,
> 'MM/DD/YY'), #fileLink#)   // The FileLink has the byte[] for the blob to be
> inserted to the table.
>
>                 </insert>
>
>
>
>                 <insert id="insertFileEmptyBlob" parameterClass="
> com.newsamerica.value.ffms.jobinformation.JobAttachmentValue">
>
>                                 INSERT INTO
>
>                                 FILEUPLOAD ( FILEID , FILENAME ,
> UPLOADDATE, FILELOCATION)
>
>                                 VALUES
>
>                                 (#fileId#, #fileName#,TO_DATE(SYSDATE,
> 'MM/DD/YY'), empty_blob())
>
>                 </insert>
>
>
>
> *Exception*
>
> * *
>
> 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?
>
>
>
> Anxiously waiting for Your Reply,
>
> Warm Regards,
>
> Akil
>  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
>