This program can be used as a template for your JDBC connectivity:
// JDBC Test Program import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.sql.ResultSet; public class jdbctest { static String userid="beehive", password = "beehive"; // Change the IP address to the node you want to connect to. static String url = "jdbc:ncluster://10.60.3.100:2406/beehive"; //2.0 static Connection con = null; public static void main(String[] args) throws Exception { Connection con = getJDBCConnection(); if(con!= null){ try { int count = 0; System.out.println("Got Connection."); DatabaseMetaData meta = con.getMetaData(); System.out.println("getDriverName: "+meta.getDriverName()); System.out.println("getDriverVersion: "+meta.getDriverVersion()); System.out.println("getDriverMajorVersion: "+meta.getDriverMajorVersion()); System.out.println("getDriverMinorVersion: "+meta.getDriverMinorVersion()); System.out.println("getDatabaseProductName: "+meta.getDatabaseProductName()); System.out.println("getDatabaseProductVersion: "+meta.getDatabaseProductVersion()); System.out.println("getIdentifierQuoteString: "+meta.getIdentifierQuoteString()); System.out.println("\ngetSQLKeywords: "+meta.getSQLKeywords()); System.out.println("\ngetNumericFunctions: "+meta.getNumericFunctions()); System.out.println("\ngetStringFunctions : "+meta.getStringFunctions()); System.out.println("getSystemFunctions : "+meta.getSystemFunctions()); System.out.println("getTimeDateFunctions : "+meta.getTimeDateFunctions()); System.out.println("getSearchStringEscape : "+meta.getSearchStringEscape()); System.out.println("getExtraNameCharacters : "+meta.getExtraNameCharacters()); System.out.println("getCatalogTerm : "+meta.getCatalogTerm()); System.out.println("getCatalogSeparator : "+meta.getCatalogSeparator()); System.out.println("getURL : "+meta.getURL()); System.out.println("getUserName : "+meta.getUserName()); System.out.println("getMaxCursorNameLength : "+meta.getMaxCursorNameLength()); System.out.println("getMaxSchemaNameLength : "+meta.getMaxSchemaNameLength()); System.out.println("getMaxProcedureNameLength : "+meta.getMaxProcedureNameLength()); System.out.println("getMaxCatalogNameLength : "+meta.getMaxCatalogNameLength()); System.out.println("getMaxColumnsInIndex : "+meta.getMaxColumnsInIndex()); System.out.println("supportsSubqueriesInComparisons : "+meta.supportsSubqueriesInComparisons()); System.out.println("getMaxConnections : "+meta.getMaxConnections()); System.out.println("getMaxColumnsInTable : "+meta.getMaxColumnsInTable()); System.out.println("isReadOnly : "+meta.isReadOnly()); System.out.println("\ngetCatalogs:"); ResultSet res = meta.getCatalogs(); while (res.next()) { System.out.println(res.getString(1)); } System.out.println("\ngetTables:"); res.close(); res = meta.getTables(null,null,"%",null); while (res.next()) { System.out.println(res.getString(1) +res.getString(2) +res.getString(3) +res.getString(4)); } System.out.println(""); res.close(); res = meta.getTableTypes(); System.out.println("\ngetTableTypes:"); while (res.next()) { System.out.println(res.getString(1)); } res.close(); Statement stmt=con.createStatement(); ResultSet rs = stmt.executeQuery("select count(*) from page_views"); while (rs.next()) { System.out.println(rs.getInt(1)); } rs.close(); stmt.close(); con.close(); } catch(SQLException ex) { System.err.println("SQLException: " + ex.getMessage()); } }else{ System.out.println("Could not Get Connection"); } } public static Connection getJDBCConnection(){ try { Class.forName("com.asterdata.ncluster.Driver"); } catch(java.lang.ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); System.err.println(e.getMessage()); } try { con = DriverManager.getConnection(url, userid, password); } catch(SQLException ex) { System.err.println("SQLException: " + ex.getMessage()); } return con; } }