高手进来看看这个难问题???
2007-09-14 00:05:05 [org.springframework.beans.factory.xml.XmlBeanDefinitionReader]-[INFO] Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
2007-09-14 00:05:05 [org.springframework.jdbc.support.SQLErrorCodesFactory]-[INFO] SQLErrorCodes loaded: [DB2, HSQL, MS-SQL, MySQL, Oracle, Informix, PostgreSQL, Sybase]
2007-09-14 00:05:05 [com.leadtone.gegw.snmpfile.timer.timertransact.SnmpDayFile]-[ERROR] cef_status:2007-09-14=========get data was failed================
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select cefcid, agentregusernum, agentupflow, agentdownflow,agentconnkeeptime, agentrecvsuccnum, agentrecvmailfailnum, agentsendmailsuccnum, agentsendmailfailnum from active_cef_capability where sampletime = to_date( '2007-09-14 ', 'YYYY-MM-DD ')]; SQL state [null]; error code [17026]; 数字溢出; nested exception is java.sql.SQLException: 数字溢出
java.sql.SQLException: 数字溢出
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java(Inlined Compiled Code))
at oracle.jdbc.driver.NumberCommonAccessor.getInt(NumberCommonAccessor.java(Compiled Code))
at oracle.jdbc.driver.OracleResultSetImpl.getInt(OracleResultSetImpl.java(Compiled Code))
at oracle.jdbc.driver.OracleResultSet.getInt(OracleResultSet.java(Compiled Code))
at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java(Compiled Code))
at com.leadtone.gegw.snmpfile.database.dao.CefStatusDao$1.processRow(CefStatusDao.java(Compiled Code))
at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java(Compiled Code))
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:540)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:476)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:528)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:561)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:579)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:589)
at com.leadtone.gegw.snmpfile.database.dao.CefStatusDao.getDaoData(CefStatusDao.java:24)
at com.leadtone.gegw.snmpfile.datatransact.CefStatus.getData(CefStatus.java:16)
at com.leadtone.gegw.snmpfile.timer.timertransact.SnmpDayFile.execute(SnmpDayFile.java:42)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
不知道什么原因,请各位指教!!
[解决办法]
sampletime = to_date( '2007-09-14 ', 'yyyy-MM-dd ')
[解决办法]
可能是数据库设计的数据长度太小，放不下你放入的日期长度
