Can we see the item.xml sqlmap and associated bean? Brandon
On Fri, 31 Dec 2004 11:55:51 -0500, Carol Villeneuve <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] 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 > >
