Connection with a remote database using java swing application

Question

I am working with a swing application and the initial part of the application is "user authentication" ..for that module i want to authenticate(verify) the user but the problem is that my database is remotly located with different port(not 1521). everytime i try to connect through some easy and simple jdbc,a well designed exception occures to decorate my console something like this

"SEVERE: null java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)"

The Programmers who have worked with swings specially when they made a tool for some webservices might have fallen into the same category..please give it a look and thought.

Jigar Joshi · Accepted Answer · 2010-10-05 10:09:20Z

1

using simple JDBC you can connect to remote oracle DB.

answered Oct 5, 2010 at 10:09

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Aman Over a year ago

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Aman Over a year ago

i tried to do that but "java.sql.SQLException: Io exception: The Network Adapter could not establish the connection" is there every time

Jigar Joshi Over a year ago

@Aman , can you ping your remote Oracle DB Server ? can you please update your question with stacktrace , your code

Aman Over a year ago

i am able to ping remote oracle db server. the code is like that :String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber + ":" + sid; String username = "AMNHU"; String password = "bmtmkc"; try { connection = DriverManager.getConnection(url, username, password); System.out.println("Connected*****************************"); } catch (SQLException ex) { Logger.getLogger(Test.class.getName()).log(Level.SEVERE, null, ex); } i think there is a problem of port

Aman Over a year ago

Please share some more ideas..i've got stuck ther only.trying to find the best but everytime its ZERO..

|

Thorbjørn Ravn Andersen · Accepted Answer · 2010-10-05 10:44:37Z

1

LDAP is essentially a big Map allowing you to look things up. You don't use that to talk to an Oracle database, but a JDBC-driver.

You will need one that corresponds to your Oracle database, and you have two options:

thin: This one is in pure Java and you need to use the IP-number or DNS-name of the database server.
thick: This one calls the same libraries as SQLPLUS so you can use the same database names as you can in SQLPLUS.

Also note that the Swing application needs to be able to actually reach the database across the network for this to work. Usually Oracle runs on port 1521. This frequently means firewall rules for any non-trivial setup.

edited Oct 5, 2010 at 10:44

answered Oct 5, 2010 at 10:35

Thorbjørn Ravn Andersen

75.4k35 gold badges203 silver badges359 bronze badges

1 Comment

Aman Over a year ago

Very Appreciative suggestion. Thnx !! is there any remedy for that.like proxy setting etc..

virgium03 · Accepted Answer · 2010-10-05 12:01:05Z

0

This is clearly a network problem, meaning that you cannot access the database through the network or maybe the provided url is invalid. Also, make sure that you use something like this:

String driverName = "oracle.jdbc.driver.OracleDriver"; 
Class.forName(driverName);
connection = DriverManager.getConnection(url, username, password);

The Light Directory Access Protocol is used for authenticating users into the application, not for connecting to the database.

answered Oct 5, 2010 at 12:01

virgium03

6371 gold badge6 silver badges14 bronze badges

3 Comments

Aman Over a year ago

I dont know much about LDAP but want to know about it,i went through many tutorials and finally seted my mind up with respect to LDAP...Please share some code where i can authenticate my user with ldap using a swing application. Thnaks in advance

virgium03 Over a year ago

I don't have code using LDAP but I can suggest you a framework that will ease your pain using LDAP. It is called Apache Shiro. Maybe you can take a look and see if it helps. Cheers

virgium03 Over a year ago

Also, you can try Apache Directory Studio which is a LDAP browser and directory client.

WarFox · Accepted Answer · 2011-02-01 13:29:56Z

0

I am also having this same problem. When connecting from Swing application framework alone, this error is coming. I am able to connect to the database from PLSQL Developer. I am also able to connect to db using another java desktop application, which is not based on "SwingAppliation Framework". I am trying to connect to database from Task classes, and it fails. In The other application which works, I am using normal java class. In both the application I am using Hibernate.

answered Feb 1, 2011 at 13:29

WarFox

4,9913 gold badges30 silver badges34 bronze badges

1 Comment

WarFox Over a year ago

My issue got resolved, after by-passing proxy server for the db servers. The other applications doesnot use proxy server so they were working. But when using Swing Application Framework, it was sending requests to proxy server and it was blocking communication.

Collectives™ on Stack Overflow

Connection with a remote database using java swing application

4 Answers 4

6 Comments

1 Comment

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

1 Comment

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related