java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/metastore_db;create=true

Stack Overflow | Nikhil Verma | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    HIVE not working, No suitable driver found for jdbc:derby://localhost:1527

    Stack Overflow | 8 months ago | Nikhil Verma
    java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/metastore_db;create=true
  2. 0

    Hive giving error upon initialization

    Stack Overflow | 1 year ago | nishi jain
    java.sql.SQLException: No suitable driver found for jdbc:derby://localhost:1527/metastore_db;create=true
  3. 0

    GitHub comment 258#226719448

    GitHub | 8 months ago | giaosudau
    java.sql.SQLException: No suitable driver found for jdbc:snappydata:;user=HIVE_METASTORE;disable-streaming=true;default-persistent=true
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 46#19873820

    GitHub | 4 years ago | edofic
    java.net.UnknownHostException: 0f70808f132b: 0f70808f132b at at java.net.InetAddress.getLocalHost(InetAddress.java:1426) at at ch.qos.logback.core.util.ContextUtil.getLocalHostName(ContextUtil.java:32) at at ch.qos.logback.core.util.ContextUtil.addHostNameAsProperty(ContextUtil.java:41) at at ch.qos.logback.classic.joran.action.ConfigurationAction.begin(ConfigurationAction.java:48) at at ch.qos.logback.core.joran.spi.Interpreter.callBeginAction(Interpreter.java:276) at at ch.qos.logback.core.joran.spi.Interpreter.startElement(Interpreter.java:148) at at ch.qos.logback.core.joran.spi.Interpreter.startElement(Interpreter.java:130) at at ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:50) at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:147) at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:133) at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:96) at at ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:55) at at play.api.Logger$$anonfun$configure$8.apply(Logger.scala:251) at at play.api.Logger$$anonfun$configure$8.apply(Logger.scala:250) at at scala.Option.map(Option.scala:133) at at play.api.Logger$.configure(Logger.scala:250) at at play.api.Application.<init>(Application.scala:106) at at play.core.StaticApplication.<init>(ApplicationProvider.scala:49) at at play.core.server.NettyServer$.createServer(NettyServer.scala:133) at at play.core.server.NettyServer$$anonfun$main$5.apply(NettyServer.scala:162) at at play.core.server.NettyServer$$anonfun$main$5.apply(NettyServer.scala:161) at at scala.Option.map(Option.scala:133) at at play.core.server.NettyServer$.main(NettyServer.scala:161) at at play.core.server.NettyServer.main(NettyServer.scala) 13:06:23,852 |-INFO in ch.qos.logback.core.joran.action.ConversionRuleAction - registering conversion word coloredLevel with class [play.api.Logger$ColoredLevel] 13:06:23,852 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.FileAppender] 13:06:23,853 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [FILE] 13:06:23,882 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property 13:06:23,891 |-INFO in ch.qos.logback.core.FileAppender[FILE] - File property is set to [/app/target/../logs/application.log] 13:06:23,893 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender] 13:06:23,893 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT] 13:06:23,895 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property 13:06:23,896 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [play] to INFO 13:06:23,896 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [application] to INFO 13:06:23,897 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [com.avaje.ebean.config.PropertyMapLoader] to OFF 13:06:23,897 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [com.avaje.ebeaninternal.server.core.XmlConfigLoader] to OFF 13:06:23,897 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [com.avaje.ebeaninternal.server.lib.BackgroundThread] to OFF 13:06:23,897 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to ERROR 13:06:23,897 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [STDOUT] to Logger[ROOT] 13:06:23,897 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [FILE] to Logger[ROOT] 13:06:23,897 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@5b7b0998 - Registering current configuration as safe fallback point [error] c.j.b.h.AbstractConnectionHook - Failed to obtain initial connection Sleeping for 0ms and trying again. Attempts left: 0. Exception: null Oops, cannot start the server. /app/.profile.d/config_vars: line 2: -Xss512k: command not found /app/.profile.d/config_vars: line 3: -Xss512k: command not found Picked up JAVA_TOOL_OPTIONS: -Djava.rmi.server.useCodebaseOnly=true Configuration error: Configuration error [Cannot connect to database [default]]
  6. 0

    In memory test is not able to get oracle.jdbc.driver.oracledriver

    Google Groups | 7 months ago | Nimesh Nambiar
    java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=NO)(ADDRESS=(PROTOCOL=TCP)(HOST=SomeHost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SomeServerName)))
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    No suitable driver found for jdbc:derby://localhost:1527/metastore_db;create=true

    at java.sql.DriverManager.getConnection()
  2. Java RT
    DriverManager.getConnection
    1. java.sql.DriverManager.getConnection(DriverManager.java:689)
    2. java.sql.DriverManager.getConnection(DriverManager.java:208)
    2 frames
  3. BoneCP :: Core Library
    BoneCPDataSource.getConnection
    1. com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
    2. com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)
    3. com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)
    3 frames
  4. DataNucleus RDBMS plugin
    RDBMSStoreManager.<init>
    1. org.datanucleus.store.rdbms.ConnectionFactoryImpl$ManagedConnectionImpl.getConnection(ConnectionFactoryImpl.java:483)
    2. org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:296)
    2 frames
  5. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    4 frames
  6. DataNucleus Core
    PersistenceNucleusContextImpl.initialise
    1. org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:606)
    2. org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
    3. org.datanucleus.NucleusContextHelper.createStoreManagerForProperties(NucleusContextHelper.java:133)
    4. org.datanucleus.PersistenceNucleusContextImpl.initialise(PersistenceNucleusContextImpl.java:420)
    4 frames
  7. DataNucleus JDO API plugin
    JDOPersistenceManagerFactory.getPersistenceManagerFactory
    1. org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:821)
    2. org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:338)
    3. org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:217)
    3 frames
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  9. JDO API
    JDOHelper$16.run
    1. javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
    1 frame
  10. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  11. JDO API
    JDOHelper.getPersistenceManagerFactory
    1. javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
    2. javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
    3. javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
    4. javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
    4 frames
  12. Hive Metastore
    ObjectStore.setConf
    1. org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:424)
    2. org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:453)
    3. org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:327)
    4. org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:294)
    4 frames
  13. Hadoop
    ReflectionUtils.newInstance
    1. org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
    2. org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
    2 frames
  14. Hive Metastore
    HiveMetaStoreClient.<init>
    1. org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:58)
    2. org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67)
    3. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:581)
    4. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:546)
    5. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:612)
    6. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:398)
    7. org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:78)
    8. org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:84)
    9. org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:6396)
    10. org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:236)
    10 frames
  15. Hive Query Language
    SessionHiveMetaStoreClient.<init>
    1. org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:70)
    1 frame
  16. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    4 frames
  17. Hive Metastore
    RetryingMetaStoreClient.getProxy
    1. org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1625)
    2. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:80)
    3. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:130)
    4. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:101)
    4 frames
  18. Hive Query Language
    SessionState.beginStart
    1. org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3317)
    2. org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3356)
    3. org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3336)
    4. org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3590)
    5. org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:236)
    6. org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:221)
    7. org.apache.hadoop.hive.ql.metadata.Hive.<init>(Hive.java:366)
    8. org.apache.hadoop.hive.ql.metadata.Hive.create(Hive.java:310)
    9. org.apache.hadoop.hive.ql.metadata.Hive.getInternal(Hive.java:290)
    10. org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:266)
    11. org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:545)
    12. org.apache.hadoop.hive.ql.session.SessionState.beginStart(SessionState.java:518)
    12 frames
  19. org.apache.hadoop
    CliDriver.main
    1. org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:705)
    2. org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:641)
    2 frames
  20. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:498)
    4 frames
  21. Hadoop
    RunJar.main
    1. org.apache.hadoop.util.RunJar.run(RunJar.java:221)
    2. org.apache.hadoop.util.RunJar.main(RunJar.java:136)
    2 frames