ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: DaoException: Failed to update
Date Sat, 01 Jan 2005 19:46:31 GMT
Can we see the item.xml sqlmap and associated bean?

Brandon


On Fri, 31 Dec 2004 11:55:51 -0500, Carol Villeneuve
<CVilleneuve@gildan.com> wrote:
> Hi,
> 
> We used the JDBC Driver from BEA WebLogic Type 4 JDBC MS SQL Server
>         driver=weblogic.jdbc.sqlserver.SQLServerDriver
>         url=jdbc:bea:sqlserver://ammtl1sqls01:1961
> Since we use this driver we got an error when the application try to update a field type
date with a null value
> 
> Befor we using this driver and we didn't have this error
>         url=jdbc:inetdae:ammtl1sqls01:1961
>         driver=com.inet.tds.TdsDriver
> 
> We have all ibatis-xx-2.jar
> 
> the stack trace is:
> 
> com.ibatis.dao.client.DaoException: Failed to update - id [updateItemBranch] - parameterObject
[com.gildan.ecrm.domain.store.Item@1e592d9].  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/gildan/ecrm/persistence/sql/Item.xml.
> --- The error occurred while applying a parameter map.
> --- Check the updateItemBranch-InlineParameterMap.
> --- Check the parameter mapping for the 'availableDate' property.
> --- Cause: java.sql.SQLException: [BEA][SQLServer JDBC Driver]The specified SQL type
is not supported by this driver
> Caused by: java.sql.SQLException: [BEA][SQLServer JDBC Driver]The specified SQL type
is not supported by this driver
> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred in com/gildan/ecrm/persistence/sql/Item.xml.
> --- The error occurred while applying a parameter map.
> --- Check the updateItemBranch-InlineParameterMap.
> --- Check the parameter mapping for the 'availableDate' property.
> --- Cause: java.sql.SQLException: [BEA][SQLServer JDBC Driver]The specified SQL type
is not supported by this driver
> Caused by: java.sql.SQLException: [BEA][SQLServer JDBC Driver]The specified SQL type
is not supported by this driver.
>         at com.ibatis.dao.client.template.SqlMapDaoTemplate.update(SqlMapDaoTemplate.java:124)
>         at com.gildan.ecrm.persistence.dao.sqlmapdao.ItemSqlMapDao.updateItemBranch(ItemSqlMapDao.java:84)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:324)
>         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
>         at $Proxy40.updateItemBranch(Unknown Source)
>         at com.gildan.ecrm.domain.logic.EcrmLogic.updateItemBranch(EcrmLogic.java:405)
>         at com.gildan.ecrm.presentation.action.admin.EtaAction.update(EtaAction.java:234)
>         at com.gildan.ecrm.presentation.action.admin.EtaAction.execute(EtaAction.java:89)
>         at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
>         at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
>         at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
>         at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
>         at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:996)
>         at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
>         at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
>         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
>         at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:129)
>         at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
>         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
>         at com.gildan.ecrm.presentation.filter.ContextPathFilter.doFilter(ContextPathFilter.java:25)
>         at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
>         at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6458)
>         at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
>         at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:118)
>         at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3661)
>         at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2630)
>         at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
>         at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
> 
> ___________________
> Carol Villeneuve
> Gildan Activewear
> Analyste-Programmeur
> Tél: (514) 343-8818
> 
>

Mime
View raw message