Trying to configure datasource for JS 7 and mssql. I did: 1. modify mo

terryc over 11 years ago

Trying to configure datasource for JS 7 and mssql.
I did:
1. modify module.xml
<module xmlns="urn:jboss:module:1.0" name="com.microsoft.sqlserver.jdbc">
<resources>
<resource-root path="sqljdbc4.jar"/>
</resources>
<dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>

2. delete the dataspurce section in standalone.xml (not deleteing it gave me duplicated resources
3. modify appian-ds.xml
<datasources
xmlns:xsi="www.w3.org/.../XMLSchema-instance"
xsi:noNamespaceSchemaLocation="www.jboss.org/.../datasources_1_0.xsd">
<xa-datasource jndi-name="jdbc/AppianPrimary" pool-name="AppianPrimary" use-java-context="false">
<xa-datasource-property name="URL">
jdbc:sqlserver://myservername:1433;databaseName=APPIAN_DEV;integratedSecurity=true
</xa-datasource-property>

<driver>com...

Discussion posts and replies are publicly visible

Parents

0 terryc over 11 years ago

....microsoft.sqlserver.jdbc</driver>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

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

appian-ds.xml deploy fine.

but gotten

javax.naming.NameNotFoundException: jdbc/AppianPrimary -- service jboss.naming.context.java.jdbc.AppianPrimary

Did I missing any step?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 terryc over 11 years ago

....microsoft.sqlserver.jdbc</driver>
<xa-datasource-class>com.microsoft.sqlserver.jdbc.SQLServerXADataSource</xa-datasource-class>

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

appian-ds.xml deploy fine.

but gotten

javax.naming.NameNotFoundException: jdbc/AppianPrimary -- service jboss.naming.context.java.jdbc.AppianPrimary

Did I missing any step?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data