经验首页 前端设计 程序设计 Java相关 移动开发 数据库/运维 软件/图像 大数据/云计算 其他经验
当前位置：技术经验 » 数据库/运维 » Oracle » 查看文章
java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字
来源：cnblogs　　作者：罗小扇　　时间：2019/3/26 8:39:50　　对本文有异议 
  1. ### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字
  3. ### The error may involve com.lecar.user.mapper.StationManageMapper.insertStation-Inline
  4. ### The error occurred while setting parameters
  5. ### SQL: INSERT INTO T_CORP_STATION_INFO           (C_CORP_ID,n_station_code,v_station_name,v_station_header,v_station_tel,v_sendsite,n_area_id,v_station_note,n_inputflag,n_mainflag,n_sendflag,n_arrivedflag,           n_endflag,n_sendoutflag,n_sendinflag,n_arrivedoutflag,n_arrivedinflag,n_delflag,v_input_user_name,d_input_date)           values (?,?,?,?,?,?,           ?,?,?,?,           ?,?,?,?,           ?,?,           ?,?,?,?)
  6. ### Cause: java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字
  8. ; SQL []; ORA-01722: 无效数字
  9. ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字
  12.     at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:242)
  13.     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  14.     at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
  15.     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
  16.     at com.sun.proxy.$Proxy120.insert(Unknown Source)
  17.     at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:279)
  18.     at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:56)
  19.     at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
  20.     at com.sun.proxy.$Proxy189.insertStation(Unknown Source)
  21.     at com.lecar.user.company.TestStationMapper.insertStation(TestStationMapper.java:69)
  22.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  23.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  24.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  25.     at java.lang.reflect.Method.invoke(Method.java:498)
  26.     at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
  27.     at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  28.     at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
  29.     at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
  30.     at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
  31.     at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
  32.     at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
  33.     at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
  34.     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252)
  35.     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
  36.     at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
  37.     at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
  38.     at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
  39.     at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
  40.     at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
  41.     at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
  42.     at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
  43.     at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
  44.     at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
  45.     at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
  46.     at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
  47.     at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
  48.     at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
  49.     at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
  50. Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字
  52.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  53.     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  54.     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
  55.     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:459)
  56.     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:193)
  57.     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  58.     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
  59.     at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1264)
  60.     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1585)
  61.     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3929)
  62.     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4118)
  63.     at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:4093)
  64.     at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  65.     at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  66.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  67.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  68.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  69.     at java.lang.reflect.Method.invoke(Method.java:498)
  70.     at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  71.     at com.sun.proxy.$Proxy191.execute(Unknown Source)
  72.     at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:46)
  73.     at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
  74.     at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
  75.     at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
  76.     at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
  77.     at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
  78.     at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
  79.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  80.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  81.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  82.     at java.lang.reflect.Method.invoke(Method.java:498)
  83.     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
  84.     ... 34 more

解决办法 ：实体类的格式与数据库格式不匹配！

仔细检查会成功的！

原文链接：http://www.cnblogs.com/adrien/p/10592621.html

 友情链接：直通硅谷 　点职佳 　北美留学生论坛

Oracle热门文章

  • 【Oracle学习笔记】Oralce随机数与随机取样
  • java.sql.SQLSyntaxErrorException: ORA-01722: 无效数字
  • .NET多种数据库大数据批量插入、更新（支持SqlServer、MySql、PgSql和Oracle）
  • Navicat Premium 连接oracle ORA-01017：用户名/口令无效；登陆被拒绝
  • oracle - for in loop 循环更新
  • oracle json 解析函数
  • expdp导出时报错ora-16000
  • WARNING OGG-01519
  • ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务
  • oracle数据库与其他数据库区别

    • Oracle推荐文章

  • 在RockyLinux 9.3环境中采用RPM模式部署Oracle 19C
  • 你真会判断DataGuard的延迟吗？
  • Oracle rac环境的数据库导入操作记录
  • 使用Oracle进行数据库备份与还原
  • 从零写一个兼容MySQL/Oracle的Proxy中件间（一）《初识Oracle的通信协议》
  • 一文详解TDSQL PG版Oracle兼容性实践
  • 达梦与Oracle逻辑备份与还原性能对比
  • [20211213]提示precompute_subquery.txt
  • ORA-01536: space quota exceeded for tablespace案例
  • ORACLE如何查看当前账号的相关信息总结

    • 本站QQ群：前端 618073944 | Java 606181507 | Python 626812652 | C/C++ 612253063 | 微信 634508462 | 苹果 692586424 | C#/.net 182808419 | PHP 305140648 | 运维 608723728

    W3xue 的所有内容仅供测试，对任何法律问题及风险不承担任何责任。通过使用本站内容随之而来的风险与本站无关。
    关于我们  |  意见建议  |  捐助我们  |  报错有奖  |  广告合作、友情链接（目前9元/月）请联系QQ：27243702 沸活量
    皖ICP备17017327号-2　皖公网安备34020702000426号