問題描述

使用jdbc連接postgresql數(shù)據(jù)庫時(shí)報(bào)錯(cuò)如下：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (????????: ?????? 'uav_test ' ??????)### The error may exist in file [G:UavNewMavenDemotargetclassesmapperUserMapper.xml]### The error may involve UserMapper.getUserInfo### The error occurred while executing a query### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (????????: ?????? 'uav_test ' ??????) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:79) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447) at com.sun.proxy.$Proxy27.selectList(Unknown Source)

關(guān)鍵的報(bào)錯(cuò)信息： Cannot create PoolableConnectionFactory (????????: ?????? 'uav_test ' ??????)

連接的參數(shù)如下：

#Postgresql driver=org.postgresql.Driverurl=jdbc:postgresql://localhost:5432/uav_test username=postgrespassword=rootdialect=postgresql

當(dāng)我把postgresql數(shù)據(jù)庫改為使用mysql時(shí)就沒有問題，mysql時(shí)的參數(shù)：

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/mysqlusername=rootpassword=rootdialect=mysql

不太明白為什么會(huì)出現(xiàn)此種情況

問題解答

填坑來了;搞了半天，原來是誤把uav_test這個(gè)連接名當(dāng)成了數(shù)據(jù)庫名，而且真實(shí)的報(bào)錯(cuò)信息是這樣的： 致命錯(cuò)誤: 數(shù)據(jù)庫 'uav_test' 不存在，可能是因?yàn)榫幋a格式問題，顯示不了中文，導(dǎo)致尋找錯(cuò)誤無從下手。

菜鳥才會(huì)犯得錯(cuò)啊

應(yīng)該是sql語句寫錯(cuò)了吧，