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
