I'm not aware of this limitation. We have run into similar things
before with the oracle driver. But, upgrading has always fixed it.
Have you attempted a test using straight JDBC?
Brandon
On 6/9/05, Henry Lu [EMAIL PROTECTED] wrote:
I got the following errors when I insert a large text into a
I don't have any idea off the top of my head. This may be a good
opportunity for you to do it with straight JDBC to see what works and
then look at our TypeHandlers to see how they are translating.
Brandon
On 6/9/05, Henry Lu [EMAIL PROTECTED] wrote:
No, I didn't. However, I got more details on
Item 1 is String limitation.
Item 2 I've never hit when using iBatis. I did get it however a few
times in PL-SQL... the problem was then solved by using the Oracle
function to_lob() while inserting the lob.
Regards,
Sven Boden
On Thu, 09 Jun 2005 13:05:50 -0400, you wrote:
No, I didn't.
Thanks for your info. I change my sql to be:
insert id=insert_clob
insert into x_clob
(name,c)
values
(#name:VARCHAR#,to_lob(#c:VARCHAR#))
/insert
and got the following errors:
[java] size=1819572, 1819572
[java] org.springframework.jdbc.BadSqlGrammarException:
In your trace it states:
Check the statement (update failed).
I would have to check the iBatis code what's actually happening (and
probably would need a few more pieces of information from your setup)
but LOBs/CLOBs can't be updated, only deleted/inserted.
From the Oracle documentation:
Are you sure that your drivers are the most up-to-date available?
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I
+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F
Check at the bottom of the page.
Nathan
On Jun 9, 2005, at 11:47 AM, Henry Lu wrote:
Could you send me
If you change BLOB to CLOB in the example, it DIDn't work!!!
-Henry
Nathan Maves wrote:
Are you sure that your drivers are the most up-to-date available?
http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I
+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F
Check at the
Is there anyone who have a working-code for insert CLOB and LONG data
type in Oracle?
-Henry
P.S.
Check the statement (update failed). - is a missleading error message from
iBatis. I did use INSERT command.
-Henry
Sven Boden wrote:
In your trace it states:
Check the statement (update
8 matches
Mail list logo