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

In customer.properties
conf.data.primary.datasource=@conf.data.datasources.primary.jndiname@
in environment specific build.xml
#conf.data.datasources.primary.jndiname=java:/jdbc/AppianPrimary
#conf.data.datasources.primary.host=myservername
#conf.data.datasources.primary.port=:1433
#conf.data.datasources.primary.instance=
#conf.data.datasources.primary.databaseName=APPIAN_DEV
#conf.data.datasources.primary.integratedSecurity=true
#conf.data.datasources.primary.username=
#conf.data.datasources.primary.password=
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 terryc over 11 years ago

In customer.properties
conf.data.primary.datasource=@conf.data.datasources.primary.jndiname@
in environment specific build.xml
#conf.data.datasources.primary.jndiname=java:/jdbc/AppianPrimary
#conf.data.datasources.primary.host=myservername
#conf.data.datasources.primary.port=:1433
#conf.data.datasources.primary.instance=
#conf.data.datasources.primary.databaseName=APPIAN_DEV
#conf.data.datasources.primary.integratedSecurity=true
#conf.data.datasources.primary.username=
#conf.data.datasources.primary.password=
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data