[jboss-jira] [JBoss JIRA] (AS7-4865) Datasource after creation is in a peculiar state

[Stefano Maestri (JIRA)]

    [ https://issues.jboss.org/browse/AS7-4865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12694723#comment-12694723 ] 

Stefano Maestri commented on AS7-4865:
--------------------------------------

The root cause of the issue is that newly created ds are disabled, but the attribute enabled is set (wrongly) to true, "confusing" web console.
                
> Datasource after creation is in a peculiar state
> ------------------------------------------------
>
>                 Key: AS7-4865
>                 URL: https://issues.jboss.org/browse/AS7-4865
>             Project: Application Server 7
>          Issue Type: Bug
>          Components: JCA
>            Reporter: Jan Martiska
>            Assignee: Stefano Maestri
>            Priority: Critical
>
> Create a (xa)datasource in admin console. Try to disable it using the appropriate button. This error will happen:
> {noformat}
> Request
> {
>     "xa-datasource-class" => "org.h2.jdbcx.JdbcDataSource",
>     "pad-xid" => false,
>     "wrap-xa-resource" => false,
>     "same-rm-override" => false,
>     "interleaving" => false,
>     "name" => "qrh",
>     "driver-name" => "h2",
>     "password" => "",
>     "enabled" => true,
>     "user-name" => "",
>     "security-domain" => "",
>     "jndi-name" => "java:/uyyyy",
>     "pool-name" => "",
>     "transaction-isolation" => "",
>     "new-connection-sql" => "",
>     "connection-url" => "",
>     "driver-class" => "",
>     "valid-connection-checker-class-name" => "",
>     "check-valid-connection-sql" => "",
>     "background-validation" => false,
>     "background-validation-millis" => -1L,
>     "validate-on-match" => false,
>     "stale-connection-checker-class-name" => "",
>     "exception-sorter-class-name" => "",
>     "prepared-statements-cache-size" => -1L,
>     "share-prepared-statements" => false,
>     "use-ccm" => false,
>     "operation" => "disable",
>     "address" => [
>         ("subsystem" => "datasources"),
>         ("xa-data-source" => "qrh")
>     ],
>     "operation-headers" => {"allow-resource-service-restart" => true}
> }
> Response
> Internal Server Error
> {
>     "outcome" => "failed",
>     "failure-description" => "JBAS010455: Data-source service [qrh] is not enabled",
>     "rolled-back" => true,
>     "response-headers" => {"process-state" => "restart-required"}
> }
> {noformat}
> It states that "Data-source service [qrh] is not enabled" even though the datasource has property "enabled" equal "true". 
> After you disable the datasource in CLI using :disable operation (this works) and then enable it back -> from this point, disabling and enabling in console will work, just the first time (after creation) it doesn't.
> *Also, weird thing is - after you create a datasource, it is not shown in JNDI naming tree, it looks like it is not active, even though CLI says it is enabled.* You have to reload server, only then will the datasource appear in JNDI naming tree - it behaves like datasource creation requires server-reload, but JCA subsystem doesn't indicate this.
> What is the correct behavior? 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira