GVKun编程网logo

org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: java.sql.SQL...

26

对于想了解org.apache.ibatis.exceptions.PersistenceException:Errorqueryingdatabase.Cause:java.sql.SQL...的读

对于想了解org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: java.sql.SQL...的读者，本文将是一篇不可错过的文章，并且为您提供关于### Error querying database. Cause: org.postgresql.util.PSQLException: 大型对象无法被使用在自动确认事物交易模式、### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291...、could not execute statement； SQL [n/a]； nested exception is org.hibernate.exception.DataException:、Error querying database. Cause: java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB的有价值信息。

本文目录一览：

org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: java.sql.SQL...

org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: java.sql.SQL...

1. 笔者的目录结构如下:

2. 由于单元测试报错:org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
### The error may exist in top/wajq/mapper/CustomerMapper.xml
### The error may involve top.wajq.mapper.CustomerMapper.findCustomerByNameAndJobs-Inline
### The error occurred while setting parameters
### SQL: select * from t_customer where 1=1        and username like concat(''%'',''?'',''%'')            and jobs=?
### Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:26)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
    at top.wajq.test.MybatisTest.findCustomerByNameAndJobs(MybatisTest.java:168)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
    at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:538)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:760)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:460)
    at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:206)
Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3326)
    at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3310)
    at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4146)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:70)
    at com.sun.proxy.$Proxy9.setString(Unknown Source)
    at org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:31)
    at org.apache.ibatis.type.StringTypeHandler.setNonNullParameter(StringTypeHandler.java:26)
    at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:50)
    at org.apache.ibatis.scripting.defaults.DefaultParameterHandler.setParameters(DefaultParameterHandler.java:81)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:80)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:61)
    at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:74)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
    ... 25 more

通过仔细阅读错误信息确定了是由于 {SQL: select * from t_customer where 1=1        and username like concat (''%'',''?'',''%'')            and jobs=?} 这句话产生了错误，大意是由于动态 SQL 语句不正确，所以查看 sql 配置:<select id="findCustomerByNameAndJobs" parameterType="top.wajq.bean.Custumer" resultType="top.wajq.bean.Custumer">
        select * from t_customer where 1=1
        <if test="username !=null and username != ''''">
            and username like concat(''%'',''#{username}'',''%'')
        </if>
        <if test="jobs !=null and jobs != ''''">
            and jobs=#{jobs}
        </if>
    </select> 

   多了引号。 正确如下: and username like concat (''%'',#{username'',''%'')，果然对了。
总结：1. 要对数据库的数据完整以及是否存在查询；

　　　2.mybatis 是与数据库相关的所以极大多数是 SQL 语句的问题，排查数据库的语句问题；

　　    3. 由于要进行 mapper 配置所以其中的名称信息需极细心，

　　    4. 其次要进行单元测试从而达到查错的目的。

### Error querying database. Cause: org.postgresql.util.PSQLException: 大型对象无法被使用在自动确认事物交易模式

### Error querying database. Cause: org.postgresql.util.PSQLException: 大型对象无法被使用在自动确认事物交易模式

把LONGVARCHAR改为VARCHAR

### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291...

### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291...

在向Oracle数据库里面插入数据时发生了以下错误

; ]; ORA-02291: 违反完整约束条件 (SSM.SYS_C0011830) - 未找到父项关键字
; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-02291: 违反完整约束条件 (SSM.SYS_C0011830) - 未找到父项关键字

    org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:986)
    org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:881)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
    org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
    org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
    org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
    org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
    org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
    org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
    org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
    org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)

A表和B表通过主键与中间表C表关联，在向C表中插入数据时，如果插入C表时中数据没有与A表或者B表中主键对应，就会出现该错误。

 

简而言之就是在插入数据时，中间表的数据必须在它所关联的表中存在。

could not execute statement； SQL [n/a]； nested exception is org.hibernate.exception.DataException:

could not execute statement； SQL [n/a]； nested exception is org.hibernate.exception.DataException:

向mysql插入数据时出现错误
原因：mysql表里的字段太短：Varchar（11），把它改大一点就好了

Error querying database. Cause: java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB

Error querying database. Cause: java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB

@thinkgem 你好，想跟你请教个问题：

我用系统创建了一个用户，并分配了一些权限，但是登陆的时候提示错误：

Error querying database.  Cause: java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB


我数据库是oracle ，请问这是怎么回事？需要怎么改正？

关于org.apache.ibatis.exceptions.PersistenceException: Error querying database. Cause: java.sql.SQL...的问题我们已经讲解完毕，感谢您的阅读，如果还想了解更多关于### Error querying database. Cause: org.postgresql.util.PSQLException: 大型对象无法被使用在自动确认事物交易模式、### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-02291...、could not execute statement； SQL [n/a]； nested exception is org.hibernate.exception.DataException:、Error querying database. Cause: java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 NCLOB等相关内容，可以在本站寻找。

本文标签：

上一篇如何解决TypeError：environment.teardown不是函数？（typeerror is not a function）

下一篇react 高阶组件的使用（react 高级组件）

相关文章