protected boolean hasResultSet() throws SQLException { return updateCounts == null && resultSet != null && resultSet.getMetaData().getColumnCount() > 0; }
protected boolean hasResultSet() throws SQLException { return updateCounts == null && resultSet != null && resultSet.getMetaData().getColumnCount() > 0; }
protected int findColumnIndex(String columnName) throws SQLException { if (this.columnMap == null) { columnMap = new TreeMap<String, Integer>(String.CASE_INSENSITIVE_ORDER); int colCount = getMetaData().getColumnCount(); for (int i = 1; i <= colCount; i++) { columnMap.put(getMetaData().getColumnLabel(i), i); } } Integer index = columnMap.get(columnName); if (index != null) { return index; } String msg = JDBCPlugin.Util.getString( "MMResultsImpl.Col_doesnt_exist", columnName); //$NON-NLS-1$ throw new TeiidSQLException(msg); }
protected int findColumnIndex(String columnName) throws SQLException { if (this.columnMap == null) { columnMap = new TreeMap<String, Integer>(String.CASE_INSENSITIVE_ORDER); int colCount = getMetaData().getColumnCount(); for (int i = 1; i <= colCount; i++) { columnMap.put(getMetaData().getColumnLabel(i), i); } } Integer index = columnMap.get(columnName); if (index != null) { return index; } String msg = JDBCPlugin.Util.getString( "MMResultsImpl.Col_doesnt_exist", columnName); //$NON-NLS-1$ throw new TeiidSQLException(msg); }
public ResultSet getTypeInfo() throws SQLException { if (driverConnection.getServerConnection().getServerVersion().compareTo("09.03") >= 0) { //$NON-NLS-1$ //use the system table ResultSetMetaData rmetadata = null; ResultSetImpl results = null; PreparedStatement prepareQuery = null; List<List<?>> records = new ArrayList<List<?>>(); try { prepareQuery = driverConnection.prepareStatement(QUERY_TYPEINFO); results = (ResultSetImpl) prepareQuery.executeQuery(); while (results.next ()) { List<Object> currentRow = new ArrayList<Object>(); for(int i=0; i < results.getMetaData().getColumnCount(); i++) { currentRow.add(results.getObject(i+1)); } records.add(currentRow); } rmetadata = results.getMetaData(); return dummyStatement().createResultSet(records, rmetadata); } catch (Exception e) { throw TeiidSQLException.create(e, JDBCPlugin.Util.getString("MMDatabaseMetadata.getTypeInfo_error", e.getMessage())); //$NON-NLS-1$ } finally { if (prepareQuery != null) { prepareQuery.close(); } } } return getStaticTypeInfo(); }
public ResultSet getTypeInfo() throws SQLException { if (driverConnection.getServerConnection().getServerVersion().compareTo("09.03") >= 0) { //$NON-NLS-1$ //use the system table ResultSetMetaData rmetadata = null; ResultSetImpl results = null; PreparedStatement prepareQuery = null; List<List<?>> records = new ArrayList<List<?>>(); try { prepareQuery = driverConnection.prepareStatement(QUERY_TYPEINFO); results = (ResultSetImpl) prepareQuery.executeQuery(); while (results.next ()) { List<Object> currentRow = new ArrayList<Object>(); for(int i=0; i < results.getMetaData().getColumnCount(); i++) { currentRow.add(results.getObject(i+1)); } records.add(currentRow); } rmetadata = results.getMetaData(); return dummyStatement().createResultSet(records, rmetadata); } catch (Exception e) { throw TeiidSQLException.create(e, JDBCPlugin.Util.getString("MMDatabaseMetadata.getTypeInfo_error", e.getMessage())); //$NON-NLS-1$ } finally { if (prepareQuery != null) { prepareQuery.close(); } } } return getStaticTypeInfo(); }
rmetadata = results.getMetaData();
rmetadata = results.getMetaData();
rmetadata = results.getMetaData();
rmetadata = results.getMetaData();
results = prepareQuery.executeQuery(); rmetadata = results.getMetaData(); int cols = rmetadata.getColumnCount(); while (results.next ()) {
results = prepareQuery.executeQuery(); rmetadata = results.getMetaData(); int cols = rmetadata.getColumnCount(); while (results.next ()) {
results = prepareQuery.executeQuery(); rmetadata = results.getMetaData(); int cols = rmetadata.getColumnCount(); while (results.next ()) {
rmetadata = results.getMetaData();
rmetadata = results.getMetaData();
public ResultSetMetaData getMetaData() throws SQLException { // check if the statement is open checkStatement(); if(metadata == null) { if (updateCounts != null) { return null; } else if(resultSet != null) { metadata = resultSet.getMetaData(); } else { Matcher matcher = StatementImpl.SHOW_STATEMENT.matcher(prepareSql); if (matcher.matches()) { this.executeShow(matcher); metadata = this.resultSet.getMetaData(); this.resultSet = null; return metadata; } if (getMetadataResults().getColumnMetadata() == null || getMetadataResults().getColumnMetadata().length == 0) { return null; } MetadataProvider provider = new MetadataProvider(getMetadataResults().getColumnMetadata()); metadata = new ResultSetMetaDataImpl(provider, this.getExecutionProperty(ExecutionProperties.JDBC4COLUMNNAMEANDLABELSEMANTICS)); } } return metadata; }
public ResultSetMetaData getMetaData() throws SQLException { // check if the statement is open checkStatement(); if(metadata == null) { if (updateCounts != null) { return null; } else if(resultSet != null) { metadata = resultSet.getMetaData(); } else { Matcher matcher = StatementImpl.SHOW_STATEMENT.matcher(prepareSql); if (matcher.matches()) { this.executeShow(matcher); metadata = this.resultSet.getMetaData(); this.resultSet = null; return metadata; } if (getMetadataResults().getColumnMetadata() == null || getMetadataResults().getColumnMetadata().length == 0) { return null; } MetadataProvider provider = new MetadataProvider(getMetadataResults().getColumnMetadata()); metadata = new ResultSetMetaDataImpl(provider, this.getExecutionProperty(ExecutionProperties.JDBC4COLUMNNAMEANDLABELSEMANTICS)); } } return metadata; }
/** test basic results-related metadata */ @Test public void testGetMetaData() throws SQLException { ResultSetImpl cs = helpExecuteQuery(); // check result set metadata // expected column info. List<String> columnName = getBQTRSMetaData1a(); List<Integer> columnType = getBQTRSMetaData1b(); List<String> columnTypeName = getBQTRSMetaData1c(); ResultSetMetaData rm = cs.getMetaData(); assertNotNull(rm); for (int j = 1; j <= rm.getColumnCount(); j++) { assertEquals(" Actual doesn't match with expected. ", columnName.get(j-1), rm.getColumnLabel(j)); //$NON-NLS-1$ assertEquals(" Actual doesn't match with expected. ", columnType.get(j-1), new Integer(rm.getColumnType(j))); //$NON-NLS-1$ assertEquals(" Actual doesn't match with expected. ", columnTypeName.get(j-1), rm.getColumnTypeName(j)); //$NON-NLS-1$ } cs.close(); }
@Test public void testGetMetaData() throws Exception { ResultSetImpl rs = new ResultSetImpl(exampleResultsMsg2a(), statement); ResultSetMetaData rmetadata = rs.getMetaData(); assertEquals(2, rmetadata.getColumnCount()); String[] columnNames = columnNames(); String[] dataTypes = dataTypes(); for (int i = 0; i < 2; i++) { assertEquals(columnNames[i], rmetadata.getColumnLabel(i + 1)); assertEquals(dataTypes[i], rmetadata.getColumnTypeName(i + 1)); } rs.close(); }
@Test public void testFindColumn() throws SQLException { ResultSetImpl cs = helpExecuteQuery(); ResultSetMetaData rm = cs.getMetaData(); assertNotNull(rm); //assertEquals(" Actual columnName doesn't match with expected. ", 1, cs.findColumn("BQT1.MediumA.IntKey")); assertEquals(" Actual columnName doesn't match with expected. ", 1, cs.findColumn("IntKey")); //$NON-NLS-1$ //$NON-NLS-2$ cs.close(); }