使用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:\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)
關(guān)鍵的報(bào)錯(cuò)信息: Cannot create PoolableConnectionFactory (????????: ?????? "uav_test " ??????)
連接的參數(shù)如下:
#Postgresql
driver=org.postgresql.Driver
url=jdbc:postgresql://localhost:5432/uav_test
username=postgres
password=root
dialect=postgresql
當(dāng)我把postgresql數(shù)據(jù)庫改為使用mysql時(shí)就沒有問題,mysql時(shí)的參數(shù):
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mysql
username=root
password=root
dialect=mysql
不太明白為什么會(huì)出現(xiàn)此種情況
2 回答

喵喔喔
TA貢獻(xiàn)1735條經(jīng)驗(yàn) 獲得超5個(gè)贊
填坑來了;
搞了半天,原來是誤把uav_test這個(gè)連接名當(dāng)成了數(shù)據(jù)庫名,而且真實(shí)的報(bào)錯(cuò)信息是這樣的: 致命錯(cuò)誤: 數(shù)據(jù)庫 "uav_test" 不存在,可能是因?yàn)榫幋a格式問題,顯示不了中文,導(dǎo)致尋找錯(cuò)誤無從下手。菜鳥才會(huì)犯得錯(cuò)啊
添加回答
舉報(bào)
0/150
提交
取消