作者:mmmmGi_626 | 来源:互联网 | 2022-12-06 17:23
如何解决《SpringBoot错误:未找到driverClassName=oracle.jdbc.driver.OracleDriver的已注册驱动程序,尝试直接实例化》经验,为你挑选了2个好方法。
我正在学习SpringBoot,我只是尝试运行我曾经成功运行的项目,但现在弹出这个错误
enter cod2018-08-25 11:30:21 WARN c.z.hikari.util.DriverDataSource - Registered driver with driverClassName=oracle.jdbc.driver.OracleDriver was not found, trying direct instantiation.
2018-08-25 11:30:24 ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connectione here
在这几个异常被抛出之后......
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) ~[na:1.8.0_144]
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673) ~[ojdbc7-12.1.0.2.jar:12.1.0.1.0]
application.properties:
#server
server.port=7003
#database
spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:Xe
spring.datasource.username=XXXXXX
spring.datasource.password=XXXXXX
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.temp.use_jdbc_metadata_defaults=false
#logging
logging.pattern.cOnsole=%d{yyyy-MM-dd HH:mm:ss} %-5level %logger{36} - %msg%n
logging.level.org.hibernate.SQL=INFO
logging.level.org.hibernate.type.descriptor.sql=trace
logging.level.=INFO
#eureka-guidelines
eureka.client.register-with-eureka=true
eureka.client.serviceUrl.defaultZOne=http://localhost:7005/eureka
spring.application.name=SupplyManagement_14_SpringBoot
的pom.xml
4.0.0
com.myapp.supplyManagement
SupplyManagement_14_SpringBoot
0.0.1-SNAPSHOT
jar
SupplyManagement_14_SpringBoot
Demo project for Spring Boot
org.springframework.boot
spring-boot-starter-parent
2.0.4.RELEASE
UTF-8
UTF-8
1.8
Finchley.SR1
org.springframework.boot
spring-boot-starter-data-jpa
org.springframework.boot
spring-boot-starter-jdbc
org.springframework.boot
spring-boot-starter-web
org.springframework.cloud
spring-cloud-starter-netflix-eureka-client
org.springframework.boot
spring-boot-starter-test
test
com.oracle
ojdbc7
12.1.0.2
org.springframework.cloud
spring-cloud-dependencies
${spring-cloud.version}
pom
import
org.springframework.boot
spring-boot-maven-plugin
我尝试了一些调试,比如1.手动检查oracle.jdbc.driver.OracleDriver是否存在.2.使用其他ojdbc之类的6. 3. maven更新.
但似乎没有任何效果.任何帮助表示赞赏.
UPDATE
我不知道为什么,但我重新启动了我的系统,现在它工作正常.
1> Kirill..:
关于问题标题的警告信息:
未找到driverClassName = oracle.jdbc.driver.OracleDriver的已注册驱动程序,尝试直接实例化
那是因为您使用了错误的值: spring.datasource.driver-class-name
用oracle.jdbc.OracleDriver
而不是oracle.jdbc.driver.OracleDriver
请参阅此处的详细答案:https://stackoverflow.com/a/6202721/3581539
2> 小智..:
您必须使用oracle.jdbc.OracleDriver
而不是oracle.jdbc.driver.OracleDriver
在POM文件中