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="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

0 ankitb0003 over 12 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
0 Jim Beckley
Appian Employee
over 12 years ago

<user-name> and <password> are no longer valid. If you're storing usernames and passwords directly in the file (not recommended) then you must use xa-datasource-property tags such as. <xa-datasource-property name="user-name"> and <xa-datasource-property name="password">
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ankitb0003 over 12 years ago

I have to place any JAR for Sql 5.5 if so which folder i have to place.

Thanks in advance
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jim Beckley
Appian Employee
over 12 years ago

That driver needs to go in the <JBOSS_HOME>/modules/com/microsoft/sqlserver/jdbc/main/ directory.
Be sure to also configure the module.xml file found in that same directory to list the exact filename of your jar file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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
0 ankitb0003 over 12 years ago

I have did it but i am getting some error not sure why it is throwing error,
I am able to connect with my sql from Sql client.
But in Appian Jboss i am getting following error.
19:04:27,544 INFO [STDOUT] 2013-03-27 19:04:27,544 [Timer-5] ERROR org.hibernat
e.util.JDBCExceptionReporter - You are trying to use a connection factory that h
as been shut down: ManagedConnectionFactory is null.; - nested throwable: (javax
.resource.ResourceException: You are trying to use a connection factory that has
been shut down: ManagedConnectionFactory is null.)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jim Beckley
Appian Employee
over 12 years ago

That error may indicate a configuration problem. Check for the presence of an appian-ds.xml.failed file in the same directory as the appian-ds.xml. If there is one there, read it to see additional details on the problem, then delete the file. JBoss won't start if it detects the presence of an appian-ds.xml.failed file.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel