java - jdbc無法連接postgresql資料庫

Question

• 使用jdbc連接postgresql資料庫報錯誤如下：

#

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:\Uav\NewMavenDemo\target\classes\mapper\UserMapper.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)

• 關鍵的報錯訊息： Cannot create PoolableConnectionFactory (????????: ?????? "uav_test " ??????)

• 連接的參數如下：

#

#Postgresql  
driver=org.postgresql.Driver
url=jdbc:postgresql://localhost:5432/uav_test 
username=postgres
password=root
dialect=postgresql

• 當我把postgresql資料庫改為使用mysql時就沒有問題，mysql時的參數：

#

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mysql
username=root
password=root
dialect=mysql 

• 不太明白為什麼會出現此種情況

Answer 1

• 填坑來了;
  搞了半天，原來是誤把uav_test這個連接名當成了數據庫名，而且真實的報錯信息是這樣的： 致命錯誤: 數據庫"uav_test" 不存在，可能是因為編碼格式問題，顯示不了中文，導致尋找錯誤無從下手。

• 菜鳥才會犯錯

Answer 2

應該是sql語句寫錯了吧，