springboot 连接达梦数据库,配置双数据源

springboot数据源配置

在resources下建立lib目录,将达梦驱动放进去

pom引用

<dependency>
    <groupId>com.dm</groupId>
    <artifactId>DmJdbcDriver</artifactId>
    <version>1.8</version>
    <scope>system</scope>
    <systemPath>${project.basedir}/src/main/resources/lib/DmJdbcDriver18.jar</systemPath>
</dependency>

plugin配置(将达梦驱动打包)

<plugin>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-maven-plugin</artifactId>
    <configuration>
        <includeSystemScope>true</includeSystemScope>
    </configuration>
</plugin>

在这里插入图片描述
不带模式访问参考
https://blog.csdn.net/frankcheng5143/article/details/108219862

双数据源配置参考
https://blog.csdn.net/LOYE_YOU/article/details/90722045

已标记关键词 清除标记
本人使用的是springboot的框架 配置用的jdbc连接数据库7.0版本的, 程序运行成功,但是访问数据的时候就会报错,无法创建池的初始连接,请各位大神看看是哪的问题! ![图片说明](https://img-ask.csdn.net/upload/201910/25/1571983949_26343.jpg)![图片说明](https://img-ask.csdn.net/upload/201910/25/1571983957_258419.jpg)![图片说明](https://img-ask.csdn.net/upload/201910/25/1571983963_912962.jpg) 这是的pom 配置文件 ``` <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.lm.spring-boot</groupId> <artifactId>spring-boot</artifactId> <version>0.0.1-SNAPSHOT</version> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.3.0.RELEASE</version> </parent> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!--视图采用freemarker渲染 --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-freemarker</artifactId> </dependency> <!-- JDBC --> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> </dependencies> <build> <plugins> <plugin> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>1.6</source> <target>1.6</target> </configuration> </plugin> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> <executions> <execution> <goals> <goal>repackage</goal> </goals> </execution> </executions> <dependencies> <dependency> <groupId>org.springframework</groupId> <artifactId>springloaded</artifactId> <version>1.2.5.RELEASE</version> </dependency> </dependencies> </plugin> </plugins> <!-- 指定最终生成jar包的文件名--> <finalName>spring-boot</finalName> </build> </project> 这个是我获取数据用的jdbc访问数据库的方式 ``` @Resource private JdbcTemplate jdbcTemplate; @RequestMapping("/user") public String getUserList(ModelMap map) { String sql = "select * from \"USER\".\"users\""; List<User> userList = jdbcTemplate.query(sql, new RowMapper<User>() { User user = null; public User mapRow(ResultSet rs, int rowNum) throws SQLException { user = new User(); user.setId(rs.getString("id")); user.setName(rs.getString("name")); user.setSex(rs.getString("sex")); user.setAge(rs.getString("age")); return user; } }); for (User user : userList) { System.out.println(user.getName()); } map.addAttribute("users", userList); return "user"; } ``` ```
©️2020 CSDN 皮肤主题: 酷酷鲨 设计师:CSDN官方博客 返回首页