2025年记一次 oracle not support oracle driver 4.0

记一次 oracle not support oracle driver 4.0原来的配置文件 spring datasource driver class name com alibaba druid proxy DruidDriver spring datasource url jdbc oracle thin 127 0 0 1 1521 orcl spring datasource username erose

大家好,我是讯享网,很高兴认识大家。

原来的配置文件

spring.datasource.driver-class-name=com.alibaba.druid.proxy.DruidDriver spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl spring.datasource.username=erose spring.datasource.password=EROSE spring.datasource.type=com.alibaba.druid.pool.DruidDataSource mybatis-plus.mapper-locations=classpath:mapper/*_mapper.xml 

讯享网

后来的配置文件


讯享网

讯享网spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl spring.datasource.username=erose spring.datasource.password=EROSE spring.datasource.type=com.alibaba.druid.pool.DruidDataSource mybatis-plus.mapper-locations=classpath:mapper/*_mapper.xml 

DruidDriver替换为oracleDriver后问题得到了解决。
具体原因尚未可知,如有大佬答复,不胜感激。
另附上Oracle配置文件

package com.positioningsystem.configuration; import com.alibaba.druid.pool.DruidDataSource; import org.apache.ibatis.session.SqlSessionFactory; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.annotation.MapperScan; import org.mybatis.spring.mapper.MapperScannerConfigurer; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.beans.factory.annotation.Value; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.context.annotation.Primary; import org.springframework.context.support.PropertySourcesPlaceholderConfigurer; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import javax.sql.DataSource; import java.sql.SQLException; @Configuration public class DBConfiguration { 
    @Value("${spring.datasource.url}") private String url; @Value("${spring.datasource.username}") private String username; @Value("${spring.datasource.password}") private String passowrd; @Value("${spring.datasource.driver-class-name}") private String drivername; private static final String mapperlocations = "classpath:mapper/*.xml"; private static final String pageScanse = "com.positioningsystem.dao"; @Primary @Bean(name = "mainDatabase") @ConfigurationProperties(prefix = "spring.datasource") public DataSource druid(){ 
    DruidDataSource druidDataSource = new DruidDataSource(); druidDataSource.setInitialSize(30); druidDataSource.setMaxActive(200); druidDataSource.setMinIdle(50); druidDataSource.setMaxWait(); try { 
    druidDataSource.setFilters("stat,wall"); }catch (SQLException e){ 
    e.printStackTrace(); } return druidDataSource; } @Bean(name = "mainSqlSessionFactory") @Primary public SqlSessionFactory getSqlSessionFactory(@Qualifier("mainDatabase") DataSource dataSource) throws Exception{ 
    SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); sqlSessionFactoryBean.setDataSource(dataSource); sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperlocations)); sqlSessionFactoryBean.setTypeAliasesPackage(pageScanse); return sqlSessionFactoryBean.getObject(); } } 
小讯
上一篇 2025-04-02 10:39
下一篇 2025-01-07 10:19

相关推荐

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容,请联系我们,一经查实,本站将立刻删除。
如需转载请保留出处:https://51itzy.com/kjqy/117337.html