jdbc 连接 mysql，oracle都异常，win10系统

[Lewis_刘]

连接oracle异常：
java.sql.SQLException: 内部 - 不期望的值
at oracle.jdbc.driver.T4CTTIoauthenticate.processRPA(T4CTTIoauthenticate.java:516)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:295)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:390)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:356)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.ylink.test01.jdbc.OracleJdbc.getConnection(OracleJdbc.java:15)
at com.ylink.test01.jdbc.OracleJdbc.main(OracleJdbc.java:28)
连接mysql：
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:875)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1712)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1228)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:20
搞了好久了，不知道怎么解决，跪求大神

[达人游戏男孩]

oracle 不知道，mysql是用户名和密码错误

[鱿鱼ing]

可以贴一下你的连接数据库的配置看看

[shaguaxueye]

反正mysql 用户名和密码不对。。。。。。。。。

[qq_15654157]

你看看 你的 mysql 的 mysql数据库的user表


看看有没有 localhost root 。

localhost行的root 表示可以用localhost地址连接数据库（只限本机连接）
% 行的root 表示可以用 IP地址 远程连接，比如mysql安装在 192.168.1.100那台服务上，你的ＩＰ为192.168.1.101
你的连接就可以用 192.168.1.100去连接， 没有 % 的root 就 不能用 ip地址连接

如果有 ，你确定你的密码 正确？？

[Lewis_刘]

String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String user="test";
String password="test";
try {
Class.forName("oracle.jdbc.OracleDriver");
conn=DriverManager.getConnection(url,user,password);
}
另外，用命令行都可以mysql和oracle，怀疑是驱动的问题，但是oracle驱动的版本都是用的最合适的版本，mysql驱动用的5.1.39

[Lewis_刘]

String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl"; String user="test"; String password="test"; try { Class.forName("oracle.jdbc.OracleDriver"); conn=DriverManager.getConnection(url,user,password); } Connection conn=null; String url = "jdbc:mysql://localhost:3306/test?" + "user=root&password=root&useUnicode=true&characterEncoding=UTF8&useSSL=false"; // String user="root"; // String password="root"; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(url);

[Lewis_刘]

换了个oracle驱动 java.sql.SQLException: IO 错误: Connection refused at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at com.ylink.test01.jdbc.OracleJdbc.getConnection(OracleJdbc.java:15) at com.ylink.test01.jdbc.OracleJdbc.main(OracleJdbc.java:28) Caused by: oracle.net.ns.NetException: Connection refused at oracle.net.ns.NSProtocol.connect(NSProtocol.java:399) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)

[谁主沉浮oo7]

引用 6 楼 l475128303 的回复:

String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl"; String user="test"; String password="test"; try { Class.forName("oracle.jdbc.OracleDriver"); conn=DriverManager.getConnection(url,user,password); } Connection conn=null; String url = "jdbc:mysql://localhost:3306/test?" + "user=root&password=root&useUnicode=true&characterEncoding=UTF8&useSSL=false"; // String user="root"; // String password="root"; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(url);

你连的是orcle数据库，但是加载的驱动却是mysql的 而且mysql和orcle加载驱动的方式不一样，需要加载的包更是不一样，不是简单的改名字