ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carol Villeneuve" <CVillene...@gildan.com>
Subject DaoException: Failed to update
Date Fri, 31 Dec 2004 16:55:51 GMT
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