Implementing a UNIX Socket for Java?

Question

I understand that since UNIX sockets are platform specific, some non-Java code must be involved. In particular, we are interested in using JDBC to connect to a MySQL instance in which only UNIX sockets are included.

It doesn't seem like this is supported, but from what I read, it should at least be possible to write a SocketFactory for JDBC based on UNIX sockets, if we can find a decent implementation of UNIX sockets for Java.

Has anyone tried this? Does anyone know of such an implementation?

Answer 1

Place an order in the JUDS library. This is the Java Socket Socket Java Library ...

https://github.com/mcfunley/juds

Answer 2

You can use junixsocket: https://github.com/kohlschutter/junixsocket

It already provides code for connecting to MySQL from Java (Connector / J) via Unix sockets.

One big advantage over other implementations is that junixsocket uses the standard Java Socket API.

Answer 3

Check out the JNA library. This is halfway between pure Java and JNI native code.

https://github.com/twall/jna/

Answer 4

Since the original kohlschutter / junixsocket mentioned in another answer seems to be dead, you can check its plugs.

Especially fiken / junixsocket looks promising. Its author added support for connecting to PostgreSQL using a unix socket via pgjdbc , for example.

Answer 5

The MariaDB JDBC driver now supports this and is compatible with the MySQL JDBC driver.

Use the JDBC URL, for example:

jdbc:mariadb://localhost:3306/revmgt?localSocket=/var/run/mysqld/mysqld.sock

It is worth noting that you need to include the JNA library in this library, since it uses JNA to access the native sockets of the unix domain. This works very well in my testing. I have seen speed improvements on processors related to java processes from unloading to native code.

Answer 6

The following useful library has been found in some searches on the Internet:

http://www.nfrese.net/software/gnu_net_local/overview.html

Wayback link

Writing a factory socket should be fairly straightforward. Once you do this, you can pass it to your THUSLY driver. ( Wayback Link ).

 import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import com.mysql.management.driverlaunched.ServerLauncherSocketFactory; public class ConnectorMXJTestExample { public static void main(String[] args) throws Exception { String hostColonPort = "localhost:3336"; String driver = com.mysql.jdbc.Driver.class.getName(); String url = "jdbc:mysql://" + hostColonPort + "/" + "?" + "socketFactory=" + ServerLauncherSocketFactory.class.getName(); String userName = "root"; String password = ""; Class.forName(driver); Connection conn = null; try { conn = DriverManager.getConnection(url, userName, password); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("SELECT VERSION()"); rs.next(); String version = rs.getString(1); rs.close(); stmt.close(); System.out.println("------------------------"); System.out.println(version); System.out.println("------------------------"); } finally { try { conn.close(); } catch (Exception e) { e.printStackTrace(); } ServerLauncherSocketFactory.shutdown(hostColonPort); } } } 

Answer 7

The JNR project (which is the free basis for the panama project ) has an unix socket implementation.