JDBC MYSQL XAMPP

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

JDBC MYSQL XAMPP

Postby Studente » 23. April 2021 16:36

I got java file work on mama pro and mamp but does not work on XAMPP
Code: Select all
package model;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class ConnettoreDB {
   
      private static Connection conn=null;
      public static Connection getDBDipendenti() {
         try {
            if(conn==null) {
               Class.forName("com.mysql.cj.jdbc.Driver");
               conn=DriverManager.getConnection("jdbc:mysql://localhost:8080/Gestione_Dipendenti_DB?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","name","password");
               //mamp
               //conn=DriverManager.getConnection("jdbc:mysql://localhost:number mysql port/Gestione_Dipendenti_DB?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","root","root");
               //conn=DriverManager.getConnection("jdbc:mysql://localhost:mysql port/Gestione_Dipendenti_DB?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","name","password");
               // per mamp pro
               //conn=DriverManager.getConnection("jdbc:mysql://localhost:mysql port/Gestione_Dipendenti_DB?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","name","password");
               
            }
         } catch(ClassNotFoundException e){
            e.printStackTrace();
         } catch(SQLException e) {
            e.printStackTrace();
         }
         return conn;
      }
      private ConnettoreDB(){}
   
   /*public static Connection getDBDipendenti() {
      String url = "jdbc:postgresql://localhost:number port/name db";
      Properties props = new Properties();
      props.setProperty("user", "root");
      props.setProperty("password", "");
      Connection conn = null;
      try {
          conn = DriverManager.getConnection(url, props);
         System.out.println("Test di connessione avvenuto con successo");
      } catch (SQLException e) {
         e.printStackTrace();
      } finally {
         try {
            if (conn != null)
               conn.close();
         } catch (SQLException e) {
            e.printStackTrace();
         }
      }
      return conn;
   }
   */
}



how to check mysql port on xampp? is it the same of phpmyadmin? 8080?
it says:

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at model.ConnettoreDB.getDBDipendenti(ConnettoreDB.java:15)
at model.DipendenteCRUD.leggi(DipendenteCRUD.java:60)
at view.ViewDipendente.schedaDipendente(ViewDipendente.java:124)
at controller.Avvio.main(Avvio.java:82)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:64)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:500)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:481)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:546)
at com.mysql.cj.protocol.a.NativeProtocol.readServerCapabilities(NativeProtocol.java:498)
at com.mysql.cj.protocol.a.NativeProtocol.beforeHandshake(NativeProtocol.java:385)
at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1348)
at com.mysql.cj.NativeSession.connect(NativeSession.java:157)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:953)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
... 9 more
Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:67)
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63)
at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45)
at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:540)
... 15 more
Studente
 
Posts: 1
Joined: 23. April 2021 16:29
XAMPP version: 8.0.0-2
Operating System: 10.15

Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 20 guests