菜鸟日记之oracle weblogic
java 代码[*]com.ibatis.common.jdbc.exception.NestedSQLException:
[*]--- The error occurred while applying a parameter map.
[*]--- Check the insertRule-InlineParameterMap.
[*]--- Check the statement (update failed).
[*]--- Cause: java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable
[*]
[*] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:91)
[*] at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:447)
[*] at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
[*] at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:59)
[*] at com.dc.tirip.uwp.dao.rule.RuleDAO.insertRule(RuleDAO.java:33)
[*] at com.dc.tirip.uwp.servlet.rule.util.RulesOPR.addRecords(RulesOPR.java:132)
[*] at jsp_servlet._rules.__upload._jspService(upload.jsp:78)
[*] at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
[*] at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
[*] at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
[*] at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
[*] at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
[*] at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
[*] at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
[*] at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6724)
[*] at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
[*] at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
[*] at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
[*] at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
[*] at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
[*] at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
[*]Caused by: java.sql.SQLException: ORA-01483: invalid length for DATE or NUMBER bind variable
[*]
[*] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
[*] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
[*] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
[*] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
[*] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
[*] at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
[*] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027)
[*] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2885)
[*] at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2976)
[*] at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
[*] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[*] at java.lang.reflect.Method.invoke(Method.java:324)
[*] at com.ibatis.common.jdbc.logging.PreparedStatementLogProxy.invoke(PreparedStatementLogProxy.java:62)
[*] at $Proxy9.execute(Unknown Source)
[*] at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeUpdate(SqlExecutor.java:81)
[*] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteUpdate(GeneralStatement.java:200)
[*] at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(GeneralStatement.java:78)
[*] ... 20 more
[*]<2007-10-23 下午05时57分26秒 CST> <error></error> <http></http> 101018> < Servlet failed with ServletException
[*]javax.servlet.ServletException: 100
[*] at com.dc.tirip.uwp.servlet.rule.util.RulesOPR.addRecords(RulesOPR.java:136)
[*] at jsp_servlet._rules.__upload._jspService(upload.jsp:78)
[*] at weblogic.servlet.jsp.JspBase.service(JspBase.java:33)
[*] at weblogic.servlet.internal.ServletStubImpl$ServletInvocationAction.run(ServletStubImpl.java:1006)
[*] at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java:419)
[*] at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:28)
[*] at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
[*] at org.extremecomponents.table.filter.AbstractExportFilter.doFilter(AbstractExportFilter.java:49)
[*] at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:27)
[*] at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:6724)
[*] at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
[*] at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
[*] at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletContext.java:3764)
[*] at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java:2644)
[*] at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
[*] at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
[*]>
最后的问题是jdbc的jar包的问题,换了驱动并且扩大了DB字段问题解决。
页:
[1]