When i try to start the JBoss server for the first time i get the folowing error

raghunandanj3904

Certified Senior Developer

over 11 years ago

When i try to start the JBoss server for the first time i get the folowing error:

11:13:21,435 WARN [com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery go
t XA exception XAException.XAER_RMERR: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLServe
rException: Failed to create the XA control connection. Error: "Could not find stored procedure 'master..xp_sq
ljdbc_xa_init_ex'."
May i know if i need to sdo any othr seting for this. I am tryin to install Appian 7.1...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 11 years ago

Or switch to non-xa data sources. For a local installa doesn't make sense to use xa data sources:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<datasources>
<datasource enabled="true" jndi-name="/jdbc/XXXXXX" jta="true" pool-name="XXXXXX" spy="false" use-ccm="true" use-java-context="true">
<connection-url>jdbc:sqlserver://XXXXXX:1433;databaseName=XXXXXXXt</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<datasource-class/>
<driver>com.microsoft.sqlserver.jdbc</driver>
<transaction-isolation>TRANSACTION_NONE</transaction-isolation>
<pool>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>XXXXX</user-name>
<password>XXXXXXX</password>
</security>
<validation> </validation>
<timeout>
</timeout>
<statement>
<track-statements>false</track-statements>
</statement>
</datasource>
</datasources>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 11 years ago

Or switch to non-xa data sources. For a local installa doesn't make sense to use xa data sources:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<datasources>
<datasource enabled="true" jndi-name="/jdbc/XXXXXX" jta="true" pool-name="XXXXXX" spy="false" use-ccm="true" use-java-context="true">
<connection-url>jdbc:sqlserver://XXXXXX:1433;databaseName=XXXXXXXt</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<datasource-class/>
<driver>com.microsoft.sqlserver.jdbc</driver>
<transaction-isolation>TRANSACTION_NONE</transaction-isolation>
<pool>
<prefill>false</prefill>
<use-strict-min>false</use-strict-min>
<flush-strategy>FailingConnectionOnly</flush-strategy>
</pool>
<security>
<user-name>XXXXX</user-name>
<password>XXXXXXX</password>
</security>
<validation> </validation>
<timeout>
</timeout>
<statement>
<track-statements>false</track-statements>
</statement>
</datasource>
</datasources>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data