java.sql.SQLException

Cannot create PoolableConnectionFactory (Unknown database 'connect_db_1')

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4010

  • via Stack Overflow by Rasputin Jones
    , 10 months ago
    Cannot create PoolableConnectionFactory (Unknown database 'connect_db_1')
  • Cannot create PoolableConnectionFactory (Unknown database 'chaperone')
  • via JIRA by Etienne Morency-Bachand [X], 1 year ago
    Cannot create PoolableConnectionFactory (Unknown database 'opal_data_sql123')
  • Stack trace

    • java.sql.SQLException: Cannot create PoolableConnectionFactory (Unknown database 'connect_db_1') at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294)[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039)[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533)[commons-dbcp2-2.1.1.jar:2.1.1] at com.memsql.spark.connector.MemSQLConnectionPool$.connect(MemSQLConnectionPool.scala:34)[memsql-connector_2.10-1.3.3.jar:1.3.3] at com.memsql.spark.connector.rdd.MemSQLRDD$$anon$1.<init>(MemSQLRDD.scala:241)[memsql-connector_2.10-1.3.3.jar:1.3.3] at com.memsql.spark.connector.rdd.MemSQLRDD.compute(MemSQLRDD.scala:231)[memsql-connector_2.10-1.3.3.jar:1.3.3] at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:300)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.RDD.iterator(RDD.scala:264)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:300)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.RDD.iterator(RDD.scala:264)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:300)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.RDD.iterator(RDD.scala:264)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.MapPartitionsRDD.compute(MapPartitionsRDD.scala:38)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.RDD.computeOrReadCheckpoint(RDD.scala:300)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.rdd.RDD.iterator(RDD.scala:264)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:66)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.scheduler.Task.run(Task.scala:88)[spark-core_2.10-1.5.2.jar:1.5.2] at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:214)[spark-core_2.10-1.5.2.jar:1.5.2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_92] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_92] at java.lang.Thread.run(Thread.java:745)[na:1.8.0_92] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'connect_db_1' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.8.0_92] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[na:1.8.0_92] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[na:1.8.0_92] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[na:1.8.0_92] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.Util.getInstance(Util.java:360)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1659)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1206)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2234)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2265)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2064)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)[mysql-connector-java-5.1.34.jar:5.1.34] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[na:1.8.0_92] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[na:1.8.0_92] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[na:1.8.0_92] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[na:1.8.0_92] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)[mysql-connector-java-5.1.34.jar:5.1.34] at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39)[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:256)[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2304)[commons-dbcp2-2.1.1.jar:2.1.1] at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2290)[commons-dbcp2-2.1.1.jar:2.1.1] ... 22 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    4 times, 2 weeks ago
    Once, 1 day ago
    Once, 6 days ago
    Once, 1 month ago
    Once, 1 month ago
    117 more bugmates