[Installation, Configuration & DEPLOYMENT] - How start mysql via mysqld-service using named pipes
by lpmon
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
17 years, 5 months
[EJB 3.0] - Injecting EJB References NullPointerException JBoss 5.0 in S
by mpurdy1973
When using @EJB for a session bean in a servlet i get a NullPointerException - Am I missing something (new to Jee5 and Injections)
HelloWorldSession is the interface for HelloWorldSessionBean
|
| public class HelloWorldCallingSessionEJBServlet extends HttpServlet
| {
| @EJB
| private HelloWorldSession helloWorldSession;
|
| public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
| {
| this.doWork(request, response);
|
| }//end method doGet
|
| public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
| {
| this.doWork(request, response);
|
| }//end method doPost
|
| private void doWork(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
| {
| ;
| String helloString = "empty string";
|
| helloString = this.helloWorldSession.sayHello();
|
| response.setContentType("text/html");
| PrintWriter out = response.getWriter();
|
| out.println("<html><head><title>HelloWorld</title></head><body>");
| out.println("<h3>" + helloString + "</h3>");
| out.println("</body></html>");
|
|
| }//end method doWork
|
|
| }//end class HelloWorldCallingSessionEJBServlet
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4187110#4187110
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4187110
17 years, 5 months
[JBoss Cache: Core Edition] - Problem with SERIALIZABLE Isolation Level
by andre.rigon
Hello guys,
I'm using JBossCache 1.4.1.SP9.
I need to use SERIALIZABLE isolation level in my application.
I did the following test:
1) started one jboss instance and at some point did:
| TreeCache cache = cacheManagerImpl.getCache();
| cache.put("1", "1", "test");
| cache.getTransactionManager().begin();
| cache.put("1", "1", "test2");
|
and never call commit.
in other jboss instance, I did:
| TreeCache cache = cacheManagerImpl.getCache();
| cache.getTransactionManager().begin();
| @SuppressWarnings("unchecked")
| T returnString = (T) cache.get("1", "1");
| cache.getTransactionManager().commit();
| return returnString;
|
So, I was expecting a failure, because the isolation level is SERIALIZABLE, and I didnt make a commit in the first jboss instance.
But the second code block succeed with no error.
If a had inserted a cache.put(..) in the second block, it would fail.
Are my expects corrects? Or I misunderstanding something?
thanks in advance,
andre
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4187106#4187106
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4187106
17 years, 5 months