JDBC programe working on windows but failing on linux 1

[mhburney]

Hi,

I cannot run any JDBC programe on my linux machine..the same programmes would run on windows but not on linux ( is extremely annoying as the error message is not that helping either...it just says this for all the programmes:

-----------------------------------------------
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException
MESSAGE: java.net.SocketException: Invalid argument or cannot assign requested address
------------------------------------------------

Desperately need help..
Cheers!

 

[Diancecht]

Maybe you need to change your driver to a Linux one ...

Cheers,
Dian

 

[mhburney]

I believe the JAR files are the same for all operating systems...??

I am using the zip version from this place

http://dev.mysql.com/downloads/connector/j/3.1.html

 

[Diancecht]

I think there are some kind of drivers that are OS-specific, but this seems not to be the case.

Looks like the problem is conectivity. Are you sure you have the necessaryu ports opened in your linux box to access the database?

Cheers,
Dian

 

[mhburney]

My MySQL server is also on a linux machine and it works fine..i have configured this remote host in MySQL to be able to connect remotely i.e using Grant.The MYSQL Client connects fine on the server..but if i use JDBC using the same remote client..i get that error...

 

[Diancecht]

Not a good thing.

I'd try downloading the lastest driver and cechking compatibility with you distribution.

Are you using fedora core?

Cheers,
Dian

 

[mhburney]

yes iam using Fedora core..why did you ask?

 

[Diancecht]

Maybe you can use this:
java -Djava.net.preferIPv4Stack=true YourApp

More info on:

http://www.jroller.com/page/dissonance/20050630#fedora_core_4_and_jdk

http://www.linuxquestions.org/questions/history/334291

Cheers,
Dian

 

[mhburney]

Brilliant this is just damn brilliant..the solution on first link worked

****Thanks mate!