spring boot 相关错误总结（1）

最新推荐文章于 2024-01-23 14:19:15 发布

原创最新推荐文章于 2024-01-23 14:19:15 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

本文总结了使用Spring Boot进行数据库操作时常见的六个问题及其解决方案，包括未配置方言、无法找到实体、服务器连接问题、时区问题、找不到hibernate_sequence以及构造函数问题，为开发者提供实用的故障排查指南。

一、连接数据库时未配置方言。

报错信息：

Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set
   at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:100)
   at org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:54)
   at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:137)
   at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
   at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:94)
   at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263)
   ... 56 more

解决方案：

在application.properties配置中加一条设置SQL方言的选项：

spring.jpa.database-platform=org.hibernate.dialect.MySQLDialect

如果mysql版本大于5 ，则设置

spring.jpa.database-platform=org.hibernate.dialect.MySQL5Dialect

问题解决。

二、无法找到对应实体。

报错信息：

No Identifier specified for entity

解决方案：

注解@Id的import错了，应该是

import javax.persistence.*;

三、服务器连不上

报错信息：

cannot connect to server ：检查服务器是否打开。

denied by server (user = xxxxx, password = YES): 密码错误。

denied by server: no such datebase named xxxxx: 数据库不对。

解决方案：

在application.properties 中更改设置即可。

四、 mysql 的时区问题：

报错信息：

The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
   at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85)
   at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132)
   at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241)
   at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265)
   at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319)
   at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:966)
   at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825)
   ... 72 more

解决方案：

打开Mysql，调整时区，只是为什么会报错。。。并不知道。

五、无法找到hibernate_sequence：

报错信息：

Table 'table_01.hibernate_sequence' doesn't exist
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
   at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
   at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
   at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1020)
   at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
   at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
   at org.hibernate.id.enhanced.TableStructure.executeQuery(TableStructure.java:216)
   at org.hibernate.id.enhanced.TableStructure.access$300(TableStructure.java:46)
   at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:138)
   at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:126)
   at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:55)
   at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
   at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:57)
   ... 74 more

解决办法：

把

@GeneratedValue(strategy = GenerationType.AUTO)换成

@GeneratedValue(strategy = GenerationType.IDENTITY)

即可。

六、无法找到构造函数：

报错信息：

org.hibernate.InstantiationException: No default constructor for entity: : com.example.jpa.User
   at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:85)
   at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:105)
   at org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:673)
   at org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:4946)
   at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1682)
   at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1666)
   at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1663)
   at org.hibernate.loader.Loader.getRow(Loader.java:1561)
   at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:731)
   at org.hibernate.loader.Loader.processResultSet(Loader.java:990)
   at org.hibernate.loader.Loader.doQuery(Loader.java:948)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)
   at org.hibernate.loader.Loader.doList(Loader.java:2689)
   at org.hibernate.loader.Loader.doList(Loader.java:2672)
   at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)
   at org.hibernate.loader.Loader.list(Loader.java:2501)
   at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
   at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)
   at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)
   at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508)
   at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537)
   at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505)
   at org.hibernate.query.Query.getResultList(Query.java:135)
   at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:74)
   at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:306)
   at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:73)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:359)
   at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:200)
   at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:644)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:608)
   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.lambda$invoke$3(RepositoryFactorySupport.java:595)
   at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:595)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
   at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:59)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
   at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
   ... 40 more