ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin" <brandon.goo...@gmail.com>
Subject Re: Ibatis Blob Insertion problems
Date Thu, 12 Oct 2006 14:59:44 GMT
Just so everyone knows... I passed them the wiki link to Nathan's BLOB and
CLOB tutorial. I have also reponded privately encouraging them to make use
of the current iBATIS 2.2.0 jars.

Brandon

On 10/12/06, Jambunathan, Akilaprasad (Cognizant) <
Akilaprasad.Jambunathan@cognizant.com> wrote:
>
>  Greetings!!!
>
>
>
> 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, 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 ,
> UPLOADDATE, FILELOCATION)
>
>                                 VALUES
>
>                                 (#fileId#, #fileName#,TO_DATE(SYSDATE,
> 'MM/DD/YY'), #fileLink#)
>
>                 </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?
>
>
>
> 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
>

Mime
View raw message