FATAL: DataSourcePool [db] is down or has network error!!!

David Smith

unread,

Dec 23, 2020, 1:25:12 PM12/23/20

to Ebean ORM

Trying to connect to postgresql (Amazon RDS) using Play (sbt configs attached) and with this application.properties:

atasource:

db:

platform: postgres

driver: org.postgresql.Driver

url: "jdbc:postgresql://cpp-dev.cuhui0gwzwbs.us-east-1.rds.amazonaws.com/cpp"

username: "cpp"

password: <REDACTED>

I get this error on the initial io.ebean.DB invocation:

[error] i.e.d.p.ConnectionPool - FATAL: DataSourcePool [db] is down or has network error!!!

[error] i.e.DbContext - Error trying to create the default Database

io.ebean.datasource.DataSourceInitialiseException: Error initialising DataSource with user: "cpp" url:"jdbc:postgresql://cpp-dev.cuhui0gwzwbs.us-east-1.rds.amazonaws.com/cpp" error:No suitable driver found for "jdbc:postgresql://cpp-dev.cuhui0gwzwbs.us-east-1.rds.amazonaws.com/cpp"

at io.ebean.datasource.pool.ConnectionPool.<init>(ConnectionPool.java:250)

at io.ebean.datasource.pool.ConnectionPoolFactory.createPool(ConnectionPoolFactory.java:14)

at io.ebean.datasource.DataSourceFactory.create(DataSourceFactory.java:26)

at io.ebeaninternal.server.core.InitDataSource.create(InitDataSource.java:121)

at io.ebeaninternal.server.core.InitDataSource.createFromConfig(InitDataSource.java:116)

at io.ebeaninternal.server.core.InitDataSource.initDataSource(InitDataSource.java:49)

at io.ebeaninternal.server.core.InitDataSource.initialise(InitDataSource.java:34)

at io.ebeaninternal.server.core.InitDataSource.init(InitDataSource.java:25)

at io.ebeaninternal.server.core.DefaultContainer.setDataSource(DefaultContainer.java:234)

at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:90)

Caused by: java.sql.SQLException: No suitable driver found for "jdbc:postgresql://cpp-dev.cuhui0gwzwbs.us-east-1.rds.amazonaws.com/cpp"

at java.sql.DriverManager.getConnection(DriverManager.java:689)

at java.sql.DriverManager.getConnection(DriverManager.java:208)

at io.ebean.datasource.pool.ConnectionPool.createUnpooledConnection(ConnectionPool.java:543)

at io.ebean.datasource.pool.ConnectionPool.createUnpooledConnection(ConnectionPool.java:538)

at io.ebean.datasource.pool.ConnectionPool.createConnectionForQueue(ConnectionPool.java:757)

at io.ebean.datasource.pool.PooledConnectionQueue.ensureMinimumConnections(PooledConnectionQueue.java:176)

at io.ebean.datasource.pool.ConnectionPool.initialise(ConnectionPool.java:298)

at io.ebean.datasource.pool.ConnectionPool.<init>(ConnectionPool.java:247)

at io.ebean.datasource.pool.ConnectionPoolFactory.createPool(ConnectionPoolFactory.java:14)

at io.ebean.datasource.DataSourceFactory.create(DataSourceFactory.java:26)

direct connects with psql work fine.

sbt-files.txt

Rob Bygrave

unread,

Dec 23, 2020, 10:00:45 PM12/23/20

to ebean@googlegroups

> Caused by: java.sql.SQLException: No suitable driver found for "jdbc:postgresql://cpp-dev.cuhui0gwzwbs.us-east-1.rds.amazonaws.com/cpp"

at java.sql.DriverManager.getConnection(DriverManager.java:689)

This error suggests that the postgres jdbc driver is not in the classpath? Can you check that?

Cheers, Rob.

--

---
You received this message because you are subscribed to the Google Groups "Ebean ORM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ebean+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ebean/a13bb0a5-0ed3-4b1a-936a-bf97928967b1n%40googlegroups.com.

David Smith

unread,

Dec 24, 2020, 7:51:10 AM12/24/20

to Ebean ORM

Thank you for your quick response. Yes, postgres is in the classpath:

[info] * Attributed(/opt/comcast/home/.cache/coursier/v1/https/repo1.maven.org/maven2/org/postgresql/postgresql/42.2.18/postgresql-42.2.18.jar)

Also, I check in the application for the presence of org.postgresql.Driver:

try {

DatabaseConfig dbconf = new DatabaseConfig();

dbconf.loadFromProperties();

dbconf.setName("db");

System.out.println(dbconf.getProperties());

System.out.println("loaded postgres driver: " + org.postgresql.Driver.getVersion());

} catch (Exception e) {

System.out.println(e);

System.exit(1);

}

This reports the following (including the fatal error):

(Server started, use Enter to stop and go back to the console...)

[info] p.a.d.DefaultDBApi - Database [default] initialized

[info] p.a.d.HikariCPConnectionPool - Creating Pool for datasource 'default'

{platform=postgres, datasource=, db=, url="jdbc:postgresql://cpp-dev.cuhui0gwzwbs.us-east-1.rds.amazonaws.com/cpp", password=<REDACTED>, driver=org.postgresql.Driver, username="cpp"}

loaded postgres driver: PostgreSQL JDBC Driver 42.2.18