[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Checking DB connectivity from JMX console
So, it seems I didn't overlook anything, and there's no existing solution for what I was trying to do. My solution was to develop a custom MBean packaged in a .sar and put it in the deploy directory. It has a function where for simply typing the JNDI name of the datasource, and returning either a success string or the exception if the connection failed. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4161816#4161816 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4161816 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Checking DB connectivity from JMX console
Gap_Tooth wrote : Is there a way to check and see if you can get a valid database connection from the JMX console? Maybe not be exactly what you are looking for, but there's a new-connection-sql attribute you can configure in the -ds.xml. See this for more details http://wiki.jboss.org/wiki/ConfigDataSources View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4161819#4161819 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4161819 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Checking DB connectivity from JMX console
As far as I understand from the documentation, the new-connection-sql attribute and the valid-connection-checker attribute merely check to see if the connection returned from the pool is valid or not. I wanted to be able to go into the JMX console and quickly check to see if my configuration for the DataSource was correct or not. The MBean I developed allowed me to do this pretty quickly, and only took about fifteen minutes to write. If anyone needs help implementing the same thing, I can post a skeleton implementation of the MBean interface and service implementation I made here. View the original post : http://www.jboss.com/index.html?module=bbop=viewtopicp=4161866#4161866 Reply to the post : http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4161866 ___ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user