Does your Kylin server listen on default HTTP port 80? On 3/2/15, 5:53 PM, "Han, Luke" <[email protected]> wrote:
>Forward to mailing list for further support. > >Thanks. > > > > >On 2/27/15, 12:01, "cc mac" <[email protected]> wrote: > >> >> >>@Test >> public void testWithCubeData() throws SQLException, >>InstantiationException, IllegalAccessException, ClassNotFoundException { >> Driver driver = (Driver) >>Class.forName("com.kylinolap.jdbc.Driver").newInstance(); >> Properties info = new Properties(); >> info.put("user", "ADMIN"); >> info.put("password", "KYLIN"); >> Connection conn = >>driver.connect("jdbc:kylin://localhost/default", info); >> >> ResultSet catalogs = conn.getMetaData().getCatalogs(); >> while (catalogs.next()) { >> System.out.println(catalogs.getString("TABLE_CAT")); >> } >> >> ResultSet schemas = conn.getMetaData().getSchemas(); >> while (schemas.next()) { >> System.out.println(schemas.getString(1)); >> System.out.println(schemas.getString(2)); >> } >> >> ResultSet tables = conn.getMetaData().getTables(null, null, null, >>null); >> while (tables.next()) { >> String tableName = tables.getString(3); >> assertEquals(tables.getString("TABLE_NAME"), tableName); >> ResultSet columns = conn.getMetaData().getColumns(null, null, >>tableName, null); >> >> while (columns.next()) { >> System.out.println(columns.getString("COLUMN_NAME")); >> String column = ""; >> for (int i = 0; i < 23; i++) { >> column += columns.getString(i + 1) + ", "; >> } >> >> System.out.println("Column in table " + tableName + ": " >>+ column); >> } >> } >> >> for (int j = 0; j < 3; j++) { >> Statement state = conn.createStatement(); >> ResultSet resultSet = state.executeQuery("select * from >>test_kylin_fact"); >> >> ResultSetMetaData metadata = resultSet.getMetaData(); >> System.out.println("Metadata:"); >> >> for (int i = 0; i < metadata.getColumnCount(); i++) { >> String metaStr = metadata.getCatalogName(i + 1) + " " + >>metadata.getColumnClassName(i + 1) + " " + >>metadata.getColumnDisplaySize(i + 1) + " " + metadata.getColumnLabel(i + >>1) + " " + metadata.getColumnName(i + 1) + " " + metadata.getColumnType(i >>+ 1) + " " + metadata.getColumnTypeName(i + 1) + " " + >>metadata.getPrecision(i + 1) + " " + metadata.getScale(i + 1) + " " + >>metadata.getSchemaName(i + 1) + " " + metadata.getTableName(i + 1); >> System.out.println(metaStr); >> } >> >> System.out.println("Data:"); >> while (resultSet.next()) { >> String dataStr = resultSet.getFloat(1) + " " + >>resultSet.getInt(2) + " " + resultSet.getInt(3) + " " + >>resultSet.getLong(4) + " " + resultSet.getDate(5) + " " + >>resultSet.getString(6); >> System.out.println(dataStr); >> } >> } >> } >
