ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yee, Richard K CTR DMDC" <Richard.Yee....@osd.pentagon.mil>
Subject RE: Ibatis Blob Insertion problems
Date Thu, 12 Oct 2006 21:02:33 GMT
Use the Oracle 10g thin driver instead of the 9i driver.
 
-Richard

-----Original Message-----
From: Jambunathan, Akilaprasad (Cognizant)
[mailto:Akilaprasad.Jambunathan@cognizant.com] 
Sent: Thursday, October 12, 2006 1:41 PM
To: user-java@ibatis.apache.org
Subject: RE: Ibatis Blob Insertion problems



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

 

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