Hi, CLOB isn't supported directly. At this time, you need to write a custom type handler (because most CLOB implementations are vendor specific). Luckily there is one available for download here:
http://nagoya.apache.org/jira/browse/IBATIS-4 Look for iBATISClob.zip Cheers, Clinton On Fri, 03 Dec 2004 16:05:51 +0100, Emiliano Armellin <[EMAIL PROTECTED]> wrote: > 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 > > * > W_ > www.ateikon.com <http://www.ateikon.com> > * > @_ > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > * > T_ > *+39 0422 452101* > > Get Firefox! <http://www.spreadfirefox.com/?q=affiliates&id=15653&t=86> > Get Thunderbird <http://www.mozilla.org/products/thunderbird/> > >
