2013年11月19日星期二

About mybatis3.0 handle long field problems

I am using oracle 10g, architecture spring + mybatis3, jdbc package using the oracle installation path inside ojdbc14, table has a field is of type long , generate xml file which , if I write
LONGVARCHAR "/>
or CLOB "/>
when they are being given in the query : Caused by: java.sql.SQLException: Invalid column type : getCLOB not implemented for class oracle.jdbc.driver.T4CLongAccessor

If you write : BLOB "/>
when it was being given in the query Caused by: java.sql.SQLException: Stream has been closed

What is the Editor ah ? I used to write jdbc then there is no such problem
------ Solution ------------------------------ --------------
DECIMAL "/>
use this to try
------ Solution -------------------------------- ------------
varchar not do it directly ? Field data is too long ?
------ For reference only -------------------------------------- -

oracle inside the long type is used to store variable-length character string data , it is not a java meaning inside the long , my data can be 1122334455 this format , with decimal certainly not
------ For reference only ------------------------------ ---------


now engaged in system reform , we can not say it directly to the field type rid
------ For reference only -------------------- -------------------
nobody encountered thing ?
------ For reference only -------------------------------------- -
mybatis deal with large fields , it seems relatively little information ah ?

没有评论:

发表评论