Multiple cuba app, jdbc MS SQL same db connection error

Support
#1

Hi,
I have this scenario:

until yesterday:
1 cuba app that run in centos machine with main db postgres and readonly db MSQL

cuba.dataSource_infinityASIA.username=infinityASIA-ithasia
cuba.dataSource_infinityASIA.password=XXXXXX
cuba.dataSource_infinityASIA.dbName=infinityASIA
cuba.dataSource_infinityASIA.host=dbinfinity
cuba.dataSource_infinityASIA.poolName=ithasiaPool

cuba.additionalStores=infinityASIA
cuba.persistenceConfig_infinityASIA=+com/innovit/adrapp/infinityASIA-persistence.xml
cuba.dbmsType_infinityASIA=mssql
cuba.dbmsVersion_infinityASIA=2012

All works perfectly

from today:
2 cuba app that run in the same centos machine with main db on postgres and readonly db on MSQL server.

cuba.dataSource_infinityASIA.username=infinityASIA-adrapp
cuba.dataSource_infinityASIA.password=XXXXXX
cuba.dataSource_infinityASIA.dbName=infinityASIA
cuba.dataSource_infinityASIA.host=dbinfinity
cuba.dataSource_infinityASIA.poolName=ithasiaPool

cuba.additionalStores=infinityASIA
cuba.persistenceConfig_infinityASIA=+com/innovit/adrapp/infinityASIA-persistence.xml
cuba.dbmsType_infinityASIA=mssql
cuba.dbmsVersion_infinityASIA=2012

so app 1 is running, I started app 2 and all works… I can query sql

if I try to restart app… I get pooling error and I can’t to run the app because of this error:
com.microsoft.sqlserver.jdbc.SQLServerException: Accesso non riuscito per l’utente ‘infinityASIA-ithasia’. ClientConnectionId:1e2e6d08-d6e7-4da9-b949-fa347394727d

Have you any suggestion to connect multiple app to sql server? thanks

#2

What happens if you open two instances of mssql enterprise manager, and connect to your mssql database, one with username infinityASIA-ithasia and the other with username infinityASIA-adrapp?

Are App1 and App2 using the same main postgres datasource?

#3

Are App1 and App2 using the same main postgres datasource?
ok they do

Try to not use the same connection pool name for both applications, try with this
for app1:
cuba.dataSource_infinityASIA.poolName=ithasiaPool1
for app2:
cuba.dataSource_infinityASIA.poolName=ithasiaPool2

Kind regards,
Mladen

#4

Tha postgres db are different, I had use 2 different VM, in the first scenario was a clone and doesn’t works, so I had created new VM with different OS, change poolName and all seems to works well. maybe pool is related also to machine ID or something like this.