我的TNS是这样配置的:
DMPR1A =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.45.67.89)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DMPR1A)
)
)
那么我在写代码的时候
String url = "jdbc:oracle:[email protected]:1521:??"
DriverManager.getConnection(url, "user", "user")问号的地方到底应该写什么啊?或者哪位老大给出url = "?";
万分感谢!
DMPR1A =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.45.67.89)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DMPR1A)
)
)
那么我在写代码的时候
String url = "jdbc:oracle:[email protected]:1521:??"
DriverManager.getConnection(url, "user", "user")问号的地方到底应该写什么啊?或者哪位老大给出url = "?";
万分感谢!
java.sql.SQLException: 指定了无效的 Oracle URL
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:203)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at dao.OutMinusInDAO.<init>(OutMinusInDAO.java:37)
at test.Test.main(Test.java:12)
Exception in thread "main" java.lang.NullPointerException
at dao.OutMinusInDAO.selectresule(OutMinusInDAO.java:57)
at test.Test.main(Test.java:13)
// oracle数据库驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:[email protected]:1521:DMPR1A";
con = DriverManager.getConnection(url,"user", "pwd"); } catch (Exception e) {
e.printStackTrace();
}