protected IDataSet createDataSetFromResultSet(ResultSet rs) throws DataSetException { final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, DialectType.MYSQL); if (!_firstRowOnly) { return rsds; } final int columnCount = rsds.getColumnCount(); final ColumnDisplayDefinition[] colDefs = rsds.getDataSetDefinition().getColumnDefinitions(); final Map<String, Object> data = new HashMap<String, Object>(); if (rsds.next(null)) { for (int i = 0; i < columnCount; ++i) { data.put(colDefs[i].getColumnName(), rsds.get(i)); } } return new MapDataSet(data); } }
protected IDataSet createDataSetFromResultSet(ResultSet rs) throws DataSetException { final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, getDialectType()); if (!_firstRowOnly) { return rsds; } final int columnCount = rsds.getColumnCount(); final ColumnDisplayDefinition[] colDefs = rsds.getDataSetDefinition().getColumnDefinitions(); final Map<String, Object> data = new HashMap<String, Object>(); if (rsds.next(null)) { for (int i = 0; i < columnCount; ++i) { data.put(colDefs[i].getColumnName(), rsds.get(i)); } } return new MapDataSet(data); } }
protected IDataSet createDataSetFromResultSet(ResultSet rs) throws DataSetException { final ResultSetDataSet rsds = new ResultSetDataSet(); rsds.setResultSet(rs, getDialectType()); if (!_firstRowOnly) { return rsds; } final int columnCount = rsds.getColumnCount(); final ColumnDisplayDefinition[] colDefs = rsds.getDataSetDefinition().getColumnDefinitions(); final Map<String, Object> data = new HashMap<String, Object>(); if (rsds.next(null)) { for (int i = 0; i < columnCount; ++i) { data.put(colDefs[i].getColumnName(), rsds.get(i)); } } return new MapDataSet(data); } }
/** * Create the <TT>IDataSet</TT> to be displayed in this tab. */ protected IDataSet createDataSet() throws DataSetException { final ISQLConnection conn = getSession().getSQLConnection(); final SQLDatabaseMetaData dmd = conn.getSQLMetaData(); ITableInfo ti = getTableInfo(); if (! "TABLE".equalsIgnoreCase(ti.getType())) { // Frontbase describes it's tables as "BASE TABLE". if (!DialectFactory.isFrontBase(dmd)) { return null; } } ResultSetDataSet rsds = dmd.getIndexInfo(getTableInfo(), indexIndices, true); rsds.next(null); String indexName = (String)rsds.get(1); if (indexName == null) { rsds.removeRow(0); } rsds.resetCursor(); return rsds; }
/** * Create the <TT>IDataSet</TT> to be displayed in this tab. */ protected IDataSet createDataSet() throws DataSetException { final ISQLConnection conn = getSession().getSQLConnection(); final SQLDatabaseMetaData dmd = conn.getSQLMetaData(); ITableInfo ti = getTableInfo(); if (! "TABLE".equalsIgnoreCase(ti.getType())) { // Frontbase describes it's tables as "BASE TABLE". if (!DialectFactory.isFrontBase(dmd)) { return null; } } ResultSetDataSet rsds = dmd.getIndexInfo(getTableInfo(), indexIndices, true); rsds.next(null); String indexName = (String)rsds.get(1); if (indexName == null) { rsds.removeRow(0); } rsds.resetCursor(); return rsds; }
metaData.getIndexInfo(tableInfo, indexColumnIndices, false); String indexName = ""; while (rsds.next(null)) { String thisIndexName = (String)rsds.get(0); if (thisIndexName != null) {