oracle 日志抛出,prepareStatement()抛出异常

本文介绍了一种在使用Java进行Oracle数据库操作时遇到的问题:在prepareStatement方法中的SQL语句末尾误加了分号导致的ORA-00911错误,并给出了修正后的正确SQL语句。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

在记录日志时,有这样一条数据库操作语句:

stmt = conn.prepareStatement("select nvl(max(log_id), 0) maxId from log_info;");

程序运行后抛出一大堆异常:

java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)  at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)  at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)  at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)  at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)  at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)  at com.demo.dao.LogDao.getMaxId(LogDao.java:19)  at com.demo.service.LogService.getMaxId(LogService.java:9)  at com.demo.filter.LogFilter.doFilter(LogFilter.java:43)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  at com.demo.filter.LoginFilter.doFilter(LoginFilter.java:38)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  at com.demo.filter.CharacterFilter.doFilter(CharacterFilter.java:23)  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)  at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)  at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)  at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)  at java.lang.Thread.run(Unknown Source) 原来是JAVA中的stmt的prepareStatement(String)方法中字符串不能加分号结尾。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值