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

John Sichi commented on HIVE-1335:
----------------------------------

If you use these settings, you'll get exactly what you're after:

{noformat}
<ivy-module version="2.0">
    <info organisation="org.apache.hadoop.hive" module="metastore"/>
    <dependencies>
        <dependency org="hadoop" name="core" 
rev="${hadoop.version.ant-internal}">
          <artifact name="hadoop" type="source" ext="tar.gz"/>
        </dependency> 
        <dependency org="commons-dbcp" name="commons-dbcp" rev="1.2.2">
          <exclude module="commons-pool" />
        </dependency>
        <dependency org="commons-pool" name="commons-pool" rev="1.2">
          <exclude module="commons-collections" />
          <exclude module="xerces" />
          <exclude module="xml-apis" />
        </dependency>
        <dependency org="org.datanucleus" name="datanucleus-connectionpool" 
rev="1.0.2">
          <exclude module="proxool" />
          <exclude module="c3p0" />
          <exclude module="datanucleus-core" />
          <exclude module="datanucleus-rdbms" />
          <exclude module="commons-collections" />
          <exclude module="commons-pool" />
        </dependency>
    </dependencies>
</ivy-module>

jsichi-mac:metastore jsichi$ ant ivy-retrieve
Buildfile: build.xml

ivy-init-dirs:

ivy-download:
      [get] Getting: 
http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar
      [get] To: /Users/jsichi/open/hive-trunk/build/ivy/lib/ivy-2.1.0.jar
      [get] Not modified - so not downloaded

ivy-probe-antlib:

ivy-init-antlib:

ivy-init:

ivy-resolve:
[ivy:resolve] :: Ivy 2.1.0 - 20090925235825 :: http://ant.apache.org/ivy/ ::
[ivy:resolve] :: loading settings :: file = 
/Users/jsichi/open/hive-trunk/ivy/ivysettings.xml
[ivy:resolve] downloading 
http://repo1.maven.org/maven2/commons-dbcp/commons-dbcp/1.2.2/commons-dbcp-1.2.2.jar
 ...
[ivy:resolve] .........................................................
[ivy:resolve] ............................. (118kB)
[ivy:resolve] .. (0kB)
[ivy:resolve]   [SUCCESSFUL ] commons-dbcp#commons-dbcp;1.2.2!commons-dbcp.jar 
(3271ms)
[ivy:resolve] downloading 
http://repo1.maven.org/maven2/commons-pool/commons-pool/1.2/commons-pool-1.2.jar
 ...
[ivy:resolve] ............................... (41kB)
[ivy:resolve] .. (0kB)
[ivy:resolve]   [SUCCESSFUL ] commons-pool#commons-pool;1.2!commons-pool.jar 
(2412ms)
[ivy:resolve] downloading 
http://repo1.maven.org/maven2/org/datanucleus/datanucleus-connectionpool/1.0.2/datanucleus-connectionpool-1.0.2.jar
 ...
[ivy:resolve] ............ (14kB)
[ivy:resolve] .. (0kB)
[ivy:resolve]   [SUCCESSFUL ] 
org.datanucleus#datanucleus-connectionpool;1.0.2!datanucleus-connectionpool.jar 
(2683ms)

ivy-retrieve:

BUILD SUCCESSFUL
{noformat}

Personally, I agree that the cost/benefit of ivy is shaky, but if Hive as a 
project has chosen it, then we should use it where possible.  If that decision 
needs to be revisited, then it would be good to resolve that.


> DataNucleus should use connection pooling
> -----------------------------------------
>
>                 Key: HIVE-1335
>                 URL: https://issues.apache.org/jira/browse/HIVE-1335
>             Project: Hadoop Hive
>          Issue Type: Improvement
>            Reporter: Edward Capriolo
>            Assignee: Edward Capriolo
>             Fix For: 0.6.0
>
>         Attachments: commons-dbcp-1.2.2.jar, commons-dbcp.LICENSE, 
> commons-pool-1.2.jar, commons-pool.LICENSE, 
> datanucleus-connectionpool-1.0.2.jar, datanucleus-connectionpool.LICENSE, 
> hive-1335.patch.txt
>
>
> Currently each Data Nucleus operation disconnects and reconnects to the 
> MetaStore over jdbc. Queries fail to even explain properly in cases where a 
> table has many partitions. This is fixed by enabling one parameter and 
> including several jars.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to