• State Not Answered
  • Replies 9 replies
  • Subscribers 7 subscribers
  • Views 5845 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Integrations

#Sharing - Access AS400 DB2 Here I want to sharing steps for access A

heriz
#Sharing - Access AS400 DB2

Here I want to sharing steps for access AS400 DB2 Database from Appian Query Database Smart Service.

Steps:
1. Create a folder <JBOSS_HOME>\\modules\\com\\ibm\\as400\\main. Copy AS400 DB2 driver ('jt400.jar') and file module.xml (attached).
2. Update driver datasources list in 'standalone.xml' file :
<driver name="as400" module="com.ibm.as400">
<driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
<xa-datasource-class>com.ibm.as400.access.AS400JDBCXADataSource</xa-datasource-class>
</driver>
3. Add datasource in standalone.xml between "<subsystem xmlns="urn:jboss:domain:datasources:1.2">". My script like this (or you can add the datasource in Jboss Management Console):
<datasource jta="true" jndi-name="java:/jdbc/as400" pool-name="AS400" enabled="true" use-ccm="true" statistics-enabled="false">
<connection-url>jdbc:as400://HOSTNAME</connection-url> <!-- Fill your AS400 server Hostname -->
<driver-class>com.ibm.as40...

module.xml

OriginalPostID-208453

OriginalPostID-208453

  Discussion posts and replies are publicly visible

Parents
  • 0
    ...0.access.AS400JDBCDriver</driver-class>
    <driver>as400</driver>
    <pool>
    <max-pool-size>1000</max-pool-size>
    </pool>
    <security>
    <user-name>USERNAME</user-name> <!-- Insert Username for login to DB AS400 -->
    <password>PASSWORD</password> <!-- Insert Password for login to DB AS40 -->
    </security>
    <validation>
    <validate-on-match>false</validate-on-match>
    <background-validation>false</background-validation>
    </validation>
    <timeout>
    <set-tx-query-timeout>false</set-tx-query-timeout>
    <blocking-timeout-millis>0</blocking-timeout-millis>
    <idle-timeout-minutes>300000</idle-timeout-minutes>
    <query-timeout>0</query-timeout>
    <use-try-lock>0</use-try-lock>
    <allocation-retry>0</allocation-retry>
    <allocation-retry-wait-millis>0</allocation-retry-wait-millis>
    </timeout>
    <statement>
    <share-prepared-statements>false</share-prepared-statements>
    </statement>
    </datasource>
    4. Add the new JNDI Name (ex: java:/jdbc/as400) in 'conf.data.datasources' on 'custom.properties' file.
    5. After this, w...
Reply
  • 0
    ...0.access.AS400JDBCDriver</driver-class>
    <driver>as400</driver>
    <pool>
    <max-pool-size>1000</max-pool-size>
    </pool>
    <security>
    <user-name>USERNAME</user-name> <!-- Insert Username for login to DB AS400 -->
    <password>PASSWORD</password> <!-- Insert Password for login to DB AS40 -->
    </security>
    <validation>
    <validate-on-match>false</validate-on-match>
    <background-validation>false</background-validation>
    </validation>
    <timeout>
    <set-tx-query-timeout>false</set-tx-query-timeout>
    <blocking-timeout-millis>0</blocking-timeout-millis>
    <idle-timeout-minutes>300000</idle-timeout-minutes>
    <query-timeout>0</query-timeout>
    <use-try-lock>0</use-try-lock>
    <allocation-retry>0</allocation-retry>
    <allocation-retry-wait-millis>0</allocation-retry-wait-millis>
    </timeout>
    <statement>
    <share-prepared-statements>false</share-prepared-statements>
    </statement>
    </datasource>
    4. Add the new JNDI Name (ex: java:/jdbc/as400) in 'conf.data.datasources' on 'custom.properties' file.
    5. After this, w...
Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.