Spring引导应用程序找不到SQLite jdbc驱动程序类
在我的Spring应用程序中，指定了sqlite驱动程序的依赖项：
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.34.0</version>
</dependency>在pom.xml属性中
<hibernate.version>5.1.0.Final</hibernate.version>在我的application.properties中有以下内容：
spring.jpa.database-platform=com.springboot.sqlite.SQLDialect
spring.jpa.hibernate.ddl-auto=update
spring.jpa.defer-datasource-initialization = true
spring.datasource.url = jdbc:sqlite:cryptobot.db
spring.datasource.driver-class-name = org.sqlite.JDBC我提供的SQLDialect类是从这篇文章复制的。但是，运行应用程序将失败。
org.springframework.beans.factory.UnsatisfiedDependencyException:错误创建类路径资源中定义的名为“entityManagerFactory”的bean，org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class:不满意的依赖项通过方法'entityManagerFactory‘参数0表示，嵌套异常是创建类路径资源中定义的名为'entityManagerFactoryBuilder’的org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class:不满意依赖项的org.springframework.beans.factory.UnsatisfiedDependencyException:错误；嵌套异常是org.springframework.beans.factory.BeanCreationException:错误创建名为“jpaVendorAdapter”的类路径资源org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaConfiguration.class: bean通过工厂方法实例化失败；嵌套异常是org.springframework.beans.BeanInstantiationException:无法实例化org.springframework.orm.jpa.JpaVendorAdapter:工厂方法jpaVendorAdapter抛出的异常；嵌套的例外是: org/hibernate/jpa/HibernatePersistenceProvider at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) ~org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800)-beans-5.3.13.jar:5.3.13在org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) ~spring 5.3.13.jar:5.3.13在org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~spring 5.3org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~spring 5.3.13.jar:5.3.13 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) -beans-5.3.13.jar:5.3.13 org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~spring-beans-5.3.13.jar:5org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~spring 5.3.13.jar:5.3.13 org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) -beans-5.3.13.jar:5.3.13 org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) -beans-5.3.13.jar:5.3.13.jar:5.3.13.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~spring 5.3.13.jar:5.3.13在org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~spring-上下文-5.3.13.jar:5.3.13在org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908) ~spring-上下文-5.3.13.jar:5.3.13在org.springframework.context.support.AbstractApplicationContext.refresh( org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730) ~AbstractApplicationContext.java:583)~spring-上下文-5.3.13.jar:5.3.13在org.springframework.boot.SpringApplication.run(SpringApplication.java:302) ~spring-boot-2.6.1.jar:2.6.1在org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:412) ~spring-2.6.1.jar:2.6.1在org.springframework.boot.SpringApplication.run(SpringApplication.java:302)~spring-2.6.1.jar:2.6.1在org.springframework.boot.SpringApplication.run(SpringApplication.java:1301) ~spring 2.6.1.jar:2.6.1在org.springframework.boot.SpringApplication.run(SpringApplication.java:1290) ~spring-启动-2.6.1.jar:2.6.1在com.binance.bot.BinancebotApplication.main(BinancebotApplication.java:10) ~classes/:na
这里出什么问题了？
Stack Overflow用户
发布于 2021-12-22 10:19:45
由于Hibernate不附带SQLite的方言，所以您可以遵循以下路径：
1.通过扩展方言创建自己的方言类。
import java.sql.Types;
import org.hibernate.dialect.Dialect;
public class SQLiteDialect extends Dialect {
public SQLiteDialect() {
super();
registerColumnType(Types.BIT, "integer");
registerColumnType(Types.TINYINT, "tinyint");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.INTEGER, "integer");
registerColumnType(Types.BIGINT, "bigint");
registerColumnType(Types.FLOAT, "float");
registerColumnType(Types.REAL, "real");
registerColumnType(Types.DOUBLE, "double");
registerColumnType(Types.NUMERIC, "numeric");
registerColumnType(Types.DECIMAL, "decimal");
registerColumnType(Types.CHAR, "char");
registerColumnType(Types.VARCHAR, "varchar");
.
.
.
}
}完整示例的点击。
2.你可以使用第三方方言。
对于Hibernate 5，添加依赖性
<dependency>
<groupId>com.github.gwenn</groupId>
<artifactId>sqlite-dialect</artifactId>
<version>0.1.2</version>
</dependency>以及配置：
hibernate.dialect=org.sqlite.hibernate.dialect.SQLiteDialecthttps://stackoverflow.com/questions/70404755
复制相似问题
腾讯云开发者
