> We are running on mysql. I am getting frequent (every few minutes) > constraint violations. Here is the exception: > Exception in thread "pool-1-thread-70998" > org.springframework.dao.DataIntegrityViolationException: > PreparedStatementCallback; SQL [Insert into COM_STATISTICS(STAT_SERVER_IP, > STAT_DATE, APPLIC_CD, STAT_PRECISION, STAT_COUNT, STAT_NAME) VALUES(?, ?, ?, > ?, 1, ?)]; Duplicate entry > 'unknown-2010-01-15-CAS-MINUTE-GRANT_SERVICE_TICKET-1' for key 1; nested > exception is > com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: > Duplicate entry 'unknown-2010-01-15-CAS-MINUTE-GRANT_SERVICE_TICKET-1' for > key 1
My hunch is that the MySQL DATE data type doesn't have enough granularity to store HH:MM:SS needed to make each entry unique. I would recommend updating the table schema to the TIMESTAMP datatype, or MySQL's version of same, and see if it goes away. M -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
