[
https://issues.jboss.org/browse/AS7-3433?page=com.atlassian.jira.plugin.s...
]
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