Announcement Announcement Module
Collapse
No announcement yet.
Data truncation pronlem while inserting into MS SQL Server 2000 -Spring Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data truncation pronlem while inserting into MS SQL Server 2000 -Spring

    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'
Working...
X