I can start MySQL outside of JBoss with named pipes enabled and then configure
a datasource to connect to it. If I launch MySQL via jmx (mysqld-service.xml)
I see it running but when the datasource using it tries to connect it cannot.
I see this in the log:
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:729)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)
... 122 more
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)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
... 126 more
There is a propery called namedPipePath. If I use that in the mysql startup
(mysqld-service.xml) it will not start and says that is not a valid attribute.
Error is: No Attribute found with name: namedPipePath
My knowledge of named pipes is minimal. Does the connector/datasource need to
know named pipe path in use? How do I find that? Or what?
I must be missing some key configuration step. Help!
Example configuration files would be great.
>From mysqld-service.xml
..\server\default\data\mysql\data
..\server\default\data\mysql
true
true
from mysql-ds.xml
<connection-url>jdbc:mysql://./mytestdb</connection-url>
<connection-property
name="socketFactory">com.mysql.jdbc.NamedPipeSocketFactory</connection-property>
<!-- commented out now, tried earlier connection-property
name="namedPipePath">c:\pipe\MySQL</connection-property-->
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4187114#4187114
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4187114
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
