Phoenix Data Sources

Comment edited by Mark S :


Changes (2)

...

{code:language=html/xml|title= wildfly-10.0.0.Final/modules/org/apache/phoenix/main/module.xml}
<?xml version="1.0" ?>

...
</dependencies>
</module>{code}
{code:language=html/xml|title=Widlfly Datasource}

{code:language=html/xml|title=Widlfly Datasource Snippet}
<datasource jndi-name="java:jboss/datasources/PhoenixDS" pool-name="PhoenixDS" enabled="true" use-java-context="true">
<connection-url>jdbc:phoenix:server01:/hbase-unsecure</connection-url>
...

Full Content

I used the above information to configure a Phoenix DataSource for a Wildfly 10 instance and I thought I would share my results.

  • Phoenix User Group Post
  • Phoenix User Group Thread
wildfly-10.0.0.Final/modules/org/apache/phoenix/main/module.xml
<?xml version="1.0" ?>

<module xmlns="urn:jboss:module:1.1" name="org.apache.phoenix">

  <resources>
    <resource-root path="phoenix-4.4.0.2.4.0.0-169-client.jar">
      <filter>
        <exclude-set>
          <path name="javax" />
          <path name="org/xml" />
          <path name="org/w3c/dom" />
          <path name="org/w3c/sax" />
          <path name="javax/xml/parsers" />
          <path name="com/sun/org/apache/xerces/internal/jaxp" />
          <path name="org/apache/xerces/jaxp" />
          <path name="com/sun/jersey/core/impl/provider/xml" />
        </exclude-set>
      </filter>
    </resource-root>
  </resources>

  <dependencies>
    <module name="javax.api"/>
    <module name="sun.jdk"/>
    <module name="org.apache.log4j"/>
    <module name="javax.transaction.api"/>
    <module name="org.apache.commons.logging"/>
  </dependencies>
</module>
Widlfly Datasource Snippet
<datasource jndi-name="java:jboss/datasources/PhoenixDS" pool-name="PhoenixDS" enabled="true" use-java-context="true">
  <connection-url>jdbc:phoenix:server01:/hbase-unsecure</connection-url>
  <connection-property name="phoenix.connection.autoCommit">
    true
  </connection-property>
  <driver>phoenix</driver>
  <validation>
    <check-valid-connection-sql>SELECT 1 FROM SYSTEM.CATALOG LIMIT 1</check-valid-connection-sql>
  </validation>
</datasource>
Environment
Name Version
Phoenix
4.4
Wildfly
10.0.0.Final
Ambari
2.2.1.0
HDFS
2.7.1.2.4
MapReduce2
2.7.1.2.4
YARN
2.7.1.2.4
HBase
1.1.2.2.4
Stop watching space | Change email notification preferences
View Online | Reply To This