Question

jdbc-odbc连接数据库

//1.加载驱动 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //2.得到链接,如果要填必须要配置数据源 Connection ct = DriverManager.getConnection("jdbc:odbc:testsp","system","1111");
核心代码就这两行
可是发生如下错误：
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-28547: 连接服务器失败, 可能是 Oracle Net 管理错误 at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
所有的服务也都启动了

Answer 1

看看oracle的网络配置文件是否正确，

D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)