JDBC 连接oracle 11问题，急急急！！

Question

我用JDBC连接JDBC 连接oracle 11时报以下错误！！！
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at org.eclipse.datatools.enablement.postgresql.profile.PostgreSQLJDBCConnection.createConnection(PostgreSQLJDBCConnection.java:87)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)
at org.eclipse.datatools.enablement.postgresql.profile.PostgreSQLJDBCConnection.<init>(PostgreSQLJDBCConnection.java:47)
at org.eclipse.datatools.enablement.postgresql.profile.PostgreSQLConnectionFactory.createConnection(PostgreSQLConnectionFactory.java:51)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:77)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:354)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:57)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 13 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at java.net.Socket.<init>(Socket.java:366)
at java.net.Socket.<init>(Socket.java:180)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127)
at oracle.net.nt.ConnOption.connect(ConnOption.java:126)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)
... 18 more

Answer 1

SQL语句应该没有错
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@localhost:1521:mldn 
scott
tiger

Answer 2

看看连接数据库的jar包是否正确，在看看数据库是否能连接上。

Answer 3

我的Jar包用ojdbc6.jar唔知对不对，
我JDK系1.6的

Answer 4

Java操作oracle
JDBC-ODBC: windows内配置odbc数据源，本机适用
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:???","scott","scott"); Statement s=con.createStatement();
ResultSet rs=s.executeQuery("select * from emp");
while ( rs.next() ) {
System.out.println("用户名："+ rs.getString(2));
}
JDBC: [oracle]/product/10.1.0/Db_1/jdbc/lib/classes12.jar
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:DBexample","scott","scott"); Statement s=con.createStatement();
ResultSet rs=s.executeQuery("select * from emp");
while ( rs.next() ) {
System.out.println("用户名："+ rs.getString(2));
}

Answer 5

SQL语句应该没有错
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@localhost:1521:mldn  
scott
tiger

Answer 6

你通过PLSQL能不能连接上去  应该是oracle的监听没有打开

Answer 7

可以用myeclipse的db尝试去连接，不是程序问题，是数据库设置问题

Answer 8

ojdbc6.jar-->这是什么JAR包?
Oracle不是应该用Classes12,或Classes14.建议你把相关的源代码贴上来看看.

Answer 9

关键在这:
java.sql.SQLException: The Network Adapter could not establish the connection
你在dos下看看能不能进oracle
建议重启下你的服务。

Answer 10

java.sql.SQLException: The Network Adapter could not establish the connection
这个好像就是服务没有启动全