All Downloads are FREE. Search and download functionalities are using the official Maven repository.

oenix.phoenix-core.5.1.3.source-code.overview.html Maven / Gradle / Ivy

There is a newer version: 5.2.1
Show newest version




This document is for the JDBC implementation of Phoenix, targeting those who are interested in extending the level of SQL support.
For users of Phoenix, the programmatic API is JDBC.
For example, the following snippet demonstrates how to query a table:

        Properties props = new Properties();
        // Ensure the driver is on classpath
        // Connect through Phoenix to the zookeeper quorum with a host name of myServer
        Connection conn = DriverManager.getConnection("jdbc:phoenix:myServer", props);
        try {
            PreparedStatement statement = conn.prepareStatement("SELECT count(1) FROM product_metrics WHERE organization_id=?");
            statement.setString(1, orgId);
            ResultSet rs = statement.executeQuery();
            if (rs.next()) {
                System.out.println("Row count of orgId='" + orgId + "' is " + rs.getLong(1));
            }
        } finally {
            conn.close();
        }




© 2015 - 2024 Weber Informatics LLC | Privacy Policy