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
10 replies
Subscribers
8 subscribers
Views
2351 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Administration
Is it necessary to use XA-Datasource in Appian 7.3? We have Service Corp databas
rishub
over 10 years ago
Is it necessary to use XA-Datasource in Appian 7.3? We have Service Corp database which is non XA Enabled & it is not possible to enable XA on that. IS there any workaround?
Thanks...
OriginalPostID-88446
OriginalPostID-88446
Discussion posts and replies are publicly visible
0
Tim Nguyen
Appian Employee
over 10 years ago
It does not need to be enabled for Appian. However it has been known to produce warnings in the application server logs.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Tim,
Are there any configuration changes required for non XA datasource?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim Nguyen
Appian Employee
over 10 years ago
No there are not.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Thanks for update Tim. Then how will we replace the following line:
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim Nguyen
Appian Employee
over 10 years ago
I'm not sure I understand, could you elaborate a bit more? Are you trying to reconfigure your Appian Datasource deployment?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Tim,
I am updating server from 6.6 to 7.3. My datasources are non XA-enabled so I was wondering if I need to do anything different in configuration. As per Appian relational database configuration documentaion for sql server, we need to add the following code in standalone.xml:
<subsystem xmlns="urn:jboss:domain:datasources:1.0">
<datasources>
<drivers>
<driver module="com.microsoft.sqlserver.jdbc" name="com.microsoft.sqlserver.jdbc">
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
so I was wondering if the "<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>" is needed to be changed or it can be there without any chages?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim Nguyen
Appian Employee
over 10 years ago
Ah thank you for clarifying. No changes are needed to the standard configuration that is outlined in 7.3 documentations. The application server may produce harmless warning messages, but otherwise functionality will remain intact.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
Thanks for update Tim. Do we have the option of just configuring as <datasource> type? i.e. non-xa?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Tim Nguyen
Appian Employee
over 10 years ago
Since it has not been extensively tested, I can not recommend changing the type tag.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 10 years ago
ok Tim. Thank you.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel