When I try to use named pipes with MySQL launched via mysqld-service.xml I get:
.....
Caused by: java.io.FileNotFoundException: \\.\pipe\MySQL (The system cannot find the file specified)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.(RandomAccessFile.java:212)
at java.io.RandomAccessFile.(RandomAccessFile.java:98)
at com.mysql.jdbc.NamedPipeSocketFactory$NamedPipeSocket.(NamedPipeSocketFactory.java:57)
at com.mysql.jdbc.NamedPipeSocketFactory.connect(NamedPipeSocketFactory.java:215)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276)
I I start MySQL outside of jboss it works. Every hint/help I find by searching says the problem is that mysql was not started with named pipes. I can see by using mysqladmin that named_pipe is on:
| named_pipe | ON
Any ideas how to resolve this?
mysql-ds.xml datasource contains:
connection-url jdbc:mysql://./mydbv2
connection-property name="socketFactory"
com.mysql.jdbc.NamedPipeSocketFactory
But that works when not launching via mysqld-service so mysql-ds.xml is probably not the problem.