I can advice you just to check whether the required methods work in pure java, i.e. write an simple java cli-app, that checks available tables and databases. Here is a small snapshots of java-code, that queries for DB-meta information using JDBC.

import java.sql.Connection;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;
    private static DataSource getDataSource(){
        String login = "root", pwd = "kne";
        String url = "jdbc:mysql://localhost:3306/test";
        BasicDataSource ds = new BasicDataSource();
        ds.setDriverClassName("com.mysql.jdbc.Driver");
        ds.setUsername(login);
        ds.setPassword(pwd);
        ds.setUrl(url);
        return ds;
    }

    private static Object show(ResultSet rs, String title) throws Exce
+ption{
        Object r = null;
        System.out.println("[showing " + title + "]");
        ResultSetMetaData rsmd = rs.getMetaData();
        while(rs.next()){
            for(int c = 1; c <= rsmd.getColumnCount(); c++){
                String name = rsmd.getColumnName(c);
                Object value = rs.getObject(c);
                System.out.println(name + " : " + value);
                if(r == null){
                    r = value;
                }
            }
        }
        System.out.println();
        return r;
    }

    public static void main(String[] args) throws Exception{
        DataSource ds = getDataSource();
        Connection con = ds.getConnection();
        DatabaseMetaData dbMetaData = con.getMetaData();
        ResultSet catalogs = dbMetaData.getCatalogs();
        String catalog = (String)show(catalogs, "catalogs");
        ResultSet schemas = dbMetaData.getSchemas();
        String schema = (String)show(schemas, "schemas");
        ResultSet tables = dbMetaData.getTables("test", null, "", null
+);
        show(tables, "tables");
        System.out.println("ok");
    }
[download]

So, you should validate, that JDBC driver you provide, actually works, and supports metainformation retrieval. As altenative you can download SQuirrelSQL, attach your jdbc-drivers for Phoenix, and check, that it actually works.

So, it might be, that HBase or Phoenix, or JDBC driver does not support some operations. Only after assertion of that, you should look at perl's DBD::JDBC

PS. Too much bridges/layers!

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.