Hi, I m getting following problem while inserting data into table. database is MS SQL 2000 I m using jtds1.2.2.jar
Trace is as follows with my logger message :
com.i2e.classes.file.controller.FileDataController - It mean no duplicate group name for this user-- SO add this Group into table
com.i2e.classes.file.controller.FileDataController - Biren-ss-2009-04-20 01-30-21-Biren
com.i2e.classes.file.controller.FileDataController - Calling method to add New User Group
org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL update
org.springframework.jdbc.core.JdbcTemplate - Executing prepared SQL statement [insert into userfilegroup_tbl (username,userfilegroupname,changeDate,changeBy) values(?,?,?,?)]
org.springframework.jdbc.datasource.DataSourceUtil s - Fetching JDBC Connection from DataSource
org.springframework.jdbc.core.StatementCreatorUtil s - Setting SQL statement parameter value: column index 1, parameter value [Biren], value class [java.lang.String], SQL type unknown
org.springframework.jdbc.core.StatementCreatorUtil s - Setting SQL statement parameter value: column index 2, parameter value [ss], value class [java.lang.String], SQL type unknown
org.springframework.jdbc.core.StatementCreatorUtil s - Setting SQL statement parameter value: column index 3, parameter value [2009-04-20 01-30-21], value class [java.lang.String], SQL type unknown
org.springframework.jdbc.core.StatementCreatorUtil s - Setting SQL statement parameter value: column index 4, parameter value [Biren], value class [java.lang.String], SQL type unknown
org.springframework.jdbc.datasource.DataSourceUtil s - Returning JDBC Connection to DataSource
org.springframework.jdbc.support.SQLErrorCodeSQLEx ceptionTranslator - Unable to translate SQLException with Error code '0', will now try the fallback translator
com.i2e.classes.file.controller.FileDataController - FileDataController.handleRequest- In catch block[org.springframework.dao.DataIntegrityViolationExce ption: PreparedStatementCallback; SQL [insert into userfilegroup_tbl (username,userfilegroupname,changeDate,changeBy) values(?,?,?,?)]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation]
com.i2e.classes.file.controller.FileDataController - FileDataController.handleRequest-end
org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.InternalResou rceView: name 'global/Error'; URL [/WEB-INF/jsp/global/Error.jsp]] in DispatcherServlet with name 'WFMS'