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
这里出什么问题了？
回答 3
Stack Overflow用户
发布于 2021-12-24 19:22:39
这个主要问题是在pom.xml中通过下面的配置显式地配置为使用Hibernate 5.1.0
<hibernate.version>5.1.0.Final</hibernate.version>这太旧了(6年前发布)和spring 2.6.1不再支持它很长时间了。
从技术上讲，spring 2.6是基于Spring5.3开发的，Spring5.3是在Hibernate 5.3+上开发和测试的，并且尝试在运行时尽可能地向后兼容Hibernate 5.2。您可以在HibernateJpaVendorAdapter的javadoc和这个问题上找到这样的信息。
它尝试在某个时候加载org.hibernate.jpa.HibernatePersistenceProvider，但是这个类只存在于Hibernate 5.2之后。由于您现在正在使用Hibernate 5.1，因此它抱怨不能用以下错误加载它：
org/hibernate/jpa/HibernatePersistenceProvider : org.springframework.orm.jpa.JpaVendorAdapter:工厂方法'jpaVendorAdapter‘抛出异常；嵌套异常为java.lang.NoClassDefFoundError: jpaVendorAdapter
因此，只需在<hibernate.version>中删除上面的pom.xml，这样它将使用spring 2.6.1定义的hibernate 5.6.1，然后您的问题就会得到解决。在一个新项目中使用一个非常古老的Hibernate版本是没有意义的。
Stack Overflow用户
发布于 2021-12-22 05:38:48
我试着在我的本地机器上复制这个，这里是解决方案。
您必须通过扩展org.hibernate.dialect来创建自己的扩展
package com.mehul.SQLiteDemo.dialect;
import java.sql.Types;
import org.hibernate.dialect.Dialect;
import org.hibernate.dialect.function.SQLFunctionTemplate;
import org.hibernate.dialect.function.StandardSQLFunction;
import org.hibernate.dialect.function.VarArgsSQLFunction;
import org.hibernate.type.StringType;
public class SQLDialect extends Dialect {
public SQLDialect() {
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");
registerColumnType(Types.LONGVARCHAR, "longvarchar");
registerColumnType(Types.DATE, "date");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.BINARY, "blob");
registerColumnType(Types.VARBINARY, "blob");
registerColumnType(Types.LONGVARBINARY, "blob");
// registerColumnType(Types.NULL, "null");
registerColumnType(Types.BLOB, "blob");
registerColumnType(Types.CLOB, "clob");
registerColumnType(Types.BOOLEAN, "integer");
registerFunction("concat", new VarArgsSQLFunction(StringType.INSTANCE, "", "||", ""));
registerFunction("mod", new SQLFunctionTemplate(StringType.INSTANCE, "?1 % ?2"));
registerFunction("substr", new StandardSQLFunction("substr", StringType.INSTANCE));
registerFunction("substring", new StandardSQLFunction("substr", StringType.INSTANCE));
}
public boolean supportsIdentityColumns() {
return true;
}
public boolean hasDataTypeInIdentityColumn() {
return false; // As specify in NHibernate dialect
}
public String getIdentityColumnString() {
// return "integer primary key autoincrement";
return "integer";
}
public String getIdentitySelectString() {
return "select last_insert_rowid()";
}
public boolean supportsLimit() {
return true;
}
protected String getLimitString(String query, boolean hasOffset) {
return new StringBuffer(query.length() + 20).append(query).append(hasOffset ? " limit ? offset ?" : " limit ?")
.toString();
}
public boolean supportsTemporaryTables() {
return true;
}
public String getCreateTemporaryTableString() {
return "create temporary table if not exists";
}
public boolean dropTemporaryTableAfterUse() {
return false;
}
public boolean supportsCurrentTimestampSelection() {
return true;
}
public boolean isCurrentTimestampSelectStringCallable() {
return false;
}
public String getCurrentTimestampSelectString() {
return "select current_timestamp";
}
public boolean supportsUnionAll() {
return true;
}
public boolean hasAlterTable() {
return false; // As specify in NHibernate dialect
}
public boolean dropConstraints() {
return false;
}
public String getAddColumnString() {
return "add column";
}
public String getForUpdateString() {
return "";
}
public boolean supportsOuterJoinForUpdate() {
return false;
}
public String getDropForeignKeyString() {
throw new UnsupportedOperationException("No drop foreign key syntax supported by SQLiteDialect");
}
public String getAddForeignKeyConstraintString(String constraintName, String[] foreignKey, String referencedTable,
String[] primaryKey, boolean referencesPrimaryKey) {
throw new UnsupportedOperationException("No add foreign key syntax supported by SQLiteDialect");
}
public String getAddPrimaryKeyConstraintString(String constraintName) {
throw new UnsupportedOperationException("No add primary key syntax supported by SQLiteDialect");
}
public boolean supportsIfExistsBeforeTableName() {
return true;
}
public boolean supportsCascadeDelete() {
return false;
}
}还可以用包和类名更新spring.jpa.database-platform=com.mehul.SQLiteDemo.dialect.SQLDialect。
注意事项：我使用了<hibernate.version>5.6.3.Final</hibernate.version>
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
复制相似问题
腾讯云开发者
