Oracle数据库连接出错——用户名密码非法
能获取到配置文件的内容,但是连接出错,错误信息如下:(用户名密码非法)
{user=jd2010, maxWait=30oo,maxActive=1o, password=jd2010,
url=jdbc:oracle:thin:@localhost:1521:xe,driver=oracle.jdbc.OracleDriver,
initialSize=5}
十月15,20207:24:31下午com.alibaba.druid.pool.DruidDataSource error
严重: init datasource error,url: jdbc:oracle:thin:@localhost:1521:xe
java.sql.SQLException: ORA-O1017: invalid username/password; logon
denied
at oracle.jdbc.driver.T4CTTloer.processError(T4CTTloer.java:45o)
at oracle.jdbc.driver.T4CTTloer.processError(T4CTTloer.java:392)
at oracle.jdbc.driver.T4CTTloer.processError(T4CTTloer.java:385)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:938)
连接数据库的文件如下:DBUtils.class
package com.briup.common;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
public class DBUtils {
private static Properties props = new Properties();
private static DataSource ds;
static {
try {
//以/开头放在src下,不以/开头,DBUtils放哪就放那
props.load(DBUtils.class.getResourceAsStream("/db.properties"));
System.out.println(props);
ds = DruidDataSourceFactory.createDataSource(props);
}catch (Exception e){
e.printStackTrace();
throw new RuntimeException(e);
}
}
//每有一个请求过来就获取—次连接
public static Connection getConnection() throws SQLException{
return ds.getConnection();
}
public static void main(String[] args)throws SQLException {
System.out.println(getConnection());
}
}
配置文件如下: db.properties
driver=oracle.jdbc.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:xe
user=jd2010
password=jd2010
initialSize=5
maxActive=10
maxWait=3000
打开数据库登录发现用户名和密码是正确的,经检查后发现是配置文件中
username只写了user,修改为username后连接数据库成功