[jboss-user] [Datasource Configuration] - url-delimiter not recognized in ha-local-tx-datasource??

[Julian Kiper]

Julian Kiper [https://community.jboss.org/people/jkiper] created the discussion

"url-delimiter not recognized in ha-local-tx-datasource??"

To view the discussion, visit: https://community.jboss.org/message/732544#732544

--------------------------------------------------------------
Hi, I've this DS in JBOSS 4.3:

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
  <ha-local-tx-datasource>
    <jndi-name>defaultDST</jndi-name>    
    <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
    <connection-url>jdbc:db2://10.0.0.10:60000/DBHADR1|jdbc:db2://10.0.0.20:60000/DBHADR2</connection-url>
    <url-delimiter>|</url-delimiter> 
    <user-name>user</user-name>
    <password>pass</password>    
    <connection-property name="currentSchema">DBHADR1</connection-property>    
          <connection-property name="retryIntervalClientReroute">2</connection-property>
    <connection-property name="maxRetriesForClientReroute">10</connection-property>
    <connection-property name="enableClientAffinitiesList">1</connection-property>      
    <min-pool-size>20</min-pool-size>
    <max-pool-size>200</max-pool-size>
    <prepared-statement-cache-size>1000</prepared-statement-cache-size>
    <check-valid-connection-sql>SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1 for read only</check-valid-connection-sql>    
    <idle-timeout-minutes>15</idle-timeout-minutes>
      <metadata>
         <type-mapping>DB2</type-mapping>
      </metadata>
  </ha-local-tx-datasource>
</datasources>

When trying to connect to the database, I'm receiving an error like if JBOSS is not detecting the URL delimiter as it reclaims for the whole string in connection-url....

Any help would be appreciated!!!

Thanks in advance.
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/732544#732544]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120426/eb34b95b/attachment.html