[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - JBoss + MySQL + named pipes: FileNotFoundException: \\.\pipe

[lpmon]

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.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4194154#4194154

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4194154