Yazılım | Programlama Eclipse mysql bağlantı hatası

XxPaRaZiTxX · 25 Ağu 2019

Sorunumun Çıktısı

Kod:

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

** BEGIN NESTED EXCEPTION ** 

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

** BEGIN NESTED EXCEPTION ** 

javax.net.ssl.SSLHandshakeException
MESSAGE: Remote host terminated the handshake

STACKTRACE:

javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:72)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:3982)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1293)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at macfinder.ConnectTest.main(ConnectTest.java:20)
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	... 14 more


** END NESTED EXCEPTION **



Last packet sent to the server was 432 ms ago.

STACKTRACE:

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

** BEGIN NESTED EXCEPTION ** 

javax.net.ssl.SSLHandshakeException
MESSAGE: Remote host terminated the handshake

STACKTRACE:

javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake
	at java.base/sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.readRecord(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:72)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:3982)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1293)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at macfinder.ConnectTest.main(ConnectTest.java:20)
Caused by: java.io.EOFException: SSL peer shut down incorrectly
	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
	... 14 more


** END NESTED EXCEPTION **



Last packet sent to the server was 432 ms ago.
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:87)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:3982)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1293)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at macfinder.ConnectTest.main(ConnectTest.java:20)


** END NESTED EXCEPTION **



Last packet sent to the server was 432 ms ago.
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
	at macfinder.ConnectTest.main(ConnectTest.java:20)

Localhost bağlanılmayacak gerekli tüm bilgileri verdim eğer eksik bilgi verdiysem belirtin vereyim

mysql -h ******-u ******* -p ********

bu veritabanını MYSQL cmd commad kullanarak bağlanabiliyorum fakat eclipse ile bağlanamıyorum kodum şu

Kod:

try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://be********m:*","***m******n@beni*rver","Fur*********kan/****9");
            System.out.println("Remote DB connection established");
        }
        catch (ClassNotFoundException e)
        {
            e.printStackTrace();
            System.out.println("Remote server could not be connected");
        }
        catch (NullPointerException e)
        {
            e.printStackTrace();
            System.out.println("Remote server could not be connected");
        }
        catch (SQLException e)
        {
            e.printStackTrace();
            System.out.println("Remote db connection establishment error");
        }
        catch (Exception e)
        {
            e.printStackTrace();
            System.out.println("False query");
        }

Codun içinde java Connecter var jar ekledim import ettim tek istediğim online bir veritabanına bağlanmak

trt12345 · 25 Ağu 2019

Bak hocam internete java String Connection yazarsan bir çok örnek bulabilirsin
yinede bi örnek

import java.sql.Connection;
import java.sql.DriverManager;

public class Main {
public static **** main(String[] argv) throws Exception {
String driver = "com.mysql.jdbc.Driver";
String connection = "jdbc:mysql://localhost:3306/YourDBName";
String user = "root";
String password = "root";
Class.forName(driver);
Connection con = DriverManager.getConnection(connection, user, password);
if (!con.isClosed()) {
con.close();
}
}
}

Bu sitede sana yardımcı olabilir.
Java-Mysql Bağlantısı (Eclipse) | Fatih BURGAZ

XxPaRaZiTxX · 25 Ağu 2019

gösterdiğiniz zaten paylaştığım kodumun içinde var

localhost olarak bağlanmayacak yukarda online mysql database hostunu ve username password verdim kodu editleyip paylaşırsanız denerim çalışırsa vds yi gönderirim ama çalışmadı denedim

trt12345 · 25 Ağu 2019

Karşılıksız yardım ediyorum bir beklentim yok şuan programlarım kurulu olmadığı için deneme fırsatım malasef yok alternatif çözümler atıyorum dene birisi olur

package database;
import java.sql.Connection;
import java.sql.DriverManager;

public final class Connect {
private Connection conn;
public Connect(){
conn = null;
try{
String userName = "root";
String password = "";
String url = "jdbc:mysql://localhost/shop";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection(url, userName, password);
}
catch(Exception e){
System.out.println("Exception found");
}
}
public Connection getConnection(){
return conn;
}
public **** closeConnection(){
try{
conn.close ();
}catch (Exception e) {
System.out.println ("Connection close error");
}
}
}

XxPaRaZiTxX · 25 Ağu 2019

trt12345' Alıntı:
Karşılıksız yardım ediyorum bir beklentim yok şuan programlarım kurulu olmadığı için deneme fırsatım malasef yok alternatif çözümler atıyorum dene birisi olur

package database;
import java.sql.Connection;
import java.sql.DriverManager;

public final class Connect {
private Connection conn;
public Connect(){
conn = null;
try{
String userName = "root";
String password = "";
String url = "jdbc:mysql://localhost/shop";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection(url, userName, password);
}
catch(Exception e){
System.out.println("Exception found");
}
}
public Connection getConnection(){
return conn;
}
public **** closeConnection(){
try{
conn.close ();
}catch (Exception e) {
System.out.println ("Connection close error");
}
}
}

olmadı teşekkür ederim yinede

jasgues · 25 Ağu 2019

trt12345' Alıntı:
Karşılıksız yardım ediyorum bir beklentim yok şuan programlarım kurulu olmadığı için deneme fırsatım malasef yok alternatif çözümler atıyorum dene birisi olur

package database;
import java.sql.Connection;
import java.sql.DriverManager;

public final class Connect {
private Connection conn;
public Connect(){
conn = null;
try{
String userName = "root";
String password = "";
String url = "jdbc:mysql://localhost/shop";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection(url, userName, password);
}
catch(Exception e){
System.out.println("Exception found");
}
}
public Connection getConnection(){
return conn;
}
public **** closeConnection(){
try{
conn.close ();
}catch (Exception e) {
System.out.println ("Connection close error");
}
}
}

Karşılıklı yardım mı olur? Karşılığı varsa o yardım olmuyor

Yazılım | Programlama Eclipse mysql bağlantı hatası

XxPaRaZiTxX

Katılımcı Üye

trt12345

Üye

XxPaRaZiTxX

Katılımcı Üye

trt12345

Üye

XxPaRaZiTxX

Katılımcı Üye

jasgues

Katılımcı Üye

Sosyal medya sayfalarımız