Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
7 subscribers
Views
2718 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
I am trying to add secondary db Mysql 5.5 but it is giving me error. can you ver
ankitb0003
over 12 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="URL">jdbc:mysql://IPofserver:3306/appian_mysql_db?useOldAliasMetadataBehavior=true</xa-datasource-property>-->
<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> ...
OriginalPostID-62190
OriginalPostID-62190
Discussion posts and replies are publicly visible
Parents
0
Jim Beckley
Appian Employee
over 12 years ago
oh, you meant MySQL 5.5 -- that driver goes in the <JBOSS_HOME>/modules/com/mysql/jdbc/main/
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Jim Beckley
Appian Employee
over 12 years ago
oh, you meant MySQL 5.5 -- that driver goes in the <JBOSS_HOME>/modules/com/mysql/jdbc/main/
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data