日期:2014-05-18  浏览次数:20702 次

高手进来看看这个难问题???
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.j