JDBC communication link FAILURE

Status
Niet open voor verdere reacties.
S

shershah

Gebruiker
Lid geworden
5 mrt 2013
Berichten
29
Hallo,

ik heb de laatste tijd problemen met deze fout 'jdbc communication link failure' ik heb alles correct ingevuld in de files, correcte jdbc link firewall disabled, en poort naar 3306 staat open. En ik heb Xampp, en remote mysql. Maar het werkt nog steeds niet, kan iemand dit na kijken en een oplossing kunnen geven?

Iemand die hier iets fouts ziet?
198.252.105.22 = niet mijn ip adress (via commandpromt met ping van een site)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
launcher.java:

public static MainLoader vote = new MainLoader("syclonepk.no-ip.org", "syclonep_mib", "*******", "syclonep_mib");

VoteManager.java

Class.forName("com.mysql.jdbc.Driver").newInstance ();
String IP="syclonepk.no-ip.org";
String DB="syclonep_mib";
String User="syclonep_mib";
String Pass="*******";
con = DriverManager.getConnection("jdbc:mysql://198.252.105.22:3306/syclonep_mib", "syclonep_mib", "*******");

Connect.java

Class.forName("com.mysql.jdbc.Driver").newInstance ();
String IP="syclonepk.no-ip.org";
String DB="syclonep_mib";
String User="syclonep_mib";
String Pass="*********";
conn = DriverManager.getConnection("jdbc:mysql://198.252.105.22:3306/syclonep_mib", "syclonep_mib", "*********");

String IP="syclonepk.no-ip.org";
String DB="syclonep_mib";
String User="syclonep_mib";
String Pass="*********";
return conn = DriverManager.getConnection("jdbc:mysql://198.252.105.22:3306/syclonep_mib", "syclonep_mib", "*********");

MainLoader.java

host = "syclonepk.com";
pass = "********";
user = "syclonep_mib";
db = "syclonep_mib";
Klik om te vergroten...

Dit is het fout:

[GTLVote V1.1] Settings initializing...
[VoteManager] Connection to SQL database failed!
com.mysql.jdbc.exceptions.jdbc4.CommunicationsExce ption: Communications link fai
lure

The last packet sent successfully to the server was 0 milliseconds ago. The driv
er has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.SQLError.createCommunicationsExcept ion(SQLError.java:1
116)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
at com.mysql.jdbc.ConnectionImpl.coreConnect(Connecti onImpl.java:2332)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co nnectionImpl.java:2
369)
at com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti onImpl.java:2153)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImp l.java:792)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connect ion.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.ConnectionImpl.getInstance(Connecti onImpl.java:381)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java
:305)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.rs.vote.Connect.connect(Connect.java:31)
at com.rs.vote.MainLoader.<init>(MainLoader.java:24)
at com.rs.Launcher.<clinit>(Launcher.java:55)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Un known Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress( Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(Stand ardSocketFactory.ja
va:257)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
... 17 more
Klik om te vergroten...

Of voeg me aub toe op skype:

shershah fedrik
of
syclonepk


Alvast bedankt.
 
Laatst bewerkt:
Nu vermoed ik dat je iets zal moeten doen als bij de bijlage
een lib toevoegen ik vermoed dat je er wel uitkomt als je deze niet had toegevoegd
tomcat en mysql.gif
verder denk ook effen om met een mysql client te kijken of kan connecteren
 
Dat gedeelte van libs klopt ook. Mijn probleem was gewoon dat mijn webhost plotseling poort 3306 niet meer open wou doen voor veiligheidsredens.
 
Status
Niet open voor verdere reacties.
Steun Ons

Nieuwste berichten

Terug
Bovenaan Onderaan