The management console currently has a feature to test a JDBC connection as the last step
of the "Create Datasource" wizard. From an user's POV I clearly see a value
to provide such a feature.
However it comes at a price: In order to test a connection, the datasource must be created
in advance. Now if the user decides to cancel the wizard, the tmp datasource must be
removed again.
Another issue occurs, if the test connection fails - say due to a typo in the password. In
this case the user can go back one step to fix the wrong password. Now the tmp datasource
needs to be modified. which in turn sets the process-state to reload-required. Further
:test-connection-in-pool() operations will fail until the server is reloaded. Doing that
in the middle of the "Create Datasource" wizard is neither user friendly nor
obvious for the user.
In domain mode there are even more things to consider. In order to create the datasource
(when clicking on "Test connection") we need a running server in a group which
matches the selected profile).
Given all these issues I strongly recommend to remove the "Test connection"
feature in the "Create Datasource" wizard at all. The user would still be able
to test the connection once it was created. Currently this can be done in both the
configuration and runtime section. When revisiting this feature, I would also like to
remove the test connection feature in the configuration section as it clearly belong to
the runtime section.
---
Harald Pehl
JBoss by Red Hat
http://hpehl.info