Question

JDBC链接Oracle出错 跪求高手指点

源码：
private final String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
private final String DB_URL ="jdbc:oracle:thin:@127.0.0.1:1521:orcl";

private final String DB_USER="test";
private final String DB_PAS="111111";

private Connection conn;
private Statement stat;

public DBUtils() throws SQLException, ClassNotFoundException
{
Class.forName(DB_DRIVER);
this.conn = DriverManager.getConnection(DB_URL,DB_USER,DB_PAS);
this.stat = this.conn.createStatement();
}

用官网提供的OJDBC6链接数据库出错，换用ojdbc14.jar不改代码就可以正常访问，但会影响其他程序的使用，jdk是1.6.43，以下是ojdbc6运行时报的错误：

Exception in thread "main" java.sql.SQLException: Undefined Error
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
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 cn.sjl.oracle.conn.DBUtils.<init>(DBUtils.java:29)
at cn.sjl.database.test.TestConnectOracle.main(TestConnectOracle.java:12)
Caused by: oracle.net.ns.NetException: Undefined Error
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 8 more

Answer 1

driver用这个：

oracle.jdbc.OracleDriver

private final String DB_DRIVER = "oracle.jdbc.OracleDriver";
private final String DB_URL ="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
private final String DB_USER="test";
private final String DB_PAS="111111";
private Connection conn;
private Statement stat;
public DBUtils() throws SQLException, ClassNotFoundException
{
    Class.forName(DB_DRIVER);
    this.conn = DriverManager.getConnection(DB_URL,DB_USER,DB_PAS);
    this.stat = this.conn.createStatement();
}

Answer 2

你的监听服务listener开了吗?

Answer 3

报错的是sql异常，你SQL怎么写的？