org.hibernate.exception.GenericJDBCException: could not prepare statement错误

最新推荐文章于 2024-08-18 15:08:47 发布
最新推荐文章于 2024-08-18 15:08:47 发布
阅读量2.8w 收藏 3
点赞数 4
分类专栏： java hibernate 文章标签： hibernate java jpa
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43864365/article/details/106240169
版权

本人使用的是JPA所以没有hibernate版本问题，这个错误是在正式库出现的，自上线以来第一次出现

错误信息如下：

org.springframework.orm.jpa.JpaSystemException: could not prepare statement; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:333)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488)
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    at com.sun.proxy.$Proxy152.findByFileName(Unknown Source)
    at com.suock.api.timing.Tmier.Analysis(Tmier.java:259)
    at com.suock.api.timing.Tmier$$FastClassBySpringCGLIB$$61385ab3.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:115)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1929)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
    at org.hibernate.loader.Loader.doQuery(Loader.java:919)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
    at org.hibernate.loader.Loader.doList(Loader.java:2617)
    at org.hibernate.loader.Loader.doList(Loader.java:2600)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)
    at org.hibernate.loader.Loader.list(Loader.java:2424)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
    at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
    at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529)
    at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:206)
    at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:85)
    at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:116)
    at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:106)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:483)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
    ... 23 more
Caused by: java.sql.SQLException: Connection has already been closed.
    at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
    at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
    at com.sun.proxy.$Proxy78.prepareStatement(Unknown Source)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
    ... 54 more
文件读取錯誤
2020-05-20 14:44:54.888  WARN 20723 --- [tithreading-120] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: null
2020-05-20 14:44:54.888 ERROR 20723 --- [tithreading-120] o.h.engine.jdbc.spi.SqlExceptionHelper   : Connection has already been closed.
org.springframework.orm.jpa.JpaSystemException: could not prepare statement; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:333)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
    at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488)
    at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
    at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    at com.sun.proxy.$Proxy152.findByFileName(Unknown Source)
    at com.suock.api.timing.Tmier.Analysis(Tmier.java:259)
    at com.suock.api.timing.Tmier$$FastClassBySpringCGLIB$$61385ab3.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.AsyncExecutionInterceptor$1.call(AsyncExecutionInterceptor.java:115)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1929)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1876)
    at org.hibernate.loader.Loader.doQuery(Loader.java:919)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)
    at org.hibernate.loader.Loader.doList(Loader.java:2617)
    at org.hibernate.loader.Loader.doList(Loader.java:2600)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2429)
    at org.hibernate.loader.Loader.list(Loader.java:2424)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:501)
    at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
    at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
    at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606)
    at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529)
    at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:206)
    at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:85)
    at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:116)
    at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:106)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:483)
    at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
    ... 23 more
Caused by: java.sql.SQLException: Connection has already been closed.
    at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:117)
    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
    at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:75)
    at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:108)
    at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:81)
    at com.sun.proxy.$Proxy78.prepareStatement(Unknown Source)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
    ... 54 more

 

 

解决方式：

1.排查你的映射是否建立好了；

2.排查你的实体类是否跟映射对应；

3.排查你的版本是否正确（Hibernate的版本）；

4.查看你的代码是否存在问题（主要是你的事务是否加错位置了）；

5.检查你的配置文件数据库连接超时（一般设置在6-8分钟，特殊情况的话设置的时间可以长些10分钟左右，这是建立在你其他几项没有问题的情况下）；

建议：要是你的程序原先没有出现过这个问题，突然出现了。这个跟你的数据量有关，其实说白了就是程序优化问题。程序优化后续我会继续更新

别的小朋友都没你可爱
关注
专栏目录
异常排查 PersistenceException：org.hibernate.exception.GenericJDBCException: could not execute statement
猴戏浅滩的博客
05-28 5559
具体异常信息如下： Unhandled exception: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) at org.hib.
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prep
weixin_33895657的博客
05-12 5094
2019独角兽企业重金招聘Python工程师标准>>> ...
hql报错could not prepare statement
z2431435的博客
03-10 2157
的错误，没有测试我就以为是错了，所以用nativeQuery = true把报错信息去掉了，因为@Query 注解允许通过将 nativeQuery 标志设置为 true 来执行原始sql，但是没想到运行时报了could not prepare statement，看了日志发现是因为使用nativeQuery = true就得写成sql，而我的写法是前面hql后面查询条件是sql，将nativeQuery = true去掉后虽然有报错但运行成功。由于写hql时报了一个。
springboot data jpa 适配 gbase8s 报错could not prepare statement
最新发布
wangyx01的博客
08-18 303
在hibernate 默认的方言中配置为true ，即在空元素时 生成 in （） sql语句，改为false 时 生成 in (null) 语法 ，在gbase 数据库中 不支持前者 ，导致 报错 201 语法错误。根据绑定变量的结构发现 selentity.total 为List 集合 ，在集合元素为0 时产生如下异常。在绑定变量为集合的场景下，需要从方言中判断 在集合元素为0 的时候，拼接sql时 时候将空集合替换为null。在适配过程中，发现部分sql报错 201 语法错误。
HTTP500nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
qq_33873421的博客
06-12 764
HTTP Status 500 - Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
JPA GenericJDBCException: could not prepare statemen问题解决
旭东怪的博客
02-21 3919
问题描述： Causedby:org.hibernate.exception.GenericJDBCException:couldnotpreparestatemen 问题分析： 1、使用了jdbc获取Connection，但是在结束时调用了close()方法，导致连接关闭。
org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement； SQL
wa2661391317的博客
08-30 2811
Junit 测试 org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [insert into ..表名. values ..]nested exception is org.hibernate.exception.SQLGrammarException: could not prepare statement 解决办法：查看创建的表里面缺少哪个字段，添加缺少的字
org.hibernate.exception.GenericJDBCException: could not execute statement
墨笙弘一
05-08 1万+
在用hibernate的时候，可能会存在错误的用法，导致报下面的这种错误：org.hibernate.exception.GenericJDBCException: could not execute statement错误信息如下：org.hibernate.exception.GenericJDBCException: could not execute statement at org.hib
org.hibernate.exception.GenericJDBCException: could not execute query项目登录验证报错
myself_sky的博客
04-14 3393
项目登录的时候，进行用户名密码验证时报错，是什么原因呢？求大神帮忙看一下，无尽感激 四月 14, 2017 12:57:57 下午 org.apache.catalina.core.ApplicationDispatcher invoke 严重: Servlet.service() for servlet AuctionListServlet threw exception org.hibe
could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
09-11
nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement"是一个错误提示，意味着执行SQL语句时出现了问题。根据代码和错误提示，可以看出是在保存用户时发生的错误。经过...
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
01-16
以下是处理javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query异常的一种方法： ```java try { // 执行数据库查询操作 // ... } catch (javax....
org.hibernate.exception.GenericJDBCException:could not prepare statement
05-19
2. SQL 语句问题：检查 SQL 语句是否正确，包括语法错误和表或列名是否正确。 3. 数据库表结构问题：检查数据库表是否存在，以及表结构是否与代码中的映射相同。 4. 数据库数据问题：检查数据库中的数据是否符合...
JPA报错could not execute statement； nested exception is org.hibernate.exception.GenericJDBCException:
huan1213858的博客
02-24 2143
jpa
could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException...
热门推荐
一名假人的博客
02-25 1万+
Mysql问题 问题描述 当后端使用的是SpringJPA作为持久层的结局方案时，前端做新增请求时报错could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement 问题解决 解决方式 到mysql给相...
关于org.hibernate.exception.GenericJDBCException: could not execute query的解决
chiphuo的专栏
12-24 9768
在用hibernate的时候，一直运行的十分正常，可是有些时候会莫名其妙的报出这样的异常(例如：在使用聚合函数sum(), avg()等等) 这种异常一时感觉到没有解决的办法 后来我发现我用的mysql的驱动程序是mysql-connector-java-3.2.0-alpha-bin.jar我想可能是驱动程序的问题当我把mysql的驱动程序换成mysql-conn
nested exception is org.hibernate.exception.DataException: could not execute statement
Blooming death的博客
12-19 8223
nested exception is org.hibernate.exception.DataException: could not execute statement 数据异常：无法指向语句， 可以看出是sql错误，说是数据异常，那么就是数据的原因，跟代码无关，于是乎就检查出是字段长度问题插入的太长，字段大小太短， 大部分问题是这种， 原文链接 ...
h2内存数据库oracle模式，分页报错rg.springframework.dao.InvalidDataAccessResourceUsageException: could not prepar
qq_43041751的博客
06-30 1399
当我们使用hibernate的NativeQuery进行分页时，底层会采用limit或rownum，而采用哪种分页方式是有由不同数据库的方言决定的，下面将讲解h2的oracle模式下使用NativeQuery进行分页时报错问题解决org.springframework.dao.InvalidDataAccessResourceUsageException: could not prepare statement; SQL [SELECT * limit ?]; nested excep......
Hibernate之org.hibernate.exception.GenericJDBCException:could not execute statement
LuuvyJune的博客
03-02 1万+
ERROR: Field 'rempid' doesn't have adefault value 2016-3-1 21:07:20 org.hibernate.engine.jdbc.batch.internal.AbstractBatchImplrelease INFO: HHH000010: On release of batchit still contained JDBC stat...
评论 6
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值