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

Parents

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

Reply

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

Children

No Data