[jira] [Commented] (HIVE-11287) Hive Metastore does not tolerate leading spaces in JDBC url

["Chen Xin Yu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-11287?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14904036#comment-14904036 ] 

Chen Xin Yu commented on HIVE-11287:
------------------------------------

I tried with below configuration:
<property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>
              jdbc:mysql://xxx/hive?createDatabaseIfNotExist=true
      </value>
    </property>

It works well with me. so I'm wondering after you change your config and remove the spaces, if it also doesn't work.
I always get this failure when missing mysql-connector-java.jar in HIVE_LIB.

> Hive Metastore does not tolerate leading spaces in JDBC url
> -----------------------------------------------------------
>
>                 Key: HIVE-11287
>                 URL: https://issues.apache.org/jira/browse/HIVE-11287
>             Project: Hive
>          Issue Type: Bug
>          Components: Configuration, Metastore
>    Affects Versions: 1.2.0, 1.3.0, 2.0.0
>            Reporter: Gopal V
>            Priority: Minor
>              Labels: newbie
>
> The hive metastore is configured with
> {code}
>  <property>
>     <name>
>        javax.jdo.option.ConnectionURL
>     </name>
>     <value>
>        jdbc:mysql://hostname/hive
>    </value>
>   </property>
> {code}
> The initialization fails with an error 
> {code}
> java.sql.SQLException: No suitable driver found for
>     jdbc:mysql://hostname/hive
>         at java.sql.DriverManager.getConnection(DriverManager.java:689)
>         at java.sql.DriverManager.getConnection(DriverManager.java:208)
>         at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:361)
>         at com.jolbox.bonecp.BoneCP.obtainInternalConnection(BoneCP.java:269)
>         at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:242)
>         at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
>         at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:85)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>         at java.lang.Thread.run(Thread.java:745)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)