Springs mybatis + informix clob insert
Posted in 2015
Topics: Connectivity: ODBC / JDBC / .NET, Triggers, Constraints & Referential Integrity
Hello ~ Informix Colleague Does anybody know about Springs mybatis + informix clob insert sample? Our customer reveiced -841 error when they insert clob data. Is it same to JDBC clob insert source ? -841 Name must start with a letter or "_" and contain letters, digits, or "_". Names of databases, reports, forms, an! d other files must conform to this rule. Repeat this operation with a name that conforms to the rule. Beginning with Version 6.0, the name of the following identifiers, as well as server and cursor names, can begin with an underscore: column, connection, constraint, database, index, procedure, synonym, table, trigger, and view. Thank you in advance. :)
Sun-Mi: The finderr output is telling you what the problem is. The name of some object named in the INSERT statement contains an illegal character. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Aug 11, 2015 at 9:31 AM, SUN-MI MIN <mhera76@naver.com> wrote: > Hello ~ Informix Colleague > > Does anybody know about Springs mybatis + informix clob insert sample? > Our customer reveiced -841 error when they insert clob data. > Is it same to JDBC clob insert source ? > > -841 Name must start with a letter or "_" and contain letters, digits, > or "_". > > Names of databases, reports, forms, an! d other files must conform to > this rule. Repeat this operation with a name that conforms to the > rule. Beginning with Version 6.0, the name of the following > identifiers, as well as server and cursor names, can begin with an > underscore: column, connection, constraint, database, index, procedure, > synonym, table, trigger, and view. > > Thank you in advance. :) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --089e0111c0162106f6051d0a05c9
Thank you for your guide. They solved error using object type that I heard today. They want to confirm Infomrix CLOB insert method . Does anybody know about this ?