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

Stack Overflow | Nikhil Verma | 5 months ago
  1. 0

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

    Stack Overflow | 5 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 | 10 months 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 | 6 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 | 3 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 | 5 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