MERGE INTO Not Working With Large CLOB, Normal INSERT Does

Hi,
I have a merge into statement using CLOB columns, simplified here. Database 
is Oracle 11.2, mybatis 3.3
  MERGE INTO T_Q_MSG_LOG t
  USING dual
  ON (MESSAGE_ID = #{messageId})
  WHEN MATCHED THEN
  ...
  WHEN NOT MATCHED THEN
  INSERT (MESSAGE_ID, ...., STACKTRACE)
  VALUES (#{messageId}, ...., #{stackTrace})
When i attempt to bind more than 4000 bytes to the stackTrace column (the 
stacktrace field is just a string) i get this error :
Caused by: java.sql.SQLRecoverableException: No more data to read from 
socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at 
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at 
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at 
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at 
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at 
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
at 
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
at 
org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:45)
at 
org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:73)
at 
org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)
at 
org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
at 
org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at 
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:386)
... 37 more
When i change the statement to a normal insert instead of merge everything 
works fine. Any ideas ?
Thanks,
Jorg
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]
For more options, visit https://groups.google.com/d/optout.

Please clarify.  You say  "When i attempt to bind more than 4000 bytes 
to the stackTrace column (the stacktrace field is just a string) i get 
this error".  If you do a merge into with stackTrace set to less than 
4000 bytes, does it work successfully?  I'd like to understand if it is 
always failing, or only when you supply more than 4000 bytes.  4000 
bytes sounds like you might be running into a pagesize limitation (which 
would only affect inline CLOBs.)  You'd need to talk to your DBA about 
that.
Guy Rouillier

Indeed the merge works fine when I bind less than 4000 bytes to the variable. 
But I do not understand why a normal insert statement does not have this limitation. It does sound more like an oracle issue though, you are right.
Jorg
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]
For more options, visit https://groups.google.com/d/optout.

Hi, I have set up to import some oracle clob columns with DIH. I am using the latest nightly release. My config says, .... But it does not seem to turn this clob into a String. The search results show: 1.8670129 [email protected] 4486 Any pointers on why I do not get the 'string' out of the clob for indexing? Is the nightly war NOT the right one to use? Thanks for your
Hello, I'm trying to run the following SQL statement on a table of my MySQL DB: insert into MYTABLE(ID, VALUE, SORTKEY) select T.ID, 'to to', MAX(T.SORTKEY) + 1 from MYTABLE as T group by T.ID This was suggested by a SQL expert (which I'm unfortunately not) , and works perfectly on MS SQL Server. :-( But, on MySQL it raises the following error: ERROR 1093: INSERT TABLE 'mytable
Cassandra 2.0.2 does not persist the map collection when I specify an if-not-exists clause in the insert operation: cqlsh:mohica>CREATE TABLE simple (id1 TEXT, ,my_map MAP,PRIMARY KEY (id1)); cqlsh:mohica>INSERT INTO simple(id1,my_map) VALUES ('id1',{'a1':'b1','a2':'b1'}) if not exists; [applied] True cqlsh:mohica>SELECT * from simple ; id1 | my_map id1 | null Mohica
I have spent a couple of days on this and have read the FAQ and googled without success, so hope I can get some help: I am trying to persist an instance of the class: public class Role { private Integer roleid; private Integer parentid; private String name; private String notes; public Integer getRoleid() { return roleid; } .......&c } with role_SqlMap.xml the
Hi, when I merge to PDFs into one using PDFMerger the Destinations of the second PDF given are being lost. I looked into PDFMergerUtility class and found that mergeInto called on Names' COSDictionary doesn't work as intended. I tried to solve this problem, see the attached patch. Now I get both Destinations in the result PDF. My questions and annotations are prefixed with "###". Any feedback
Hi! I do not know how to use INSERT and UNION together. For example: INSERT INTO tmp_table_name (a) (SELECT a FROM table_name WHERE a AND B=1 ORDER BY a LIMIT 10) UNION (SELECT a FROM table_name WHERE a AND B=2 ORDER BY a LIMIT 10) ORDER BY a; It does not work. But I think it should. Have the MySQL developers forgotten something?? I use MySQL 4.012 Download Yahoo! Messenger now
Can you describe the database table structure you're working on? /Axel >>-----Ursprüngliche Nachricht----- >>Von: Chris Marshall [mailto:[email protected]] >>Gesendet: Freitag, 18. April 2008 16:02 >>An: [email protected] >>Betreff: Re: iBATIS insert does not execute >> >> >>Further to my previous reply - I have checked all field values to be >>correct, with only the primary
Hi, With ORCFiles data inserted into the first table only. Hive 0.13 test: create table orc1 stored as orc tblproperties ("orc.compress"="ZLIB") as select rn from ( select cast(1 as int) as rn from dual union all select cast(100 as int) as rn from dual union all select cast(10000 as int) as rn from dual ) t; create table orc_rn1
I have successfully had run a number of tests on my hadoop cluster, but the terasort example failed with a mysterious issue. I installed and configured the system using SCM and have not modified the configuration file by hand. If anyone can tell me what I have misconfigured, I would really appreciate it. Cordially, Mark Henning, ITT corp. Script started on Mon 26 Sep 2011 05:46:03 PM
Hi there, I am trying to update a table with new rows. The new rows are in another table so thought a insert select would be the right choice. Unfortunatelly it is only inserting about 400 rows, but the table contains more than 700. So I do really not know whats going on. Maybe someone could help on this. Thanx in advance. Andy Statement: insert into geodata_backup.provinces_test
Hi, First time when I run the following query then it works fine, MATCH (ageGroup:AgeGroup {ageGroup: "BETWEEN_25_TO_34"}), (action:Action {action: "Like"}) MERGE (action)
I installed 5.0 and 5.1-beta on three different system (all are Fedora Core 4), and each time when I use the command-line client, I can not use the familiar up-arrow feature that normally lets you scroll through queries issued during previous command-line sessions. My history is completely blank. the $HOME/.mysql_history file does exist, but all it's got in it is: _HiStOrY_V2_ in the first
Dear Experts, I'm using NEO4J 2.1.4 on Redhat 6.4.� And have about 88K Person nodes. match �(x) return labels(x), count(*) +-----------------------+ | labels(x) �| count(*) | +-----------------------+ | ["Person"] | 87474 � �| +-----------------------+ 1 row 531 ms They all have a personid. And I have created a UNIQUE constraint on that field.� CREATE CONSTRAINT ON (p:Person) ASSERT p.personid
Hi all, I am using Subverison 1.7.8. On my disk are two Subversion working copies (from different repositories), and one working copy contains a symlink to the other: /modules/test/dir/file.dat /sources/test/modules -> ../../modules/test/ Unfortunately "svn info" does not work with an absolute path name in this scenario: ~$ svn info /sources/test/modules/dir svn: warning: W155010: The node '/sources
Hi All I have been on these for 4 days now. No matter what I feed my simple perl script in a simple rewrite_map setup it wont return any feedback when used through apache. When used through comand line it works just fine. Some background info: debian:/var/www# apache2 -v Server version: Apache/2.2.9 (Debian) Server built: Jun 1 2009 17:44:04 ####.htaccess RewriteEngine on RewriteCond ${dash2score
Win2K Server SP3 IIS 5 PHP 4.2.3 this code only works if php is ISAPI. any ideas? all help is greatly appreciated. ben
I created a task which is about gps open and off, i know thats a thing google changed, toggling gps works different now so it doesnt work and also my phone has root. But its same with secure settings configuration. please help how can i fix it? You received this message because you are subscribed to the Google Groups "Tasker" group. To unsubscribe from this group and stop receiving emails
Hi! I have posted a message about INSERT DELAYED crashing the 3.23.33 server build from tar ball to make it work on high loads. However, with or without mentioned compiler params i could never do any INSERT DELAYED on any database with ant tables using any 3.23.xx It just says "Server has gone away". Sinisa, i want to point out that this is not LINUX, it is FreeBSD which is fully rebuild
Hi In a php script which has not caused a problem before, I have an INSERT query. If this returns an error, the script dies. If not, it then gets the last_insert_id which is used as the basis of an order number. Today we found a mail about an order number without the ID component, and as this implies, there is no corresponding record in the orders table. There are however records for this
Hi guys, I am trying to insert a NULL value into a DB field. The value is not always NULL so the statement is given. Unfortunatelly it is inserting 0 instead of NULL. How can I get the thing going with NULL??? Here is the code I am using: if ($park == 'false'){ $park = NULL; } $stmt = "INSERT INTO $T1 ( belongs_to, name, caption, country, province