Return-Path: Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 13388 invoked by uid 99); 1 Jan 2005 19:46:36 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of brandon.goodin@gmail.com designates 64.233.170.194 as permitted sender) Received: from rproxy.gmail.com (HELO rproxy.gmail.com) (64.233.170.194) by apache.org (qpsmtpd/0.28) with ESMTP; Sat, 01 Jan 2005 11:46:33 -0800 Received: by rproxy.gmail.com with SMTP id c16so245826rne for ; Sat, 01 Jan 2005 11:46:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=gIYaraPDHw1bhkrFYZS48UlQbQbhaYqcqpqFXYpuTX8v7ibRKiAJTlBA+Qu6+qxqKSCfJ1e32pkRGeOAvhkpHHm0Xs5guVn9hfZEM97cRx9y1UNzFkN9PWF8zpYU6QL8SKu5r4/5xulIhBHp6uBxCJyo1XhAUMINAUTaDM8pWjs= Received: by 10.38.76.72 with SMTP id y72mr449162rna; Sat, 01 Jan 2005 11:46:31 -0800 (PST) Received: by 10.38.74.57 with HTTP; Sat, 1 Jan 2005 11:46:31 -0800 (PST) Message-ID: <2fe5ef5b05010111463665d1c@mail.gmail.com> Date: Sat, 1 Jan 2005 12:46:31 -0700 From: Brandon Goodin Reply-To: Brandon Goodin To: ibatis-user-java@incubator.apache.org Subject: Re: DaoException: Failed to update In-Reply-To: <3AB4DBDEC9F70A4195DF578528E42E54A846A3@AMMTL1MS01.corp.gildan.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable References: <3AB4DBDEC9F70A4195DF578528E42E54A846A3@AMMTL1MS01.corp.gildan.com> X-Virus-Checked: Checked Can we see the item.xml sqlmap and associated bean? Brandon On Fri, 31 Dec 2004 11:55:51 -0500, Carol Villeneuve wrote: > Hi, >=20 > We used the JDBC Driver from BEA WebLogic Type 4 JDBC MS SQL Server > driver=3Dweblogic.jdbc.sqlserver.SQLServerDriver > url=3Djdbc:bea:sqlserver://ammtl1sqls01:1961 > Since we use this driver we got an error when the application try to upda= te a field type date with a null value >=20 > Befor we using this driver and we didn't have this error > url=3Djdbc:inetdae:ammtl1sqls01:1961 > driver=3Dcom.inet.tds.TdsDriver >=20 > We have all ibatis-xx-2.jar >=20 > the stack trace is: >=20 > com.ibatis.dao.client.DaoException: Failed to update - id [updateItemBran= ch] - 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 specifi= ed SQL type is not supported by this driver > Caused by: java.sql.SQLException: [BEA][SQLServer JDBC Driver]The specifi= ed 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 specifi= ed SQL type is not supported by this driver > Caused by: java.sql.SQLException: [BEA][SQLServer JDBC Driver]The specifi= ed SQL type is not supported by this driver. > at com.ibatis.dao.client.template.SqlMapDaoTemplate.update(SqlMap= DaoTemplate.java:124) > at com.gildan.ecrm.persistence.dao.sqlmapdao.ItemSqlMapDao.update= ItemBranch(ItemSqlMapDao.java:84) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess= orImpl.java:39) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth= odAccessorImpl.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(EcrmLo= gic.java:405) > at com.gildan.ecrm.presentation.action.admin.EtaAction.update(Eta= Action.java:234) > at com.gildan.ecrm.presentation.action.admin.EtaAction.execute(Et= aAction.java:89) > at org.apache.struts.action.RequestProcessor.processActionPerform= (RequestProcessor.java:484) > at org.apache.struts.action.RequestProcessor.process(RequestProce= ssor.java:274) > at org.apache.struts.action.ActionServlet.process(ActionServlet.j= ava:1482) > at org.apache.struts.action.ActionServlet.doPost(ActionServlet.ja= va:525) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAct= ion.run(ServletStubImpl.java:996) > at weblogic.servlet.internal.ServletStubImpl.invokeServlet(Servle= tStubImpl.java:419) > at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:= 28) > at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChain= Impl.java:27) > at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(P= ageFilter.java:129) > at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(Pa= geFilter.java:61) > at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChain= Impl.java:27) > at com.gildan.ecrm.presentation.filter.ContextPathFilter.doFilter= (ContextPathFilter.java:25) > at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChain= Impl.java:27) > at weblogic.servlet.internal.WebAppServletContext$ServletInvocati= onAction.run(WebAppServletContext.java:6458) > at weblogic.security.acl.internal.AuthenticatedSubject.doAs(Authe= nticatedSubject.java:321) > at weblogic.security.service.SecurityManager.runAs(SecurityManage= r.java:118) > at weblogic.servlet.internal.WebAppServletContext.invokeServlet(W= ebAppServletContext.java:3661) > at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRe= questImpl.java:2630) > at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219) > at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178) >=20 > ___________________ > Carol Villeneuve > Gildan Activewear > Analyste-Programmeur > T=E9l: (514) 343-8818 >=20 >