7:36 a.m.
Missing configuration for HA local datasource. No url-delimiter.
----------------------------------------------------------------
Key: JBAS-5517
URL: http://jira.jboss.com/jira/browse/JBAS-5517
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: JCA service
Affects Versions: JBossAS-4.2.2.GA
Environment: Linux AS 4.0, MySql 5.0.51, IBM Power Server
Reporter: Sumanth Kalyan
Assigned To: Adrian Brock
We are Using JBoss-4.2.2GA Server for testing and Evaluation for Production Deployment. We
are looking for the feature fail over for the DB. we have configured the server
mysql-ds.xml for the same.
Configured mysql configuration is as provided.
<?xml version="1.0" encoding="UTF-8"?>
<!-- $Id: mysql-ds.xml 41016 2006-02-07 14:23:00Z acoliver $ -->
<!-- Datasource config for MySQL using 3.0.9 available from:
http://www.mysql.com/downloads/api-jdbc-stable.html
-->
<datasources>
<ha-local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<use-java-context>true</use-java-context>
<connection-url>jdbc:mysql://192.168.0.219:3306/MIS||jdbc:mysql://192.168.0.218:3306/MIS</connection-url>
<url-delimeter>||</url-delimeter>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>xxxxxxx</user-name>
<password>xxxxxxx</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- should only be used on drivers after 3.22.1 with "ping" support
-->
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
<!-- sql to call when connection is created!-->
<new-connection-sql>select current_date()</new-connection-sql>
<!-- sql to call on an existing pooled connection when it is obtained from pool -
MySQLValidConnectionChecker is preferred for newer drivers -->
<check-valid-connection-sql>select current_date()</check-valid-connection-
<!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on
first use -->
<min-pool-size>5</min-pool-size>
<!-- The maximum connections in a pool/sub-pool -->
<max-pool-size>20</max-pool-size>
<set-tx-query-timeout/>
<!-- maximum of 5 minutes for queries -->
<query-timeout>300</query-timeout>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</ha-local-tx-datasource>
</datasources>
we are getting a constant error saying (We have also tested the same with Single Piped
Delimeter)
org.jboss.util.NestedSQLException: Missing configuration for HA local datasource. No
url-delimiter. ; - nested throwable: (or
g.jboss.resource.JBossResourceException: Missing configuration for HA local datasource. No
url-delimiter. )
but we have configured the parameter in the xml file.
on further analsys in debug mode we found the tag itself is not read.
<server>
<mbean code='org.jboss.resource.connectionmanager.TxConnectionManager'
display-name='ConnectionManager for DataSource MySqlDS'
name='jboss.jca:service=LocalTxCM,name=MySqlDS'>
<attribute name='TrackConnectionByTx'>true</attribute>
<attribute name='LocalTransactions'>true</attribute>
<depends optional-attribute-name='ManagedConnectionPool'>
<mbean
code='org.jboss.resource.connectionmanager.JBossManagedConnectionPool'
display-name='Connection Pool for DataSource MySqlDS'
name='jboss.jca:service=ManagedConnectionPool,name=MySqlDS'>
<depends optional-attribute-name='ManagedConnectionFactoryName'>
<mbean code='org.jboss.resource.connectionmanager.RARDeployment'
display-name='ManagedConnectionFactory for DataSource MySqlDS'
name='jboss.jca:service=ManagedConnectionFactory,name=MySqlDS'>
<depends
optional-attribute-name='OldRarDeployment'>jboss.jca:service=RARDeployment,name='jboss-ha-local-jdbc.rar'</depends>
<attribute name='RARName'/>
<attribute
name='ConnectionDefinition'>javax.sql.DataSource</attribute>
<attribute name='ManagedConnectionFactoryProperties'>
<properties>
<config-property name='ConnectionURL'
type='java.lang.String'>jdbc:mysql://192.168.0.219:3306/MIS||jdbc:mysql://192.168.0.218:3306/MIS</config-property>
<config-property name='DriverClass'
type='java.lang.String'>com.mysql.jdbc.Driver</config-property>
<config-property name='UserName'
type='java.lang.String'>misuser</config-property>
<config-property name='Password'
type='java.lang.String'>misuser</config-property>
<config-property name='NewConnectionSQL'
type='java.lang.String'>select current_date()</config-property>
<config-property name='CheckValidConnectionSQL'
type='java.lang.String'>select current_date()</config-property>
<config-property name='ValidConnectionCheckerClassName'
type='java.lang.String'>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</config-property>
<config-property name='ExceptionSorterClassName'
type='java.lang.String'>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</config-property>
<config-property name='TransactionQueryTimeout'
type='boolean'>true</config-property>
<config-property name='QueryTimeout'
type='int'>300</config-property>
<config-property name='ValidateOnMatch'
type='boolean'>true</config-property>
</properties>
</attribute>
</mbean>
</depends>
<attribute name='PoolJndiName'>MySqlDS</attribute>
<attribute name='MinSize'>5</attribute>
<attribute name='MaxSize'>20</attribute>
<attribute name='BlockingTimeoutMillis'>30000</attribute>
<attribute name='IdleTimeoutMinutes'>15</attribute>
<attribute name='BackGroundValidation'>False</attribute>
<attribute name='BackGroundValidationMinutes'>10</attribute>
<attribute name='PreFill'>False</attribute>
<attribute name='UseFastFail'>False</attribute>
<attribute name='Criteria'>ByNothing</attribute>
</mbean>
</depends>
<attribute name='JndiName'>MySqlDS</attribute>
<depends
optional-attribute-name='CachedConnectionManager'>jboss.jca:service=CachedConnectionManager</depends>
<depends
optional-attribute-name='TransactionManagerService'>jboss:service=TransactionManager</depends>
</mbean>
<mbean code='org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService'
display-name='Binding for DataSource MySqlDS'
name='jboss.jca:service=DataSourceBinding,name=MySqlDS'>
<attribute name='JndiName'>MySqlDS</attribute>
<attribute name='UseJavaContext'>true</attribute>
<depends
optional-attribute-name='ConnectionManager'>jboss.jca:service=LocalTxCM,name=MySqlDS</depends>
</mbean>
<mbean code='org.jboss.ejb.plugins.cmp.jdbc.metadata.DataSourceMetaData'
name='jboss.jdbc:service=metadata,datasource=MySqlDS'>
<depends
optional-attribute-name='MetadataLibrary'>jboss.jdbc:service=metadata</depends>
<attribute name='TypeMapping'>mySQL</attribute>
</mbean>
</server>
would request you to provide the solution for the same.
Also we are looking for Switching back to the same DB Once the DB has been restored. We
are already running on the tight schedule, looking forward for earlier response.
Thanks
Sumanth Kalyan
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira