[jboss-jira] [JBoss JIRA] (AS7-3433) DataSource's <url-delimiter> value is ignored by AS7DataSourceDeployer

[Martijn Zuidhof (JIRA)]

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

Martijn Zuidhof commented on AS7-3433:
--------------------------------------

We use MySql database strings for the connection-url in our HA datasource. This used to work in AS6.1 but since 7.1.0.CR1
we are unable to connect successfully. Here's the connection-url:  jdbc:mysql://localhost:3306/test|jdbc:mysql://localhost:3306/test_failover.
The exception shown during server boot shows: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'test|jdbc:mysql://localhost:3306/test'. Removing the stuff after and including the | works ok, indicating the single connection-url is ok.
The url-delimiter was set to |.
                
> DataSource's <url-delimiter> value is ignored by AS7DataSourceDeployer
> ----------------------------------------------------------------------
>
>                 Key: AS7-3433
>                 URL: https://issues.jboss.org/browse/AS7-3433
>             Project: Application Server 7
>          Issue Type: Bug
>          Components: JCA
>    Affects Versions: 7.1.0.CR1
>         Environment: JBoss 7.1.0.CR1, MS SQL Sever 2005/2008
>            Reporter: Xi CHEN
>              Labels: connection_factory, connector, database, datasource, failover, url-delimiter
>
> We try to use
> <datasource ... >
>   <connection-url>jdbc:sqlserver://SERVER_ONE:1433;databaseName=MyDB|jdbc:sqlserver://SERVER_TWO:1433;databaseName=MyDB</connection-url>
>   <url-delimiter>|</url-delimiter>
>   ...
> </datasource>
> to treate database failover case, but it doesn't work in JBoss 7.1.0.CR1. It just use the first connection url.
> By looking at the code source of jboss connector ( in org.jboss.as.connector.subsystems.datasources.AbstractDataSourceService.java), I found the url-delimiter's value is never set into LocalManagedConnectionFactory.

--
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