3:11 a.m.
Wolf-Dieter Fink [https://community.jboss.org/people/wdfink] created the discussion
"Re: Jboss 7.1.1 FAILED MySql datasource test-connection-in-pool"
To view the discussion, visit: https://community.jboss.org/message/729785#729785
--------------------------------------------------------------
Your standalone configuration DS JNDI name is *java:/MySqlDS* instead of
*java:jboss/datasources/MySqlDS*
*
*
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/729785#729785]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
8:12 a.m.
Fernando Fabreti [https://community.jboss.org/people/ffabreti] created the discussion
"Re: Jboss 7.1.1 FAILED MySql datasource test-connection-in-pool"
To view the discussion, visit: https://community.jboss.org/message/737952#737952
--------------------------------------------------------------
Posting for the "Googlers".
Well, I don't know if this is a *bug* or a *configuration issue*.
In fact, what solved the problem described on the initial post was to change the line
below (in standalone.xml)
from:
<*datasource jndi-name="java:/MySqlDS"
enabled="true" use-java-context="true"
pool-name="MySqlDS"*>
to:
<*datasource jndi-name="java:/MySqlDS"
enabled="true" use-java-context="true"
pool-name="MySqlDS_pool"*>
then, after a server restart, I've got this:
fernando@kirk:/usr/local/jboss$ sudo su jboss
[sudo] password for fernando:
$ pwd
/usr/local/jboss-as-7.1.1.Final
$ bin/jboss-cli.sh --connect
[standalone@localhost:9999 /]
/subsystem=datasources/data-source=*MySqlDS_pool*:test-connection-in-pool
{
"outcome" => "success",
"result" => [true]
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/737952#737952]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
8:22 a.m.
Fernando Fabreti [https://community.jboss.org/people/ffabreti] created the discussion
"Re: Jboss 7.1.1 FAILED MySql datasource test-connection-in-pool"
To view the discussion, visit: https://community.jboss.org/message/737954#737954
--------------------------------------------------------------
Thank you, problem solved. But java:/MySqlDS didn't work.
See:
[standalone@localhost:9999 /]
/subsystem=datasources/*data-source=java\:\/MySqlDS*:test-connection-in-pool
{
"outcome" => "failed",
"failure-description" => "JBAS014807: Management resource '[
(\"subsystem\" => \"datasources\"),
(\"data-source\" => \"java:/MySqlDS\")
]' not found",
"rolled-back" => true
What worked was:
[standalone@localhost:9999 /]
/subsystem=datasources/*data-source=MySqlDS*:test-connection-in-pool
{
"outcome" => "success",
"result" => [true]
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/737954#737954]
Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&...]
4380
days inactive
4422
days old
2 comments
2 participants
participants (2)
-
Fernando Fabreti -
Wolf-Dieter Fink