I’m used to connect to multi tenants databases MySQL, H2 and PostgreSQL on Travis CI through connection pool C3P0 with Hibernate.
My test suites are stable and I have encountered no problem with these databases, popping them on Docker using standard ports and accessing them concurrently via JDBC.
Now I want to access an additional database, SQL Server. I tested this locally and it works fine:
FROM mcr.microsoft.com/mssql/server:2017-latest EXPOSE 1433 - docker run --name jsql-sqlserver --publish 3308:1433 -e ACCEPT_EULA=Y -e SA_PASSWORD=my-secret-pw -d sqlserver
But I’m trying to integrate it since yesterday and I don’t manage to make it work on Travis CI,
- I tried with all databases disabled except SQL Server
- I tried to run on single JDK instead of five
- also tried on non default database port 3308 instead of 1433
The jobs are failing with network errors Connection refused:
Do you know if there are limitations on using SQL Server on Travis CI?
Is there a configuration allowed to run this database on the platform?
[logback.xml] 2020-03-15 19:11:36 [C3P0PooledConnectionPoolManager[identityToken->z8kflta81q19z49dz0zfl|10af5f22]-HelperThread-#14] WARN c.m.v.resourcepool.BasicResourcePool - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@1f87ea97 – Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 127.0.0.1, port 3308 has failed. Error: "Connection refused (Connection refused). Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".