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语句写错了吧，