0 Replies Latest reply on Dec 3, 2008 3:48 PM by lpmon

    JBoss + MySQL + named pipes: FileNotFoundException: \\.\pipe

    lpmon Novice

      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.