Hello,
I'm creating a custom pool to interact with a MySQL database on my B2Bi 6.1 installation. Here you can find how I configured it on customer_overrides. I configured it based on this web site:
http://myibm-b2bi.blogspot.com/2018/09/jdbcService.mysqlPool.driver=com.mysql.cj.jdbc.Driver
jdbcService.mysqlPool.url=jdbc:mysql://X.X.X.X:YYYY/edi
jdbcService.mysqlPool.user=XXXX
jdbcService.mysqlPool.password=XXXX
jdbcService.mysqlPool.varDataClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.MySQLVarData
jdbcService.mysqlPool.catalog=edi
jdbcService.mysqlPool.type=remote
jdbcService.mysqlPool.transaction=false
jdbcService.mysqlPool.testOnReserve=true
jdbcService.mysqlPool.testOnReserveQuery=select * from users
jdbcService.mysqlPool.testOnReserveInterval=60000
jdbcService.mysqlPool.maxRetries=100
jdbcService.mysqlPool.blobPageSize=1024000
jdbcService.mysqlPool.compressBlob=true
jdbcService.mysqlPool.dbvendor=mysql
jdbcService.mysqlPool.buffersize=500
jdbcService.mysqlPool.maxsize=30
jdbcService.mysqlPool.initsize=0
jdbcService.mysqlPool.factory=com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionFactory
jdbcService.mysqlPool.behaviour=2
jdbcService.mysqlPool.lifespan=0
jdbcService.mysqlPool.idletimeout=86400000
jdbcService.mysqlPool.housekeepinginterval=3600000
jdbcService.mysqlPool.waittime=1000
jdbcService.mysqlPool.errorMissingTable=1146
jdbcService.mysqlPool.systemPool=true
I have previously installed mysql-connector-java-8.0.21.jar driver and I can assure you that using that driver and the same database information I can connect remotely to the database. Here is the error I obtain on system.log when doing a SELCT with a Lightweight JDBC Adapter over the new pool.
[2020-12-02 11:45:27.034] ERRORDTL [1606931127033]com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.I can tell you also that we are correctly reaching the database since after some tries MySQL is blocking my connections and the error changes to the following:
[2020-12-02 13:18:36.404] ERROR [1606936716404] null, message from server: "Host 'X.X.X.X' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"
On the server side I just can see that the number of abort connections increase on each try but no more information. I think that the problem resides on Sterling since same driver and configuration are able to connect to the database.
Do you have any idea to solve it?
Regards,
------------------------------
Victor Bonilla Palencia
------------------------------
#SupplyChain#B2BIntegration