Re: A Problem of Accessing MySQL via JDBC using Pipe

[Filipe Silva]

Hi,

1. No you can't use named pipes on Linux. However, you can use Unix domain sockets using an external library such as junixsocket that already provides a SocketFactory for Connector/J.

2. This varies too much. In a different Windows system/version you could get different results; different client server interaction could affect it too; even different driver configurations (connection properties) could affect this. So, the best you can do is to run your typical and most common use case with different settings and stick with the one that gives you better results.

3. Those are two different SocketFactory implementations. In essence, an implementation of a SocketFactory must be able to provide a java.net.Socket from which the driver pulls out an input and an output stream sot that it can read and write data from/to a MySQL server.

IHTH