• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error trying to connect with the program in java with oracle database

 
Albert Albertm
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have oracle linux 6.5, Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

I wrote a test program in NetBeans to connect to the oracle database
during the start of the program I get the error below

why?

SQL * Plus connects to the data without any problem also
Oracle SQL Developer connects to the data without a problem

library project poloczzora added ojdbc6.jar


program:


package poloczzora;

import java.sql.*;

public class Poloczzora {

/**
* @param args the command line arguments
*/
public static void main(String[] args) throws Exception {


try {

Class.forName("oracle.jdbc.OracleDriver");
} catch (java.lang.ClassNotFoundException e) {
System.err.print("Error: ClassNotFoundException");
}

Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@//localhost:1521/orcl", "scott", "tiger");
}

}






Exception in thread "main" java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
calConnection.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:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at poloczzora.Poloczzora.main(Poloczzora.java:41)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:359)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:672)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:353)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 7 more
Caused by: java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:141)
at oracle.net.nt.ConnOption.connect(ConnOption.java:123)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:337)
... 12 more
Java Result: 1
BUILD SUCCESSFUL (total time: 14 seconds)

 
K. Tsang
Bartender
Posts: 3585
16
Android Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I believe the user "scott" is disabled by default. Try enabling the account and try again. Or create your user for the database you are working with and use that.
 
Albert Albertm
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
scott
the user is active

I log on to his account from sql plus and SQL Developer
 
Paul Clapham
Sheriff
Posts: 21583
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Connection refused" most likely means "There's no server listening on that port". So... you don't have anything running on your computer (localhost) listening at port 1521, right?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic