JDBC MySQL connection using Unix Socket

by

If you want to use UNIX sockets with the Mysql JDBC Connector/J you need to provide a socketFactory.

jdbc:mysql:///?user=test&password=test&socketFactory=<classname>&<socket>=/tmp/mysql.sock

So this will vary with the implementation you use. By default, Mysql does not ship with any implementation for that, just provides an example for such a factory in it’s source-code.

There is an existing UNIX socket Java library named junixsocket which also has such a socketFactory class implementation. An example is outlined in Connecting to a MySQL database via Unix Domain Sockets which is part of their documentation.

You can find more Java UNIX socket library alternatives in related Q&A material:

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  4. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  5. Multiple queries executed in java in single statement
  6. Java: Insert multiple rows into MySQL with PreparedStatement
  7. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  8. Cannot issue data manipulation statements with executeQuery()
  9. Handling MySQL datetimes and timestamps in Java
  10. Closing JDBC Connections in Pool
  11. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  12. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  13. Java JDBC Access denied for user [closed]
  14. Retrieve an Image stored as BLOB on a MYSQL DB
  15. UNIX socket implementation for Java? [closed]
  16. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. JDBC returning MySQLSyntaxError Exception with correct statement
  19. mysql prepared statement error: MySQLSyntaxErrorException
  20. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  21. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  22. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  23. MySQL connector error “The server time zone value Central European Time” [duplicate]
  24. com.mysql.jdbc.PacketTooBigException
  25. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  26. Should a database connection stay open all the time or only be opened when needed?
  27. How to correctly write UTF-8 strings into MySQL through JDBC interface
  28. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  29. How to connect to a remote MySQL database with Java?
  30. A persistent connection with JDBC to MySQL

Leave a Comment