I am trying to add secondary db Mysql 5.5 but it is giving me error. can you ver

ankitb0003

Certified Lead Developer

over 11 years ago

I am trying to add secondary db Mysql 5.5 but it is giving me error. can you verify is this format is correct.

<xa-datasource
jndi-name="jdbc/MySqlDataSource"
pool-name="MySqlDS"
enabled="true"
use-java-context="false">

<xa-datasource-property name="serverName">Server Ip</xa-datasource-property>
<xa-datasource-property name="portNumber">3306</xa-datasource-property>
<xa-datasource-property name="databaseName">appian_mysql_db</xa-datasource-property>
<xa-datasource-property name="useUnicode">true</xa-datasource-property>
<xa-datasource-property name="characterEncoding">UTF-8</xa-datasource-property>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<user-name>User id</user-name> ...

Discussion posts and replies are publicly visible

Parents

0 ankitb0003
Certified Lead Developer
over 11 years ago

...
<password>Password</password>
<driver>com.mysql.jdbc</driver>
<security>
<security-domain/>
</security>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<xa-pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</xa-datasource>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ankitb0003
Certified Lead Developer
over 11 years ago

...
<password>Password</password>
<driver>com.mysql.jdbc</driver>
<security>
<security-domain/>
</security>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<xa-pool>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
</xa-pool>
<timeout>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>5</idle-timeout-minutes>
</timeout>
</xa-datasource>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data