0 Replies Latest reply: Mar 16, 2012 8:17 AM by Martin Kretschmer RSS

url-delimiter in xa-datasource ignored?

Martin Kretschmer Newbie

Hi,

 

I'm trying to create a xa-datasource with failover using url-delimiter set to |, but it seems that JBoss 7.1.1 final is ignoring this setting.

 

Datasource (at least the parts I think are important): 

 

<xa-datasource jndi-name="xxx" pool-name="xxx" use-ccm="false">

      <xa-datasource-property name="URL">jdbc:mysql://xxx|jdbc:mysql://yyy</xa-datasource-property>

      <driver>com.mysql</driver>

      <url-delimiter>|</url-delimiter>

</xa-datasource>

 

When starting JBoss with this configuration, I get an exception with "Database xxx|jdbc:mysql...." not found, so JBoss is not splitting

the URL by the delimiter as expected but handing over the complete URL.

 

A similar issue was filed as a bug here: https://issues.jboss.org/browse/AS7-3433 but seems to have been fixed for normal, non-xa datasources,

even though from going through the sources it seems that XAManagedConnectionFactory has some logic in it to process url-delimiters. I guess

it's misconfiguration / misunderstanding on my part then - but where?

 

Edit: I try to connect to a MySQL Cluster this way, which has two mysqld to expose the database to the JBoss host. Driver is J/Connector 5.1.18

installed as module.

 

Best regards,

Martin