java.sql.SQLException: ORA-01841

標籤：flex   struts2   spring   hibernate   

1、錯誤描述

body = (null)  clientId = "DB719904-1E0C-35DC-725D-86ABCF2B6EEC"  correlationId = "CC0B5A63-071F-6A5F-8971-7D1C17762BCC"  destination = "youCon"  extendedData = (null)  faultCode = "Server.Processing"  faultDetail = (null)  faultString = "org.springframework.dao.DataIntegrityViolationException : PreparedStatementCallback; SQL [insert into table(*,*,*,*,start_time,end_time,*,*) values(?,?,?,?,to_date(?,'yyyy-MM-dd'),to_date(?,'yyyy-MM-dd'),?,?)];  ORA-01841: (完整) 年份值必須介於 -4713 和 +9999 之間, 且不為 0; nested exception is java.sql.SQLException: ORA-01841: (完整) 年份值必須介於 -4713 和 +9999 之間, 且不為 0"  headers = (Object)#1  messageId = "DB71AC14-7D0E-9826-838B-A1C123FE42F1"  rootCause = (Object)#2    cause = (Object)#3      cause = (null)      errorCode = 1841      localizedMessage = "ORA-01841: (完整) 年份值必須介於 -4713 和 +9999 之間, 且不為 0"      message = "ORA-01841: (完整) 年份值必須介於 -4713 ??? +9999 之間, 且不為 0"      nextException = (null)      SQLState = "22008"    localizedMessage = "PreparedStatementCallback; SQL [insert into table(*,*,*,*,start_time,end_time,*,*) values(?,?,?,?,to_date(?,'yyyy-MM-dd'),to_date(?,'yyyy-MM-dd'),?,?)]; ORA-01841: (完整) 年份值必須介於 -4713 和 +9999 之間, 且不為 0; nested exception is java.sql.SQLException: ORA-01841: (完整) 年份值必須介於 -4713 和 +9999 之間, 且不為 0"    message = "PreparedStatementCallback; SQL [insert into table(*,*,*,*,start_time,end_time,*,*) values(?,?,?,?,to_date(?,'yyyy-MM-dd'),to_date(?,'yyyy-MM-dd'),?,?)];  ORA-01841: (完整) 年份值必須介於 -4713 和 +9999 之間, 且不為 0; nested exception is java.sql.SQLException: ORA-01841: (完整) 年份值必須介於 -4713 和 +9999 之間, 且不為 0"    mostSpecificCause = (Object)#3    rootCause = (Object)#3  timestamp = 1419438203085  timeToLive = 0

2、錯誤原因

3、解決辦法

java.sql.SQLException: ORA-01841