Loading...

Configuring External Databases to IBM SI

We can add as many as external databases to the IBM Sterling B2b Integrator (IBM SI). You can add these external databases to the IBM SI by the step wise procedure as explained below:
Configuring External Databases to IBM SI
  • First you got to stop IBM Sterling B2B Integrator.
  • Now after shutting down your IBM Sterling Integrator, You need to navigate to SI_INSTALL_DIR\properties for editing jdbc_customer.properties.in and now after doing this add the below properties.
  • "Run setupfiles.bat/sh (SI_INSTALL_DIR\bin\setupfiles.bat/sh)
  • Now, you are done. For confirming, restart the IBM Sterling B2B Integrator.

Note: "Please do make sight that SI_EXTENSION is pool name that I have created. You can name it as you want."

How to Validate Connection Pool Creation?

Go to Dashboard --> Operations --> System --> Troubleshooter --> Database Usage we will find connection pool.

Oracle Database

Need to change the test query depending on server, For Oracle Database
SI_EXTENSION.testOnReserveQuery=SELECT * FROM DUAL

MS SQL Server Database

Need to change the test query depending on server, For MS SQL Server Database
SI_EXTENSION.testOnReserveQuery=SELECT GETDATE()

jdbc_customer.properties.in

SI_EXTENSION.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
SI_EXTENSION.url=jdbc:sqlserver://localhost:1433;databaseName=SI_EXTENSION;SelectMethod=cursor
SI_EXTENSION.user=sa
SI_EXTENSION.password=
#SI_EXTENSION.maxconn=20
SI_EXTENSION.storedProcClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.SybaseStoredProcQuery
SI_EXTENSION.varDataClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.MSSQLVarData
SI_EXTENSION.catalog=SI_EXTENSION
SI_EXTENSION.type=remote
SI_EXTENSION.transaction=true
SI_EXTENSION.testOnReserve=true
SI_EXTENSION.testOnReserveQuery=SELECT GETDATE()
SI_EXTENSION.testOnReserveInterval=60000
SI_EXTENSION.maxRetries=100
SI_EXTENSION.blobPageSize=1024000
SI_EXTENSION.compressBlob=true
SI_EXTENSION.dbvendor=mssql
SI_EXTENSION.buffersize=500
SI_EXTENSION.maxsize=20
SI_EXTENSION.initsize=0
SI_EXTENSION.factory=com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionFactory
SI_EXTENSION.behaviour=2
SI_EXTENSION.lifespan=0
SI_EXTENSION.idletimeout=86400000
SI_EXTENSION.housekeepinginterval=3600000
SI_EXTENSION.waittime=1000
SI_EXTENSION.errorMissingTable=16945
SI_EXTENSION.systemPool=true
Training 5798342817116069216

Post a Comment

  1. After following your whole setup I am getting the following error on Sterling:
    "com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCConnectionException:-[XAH elper]getNonXAConnection: Got null back instead of a valid connection"

    ReplyDelete

emo-but-icon

Home item

Blog Archive

Popular Posts

Random Posts

Flickr Photo