ansaurus

Question

Connection with a remote database using java swing application

Answer 1

+1 A:

using simple JDBC you can connect to remote oracle DB.

org.life.java 2010-10-05 10:09:20

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

Aman 2010-10-05 10:21:52

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

Aman 2010-10-05 10:22:19

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

org.life.java 2010-10-05 10:23:54

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 2010-10-05 11:11:33

@Aman check firewall, port blocker, antivirus settings i would say..

org.life.java 2010-10-05 11:14:20

with local database this it code is absoultely working fine..

Aman 2010-10-05 11:14:56

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

Aman 2010-10-05 11:22:40

@Aman there must be some conf. issue, try connecting that Server using another client like Sqldeveloper

org.life.java 2010-10-05 11:23:22

Answer 2

+1 A:

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.

Thorbjørn Ravn Andersen 2010-10-05 10:35:38

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

Aman 2010-10-05 10:59:43

Please edit your question to include networking details.

Thorbjørn Ravn Andersen 2010-10-05 11:31:23

Answer 3

A:

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.

virgium03 2010-10-05 12:01:05

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

Aman 2010-10-06 09:34:47

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 2010-10-07 07:06:43

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

virgium03 2010-10-07 07:12:44

ansaurus

tags:

views:

answers:

Connection with a remote database using java swing application

related questions