• 使用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

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