Hello,

I have a String variable in my java bean ("contenuto") and I have to populate with this string value a CLOB field on a table in  Oracle 9i DB.
Wel,l I receive this exception:

org.springframework.jdbc.UncategorizedSQLException: (SqlMapClientTemplate): encountered SQLException [ 
--- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml. 
--- The error occurred while applying a parameter map. 
--- Check the insertAtkMessaggioItem-InlineParameterMap. 
--- Check the parameter mapping for the 'contenuto' property. 
--- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650]; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml. 
--- The error occurred while applying a parameter map. 
--- Check the insertAtkMessaggioItem-InlineParameterMap. 
--- Check the parameter mapping for the 'contenuto' property. 
--- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650
com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in com/ateikon/internet/atkim/dao/ibatis/maps/AtkMessaggio.xml. 
--- The error occurred while applying a parameter map. 
--- Check the insertAtkMessaggioItem-InlineParameterMap. 
--- Check the parameter mapping for the 'contenuto' property. 
--- Cause: java.sql.SQLException: Data size bigger than max size for this type: 5650
Caused by: java.sql.SQLException: Data size bigger than max size for this type: 5650
    at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:86)
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:266)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:70)
    at org.springframework.orm.ibatis.SqlMapClientTemplate$10.doInSqlMapClient(SqlMapClientTemplate.java:281)
    at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:142)
    at org.springframework.orm.ibatis.SqlMapClientTemplate.insert(SqlMapClientTemplate.java:279)
    at com.ateikon.internet.atkim.dao.ibatis.SqlMapAtkMessaggioDao.insertItem(SqlMapAtkMessaggioDao.java:41)
    at com.ateikon.internet.atkim.domain.logic.AtkimImpl.insertMail_NN(AtkimImpl.java:249)
    at java.lang.reflect.Method.invoke(Native Method)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:295)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:154)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:121)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:143)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:174)
    at $Proxy0.insertMail_NN(Unknown Source)
    at com.ateikon.internet.atkim.web.spring.SendMailController.handleRequestInternal(SendMailController.java:236)
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:128)
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:44)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:532)
    at org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:366)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:317)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:721)
    at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
    at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
    at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
    at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
    at java.lang.Thread.run(Unknown Source)

what can I do?


--
Emiliano Armellin
Get Firefox!
Get Thunderbird

<<inline: trust.gif>>

<<inline: thunderbird_small.png>>

Reply via email to