Is anyone out there using microsoft sql express 2005 with an appian installation

james.franklin over 10 years ago

Is anyone out there using microsoft sql express 2005 with an appian installation of v7.2?
I could use some help or pointers with the ds config. It will not honor the example on the installation docs or the version I had working for 6.7.
Thanks, James...

Discussion posts and replies are publicly visible

Parents

0 james.franklin over 10 years ago

I honestly can't see where. These are the ds settings I am currently using:
<datasources>
<xa-datasource
jndi-name="jdbc/Appian_LNNOIS_Primary"
pool-name="AppianLNNOIPrimary"
use-java-context="false">
<xa-datasource-property name="ServerName">//localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">1433</xa-datasource-property>
<xa-datasource-property name="DatabaseName">Appian_LNNOIS_Primary</xa-datasource-property>
<xa-datasource-property name="integratedSecurity">false</xa-datasource-property>
<driver>com.microsoft.sqlserver.jdbc</driver>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
<user-name>***</user-name>
<password>***</password>
<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>
</datasources>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 james.franklin over 10 years ago

I honestly can't see where. These are the ds settings I am currently using:
<datasources>
<xa-datasource
jndi-name="jdbc/Appian_LNNOIS_Primary"
pool-name="AppianLNNOIPrimary"
use-java-context="false">
<xa-datasource-property name="ServerName">//localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">1433</xa-datasource-property>
<xa-datasource-property name="DatabaseName">Appian_LNNOIS_Primary</xa-datasource-property>
<xa-datasource-property name="integratedSecurity">false</xa-datasource-property>
<driver>com.microsoft.sqlserver.jdbc</driver>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>
<user-name>***</user-name>
<password>***</password>
<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>
</datasources>
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data