incubator-blur-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amccu...@apache.org
Subject [32/51] [partial] Fixed BLUR-126.
Date Thu, 06 Jun 2013 18:58:04 GMT
http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSet.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSet.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSet.java
new file mode 100644
index 0000000..15b979a
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSet.java
@@ -0,0 +1,834 @@
+package org.apache.blur.jdbc.abstractimpl;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+import java.io.InputStream;
+import java.io.Reader;
+import java.lang.reflect.InvocationHandler;
+import java.lang.reflect.Method;
+import java.lang.reflect.Proxy;
+import java.math.BigDecimal;
+import java.net.URL;
+import java.sql.Array;
+import java.sql.Blob;
+import java.sql.Clob;
+import java.sql.Date;
+import java.sql.NClob;
+import java.sql.Ref;
+import java.sql.ResultSet;
+import java.sql.ResultSetMetaData;
+import java.sql.RowId;
+import java.sql.SQLException;
+import java.sql.SQLWarning;
+import java.sql.SQLXML;
+import java.sql.Statement;
+import java.sql.Time;
+import java.sql.Timestamp;
+import java.util.Calendar;
+import java.util.Map;
+
+import org.apache.blur.jdbc.util.NotImplemented;
+
+/**
+ * This ResultSet implementation is simply to provide the major of the
+ * method implementations that only throw not implemented exceptions. That way
+ * it's easier to see what has been implemented in the real class.
+ */
+public abstract class AbstractBlurResultSet implements ResultSet {
+
+  private ResultSet throwExceptionDelegate;
+
+  public AbstractBlurResultSet() {
+    throwExceptionDelegate = (ResultSet) Proxy.newProxyInstance(ResultSet.class.getClassLoader(),
+        new Class[] { ResultSet.class }, new InvocationHandler() {
+          @Override
+          public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
+            throw new NotImplemented(method.getName());
+          }
+        });
+  }
+
+  public boolean absolute(int row) throws SQLException {
+    return throwExceptionDelegate.absolute(row);
+  }
+
+  public void afterLast() throws SQLException {
+    throwExceptionDelegate.afterLast();
+  }
+
+  public void beforeFirst() throws SQLException {
+    throwExceptionDelegate.beforeFirst();
+  }
+
+  public void cancelRowUpdates() throws SQLException {
+    throwExceptionDelegate.cancelRowUpdates();
+  }
+
+  public void clearWarnings() throws SQLException {
+    throwExceptionDelegate.clearWarnings();
+  }
+
+  public void close() throws SQLException {
+    throwExceptionDelegate.close();
+  }
+
+  public void deleteRow() throws SQLException {
+    throwExceptionDelegate.deleteRow();
+  }
+
+  public int findColumn(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.findColumn(columnLabel);
+  }
+
+  public boolean first() throws SQLException {
+    return throwExceptionDelegate.first();
+  }
+
+  public Array getArray(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getArray(columnIndex);
+  }
+
+  public Array getArray(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getArray(columnLabel);
+  }
+
+  public InputStream getAsciiStream(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getAsciiStream(columnIndex);
+  }
+
+  public InputStream getAsciiStream(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getAsciiStream(columnLabel);
+  }
+
+  @SuppressWarnings("deprecation")
+  public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException {
+    return throwExceptionDelegate.getBigDecimal(columnIndex, scale);
+  }
+
+  public BigDecimal getBigDecimal(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getBigDecimal(columnIndex);
+  }
+
+  @SuppressWarnings("deprecation")
+  public BigDecimal getBigDecimal(String columnLabel, int scale) throws SQLException {
+    return throwExceptionDelegate.getBigDecimal(columnLabel, scale);
+  }
+
+  public BigDecimal getBigDecimal(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getBigDecimal(columnLabel);
+  }
+
+  public InputStream getBinaryStream(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getBinaryStream(columnIndex);
+  }
+
+  public InputStream getBinaryStream(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getBinaryStream(columnLabel);
+  }
+
+  public Blob getBlob(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getBlob(columnIndex);
+  }
+
+  public Blob getBlob(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getBlob(columnLabel);
+  }
+
+  public boolean getBoolean(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getBoolean(columnIndex);
+  }
+
+  public boolean getBoolean(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getBoolean(columnLabel);
+  }
+
+  public byte getByte(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getByte(columnIndex);
+  }
+
+  public byte getByte(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getByte(columnLabel);
+  }
+
+  public byte[] getBytes(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getBytes(columnIndex);
+  }
+
+  public byte[] getBytes(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getBytes(columnLabel);
+  }
+
+  public Reader getCharacterStream(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getCharacterStream(columnIndex);
+  }
+
+  public Reader getCharacterStream(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getCharacterStream(columnLabel);
+  }
+
+  public Clob getClob(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getClob(columnIndex);
+  }
+
+  public Clob getClob(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getClob(columnLabel);
+  }
+
+  public int getConcurrency() throws SQLException {
+    return throwExceptionDelegate.getConcurrency();
+  }
+
+  public String getCursorName() throws SQLException {
+    return throwExceptionDelegate.getCursorName();
+  }
+
+  public Date getDate(int columnIndex, Calendar cal) throws SQLException {
+    return throwExceptionDelegate.getDate(columnIndex, cal);
+  }
+
+  public Date getDate(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getDate(columnIndex);
+  }
+
+  public Date getDate(String columnLabel, Calendar cal) throws SQLException {
+    return throwExceptionDelegate.getDate(columnLabel, cal);
+  }
+
+  public Date getDate(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getDate(columnLabel);
+  }
+
+  public double getDouble(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getDouble(columnIndex);
+  }
+
+  public double getDouble(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getDouble(columnLabel);
+  }
+
+  public int getFetchDirection() throws SQLException {
+    return throwExceptionDelegate.getFetchDirection();
+  }
+
+  public int getFetchSize() throws SQLException {
+    return throwExceptionDelegate.getFetchSize();
+  }
+
+  public float getFloat(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getFloat(columnIndex);
+  }
+
+  public float getFloat(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getFloat(columnLabel);
+  }
+
+  public int getHoldability() throws SQLException {
+    return throwExceptionDelegate.getHoldability();
+  }
+
+  public int getInt(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getInt(columnIndex);
+  }
+
+  public int getInt(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getInt(columnLabel);
+  }
+
+  public long getLong(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getLong(columnIndex);
+  }
+
+  public long getLong(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getLong(columnLabel);
+  }
+
+  public ResultSetMetaData getMetaData() throws SQLException {
+    return throwExceptionDelegate.getMetaData();
+  }
+
+  public Reader getNCharacterStream(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getNCharacterStream(columnIndex);
+  }
+
+  public Reader getNCharacterStream(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getNCharacterStream(columnLabel);
+  }
+
+  public NClob getNClob(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getNClob(columnIndex);
+  }
+
+  public NClob getNClob(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getNClob(columnLabel);
+  }
+
+  public String getNString(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getNString(columnIndex);
+  }
+
+  public String getNString(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getNString(columnLabel);
+  }
+
+  public Object getObject(int columnIndex, Map<String, Class<?>> map) throws SQLException {
+    return throwExceptionDelegate.getObject(columnIndex, map);
+  }
+
+  public Object getObject(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getObject(columnIndex);
+  }
+
+  public Object getObject(String columnLabel, Map<String, Class<?>> map) throws SQLException {
+    return throwExceptionDelegate.getObject(columnLabel, map);
+  }
+
+  public Object getObject(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getObject(columnLabel);
+  }
+
+  public Ref getRef(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getRef(columnIndex);
+  }
+
+  public Ref getRef(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getRef(columnLabel);
+  }
+
+  public int getRow() throws SQLException {
+    return throwExceptionDelegate.getRow();
+  }
+
+  public RowId getRowId(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getRowId(columnIndex);
+  }
+
+  public RowId getRowId(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getRowId(columnLabel);
+  }
+
+  public short getShort(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getShort(columnIndex);
+  }
+
+  public short getShort(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getShort(columnLabel);
+  }
+
+  public SQLXML getSQLXML(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getSQLXML(columnIndex);
+  }
+
+  public SQLXML getSQLXML(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getSQLXML(columnLabel);
+  }
+
+  public Statement getStatement() throws SQLException {
+    return throwExceptionDelegate.getStatement();
+  }
+
+  public String getString(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getString(columnIndex);
+  }
+
+  public String getString(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getString(columnLabel);
+  }
+
+  public Time getTime(int columnIndex, Calendar cal) throws SQLException {
+    return throwExceptionDelegate.getTime(columnIndex, cal);
+  }
+
+  public Time getTime(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getTime(columnIndex);
+  }
+
+  public Time getTime(String columnLabel, Calendar cal) throws SQLException {
+    return throwExceptionDelegate.getTime(columnLabel, cal);
+  }
+
+  public Time getTime(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getTime(columnLabel);
+  }
+
+  public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException {
+    return throwExceptionDelegate.getTimestamp(columnIndex, cal);
+  }
+
+  public Timestamp getTimestamp(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getTimestamp(columnIndex);
+  }
+
+  public Timestamp getTimestamp(String columnLabel, Calendar cal) throws SQLException {
+    return throwExceptionDelegate.getTimestamp(columnLabel, cal);
+  }
+
+  public Timestamp getTimestamp(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getTimestamp(columnLabel);
+  }
+
+  public int getType() throws SQLException {
+    return throwExceptionDelegate.getType();
+  }
+
+  @SuppressWarnings("deprecation")
+  public InputStream getUnicodeStream(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getUnicodeStream(columnIndex);
+  }
+
+  @SuppressWarnings("deprecation")
+  public InputStream getUnicodeStream(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getUnicodeStream(columnLabel);
+  }
+
+  public URL getURL(int columnIndex) throws SQLException {
+    return throwExceptionDelegate.getURL(columnIndex);
+  }
+
+  public URL getURL(String columnLabel) throws SQLException {
+    return throwExceptionDelegate.getURL(columnLabel);
+  }
+
+  public SQLWarning getWarnings() throws SQLException {
+    return throwExceptionDelegate.getWarnings();
+  }
+
+  public void insertRow() throws SQLException {
+    throwExceptionDelegate.insertRow();
+  }
+
+  public boolean isAfterLast() throws SQLException {
+    return throwExceptionDelegate.isAfterLast();
+  }
+
+  public boolean isBeforeFirst() throws SQLException {
+    return throwExceptionDelegate.isBeforeFirst();
+  }
+
+  public boolean isClosed() throws SQLException {
+    return throwExceptionDelegate.isClosed();
+  }
+
+  public boolean isFirst() throws SQLException {
+    return throwExceptionDelegate.isFirst();
+  }
+
+  public boolean isLast() throws SQLException {
+    return throwExceptionDelegate.isLast();
+  }
+
+  public boolean isWrapperFor(Class<?> iface) throws SQLException {
+    return throwExceptionDelegate.isWrapperFor(iface);
+  }
+
+  public boolean last() throws SQLException {
+    return throwExceptionDelegate.last();
+  }
+
+  public void moveToCurrentRow() throws SQLException {
+    throwExceptionDelegate.moveToCurrentRow();
+  }
+
+  public void moveToInsertRow() throws SQLException {
+    throwExceptionDelegate.moveToInsertRow();
+  }
+
+  public boolean next() throws SQLException {
+    return throwExceptionDelegate.next();
+  }
+
+  public boolean previous() throws SQLException {
+    return throwExceptionDelegate.previous();
+  }
+
+  public void refreshRow() throws SQLException {
+    throwExceptionDelegate.refreshRow();
+  }
+
+  public boolean relative(int rows) throws SQLException {
+    return throwExceptionDelegate.relative(rows);
+  }
+
+  public boolean rowDeleted() throws SQLException {
+    return throwExceptionDelegate.rowDeleted();
+  }
+
+  public boolean rowInserted() throws SQLException {
+    return throwExceptionDelegate.rowInserted();
+  }
+
+  public boolean rowUpdated() throws SQLException {
+    return throwExceptionDelegate.rowUpdated();
+  }
+
+  public void setFetchDirection(int direction) throws SQLException {
+    throwExceptionDelegate.setFetchDirection(direction);
+  }
+
+  public void setFetchSize(int rows) throws SQLException {
+    throwExceptionDelegate.setFetchSize(rows);
+  }
+
+  public <T> T unwrap(Class<T> iface) throws SQLException {
+    return throwExceptionDelegate.unwrap(iface);
+  }
+
+  public void updateArray(int columnIndex, Array x) throws SQLException {
+    throwExceptionDelegate.updateArray(columnIndex, x);
+  }
+
+  public void updateArray(String columnLabel, Array x) throws SQLException {
+    throwExceptionDelegate.updateArray(columnLabel, x);
+  }
+
+  public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException {
+    throwExceptionDelegate.updateAsciiStream(columnIndex, x, length);
+  }
+
+  public void updateAsciiStream(int columnIndex, InputStream x, long length) throws SQLException {
+    throwExceptionDelegate.updateAsciiStream(columnIndex, x, length);
+  }
+
+  public void updateAsciiStream(int columnIndex, InputStream x) throws SQLException {
+    throwExceptionDelegate.updateAsciiStream(columnIndex, x);
+  }
+
+  public void updateAsciiStream(String columnLabel, InputStream x, int length) throws SQLException {
+    throwExceptionDelegate.updateAsciiStream(columnLabel, x, length);
+  }
+
+  public void updateAsciiStream(String columnLabel, InputStream x, long length) throws SQLException {
+    throwExceptionDelegate.updateAsciiStream(columnLabel, x, length);
+  }
+
+  public void updateAsciiStream(String columnLabel, InputStream x) throws SQLException {
+    throwExceptionDelegate.updateAsciiStream(columnLabel, x);
+  }
+
+  public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException {
+    throwExceptionDelegate.updateBigDecimal(columnIndex, x);
+  }
+
+  public void updateBigDecimal(String columnLabel, BigDecimal x) throws SQLException {
+    throwExceptionDelegate.updateBigDecimal(columnLabel, x);
+  }
+
+  public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException {
+    throwExceptionDelegate.updateBinaryStream(columnIndex, x, length);
+  }
+
+  public void updateBinaryStream(int columnIndex, InputStream x, long length) throws SQLException {
+    throwExceptionDelegate.updateBinaryStream(columnIndex, x, length);
+  }
+
+  public void updateBinaryStream(int columnIndex, InputStream x) throws SQLException {
+    throwExceptionDelegate.updateBinaryStream(columnIndex, x);
+  }
+
+  public void updateBinaryStream(String columnLabel, InputStream x, int length) throws SQLException {
+    throwExceptionDelegate.updateBinaryStream(columnLabel, x, length);
+  }
+
+  public void updateBinaryStream(String columnLabel, InputStream x, long length) throws SQLException {
+    throwExceptionDelegate.updateBinaryStream(columnLabel, x, length);
+  }
+
+  public void updateBinaryStream(String columnLabel, InputStream x) throws SQLException {
+    throwExceptionDelegate.updateBinaryStream(columnLabel, x);
+  }
+
+  public void updateBlob(int columnIndex, Blob x) throws SQLException {
+    throwExceptionDelegate.updateBlob(columnIndex, x);
+  }
+
+  public void updateBlob(int columnIndex, InputStream inputStream, long length) throws SQLException {
+    throwExceptionDelegate.updateBlob(columnIndex, inputStream, length);
+  }
+
+  public void updateBlob(int columnIndex, InputStream inputStream) throws SQLException {
+    throwExceptionDelegate.updateBlob(columnIndex, inputStream);
+  }
+
+  public void updateBlob(String columnLabel, Blob x) throws SQLException {
+    throwExceptionDelegate.updateBlob(columnLabel, x);
+  }
+
+  public void updateBlob(String columnLabel, InputStream inputStream, long length) throws SQLException {
+    throwExceptionDelegate.updateBlob(columnLabel, inputStream, length);
+  }
+
+  public void updateBlob(String columnLabel, InputStream inputStream) throws SQLException {
+    throwExceptionDelegate.updateBlob(columnLabel, inputStream);
+  }
+
+  public void updateBoolean(int columnIndex, boolean x) throws SQLException {
+    throwExceptionDelegate.updateBoolean(columnIndex, x);
+  }
+
+  public void updateBoolean(String columnLabel, boolean x) throws SQLException {
+    throwExceptionDelegate.updateBoolean(columnLabel, x);
+  }
+
+  public void updateByte(int columnIndex, byte x) throws SQLException {
+    throwExceptionDelegate.updateByte(columnIndex, x);
+  }
+
+  public void updateByte(String columnLabel, byte x) throws SQLException {
+    throwExceptionDelegate.updateByte(columnLabel, x);
+  }
+
+  public void updateBytes(int columnIndex, byte[] x) throws SQLException {
+    throwExceptionDelegate.updateBytes(columnIndex, x);
+  }
+
+  public void updateBytes(String columnLabel, byte[] x) throws SQLException {
+    throwExceptionDelegate.updateBytes(columnLabel, x);
+  }
+
+  public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException {
+    throwExceptionDelegate.updateCharacterStream(columnIndex, x, length);
+  }
+
+  public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException {
+    throwExceptionDelegate.updateCharacterStream(columnIndex, x, length);
+  }
+
+  public void updateCharacterStream(int columnIndex, Reader x) throws SQLException {
+    throwExceptionDelegate.updateCharacterStream(columnIndex, x);
+  }
+
+  public void updateCharacterStream(String columnLabel, Reader reader, int length) throws SQLException {
+    throwExceptionDelegate.updateCharacterStream(columnLabel, reader, length);
+  }
+
+  public void updateCharacterStream(String columnLabel, Reader reader, long length) throws SQLException {
+    throwExceptionDelegate.updateCharacterStream(columnLabel, reader, length);
+  }
+
+  public void updateCharacterStream(String columnLabel, Reader reader) throws SQLException {
+    throwExceptionDelegate.updateCharacterStream(columnLabel, reader);
+  }
+
+  public void updateClob(int columnIndex, Clob x) throws SQLException {
+    throwExceptionDelegate.updateClob(columnIndex, x);
+  }
+
+  public void updateClob(int columnIndex, Reader reader, long length) throws SQLException {
+    throwExceptionDelegate.updateClob(columnIndex, reader, length);
+  }
+
+  public void updateClob(int columnIndex, Reader reader) throws SQLException {
+    throwExceptionDelegate.updateClob(columnIndex, reader);
+  }
+
+  public void updateClob(String columnLabel, Clob x) throws SQLException {
+    throwExceptionDelegate.updateClob(columnLabel, x);
+  }
+
+  public void updateClob(String columnLabel, Reader reader, long length) throws SQLException {
+    throwExceptionDelegate.updateClob(columnLabel, reader, length);
+  }
+
+  public void updateClob(String columnLabel, Reader reader) throws SQLException {
+    throwExceptionDelegate.updateClob(columnLabel, reader);
+  }
+
+  public void updateDate(int columnIndex, Date x) throws SQLException {
+    throwExceptionDelegate.updateDate(columnIndex, x);
+  }
+
+  public void updateDate(String columnLabel, Date x) throws SQLException {
+    throwExceptionDelegate.updateDate(columnLabel, x);
+  }
+
+  public void updateDouble(int columnIndex, double x) throws SQLException {
+    throwExceptionDelegate.updateDouble(columnIndex, x);
+  }
+
+  public void updateDouble(String columnLabel, double x) throws SQLException {
+    throwExceptionDelegate.updateDouble(columnLabel, x);
+  }
+
+  public void updateFloat(int columnIndex, float x) throws SQLException {
+    throwExceptionDelegate.updateFloat(columnIndex, x);
+  }
+
+  public void updateFloat(String columnLabel, float x) throws SQLException {
+    throwExceptionDelegate.updateFloat(columnLabel, x);
+  }
+
+  public void updateInt(int columnIndex, int x) throws SQLException {
+    throwExceptionDelegate.updateInt(columnIndex, x);
+  }
+
+  public void updateInt(String columnLabel, int x) throws SQLException {
+    throwExceptionDelegate.updateInt(columnLabel, x);
+  }
+
+  public void updateLong(int columnIndex, long x) throws SQLException {
+    throwExceptionDelegate.updateLong(columnIndex, x);
+  }
+
+  public void updateLong(String columnLabel, long x) throws SQLException {
+    throwExceptionDelegate.updateLong(columnLabel, x);
+  }
+
+  public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException {
+    throwExceptionDelegate.updateNCharacterStream(columnIndex, x, length);
+  }
+
+  public void updateNCharacterStream(int columnIndex, Reader x) throws SQLException {
+    throwExceptionDelegate.updateNCharacterStream(columnIndex, x);
+  }
+
+  public void updateNCharacterStream(String columnLabel, Reader reader, long length) throws SQLException {
+    throwExceptionDelegate.updateNCharacterStream(columnLabel, reader, length);
+  }
+
+  public void updateNCharacterStream(String columnLabel, Reader reader) throws SQLException {
+    throwExceptionDelegate.updateNCharacterStream(columnLabel, reader);
+  }
+
+  public void updateNClob(int columnIndex, NClob nClob) throws SQLException {
+    throwExceptionDelegate.updateNClob(columnIndex, nClob);
+  }
+
+  public void updateNClob(int columnIndex, Reader reader, long length) throws SQLException {
+    throwExceptionDelegate.updateNClob(columnIndex, reader, length);
+  }
+
+  public void updateNClob(int columnIndex, Reader reader) throws SQLException {
+    throwExceptionDelegate.updateNClob(columnIndex, reader);
+  }
+
+  public void updateNClob(String columnLabel, NClob nClob) throws SQLException {
+    throwExceptionDelegate.updateNClob(columnLabel, nClob);
+  }
+
+  public void updateNClob(String columnLabel, Reader reader, long length) throws SQLException {
+    throwExceptionDelegate.updateNClob(columnLabel, reader, length);
+  }
+
+  public void updateNClob(String columnLabel, Reader reader) throws SQLException {
+    throwExceptionDelegate.updateNClob(columnLabel, reader);
+  }
+
+  public void updateNString(int columnIndex, String nString) throws SQLException {
+    throwExceptionDelegate.updateNString(columnIndex, nString);
+  }
+
+  public void updateNString(String columnLabel, String nString) throws SQLException {
+    throwExceptionDelegate.updateNString(columnLabel, nString);
+  }
+
+  public void updateNull(int columnIndex) throws SQLException {
+    throwExceptionDelegate.updateNull(columnIndex);
+  }
+
+  public void updateNull(String columnLabel) throws SQLException {
+    throwExceptionDelegate.updateNull(columnLabel);
+  }
+
+  public void updateObject(int columnIndex, Object x, int scaleOrLength) throws SQLException {
+    throwExceptionDelegate.updateObject(columnIndex, x, scaleOrLength);
+  }
+
+  public void updateObject(int columnIndex, Object x) throws SQLException {
+    throwExceptionDelegate.updateObject(columnIndex, x);
+  }
+
+  public void updateObject(String columnLabel, Object x, int scaleOrLength) throws SQLException {
+    throwExceptionDelegate.updateObject(columnLabel, x, scaleOrLength);
+  }
+
+  public void updateObject(String columnLabel, Object x) throws SQLException {
+    throwExceptionDelegate.updateObject(columnLabel, x);
+  }
+
+  public void updateRef(int columnIndex, Ref x) throws SQLException {
+    throwExceptionDelegate.updateRef(columnIndex, x);
+  }
+
+  public void updateRef(String columnLabel, Ref x) throws SQLException {
+    throwExceptionDelegate.updateRef(columnLabel, x);
+  }
+
+  public void updateRow() throws SQLException {
+    throwExceptionDelegate.updateRow();
+  }
+
+  public void updateRowId(int columnIndex, RowId x) throws SQLException {
+    throwExceptionDelegate.updateRowId(columnIndex, x);
+  }
+
+  public void updateRowId(String columnLabel, RowId x) throws SQLException {
+    throwExceptionDelegate.updateRowId(columnLabel, x);
+  }
+
+  public void updateShort(int columnIndex, short x) throws SQLException {
+    throwExceptionDelegate.updateShort(columnIndex, x);
+  }
+
+  public void updateShort(String columnLabel, short x) throws SQLException {
+    throwExceptionDelegate.updateShort(columnLabel, x);
+  }
+
+  public void updateSQLXML(int columnIndex, SQLXML xmlObject) throws SQLException {
+    throwExceptionDelegate.updateSQLXML(columnIndex, xmlObject);
+  }
+
+  public void updateSQLXML(String columnLabel, SQLXML xmlObject) throws SQLException {
+    throwExceptionDelegate.updateSQLXML(columnLabel, xmlObject);
+  }
+
+  public void updateString(int columnIndex, String x) throws SQLException {
+    throwExceptionDelegate.updateString(columnIndex, x);
+  }
+
+  public void updateString(String columnLabel, String x) throws SQLException {
+    throwExceptionDelegate.updateString(columnLabel, x);
+  }
+
+  public void updateTime(int columnIndex, Time x) throws SQLException {
+    throwExceptionDelegate.updateTime(columnIndex, x);
+  }
+
+  public void updateTime(String columnLabel, Time x) throws SQLException {
+    throwExceptionDelegate.updateTime(columnLabel, x);
+  }
+
+  public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException {
+    throwExceptionDelegate.updateTimestamp(columnIndex, x);
+  }
+
+  public void updateTimestamp(String columnLabel, Timestamp x) throws SQLException {
+    throwExceptionDelegate.updateTimestamp(columnLabel, x);
+  }
+
+  public boolean wasNull() throws SQLException {
+    return throwExceptionDelegate.wasNull();
+  }
+
+  // java 7
+
+  public <T> T getObject(int columnIndex, Class<T> type) throws SQLException {
+    throw new SQLException("No supported");
+  }
+
+  public <T> T getObject(String columnLabel, Class<T> type) throws SQLException {
+    throw new SQLException("No supported");
+  }
+}

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSetMetaData.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSetMetaData.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSetMetaData.java
new file mode 100644
index 0000000..7b39828
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurResultSetMetaData.java
@@ -0,0 +1,138 @@
+package org.apache.blur.jdbc.abstractimpl;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+import java.lang.reflect.InvocationHandler;
+import java.lang.reflect.Method;
+import java.lang.reflect.Proxy;
+import java.sql.ResultSetMetaData;
+import java.sql.SQLException;
+
+import org.apache.blur.jdbc.util.NotImplemented;
+
+/**
+ * This ResultSetMetaData implementation is simply to provide the major of the
+ * method implementations that only throw not implemented exceptions. That way
+ * it's easier to see what has been implemented in the real class.
+ */
+public abstract class AbstractBlurResultSetMetaData implements ResultSetMetaData {
+
+  private ResultSetMetaData throwExceptionDelegate;
+
+  public AbstractBlurResultSetMetaData() {
+    throwExceptionDelegate = (ResultSetMetaData) Proxy.newProxyInstance(ResultSetMetaData.class.getClassLoader(),
+        new Class[] { ResultSetMetaData.class }, new InvocationHandler() {
+          @Override
+          public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
+            throw new NotImplemented(method.getName());
+          }
+        });
+  }
+
+  public String getCatalogName(int column) throws SQLException {
+    return throwExceptionDelegate.getCatalogName(column);
+  }
+
+  public String getColumnClassName(int column) throws SQLException {
+    return throwExceptionDelegate.getColumnClassName(column);
+  }
+
+  public int getColumnCount() throws SQLException {
+    return throwExceptionDelegate.getColumnCount();
+  }
+
+  public int getColumnDisplaySize(int column) throws SQLException {
+    return throwExceptionDelegate.getColumnDisplaySize(column);
+  }
+
+  public String getColumnLabel(int column) throws SQLException {
+    return throwExceptionDelegate.getColumnLabel(column);
+  }
+
+  public String getColumnName(int column) throws SQLException {
+    return throwExceptionDelegate.getColumnName(column);
+  }
+
+  public int getColumnType(int column) throws SQLException {
+    return throwExceptionDelegate.getColumnType(column);
+  }
+
+  public String getColumnTypeName(int column) throws SQLException {
+    return throwExceptionDelegate.getColumnTypeName(column);
+  }
+
+  public int getPrecision(int column) throws SQLException {
+    return throwExceptionDelegate.getPrecision(column);
+  }
+
+  public int getScale(int column) throws SQLException {
+    return throwExceptionDelegate.getScale(column);
+  }
+
+  public String getSchemaName(int column) throws SQLException {
+    return throwExceptionDelegate.getSchemaName(column);
+  }
+
+  public String getTableName(int column) throws SQLException {
+    return throwExceptionDelegate.getTableName(column);
+  }
+
+  public boolean isAutoIncrement(int column) throws SQLException {
+    return throwExceptionDelegate.isAutoIncrement(column);
+  }
+
+  public boolean isCaseSensitive(int column) throws SQLException {
+    return throwExceptionDelegate.isCaseSensitive(column);
+  }
+
+  public boolean isCurrency(int column) throws SQLException {
+    return throwExceptionDelegate.isCurrency(column);
+  }
+
+  public boolean isDefinitelyWritable(int column) throws SQLException {
+    return throwExceptionDelegate.isDefinitelyWritable(column);
+  }
+
+  public int isNullable(int column) throws SQLException {
+    return throwExceptionDelegate.isNullable(column);
+  }
+
+  public boolean isReadOnly(int column) throws SQLException {
+    return throwExceptionDelegate.isReadOnly(column);
+  }
+
+  public boolean isSearchable(int column) throws SQLException {
+    return throwExceptionDelegate.isSearchable(column);
+  }
+
+  public boolean isSigned(int column) throws SQLException {
+    return throwExceptionDelegate.isSigned(column);
+  }
+
+  public boolean isWrapperFor(Class<?> iface) throws SQLException {
+    return throwExceptionDelegate.isWrapperFor(iface);
+  }
+
+  public boolean isWritable(int column) throws SQLException {
+    return throwExceptionDelegate.isWritable(column);
+  }
+
+  public <T> T unwrap(Class<T> iface) throws SQLException {
+    return throwExceptionDelegate.unwrap(iface);
+  }
+
+}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurStatement.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurStatement.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurStatement.java
new file mode 100644
index 0000000..c986b72
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/abstractimpl/AbstractBlurStatement.java
@@ -0,0 +1,227 @@
+package org.apache.blur.jdbc.abstractimpl;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+import java.lang.reflect.InvocationHandler;
+import java.lang.reflect.Method;
+import java.lang.reflect.Proxy;
+import java.sql.Connection;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.SQLWarning;
+import java.sql.Statement;
+
+import org.apache.blur.jdbc.util.NotImplemented;
+
+/**
+ * This Statement implementation is simply to provide the major of the
+ * method implementations that only throw not implemented exceptions. That way
+ * it's easier to see what has been implemented in the real class.
+ */
+public class AbstractBlurStatement implements Statement {
+
+  private Statement throwExceptionDelegate;
+
+  public AbstractBlurStatement() {
+    throwExceptionDelegate = (Statement) Proxy.newProxyInstance(Statement.class.getClassLoader(),
+        new Class[] { Statement.class }, new InvocationHandler() {
+          @Override
+          public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
+            throw new NotImplemented(method.getName());
+          }
+        });
+  }
+
+  public void addBatch(String sql) throws SQLException {
+    throwExceptionDelegate.addBatch(sql);
+  }
+
+  public void cancel() throws SQLException {
+    throwExceptionDelegate.cancel();
+  }
+
+  public void clearBatch() throws SQLException {
+    throwExceptionDelegate.clearBatch();
+  }
+
+  public void clearWarnings() throws SQLException {
+    throwExceptionDelegate.clearWarnings();
+  }
+
+  public void close() throws SQLException {
+    throwExceptionDelegate.close();
+  }
+
+  public boolean execute(String sql, int autoGeneratedKeys) throws SQLException {
+    return throwExceptionDelegate.execute(sql, autoGeneratedKeys);
+  }
+
+  public boolean execute(String sql, int[] columnIndexes) throws SQLException {
+    return throwExceptionDelegate.execute(sql, columnIndexes);
+  }
+
+  public boolean execute(String sql, String[] columnNames) throws SQLException {
+    return throwExceptionDelegate.execute(sql, columnNames);
+  }
+
+  public boolean execute(String sql) throws SQLException {
+    return throwExceptionDelegate.execute(sql);
+  }
+
+  public int[] executeBatch() throws SQLException {
+    return throwExceptionDelegate.executeBatch();
+  }
+
+  public ResultSet executeQuery(String sql) throws SQLException {
+    return throwExceptionDelegate.executeQuery(sql);
+  }
+
+  public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException {
+    return throwExceptionDelegate.executeUpdate(sql, autoGeneratedKeys);
+  }
+
+  public int executeUpdate(String sql, int[] columnIndexes) throws SQLException {
+    return throwExceptionDelegate.executeUpdate(sql, columnIndexes);
+  }
+
+  public int executeUpdate(String sql, String[] columnNames) throws SQLException {
+    return throwExceptionDelegate.executeUpdate(sql, columnNames);
+  }
+
+  public int executeUpdate(String sql) throws SQLException {
+    return throwExceptionDelegate.executeUpdate(sql);
+  }
+
+  public Connection getConnection() throws SQLException {
+    return throwExceptionDelegate.getConnection();
+  }
+
+  public int getFetchDirection() throws SQLException {
+    return throwExceptionDelegate.getFetchDirection();
+  }
+
+  public int getFetchSize() throws SQLException {
+    return throwExceptionDelegate.getFetchSize();
+  }
+
+  public ResultSet getGeneratedKeys() throws SQLException {
+    return throwExceptionDelegate.getGeneratedKeys();
+  }
+
+  public int getMaxFieldSize() throws SQLException {
+    return throwExceptionDelegate.getMaxFieldSize();
+  }
+
+  public int getMaxRows() throws SQLException {
+    return throwExceptionDelegate.getMaxRows();
+  }
+
+  public boolean getMoreResults() throws SQLException {
+    return throwExceptionDelegate.getMoreResults();
+  }
+
+  public boolean getMoreResults(int current) throws SQLException {
+    return throwExceptionDelegate.getMoreResults(current);
+  }
+
+  public int getQueryTimeout() throws SQLException {
+    return throwExceptionDelegate.getQueryTimeout();
+  }
+
+  public ResultSet getResultSet() throws SQLException {
+    return throwExceptionDelegate.getResultSet();
+  }
+
+  public int getResultSetConcurrency() throws SQLException {
+    return throwExceptionDelegate.getResultSetConcurrency();
+  }
+
+  public int getResultSetHoldability() throws SQLException {
+    return throwExceptionDelegate.getResultSetHoldability();
+  }
+
+  public int getResultSetType() throws SQLException {
+    return throwExceptionDelegate.getResultSetType();
+  }
+
+  public int getUpdateCount() throws SQLException {
+    return throwExceptionDelegate.getUpdateCount();
+  }
+
+  public SQLWarning getWarnings() throws SQLException {
+    return throwExceptionDelegate.getWarnings();
+  }
+
+  public boolean isClosed() throws SQLException {
+    return throwExceptionDelegate.isClosed();
+  }
+
+  public boolean isPoolable() throws SQLException {
+    return throwExceptionDelegate.isPoolable();
+  }
+
+  public boolean isWrapperFor(Class<?> iface) throws SQLException {
+    return throwExceptionDelegate.isWrapperFor(iface);
+  }
+
+  public void setCursorName(String name) throws SQLException {
+    throwExceptionDelegate.setCursorName(name);
+  }
+
+  public void setEscapeProcessing(boolean enable) throws SQLException {
+    throwExceptionDelegate.setEscapeProcessing(enable);
+  }
+
+  public void setFetchDirection(int direction) throws SQLException {
+    throwExceptionDelegate.setFetchDirection(direction);
+  }
+
+  public void setFetchSize(int rows) throws SQLException {
+    throwExceptionDelegate.setFetchSize(rows);
+  }
+
+  public void setMaxFieldSize(int max) throws SQLException {
+    throwExceptionDelegate.setMaxFieldSize(max);
+  }
+
+  public void setMaxRows(int max) throws SQLException {
+    throwExceptionDelegate.setMaxRows(max);
+  }
+
+  public void setPoolable(boolean poolable) throws SQLException {
+    throwExceptionDelegate.setPoolable(poolable);
+  }
+
+  public void setQueryTimeout(int seconds) throws SQLException {
+    throwExceptionDelegate.setQueryTimeout(seconds);
+  }
+
+  public <T> T unwrap(Class<T> iface) throws SQLException {
+    return throwExceptionDelegate.unwrap(iface);
+  }
+
+  // java 7
+
+  public void closeOnCompletion() throws SQLException {
+    throw new SQLException("No supported");
+  }
+
+  public boolean isCloseOnCompletion() throws SQLException {
+    throw new SQLException("No supported");
+  }
+
+}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/parser/Parser.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/parser/Parser.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/parser/Parser.java
new file mode 100644
index 0000000..c8b7287
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/parser/Parser.java
@@ -0,0 +1,205 @@
+package org.apache.blur.jdbc.parser;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+import java.util.ArrayList;
+import java.util.List;
+import java.util.StringTokenizer;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
+
+public class Parser {
+
+  private static final String SELECT = "select";
+  private static final String WHERE = "where";
+  private static final String NATURAL = "natural";
+  private static final String FROM = "from";
+  private static final String JOIN = "join";
+  private static final String SEP = new String(new char[] { 1 });
+
+  public static void main(String[] args) {
+    // System.out.println(new
+    // Parser().parse("select * from table where query('person.pn:(nice cool)')"));
+    // System.out.println(new
+    // Parser().parse("select * from table natural join table2 where person.pn = 'coandol''s' and jon='asdndandanda' And person.pf ='niorce' or nice = 'be'"));
+    // System.out.println(new
+    // Parser().parse("select * from table where person.pn = 'coandol''s' and jon='asdndandanda' And person.pf ='niorce' or nice = 'be'"));
+    System.out.println(new Parser().parse("SELECT * FROM TEST_TABLE T WHERE 1 = 0"));
+    System.out.println(new Parser().parse("select * from table t where 1 = 0"));
+    // System.out.println(new
+    // Parser().parse("select id,locationid,score,cf1.* from table where query('+person.pn:(nice cool) AND cool.a:nice')"));
+  }
+
+  private String where;
+  private String tableName;
+  private List<String> columnNames;
+  private String joinTable;
+
+  public Parser parse(String query) {
+    columnNames = getColumnNames(query);
+    tableName = getTableName(query);
+    where = getWhere(query);
+    joinTable = getJoin(query);
+    return this;
+  }
+
+  public String getJoinTable() {
+    return joinTable;
+  }
+
+  private String getJoin(String query) {
+    String table = null;
+    StringTokenizer tokenizer = new StringTokenizer(query);
+    while (tokenizer.hasMoreTokens()) {
+      if (NATURAL.equals(tokenizer.nextToken().toLowerCase())) {
+        if (JOIN.equals(tokenizer.nextToken().toLowerCase())) {
+          table = tokenizer.nextToken();
+        } else {
+          throw new RuntimeException();
+        }
+      }
+    }
+    return table;
+  }
+
+  private String getWhere(String query) {
+    StringBuilder result = new StringBuilder();
+    StringTokenizer tokenizer = new StringTokenizer(query);
+    while (tokenizer.hasMoreTokens()) {
+      if (WHERE.equals(tokenizer.nextToken().toLowerCase())) {
+        while (tokenizer.hasMoreTokens()) {
+          String token = tokenizer.nextToken();
+          result.append(token).append(' ');
+        }
+      }
+    }
+    return getQuery(result.toString().trim());
+  }
+
+  private String getQuery(String query) {
+    Pattern p = Pattern.compile("([qQ][uU][eE][rR][yY]\\s*\\(\\s*')(.*)('\\s*\\).*)");
+    Matcher matcher = p.matcher(query);
+    if (matcher.find()) {
+      if (matcher.groupCount() != 3) {// first one is the whole string
+        throw new RuntimeException("malformed query [" + query + "]");
+      }
+      return matcher.group(2);// 2nd group is the lucene query
+    } else {
+      return changeQueryToLucene(query);
+    }
+  }
+
+  private String changeQueryToLucene(String query) {
+    query = fixAndsOrs(query);
+    query = query.replaceAll("\\s*=\\s*", ":");
+    query = query.replace("''", SEP);
+    query = query.replaceAll("'", "");
+    query = query.replace(SEP, "'");
+    return query;
+  }
+
+  private String fixAndsOrs(String query) {
+    query = fixToUpperToken(query, "AND");
+    query = fixToUpperToken(query, "OR");
+    return query;
+  }
+
+  private String fixToUpperToken(String query, String token) {
+    String queryUpper = query.toUpperCase();
+    int start = 0;
+    int index = queryUpper.indexOf(token, start);
+    while (index != -1) {
+      if (!query.substring(index, index + token.length()).equals(token)) {
+        String everythingInStringToCurrentPosition = query.substring(0, index);
+        if (!isHitInParameter(everythingInStringToCurrentPosition)) {
+          query = query.substring(0, index) + token + query.substring(index + token.length());
+          return fixToUpperToken(query, token);
+        }
+      }
+      start = index + 1;
+      index = queryUpper.indexOf(token, start);
+    }
+    return query;
+  }
+
+  private boolean isHitInParameter(String everythingInStringToCurrentPosition) {
+    char[] charArray = everythingInStringToCurrentPosition.toCharArray();
+    int count = 0;
+    for (int i = 0; i < charArray.length; i++) {
+      if (charArray[i] == '\'') {
+        count++;
+      }
+    }
+    return count % 2 != 0;
+  }
+
+  private String getTableName(String query) {
+    StringTokenizer tokenizer = new StringTokenizer(query);
+    while (tokenizer.hasMoreTokens()) {
+      if (FROM.equals(tokenizer.nextToken().toLowerCase())) {
+        if (tokenizer.hasMoreTokens()) {
+          return tokenizer.nextToken();
+        }
+      }
+    }
+    throw new IllegalArgumentException("Table not found");
+  }
+
+  private List<String> getColumnNames(String query) {
+    StringTokenizer tokenizer = new StringTokenizer(query);
+    List<String> columnNames = new ArrayList<String>();
+    while (tokenizer.hasMoreTokens()) {
+      if (SELECT.equals(tokenizer.nextToken().toLowerCase())) {
+        while (tokenizer.hasMoreTokens()) {
+          String token = tokenizer.nextToken().toLowerCase();
+          if (FROM.equals(token)) {
+            return columnNames;
+          }
+          processColumnToken(columnNames, token);
+        }
+      }
+    }
+    return null;
+  }
+
+  private void processColumnToken(List<String> columnNames, String token) {
+    StringTokenizer tokenizer = new StringTokenizer(token, ",");
+    while (tokenizer.hasMoreTokens()) {
+      columnNames.add(tokenizer.nextToken());
+    }
+  }
+
+  public String getTableName() {
+    return tableName;
+  }
+
+  public List<String> getColumnNames() {
+    return columnNames;
+  }
+
+  public String getWhere() {
+    if (where == null || where.trim().isEmpty()) {
+      return "*";
+    }
+    return where;
+  }
+
+  @Override
+  public String toString() {
+    return "Parser [columnNames=" + columnNames + ", tableName=" + tableName + ", where=" + where + ", joinTable=" + joinTable + "]";
+  }
+}

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSet.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSet.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSet.java
new file mode 100644
index 0000000..1483a6b
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSet.java
@@ -0,0 +1,42 @@
+package org.apache.blur.jdbc.util;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+import java.sql.ResultSetMetaData;
+import java.sql.SQLException;
+
+import org.apache.blur.jdbc.abstractimpl.AbstractBlurResultSet;
+
+
+public class EmptyResultSet extends AbstractBlurResultSet {
+
+  @Override
+  public void close() throws SQLException {
+
+  }
+
+  @Override
+  public boolean next() throws SQLException {
+    return false;
+  }
+
+  @Override
+  public ResultSetMetaData getMetaData() throws SQLException {
+    return new EmptyResultSetMetaData();
+  }
+
+}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSetMetaData.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSetMetaData.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSetMetaData.java
new file mode 100644
index 0000000..0a0c7ab
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/EmptyResultSetMetaData.java
@@ -0,0 +1,32 @@
+package org.apache.blur.jdbc.util;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+import java.sql.ResultSetMetaData;
+import java.sql.SQLException;
+
+import org.apache.blur.jdbc.abstractimpl.AbstractBlurResultSetMetaData;
+
+
+public class EmptyResultSetMetaData extends AbstractBlurResultSetMetaData implements ResultSetMetaData {
+
+  @Override
+  public int getColumnCount() throws SQLException {
+    return 0;
+  }
+
+}
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/NotImplemented.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/NotImplemented.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/NotImplemented.java
new file mode 100644
index 0000000..cec34ab
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/NotImplemented.java
@@ -0,0 +1,37 @@
+package org.apache.blur.jdbc.util;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed with this
+ * work for additional information regarding copyright ownership. The ASF
+ * licenses this file to You under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ * 
+ * http://www.apache.org/licenses/LICENSE-2.0
+ * 
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
+ * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
+ * License for the specific language governing permissions and limitations under
+ * the License.
+ */
+public class NotImplemented extends RuntimeException {
+
+  public static final String BLUR_JDBC_DEBUG = "blur.jdbc.debug";
+  private static final long serialVersionUID = 4736975316647139778L;
+  public static final boolean debug = Boolean.getBoolean(BLUR_JDBC_DEBUG);
+
+  public NotImplemented() {
+    this(null);
+  }
+
+  public NotImplemented(String name) {
+    if (debug) {
+      if (name != null) {
+        System.err.println("Method [" + name + "]");
+      }
+      new Throwable().printStackTrace();
+    }
+  }
+}

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/SimpleStringResultSet.java
----------------------------------------------------------------------
diff --git a/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/SimpleStringResultSet.java b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/SimpleStringResultSet.java
new file mode 100644
index 0000000..eff7797
--- /dev/null
+++ b/blur-jdbc/src/main/java/org/apache/blur/jdbc/util/SimpleStringResultSet.java
@@ -0,0 +1,101 @@
+package org.apache.blur.jdbc.util;
+
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements.  See the NOTICE file distributed with
+ * this work for additional information regarding copyright ownership.
+ * The ASF licenses this file to You under the Apache License, Version 2.0
+ * (the "License"); you may not use this file except in compliance with
+ * the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+import java.sql.ResultSetMetaData;
+import java.sql.SQLException;
+import java.sql.Types;
+import java.util.List;
+import java.util.Map;
+
+import org.apache.blur.jdbc.abstractimpl.AbstractBlurResultSet;
+import org.apache.blur.jdbc.abstractimpl.AbstractBlurResultSetMetaData;
+
+
+public class SimpleStringResultSet extends AbstractBlurResultSet {
+
+  private List<String> columnNames;
+  private List<Map<String, String>> data;
+  private int position = -1;
+  private String lastValue;
+
+  public SimpleStringResultSet(List<String> columnNames, List<Map<String, String>> data) {
+    this.columnNames = columnNames;
+    this.data = data;
+  }
+
+  @Override
+  public ResultSetMetaData getMetaData() throws SQLException {
+    return new SimpleStringResultSetMetaData(columnNames);
+  }
+
+  @Override
+  public boolean next() throws SQLException {
+    if (position + 1 >= data.size()) {
+      return false;
+    }
+    position++;
+    return true;
+  }
+
+  @Override
+  public String getString(int columnIndex) throws SQLException {
+    String name = columnNames.get(columnIndex - 1);
+    Map<String, String> row = data.get(position);
+    return lastValue = row.get(name);
+  }
+
+  @Override
+  public boolean wasNull() throws SQLException {
+    return lastValue == null ? true : false;
+  }
+
+  @Override
+  public void close() throws SQLException {
+
+  }
+
+  public static class SimpleStringResultSetMetaData extends AbstractBlurResultSetMetaData {
+
+    private List<String> columnNames;
+
+    public SimpleStringResultSetMetaData(List<String> columnNames) {
+      this.columnNames = columnNames;
+    }
+
+    @Override
+    public int getColumnCount() throws SQLException {
+      return columnNames.size();
+    }
+
+    @Override
+    public String getColumnName(int column) throws SQLException {
+      return columnNames.get(column - 1);
+    }
+
+    @Override
+    public int getColumnType(int column) throws SQLException {
+      return Types.VARCHAR;
+    }
+
+    @Override
+    public String getColumnTypeName(int column) throws SQLException {
+      return "string";
+    }
+
+  }
+}

http://git-wip-us.apache.org/repos/asf/incubator-blur/blob/b0e26648/blur-mapred/input-data/short.simple.txt
----------------------------------------------------------------------
diff --git a/blur-mapred/input-data/short.simple.txt b/blur-mapred/input-data/short.simple.txt
new file mode 100644
index 0000000..6254a4f
--- /dev/null
+++ b/blur-mapred/input-data/short.simple.txt
@@ -0,0 +1,1000 @@
+KHADIJAH	ROSCH	19730722	M	
+VELLA	BOENISCH	19971117	M	
+RORY	OLIVEROS	19930806	F	
+VINCENZO	MOULDIN	19291213	F	
+ALEISHA	WHILDEN	19870618	M	
+EDDIE	LIVING	19261102	F	
+RAFAEL	USCIO	19820924	F	
+LOGAN	BUMM	19591228	F	
+MICA	FEUERBORN	19240212	M	
+REX	COXWELL	19850715	F	
+LOUIE	NETTO	19690603	F	
+TAMERA	CALDRON	19281221	M	
+DRUSILLA	BRITAIN	19421227	M	
+GROVER	KINNEBREW	19460207	F	
+KARLEEN	GRAVEL	19040225	M	
+JUNIOR	BAXI	19800522	F	
+BUCK	ORICK	19550107	F	
+CLAY	ALMSTEAD	19931104	F	
+GLENDORA	AMSDEN	19750801	M	
+BENTON	DENTEL	19631103	F	
+YUNG	EAGLEMAN	19740607	M	
+BETSY	RENIGAR	19051121	M	
+CHAUNCEY	BLOXSOM	19240914	F	
+MARIEL	SMITS	19021211	M	
+MIGUEL	PANELLA	19650718	F	
+MACHELLE	GUARD	19120908	M	
+CORALEE	MEIERHOFER	19200624	M	
+ANNITA	GERWE	19290122	M	
+SHAUNA	MAPA	20021220	M	
+JACQUELINE	AMBLER	19581109	M	
+MARHTA	STEIB	19860725	M	
+TIFFINY	BERNABO	19790811	M	
+SOL	FACIO	19751112	F	
+RICH	MONARCA	19360704	F	
+DAMION	LOZO	19330207	F	
+CARTER	MCCOIL	19030918	F	
+BURL	STROP	20011020	F	
+ROYCE	ELLEBY	19941105	F	
+SYDNEY	MIYAMOTO	19100611	F	
+DANIEL	HASTE	19050510	F	
+BLOSSOM	HAMMERMAN	19830302	M	
+TROY	BLAYDON	19890617	F	
+WINFRED	ODONNEL	19560507	F	
+ROBERTA	FRUTOZ	19371110	M	
+DAMION	CARLSSON	19841023	F	
+SANDY	STANDEVEN	19940605	F	
+IDELLA	UTECHT	19760414	M	
+NANNETTE	FORNILI	19370610	M	
+ZACHARY	BASEHORE	19470706	F	
+CARYN	TEBOW	19370425	M	
+CLAUDIO	BAGENT	19250614	F	
+SIGNE	OELTJEN	19000509	M	
+NICOLASA	MARKWELL	19930221	M	
+ARMAND	ASCHIM	19280720	F	
+DEANGELO	KEATHLEY	19680103	F	
+KRAIG	TRINDLE	19671108	F	
+NORAH	ZERAN	19920624	M	
+JEANNIE	ROUSSELLE	19940213	M	
+JOSIE	MICHALICEK	19400216	M	
+KELLEY	MCHORSE	19271216	F	
+HERSHEL	MELLENCAMP	20000320	F	
+KASI	SIGLEY	19610611	M	
+RUSTY	THIERRY	19841208	F	
+JENNETTE	YAMIN	19670315	M	
+CYRSTAL	CERULLO	19620424	M	
+QUINCY	BUCKHALTER	19701003	F	
+KYLEE	ROUTH	19180116	M	
+CHERELLE	GLEE	19911106	M	
+WILFRED	THUNEY	19150608	F	
+CHAE	WISELEY	19110328	M	
+CHINA	KRADEL	19171018	M	
+KEREN	DELVIN	19911122	M	
+SHANEL	PISICCHIO	19280405	M	
+CONRAD	SARKISIAN	19700901	F	
+NENA	KAPA	20020611	M	
+GRETA	REAGAN	19000621	M	
+GIDGET	PERTEE	19170914	M	
+MONTE	TAWNEY	19810408	F	
+BRAD	PANOWICZ	19101202	F	
+MICHAL	GAINFORTH	19601201	F	
+ALEXANDRA	MCENERY	19210627	M	
+JOHNA	JANVIER	19701210	M	
+CALEB	ZAKAR	19660723	F	
+NOLAN	FORSTHOFFER	19570323	F	
+EDWARDO	MITTELMAN	19480203	F	
+FRANCIS	FILBY	20040316	F	
+MADELINE	RIZZI	19020816	M	
+DORINDA	SYED	19670403	M	
+OLIVER	BRAMMER	19690408	F	
+SHERRON	MAILE	19101007	M	
+LATRISHA	KUALII	19400808	M	
+HUNTER	SCUTT	19791225	F	
+VERNON	GLIME	19520201	F	
+BO	FOISTER	19191206	F	
+CATARINA	MARKLEY	19510714	M	
+TIMOTHY	BUSTILLO	19490813	F	
+SHARIE	CULOTTI	19640114	M	
+WALLY	HERGERT	19280823	F	
+AUSTIN	LUBY	19891101	F	
+TRUDIE	MROCHEK	19701012	M	
+MANUAL	GRIGG	20010202	F	
+STUART	MOUNGER	19091028	F	
+RUSSELL	FRAILEY	19220804	F	
+BUFORD	KOSTICK	19201004	F	
+JUNITA	BORDLEY	19890818	M	
+MARIO	BOTRAS	19520209	M	
+MARTIN	HAVIR	19590206	F	
+NOAH	TRESSLER	19041107	F	
+UN	FEUERSTEIN	19280822	M	
+ZINA	DOHOGNE	19581007	M	
+CODI	TORRES	20020207	M	
+RAMIRO	BUTKOVICH	19251218	F	
+HIRAM	HUSSIAN	19940513	F	
+BOBBI	CZACHOROWSKI	19910820	M	
+LUCIEN	SONDROL	19000527	F	
+GUS	KILCHER	19580722	F	
+MARITZA	BEAKLEY	19690208	M	
+MARIA	BIJAN	19890201	F	
+BARTON	BAGGERLY	19600508	F	
+RUDY	MCGROTHA	19770205	F	
+DANIAL	COLGLAZIER	19871102	F	
+TRICIA	HOUSKEEPER	19760101	M	
+FREEDA	BLOOMQUIST	19281219	M	
+TEOFILA	CAYEA	19700913	M	
+CLEMMIE	WONG	19600912	M	
+ALVINA	BAKR	19370226	M	
+CLARINE	GRABOW	19190920	M	
+CORA	MEHALKO	19140205	M	
+HILARIO	POLJAK	19371013	F	
+MARANDA	SYPULT	19360111	M	
+BERRY	GABHART	19911109	F	
+NENA	DEBROT	19251125	M	
+LORINDA	CARMICKEL	19930601	M	
+BURMA	GUARIGLIA	19460917	M	
+LENORA	CIARDULLO	19710714	M	
+LIESELOTTE	CARRANZA	19170726	M	
+WILEY	LAVELETT	19850501	F	
+PATRICE	RAJAS	19240317	M	
+EVALYN	PATTINSON	19420314	M	
+ROCKY	STEFANO	19110420	F	
+EMILE	SAELENS	19031123	F	
+AL	MOGENSEN	19470311	F	
+RENE	SCRENCI	19491119	F	
+EDRA	QUIETT	19621218	M	
+GRACIELA	DANBY	19771217	M	
+BARRY	OCALLAHAN	19481019	F	
+KACEY	HAYER	19720603	M	
+WARNER	CICCHETTI	19380801	F	
+DANTE	HAZELHURST	19571010	F	
+ELDEN	CATANI	19040726	F	
+ISIDRO	PESTA	19080808	F	
+FREDRIC	SHINDORF	19470518	F	
+MANA	MASELLA	20000222	M	
+BRYCE	ESCARENO	19621228	F	
+BARTON	PEAKS	19090602	F	
+JACQUELINE	LOAR	19380419	M	
+ZACKARY	FLESCHNER	19091224	F	
+CYRUS	HOGENMILLER	19821022	F	
+LATANYA	DOWE	20001214	M	
+LAURALEE	SKERL	19120928	M	
+SHELLI	GIBBON	19620306	M	
+JED	FAVIERI	19140124	F	
+CHRISTINE	SCHENFELD	20030121	M	
+NIGEL	WHIPPLE	19821221	F	
+GEORGE	DRESBACH	20020622	F	
+PETE	WESSON	19710618	F	
+ROSEANN	MEENACH	19930520	M	
+ALEJANDRO	WOTRING	19150421	F	
+JEFFREY	BRYNTESON	19460225	F	
+JOSLYN	LYFORD	19820702	M	
+CAMMY	KENAAN	19630604	M	
+DOUG	LATTUS	19990704	F	
+CLARISSA	RIKE	19331114	M	
+TYRA	DRANEY	20000723	M	
+JADE	HAROLDSEN	19580526	M	
+ADAM	LAWHORNE	19240208	F	
+STEPHEN	ISSAC	19360315	F	
+ANDREW	SCHMITZ	19030802	F	
+PHILLIP	SCULLARK	19310527	F	
+CINDI	GRESH	19431026	M	
+SALENA	EMMERSON	19871105	M	
+CALEB	CARMICKLE	19640815	F	
+KANDY	PRILL	19300511	M	
+PANSY	SEMAAN	19890905	M	
+ALFRED	HORTH	19810515	F	
+TENNIE	HANKINSON	19300112	M	
+ALONSO	RARANG	19341125	F	
+IDALIA	LABBIE	19691107	M	
+ISABELL	BRIMFIELD	19791118	M	
+WANDA	PIERFAX	19290607	M	
+BONG	KUTSCH	19140223	M	
+SCOT	NESBY	19371006	F	
+LEIGHANN	VANDON	19270428	M	
+AISHA	SKARKE	19511218	M	
+LEAH	MACCULLOCH	19040921	M	
+EARLIE	FORSHAW	19020307	M	
+ZENAIDA	GOCHNOUR	19890324	M	
+STEVEN	STRUDWICK	19780216	F	
+ARRON	PALARDY	19490125	F	
+EZEQUIEL	CROSSON	19600320	F	
+NORBERT	WAKENIGHT	19330727	F	
+CLAUDINE	PAYSEN	19420220	M	
+FOSTER	SESKO	19510827	F	
+HERMINE	NAVAREZ	19650722	M	
+MOSHE	MONJE	19611023	F	
+TOSHIKO	MALOY	20000228	M	
+LAKENYA	ESSON	20030221	M	
+SHARI	DOREY	19480909	M	
+VONDA	CROSSLEY	19810202	M	
+TAMISHA	CRAGAN	19330526	M	
+ROLF	FERDIG	19511006	F	
+TEMIKA	PAULINO	19490202	M	
+JEFFIE	MOMENT	19090703	M	
+GROVER	POTHOVEN	19460814	F	
+KAREY	JERGENS	19751218	M	
+RICKEY	SCHOENBORN	19800626	F	
+HANK	BOWDLE	19931201	F	
+RAYMOND	PURWIN	20031020	M	
+CHRISTIAN	YOBST	19641027	M	
+HEATH	SUENTENFUSS	19841227	F	
+LESLEE	MCKINNELL	19901126	M	
+ALESHA	DARRIN	19670116	M	
+DEMETRICE	WALLENTINE	19210508	M	
+TIFFANIE	MOWATT	19000302	M	
+ROYAL	JANEWAY	19460128	F	
+SHERMAN	HINZMAN	19210228	F	
+ELDON	PREE	19461124	F	
+CHET	SEIGLER	19480720	F	
+LYNELL	DAVOS	20021120	M	
+BARRY	SIMONCINI	19961007	F	
+PAZ	LICAUSI	19310426	M	
+ANTONIA	KAFFKA	19740217	F	
+BURL	CAPETL	20040502	F	
+FRITZ	GOTTFRIED	19950403	F	
+BUSTER	AUSBY	19251209	F	
+JACK	DELASHMIT	19180802	F	
+BENITO	HAYDEL	19480618	F	
+KYLEE	MANGIARACINA	19990910	M	
+NOEL	HEROUT	19440820	F	
+ANTIONETTE	MINAYA	19250505	M	
+TAMMERA	CROSSLEY	19060911	M	
+LORRETTA	VENEZIANO	20040511	M	
+MINDI	FLEGAL	19391009	M	
+HERLINDA	MCMAHEN	19270612	M	
+NATASHIA	REIS	19681213	M	
+MERRILL	ENGLERT	19540709	F	
+CHARLIE	WOODBURN	19220917	F	
+FREDERICK	ROSEK	19780411	F	
+BETH	MANDATO	19570410	M	
+CLIFF	COSTILLA	19850520	F	
+SAMUEL	HORNBERGER	19780221	F	
+TISHA	RUPEL	19050905	M	
+ELBERT	AMADON	19571015	F	
+EMIL	SIECZKA	19670718	F	
+DONNELL	SMUCK	19440321	F	
+SHELBY	PULLING	19360610	M	
+ROSIE	HADNOT	19471006	M	
+VICENTE	PESSES	19061219	F	
+ELLYN	AMERINE	19610323	M	
+TASHA	HINT	19820408	M	
+JANICE	IODICE	19890402	M	
+LATOYIA	RIGGS	19370406	M	
+POLLY	LEBERTE	20040815	M	
+LINWOOD	MCMILLION	19120713	F	
+OMA	ROMANOSKI	19360212	M	
+CHANCE	HEITING	19960206	F	
+MILLARD	LEGEL	19790923	F	
+TERRY	WEISSBRODT	19071002	M	
+LELAND	LASLO	19660502	F	
+ROMEO	MCTHAY	19881008	F	
+TRUMAN	DILLIGARD	19990510	F	
+DEANDREA	VOELLER	19941008	M	
+BRIAN	PASSY	20020422	F	
+SHAWANDA	CAMPANARO	19550404	M	
+REINALDO	SCOULLER	19140324	F	
+NORMAN	TRIBUE	19231121	F	
+KATELYNN	PUCCIARELLI	19100822	M	
+LULU	OSUCH	19010520	M	
+DEBORAH	CHHAN	19180403	M	
+LEOPOLDO	DONELAN	19410310	F	
+WADE	SHEDRICK	19750308	F	
+LUCAS	LECHLER	19481202	F	
+DANNY	SURVIS	19530526	F	
+ODIS	LUXENBERG	20010401	F	
+SYLVESTER	PELLER	19431010	F	
+LACY	KNORR	19840801	M	
+LYNN	TURBE	20001117	M	
+DANNIE	MIRAFLORES	19780103	M	
+DEWAYNE	TEKLU	19641201	F	
+ELOY	SENSEMAN	19550914	F	
+FERNANDO	SOLIMENO	19580913	F	
+ROGER	DAMI	19231010	F	
+ABEL	DELAPAZ	19940513	F	
+NELLA	OHRNSTEIN	19120626	M	
+GENEVIEVE	SHINDO	19480223	M	
+ROXIE	MARKAKIS	19150523	M	
+MACKENZIE	LUMM	19981126	M	
+COLBY	KIRTS	19380605	F	
+SHERWOOD	BICKMORE	19680908	F	
+LINDY	DEEP	19221019	M	
+SHEREE	MASSANET	19120515	M	
+RANDAL	KESBY	19680723	F	
+DEBRA	PRILLAMAN	19841208	M	
+JEFFERY	MAHANY	19450416	F	
+TOM	HALLET	19860418	F	
+BARNEY	ZERANGUE	19800210	F	
+LEONARD	GERSBACH	19510214	F	
+ALI	BARTNETT	19591008	F	
+AYANA	LAGARD	20020512	M	
+DEXTER	VILCHES	19521112	F	
+FIDELA	JELTEMA	19430213	M	
+ARLEN	GRADILLA	19430404	F	
+CHER	OLIN	19940711	M	
+KELSEY	ALLUMS	19321012	M	
+MANUAL	CRONAUER	19180603	F	
+FLORETTA	HARADER	19030824	M	
+LIONEL	WIECHMANN	19340214	F	
+CARYLON	MARSOLAIS	19360424	M	
+EBONIE	CRYE	19900901	M	
+KRAIG	KELA	19871027	F	
+ALICE	TAPHOUS	19730122	M	
+ESTELLA	URBACH	19470827	M	
+ERICH	DEGRAVELLE	19390219	F	
+ARGELIA	CONLEE	19770919	M	
+ANTONIETTA	GAVIT	19320106	M	
+CARLEE	YARZABAL	19300315	M	
+BERNARDO	DEPPNER	19231114	F	
+JOHNIE	KRIENER	19570404	F	
+HOBERT	LAZAGA	19480907	F	
+VALENTINE	DARCO	19261006	F	
+JIM	ESPANOL	19740709	F	
+ARNOLD	HAYASE	19300628	F	
+NATACHA	MARINUCCI	19900119	M	
+WARD	IRVING	19770715	F	
+JANAE	VANDENACRE	19730106	M	
+DELICIA	CHALLBERG	19111124	M	
+WINSTON	BIROS	19560828	F	
+JOVAN	LOEVEN	19020708	M	
+GABRIELLA	KIERNAN	19210416	M	
+KELLEY	GREISER	19140607	F	
+HAL	BARTOL	19251012	F	
+JASON	LAMORELLA	19380317	F	
+MAIRE	HARIAN	19010227	M	
+CARLOTA	ZELINKA	19990124	M	
+ARLIE	HENNIGER	19251012	F	
+CASSIDY	SERENE	19191110	M	
+LANCE	BOSSLER	19630924	F	
+FERNANDO	DAPICE	19710126	F	
+NOELLA	BOLDER	20010601	M	
+TAYLOR	SOWELLS	19940308	M	
+FREDDY	CORLE	19720116	F	
+DORETHA	KNIESS	19601214	M	
+HARRY	CUBIT	19300721	F	
+DOUG	BLACKMAR	19481111	F	
+FARAH	LINDHOLM	19860509	M	
+TAMICA	GRAVELY	19590919	M	
+WINFRED	MAHALL	19410225	F	
+EMILIO	JOHANNESSEN	19131124	F	
+ROSARIA	MONTESDEOCA	19251006	M	
+JANETH	DELGER	19590811	M	
+COLBY	KIRCHBAUM	20000325	F	
+ASHLY	HELFGOTT	19400826	M	
+AMADO	UCHYTIL	19800813	F	
+LYNELLE	GEAN	19261223	M	
+JAY	PAVELEC	19990516	F	
+CONCHA	CLAVIJO	19790107	M	
+MIKEL	MACLAURIN	19590107	F	
+EVON	MAGNUSON	19590410	M	
+CHERISE	BAKERVILLE	19621107	M	
+EDMOND	DERICK	19030427	F	
+LUIS	DELANY	19611221	F	
+KEVA	TUFFEY	19791123	M	
+SANDEE	HOURIHAN	19190713	M	
+SIOBHAN	DORSON	19411114	M	
+GEORGANN	PAGO	19070308	M	
+MARIEL	RAHMAN	19541211	M	
+DORTHEY	DZINSKI	19461011	M	
+HEATH	ACAMPORA	19231206	F	
+WALTON	WARDHAUGH	19331124	F	
+JANNA	RIMAR	19850327	M	
+SEAN	PAPPA	19880604	F	
+WESTON	KINS	19140921	F	
+MOON	REGINE	19700723	M	
+KELLY	SCHOLTES	19170712	M	
+ANNELIESE	RENDLEMAN	19330505	M	
+TEREASA	SPARROW	19160101	M	
+EVETTE	HELLMUTH	19830122	M	
+SOL	TOWNSEND	19490613	M	
+ZINA	KISE	19980805	M	
+CORY	GLEE	19940209	F	
+PRICILLA	HENRIKSEN	19170617	M	
+ALETHIA	RANALLI	20031014	M	
+LEILA	RARANG	19490116	M	
+ANGELLA	TABAG	19840216	M	
+NISHA	WADFORD	19430605	M	
+HANK	LAMORA	19991021	F	
+LEATHA	OTANO	19440926	M	
+HARVEY	HYBERGER	19031128	F	
+JODI	KOULALIS	20041016	M	
+MICHIKO	ARELLANES	19510915	M	
+BARRETT	DEBIEW	19611120	F	
+FEDERICO	DELESTON	19270719	F	
+LYNWOOD	BURPO	19701010	F	
+LISANDRA	MCCANDLESS	19090515	M	
+MYRTICE	DALEE	19540428	M	
+BIRDIE	HISRICH	19190616	M	
+ALEC	STRUZIK	19830325	F	
+KRIS	YANNUCCI	19521208	F	
+KARON	TOFTE	19391020	M	
+CYTHIA	WARDLE	19930314	M	
+LAWRENCE	LICHSTEIN	20001024	F	
+VICENTE	KOESTER	19520626	F	
+DERRICK	RYKIEL	19170206	F	
+VIOLA	HARGES	19300302	M	
+YADIRA	AMPY	19590806	M	
+GERARDO	HEMMELGARN	19391108	F	
+JOAQUIN	PO	19950323	F	
+DANTE	EGUIA	19490611	F	
+LEONIE	RUEGG	19040411	M	
+MAURICIO	MAINOR	19570905	F	
+MALKA	TISHLER	19990923	M	
+CHRISTIAN	BEARE	19800524	F	
+DOMINGO	RIEMER	19390527	F	
+STEPHAN	FINGERSON	19170822	F	
+WAYNE	BERDINE	19670710	F	
+VAN	MENDESA	19230722	F	
+JEFFERY	BORROLLI	19630213	F	
+VERN	WALKINGSTICK	19180621	F	
+SOO	EXLER	19990123	M	
+BASIL	KOZAN	19301202	F	
+WILBERT	NORVILLE	19930505	F	
+BERNARDO	GANGWER	19321227	F	
+VIVIEN	MOTON	20000723	M	
+VIRGINA	GROSECLOSE	19681007	M	
+ELENA	SMIDDY	19431003	M	
+MAXIMINA	LEDDY	19310801	M	
+VERENA	PINSON	19640909	M	
+CORLISS	RINGQUIST	19471211	M	
+OMAR	BREECH	19990905	F	
+FREDRICK	FITCHEARD	19010520	F	
+JOAQUIN	MCCASTER	19821002	F	
+CHARLIE	DULL	19240226	F	
+KARIE	GRILLS	19480420	M	
+COLETTA	OSENDORF	19540711	M	
+ZANA	MCLOUD	19090701	M	
+JULI	AUSBURN	19470816	M	
+JESS	STEIGER	19870216	F	
+MERIDETH	SUSANA	19150815	M	
+BRADY	SMILEY	19200515	F	
+HARLAND	KINI	19910305	F	
+DEWITT	RAJA	19150507	F	
+TORY	MATSUNAGA	19420521	F	
+QUINCY	SCALZO	19780610	F	
+BRIAN	GIRTON	19030615	F	
+AURA	KOSTELECKY	19491006	M	
+JULIETTE	RIDGLEY	19430314	M	
+LUCIO	VESLEY	19930120	F	
+MERISSA	BRINKMEIER	19261121	M	
+CLIFFORD	MISCOE	20010513	F	
+SHAWNEE	PALMETER	19570712	M	
+JIM	MOSHER	19930224	F	
+ELBERT	PEICK	19160516	F	
+JASON	EVINGER	19311101	F	
+BERT	SPIROFF	19950813	F	
+ANABEL	GUSTINE	19310415	M	
+HONG	DIETL	19361220	F	
+DIRK	GAITAN	19571203	F	
+JASPER	NARANJO	19831202	F	
+MITCHELL	BLANN	19241103	F	
+STANFORD	CORPORAL	19740902	F	
+ERROL	ALLRIDGE	19280901	F	
+KOREY	DINKINS	19251127	F	
+KELLEY	MASTELLA	19001026	F	
+LUIGI	HANDFORD	19760319	F	
+ZORAIDA	PFLUGHOEFT	19230327	M	
+MALCOM	WELK	19921204	F	
+JOHNATHAN	GIACCHI	19460725	F	
+DARREN	LUDEWIG	19471114	F	
+REFUGIO	YAISH	19650706	F	
+CANDRA	GERBINO	19290712	M	
+TEDDY	GARTH	19341128	F	
+FORREST	AHSAN	19300625	F	
+CORENE	SEY	19330108	M	
+BERTRAM	MCCOO	19340107	F	
+ELTON	ACEVES	19180423	F	
+COLLIN	NIGHTWINE	19350726	F	
+DWAIN	DORCY	19020211	F	
+CORDIE	BODE	19240412	M	
+LATRINA	HERSKOVITS	19650709	M	
+DIAMOND	RUPAR	19991028	M	
+ISRAEL	PRESSER	19341012	F	
+ALI	CERNEY	19710914	F	
+VICENTA	MOELLERS	19680616	M	
+VENNIE	SHUTT	20000819	M	
+VANNA	PARANADA	19800708	M	
+JACQUI	PETRUCELLI	19580521	M	
+DRUCILLA	SODER	19091217	M	
+SHAVONNE	COSTANEDA	19360114	M	
+MARIO	GEHLE	19940823	F	
+EZEKIEL	BUNDE	19060125	F	
+LEESA	SUPNET	19470415	M	
+JEANNETTE	BORGMEYER	19600914	M	
+ANDREA	BOEHRINGER	19660421	F	
+AMIRA	MACCARTHY	19450612	M	
+MELODI	AGARWAL	19140727	M	
+RAISA	SMOLIC	19870413	M	
+JARVIS	MAHEIA	19940526	F	
+ANDREW	PALIN	19600327	F	
+SANTO	LEONICK	19140824	F	
+DEANDRE	WECHTER	19541005	F	
+PARIS	ASHDOWN	19910612	F	
+FRANCINE	GARDUNIO	19431008	M	
+BRYANNA	VALIN	19960226	M	
+STANLEY	PIPE	19940525	F	
+OCTAVIA	VITI	19880623	M	
+VAUGHN	OUTZEN	19450307	F	
+HUBERT	HAUSTEIN	19900506	F	
+HELGA	TAGS	19750622	M	
+JAMIE	SKALSKI	19531105	F	
+LATASHIA	MELECIO	19191013	M	
+ALDEN	HASLIP	19420627	F	
+SILVIA	PEKAREK	19170928	M	
+JULIANNE	CARLINI	19860914	M	
+DONTE	BROTEMARKLE	19531218	F	
+CLORINDA	ARCHIBALD	19300325	M	
+CLASSIE	CARGILL	19641018	M	
+RHEBA	GOVE	19680912	M	
+BULA	DAHILL	19070709	M	
+VINITA	CITY	19130804	M	
+DUNCAN	FARZAN	19810112	F	
+WALLACE	ERTLE	19791015	F	
+DEMETRIUS	GITZEN	19990807	F	
+FREEMAN	BOSCHULT	19930628	F	
+JC	HOSTETLER	19370807	F	
+ARIANNE	MORLAN	19850808	M	
+JAROD	STIDMAN	19610708	F	
+QUINN	BRANDLY	19831126	M	
+DONG	DINIS	19020819	F	
+CHERISE	GUDGEL	19820521	M	
+RILEY	PANTOJZ	19691008	F	
+MYESHA	FLUCK	19811212	M	
+AUBREY	QUADNAU	19030413	F	
+VON	ZEITLER	19640309	F	
+KENETH	WISNEWSKI	19850707	F	
+SHERRIL	DERIENZO	19421215	M	
+MAFALDA	GANDOLFO	19670601	M	
+BRENT	GIORGI	20030515	F	
+RUTH	HOOPES	19100603	M	
+CANDYCE	SPINELLO	19450306	M	
+WADE	MOONEYHAM	19430103	F	
+FREDRIC	TRUNDY	19630606	F	
+MCKINLEY	FUREY	19810516	F	
+DARREN	MISHRA	19981211	F	
+JULIE	MOSSBERG	19450205	M	
+BARNEY	BELLANTUONO	19080601	F	
+ALLEEN	CRIVARO	19330905	M	
+ELLIOT	FAIRBROTHER	19430416	F	
+CHERYLL	FEIBUSCH	19011210	M	
+PAMILA	VANDERWEGE	19060403	M	
+JILL	LACKMAN	19570215	M	
+ARON	GUILL	19260902	F	
+ARNETTA	WORTZ	19480823	M	
+ALVA	MOORING	19960310	F	
+DEVIN	TEYLER	19430719	F	
+TEODORO	HAGENY	19171220	F	
+SAMANTHA	LIEDBERG	19051016	M	
+JOSE	SHELLITO	19430207	M	
+BRETT	PLOCH	19471203	F	
+VERONA	KAAUAMO	19881214	M	
+RAE	HACKNEY	19551110	M	
+CARLOS	TERBUSH	19670723	F	
+VINCENT	EISENHAVER	19100709	F	
+HIPOLITO	DIMARIA	19710921	F	
+EZEKIEL	CARA	19630505	F	
+NATHANAEL	CONAUGHTY	19811006	F	
+LYNNA	PLUES	19020512	M	
+NATHANIAL	ZIMMEL	19120321	F	
+SHARICE	STANOJEVIC	19760710	M	
+GLAYDS	PROTTSMAN	19470714	M	
+BLAIR	HABBS	19031109	F	
+JUDSON	SHEFFEL	20010512	F	
+GERRY	SHIP	20031121	F	
+JACQUES	MILDENHALL	19481215	F	
+CHRISTY	WESTERHEIDE	19340510	M	
+CORRINE	ORRICO	19340320	M	
+JANEL	BARTOLOMEO	19051110	M	
+HEDY	WEISBERGER	20000927	M	
+LONNY	GRAND	19911019	F	
+CLAUDE	APYUAN	19090516	F	
+KENISHA	LITTERER	19730115	M	
+ADINA	PFALMER	19781113	M	
+JULIAN	HAPP	19100307	F	
+AVERY	HUMBEL	19960920	F	
+ROD	DENO	19811118	F	
+ERIK	TOYN	20020505	F	
+CHRISTOPER	BEZENEK	19650810	F	
+TRANG	SPEVACEK	19140220	M	
+VIRGINA	WHISBY	19401202	M	
+ALEJANDRO	PIGNATELLI	19711125	F	
+HOMER	JUNKINS	19971124	F	
+THOMAS	OMARA	19510501	M	
+DEBBI	HAITH	19660106	M	
+CELSA	CHADDERTON	19800304	M	
+EMORY	VOLLBRECHT	19120115	F	
+SHANE	CLYBURN	19411004	F	
+JAMISON	STARBIRD	19671026	F	
+ASTRID	RINKENBERGER	19801114	M	
+DIXIE	BILA	19780824	M	
+TYRON	SCRIM	19290504	F	
+TIMIKA	CARAVATI	19281116	M	
+ZACKARY	MARSOLAIS	19851104	F	
+AUGUSTA	CICERCHIA	19160809	M	
+MAURO	WESTER	19231120	F	
+JEROME	REICKS	19180407	F	
+LEMUEL	WARN	19571211	F	
+TOMMY	CHANOFSKY	19411002	F	
+HAYDEN	VANWYHE	19400903	F	
+ADRIAN	MORATTO	19931008	F	
+ISRAEL	KOSMICKI	19670220	F	
+LILI	CHEIRS	19130107	M	
+OSCAR	SCHERBEL	19961002	F	
+DANICA	PAPPA	19480816	M	
+WILFREDO	STRAHAN	19500716	F	
+GIUSEPPE	BERNHARDT	19520827	F	
+MARGO	TRYBUS	19200205	M	
+LUCIO	CULP	19961203	F	
+NAOMI	MEYLOR	19001028	M	
+BESSIE	BURGHARDT	19040604	M	
+ETHAN	TEVADA	19200807	F	
+TERRANCE	ONA	19041224	F	
+TINISHA	LEGO	19950204	M	
+ODELL	YOUN	19520712	M	
+NANCY	VOGELER	19560904	M	
+CLAUD	HAMMETTE	19210206	F	
+FOREST	RAMSTAD	20010926	F	
+GERRY	GENUALDI	19060401	M	
+SHASTA	GRISHAN	19610725	M	
+EDELMIRA	TINER	19890916	M	
+PABLO	BONVILLAIN	19230226	F	
+BERRY	HANSHEW	19300815	M	
+CORDELIA	BOWLAN	19260402	M	
+RAYMUNDO	SCHUNK	19120618	F	
+HOWARD	SCHLIPP	19610807	F	
+LARITA	AUALA	19490620	M	
+WALTER	DILORETO	19110513	F	
+DONALD	SIEDEL	19300418	F	
+LETTY	FETZER	19150115	M	
+LE	WHAN	19031222	M	
+TOMMY	HUXLEY	19070424	F	
+TERESSA	GAY	19060511	M	
+THEODORE	ORPEN	19650921	F	
+RAYMON	JERGENSON	19331202	F	
+LOVETTA	TREBESCH	19431126	M	
+LEONILA	BLATHERWICK	19690318	M	
+ELLENA	ELK	19550914	M	
+SHAKITA	ROSSER	19301108	M	
+FERMIN	KIRSH	19070715	F	
+ASHLEE	FICHT	19420927	M	
+MICHAEL	SCHUETT	19600126	F	
+ALBINA	FUNG	19670509	M	
+DEANNE	MCGUNAGLE	19080211	M	
+ADENA	MONFILS	19230419	M	
+OLIVER	SEAVER	19471101	F	
+MERRILEE	JACKOSN	19440403	M	
+TWANDA	MARSHBANKS	19210210	M	
+LUCI	ISABELLA	19500703	M	
+ROCKY	OQUENDA	19390223	F	
+DELOISE	AUCKERMAN	19100113	M	
+KENNITH	BITZENHOFER	19840815	F	
+GEORGE	WEHMEYER	19760818	F	
+COLEMAN	CASTRICONE	19190426	F	
+JODIE	HAMSIK	19340124	M	
+ASA	PAN	19280304	F	
+RENE	SCHONINGER	19921217	F	
+RAY	WIGGIN	19100824	F	
+EDMUNDO	WESTERFIELD	19541006	F	
+REYNALDA	OLEWINE	19080304	M	
+LEE	PUENT	19851221	F	
+FRANKLYN	SHOPEN	19130515	F	
+STACI	BARABAS	19690823	M	
+JEFFEREY	BLYLER	19081126	F	
+MAURICIO	JUBA	19211126	F	
+MOHAMED	MAX	19380702	F	
+PEARLE	VANRUITEN	19580519	M	
+ELROY	WEGER	19750807	F	
+SAMIRA	PERRIS	20000204	M	
+BERRY	HUDSPETH	20040623	F	
+KARL	GUEDESSE	19990209	F	
+DARRON	GALLMON	19761219	F	
+MARVIN	ROSSELLI	19890409	F	
+JERRI	RAMBERT	19821011	M	
+ANNE	BERRIEN	19740108	M	
+MADDIE	EDGEMON	19610828	M	
+DEDE	BOBLITT	19520727	M	
+SHAYNA	OTHER	19030203	M	
+KYLE	NARDELLI	19730112	F	
+LEIGH	PRENTISS	20000321	M	
+JACQUALINE	DETILLIER	19600208	M	
+SEYMOUR	LAME	19720811	F	
+KENYA	HANSIL	19560228	M	
+BENJAMIN	SJOGREN	19240624	F	
+PIERRE	FORBES	19190101	F	
+JENNEFER	WILLES	19520705	M	
+SHAQUITA	ORGOVAN	19500328	M	
+SEASON	LYKKEN	20020217	M	
+ARCHIE	SETO	19080125	F	
+EUSTOLIA	RACHELS	19390626	M	
+CELINDA	EDDY	19730202	M	
+BULA	CEJA	19610612	M	
+HAL	MINERY	19740221	F	
+ISSAC	MIERNIK	19700706	F	
+SHALA	EHRENZELLER	19951220	M	
+AUNDREA	BORLIN	19851022	M	
+GERALDO	LOOKER	19030418	F	
+ELSE	ENCISO	20000619	M	
+KIM	KOLOGY	19600315	F	
+TOMASA	NEMITZ	19380126	M	
+WILSON	ANNETTE	19070715	F	
+HUNG	SPIGNER	19780828	F	
+ROMONA	FLAIM	19720704	M	
+DOMENIC	BRUCK	19570116	F	
+LYNSEY	HUGHES	19320719	M	
+JOHNATHAN	WEINBURG	19970125	F	
+CLEMENTE	MCCULLOH	19280601	F	
+LYNNA	MCCAFFREE	19111127	M	
+RUTHIE	CARMONY	19260511	M	
+ABRAHAM	VANVORST	19310304	F	
+ANNAMAE	LOHNES	20010116	M	
+CLAUDIO	DEMAGGIO	19420110	F	
+LEONA	MUSCHETT	19190510	M	
+OSCAR	ARCINO	19640104	F	
+PRINCESS	NAPPS	19340517	M	
+MOIRA	SINDORF	19141101	M	
+HUBERT	BYNOE	20020224	F	
+GLENN	BRACHLE	19140116	F	
+PRESTON	KAISER	19141022	F	
+LASHANDRA	BURNS	19150223	M	
+ISREAL	HARTHORNE	19430225	F	
+ALEIDA	BLACKFORD	19140307	M	
+LUCIUS	EARNSHAW	19450809	F	
+EFRAIN	BAWA	19960402	F	
+BENEDICT	CUCVAS	19450410	F	
+JENISE	KRAVETS	19901209	M	
+BOBBI	ETH	19150627	M	
+JARRED	ABEGG	19020216	F	
+SEAN	TUONG	19160806	M	
+ALEXANDER	GASSMAN	19730823	F	
+BARI	RHODY	19271006	M	
+LEATHA	GRUENING	19290726	M	
+MAURINE	CRISPINO	19100715	M	
+CORLISS	TUKUAFA	19570501	M	
+PHYLIS	BAKST	19650522	M	
+KIMBERLI	ADJEI	19271111	M	
+TIA	SHIGO	19730517	M	
+RUSSEL	SILLEMAN	19130610	F	
+NIGEL	PFUHL	19370926	F	
+MADLYN	KACHIKIAN	19480124	M	
+JOHANNE	CASTERLINE	19820620	M	
+MARGARETTE	IGO	19511028	M	
+TOM	DEBRY	19870110	F	
+AILEEN	LAPPINGA	19681020	M	
+GRANT	STREIT	19191017	F	
+BOBBY	WERNECKE	19381212	F	
+DEXTER	MOZIE	19301221	F	
+JEFFREY	SCHWEISS	19980124	F	
+BRICE	SAKAMAKI	20010628	F	
+MARYLOUISE	DOORLEY	19060911	M	
+MARYBETH	VONGSAMPHANH	20040303	M	
+ILONA	CULLIFER	19750515	M	
+ILUMINADA	ZIOLKOWSKI	19570910	M	
+CLARISSA	CAGGIANO	19730104	M	
+SAL	REH	19180303	F	
+KEELEY	WALDSCHMIDT	19920710	M	
+NUMBERS	DELARME	19301203	F	
+ELEANORE	BELLINGTIER	19400627	M	
+RUSTY	SEALOCK	19400113	F	
+CRISTI	NAZAIRE	19790119	M	
+GENE	GOLSON	19570407	F	
+ISRAEL	OEHRLE	19441206	F	
+NICOLA	MCMILLIN	19240715	M	
+NICHOLAS	MANNES	19800912	F	
+VERNICE	LITCHMORE	19660607	M	
+LLOYD	LEICHT	19570425	F	
+CHARLIE	FOGGS	19260426	F	
+LESIA	VOLENTINE	19571223	M	
+EDMUND	MUSTARD	19270612	F	
+DARCEL	COWART	19861018	M	
+MOZELLA	DWINELL	19530809	M	
+MANIE	KNOEPPEL	20040823	M	
+CHRISTOPHER	GOSSLING	19100622	M	
+DALTON	SHERR	19540321	F	
+DARCEL	PHILO	19540223	M	
+SHAWANNA	BARCELLOS	19261128	M	
+TRINIDAD	HOMER	19100717	F	
+JEREMIAH	GLENNY	19740403	F	
+MORRIS	YSBRAND	19070924	F	
+MELLISA	PETITJEAN	19380321	M	
+CARY	PECORA	19750121	M	
+RICHIE	STUTLER	19701009	F	
+DARRIN	KRUM	19250927	F	
+ERNEST	JASSO	19290824	F	
+KANDRA	CAILLOUET	19770428	M	
+LUANN	FINKS	19910112	M	
+SHAROLYN	PACLEB	19210711	M	
+MORGAN	ZINCKE	20000903	M	
+FILOMENA	EXTINE	19970413	M	
+KEITH	RATCHFORD	19320201	F	
+TAWANNA	SWANCUTT	19130917	M	
+PEARLENE	CASTELLAN	19130523	M	
+DONETTA	BAMFORD	19160217	M	
+CRISTY	LEATHERWOOD	19860606	M	
+SCOT	LYNEMA	19070815	F	
+JUDSON	CEJKA	19900204	F	
+JAUNITA	HEIDBREDER	20040120	M	
+EUGENE	MITTELSTADT	19040117	M	
+DARRON	COBIA	20030817	F	
+TEOFILA	LY	20020621	M	
+LANI	VILLAMAR	19180320	M	
+DEDE	SLADEK	19500326	M	
+WEI	LETSCHE	19790510	M	
+ANGLEA	LOPE	19341115	M	
+WILTON	DELAHOYA	19970220	F	
+PRESTON	SKOLNICK	19451109	F	
+BREANN	BURCIAGA	19660111	M	
+EMORY	HECKMANN	19590505	F	
+CHONG	PAYNES	19281105	F	
+PEI	GRABSKI	19580718	M	
+ROYCE	BENOIST	19900705	F	
+STEVIE	IOZZO	19940812	F	
+CHERY	HEINICKE	19661118	M	
+ELINA	GRANDA	19120723	M	
+ANNAMAE	KLOMP	19170725	M	
+EUSTOLIA	HETLAND	19820815	M	
+KACY	GREASON	19620222	M	
+EARLE	CONARY	19110412	F	
+KERRIE	EMRICH	19891218	M	
+HENRIETTA	GORLICH	19210406	M	
+BLAKE	BOHLEN	19240303	M	
+CASSONDRA	LITTLES	19640907	M	
+ELWOOD	HEFLER	19290216	F	
+ELVIN	SWELEY	19600402	F	
+ELDON	LAFFEY	19190303	F	
+DESIREE	NANIA	19620605	M	
+BEATRIS	MACDONALD	19691025	M	
+TRAVIS	KRENZ	19360825	F	
+JAMIE	VILLANVEVA	19891102	M	
+BRAD	RHODUS	19610817	F	
+VALARIE	SHANON	19791007	M	
+BUENA	WHITINGER	19411125	M	
+TISH	BATLEY	19411021	M	
+TAISHA	FRANKOWSKI	19460326	M	
+SLYVIA	STREMI	19500606	M	
+DELISA	DIERKING	19750205	M	
+AL	SAYED	19540423	F	
+OLLIE	HARSHMAN	19270128	F	
+ROB	SIMAS	19920801	F	
+LAKEESHA	MICKELS	19250309	M	
+NIDIA	DRINEN	19250617	M	
+FLETCHER	DEETERS	19500901	F	
+SCOTTIE	ESPAILLAT	19230609	F	
+ANDREA	JEREZ	19940208	M	
+GILBERTO	PARKOS	19611216	F	
+REFUGIO	RAUSER	19980116	F	
+CARROL	SILAGO	19310326	F	
+GAYLENE	WINE	19480828	M	
+ZONIA	DROSTE	20010321	M	
+AL	GROSSWILER	19100808	F	
+DELILA	KIRSHNER	19920327	M	
+TERESIA	HUCKFELDT	19260703	M	
+RENALDO	ISLA	19190510	F	
+EDUARDO	MARTEL	19980204	F	
+MONTY	TRELEVEN	19090822	F	
+CONCHA	PEGODA	19860826	M	
+BENEDICT	TOPE	19611210	F	
+JULIAN	BASQUEZ	20001211	M	
+LANNIE	POMPEI	19940611	M	
+KURTIS	MANZ	19111004	F	
+MERYL	RUISE	19250428	M	
+CALEB	SATTERLY	19100120	F	
+IRENA	HERRIOTT	19230423	M	
+JANISE	CHESICK	19240919	M	
+WES	STERMAN	19471210	F	
+CARLENA	SOLDANO	19830518	M	
+CARRIE	URBAN	19180521	M	
+VERNON	WORTH	19700128	M	
+HUEY	AVIS	19940626	F	
+GILDA	DONNELLY	19770803	M	
+GINO	SHAPLEIGH	19970914	F	
+DANIELL	WHITEY	19200409	M	
+STEWART	SELBY	20040914	F	
+JACKIE	CODDINGTON	19630827	F	
+SOL	HURON	19620603	F	
+TAMAR	FONGEALLAZ	19311202	M	
+RAE	SENCABAUGH	19140103	M	
+DELILA	GOMORA	20020917	M	
+EPIFANIA	HATTABAUGH	19311218	M	
+CARYN	SIDBERRY	20010422	M	
+PERRY	GRINNAN	19081104	F	
+WILLIAMS	RIOLO	19370307	F	
+DARON	ZIPF	19250608	F	
+YUKI	BOYTE	19450613	M	
+VONDA	MCPEAKE	19250602	M	
+ANDREW	BROSSARD	19410809	F	
+PORFIRIO	SWEET	19570326	F	
+BRANDON	BRUMBAUGH	19110428	F	
+WILEY	GLADFELTER	19020414	F	
+LOVE	SLEIMAN	19251213	M	
+DELPHA	POHLMAN	19320318	M	
+DANIKA	HEINEY	19570505	M	
+CYNDI	RACIOPPI	19290803	M	
+LAVERN	REISIN	19650403	F	
+FREEDA	TIMME	19690426	M	
+FRANK	LAVEAR	19171118	F	
+TIFANY	PELCZAR	19320223	M	
+JAMEY	VALERY	19490809	F	
+HA	GRIEVES	19800511	M	
+CURTIS	BRUDER	19821221	F	
+CLYDE	BRANDWEIN	19881022	F	
+MALCOLM	LABOUNTY	19750602	F	
+KAYLENE	RIFFE	19940301	M	
+REYNALDO	SERL	19841012	F	
+MARIETTE	GREGOR	19120212	M	
+WENONA	STINCHFIELD	19250109	M	
+MARGENE	LENDRUM	19921124	M	
+LYNETTE	NYPAVER	19981101	M	
+PAULINA	STEARNE	19871226	M	
+ALAINA	CHIAPETTO	19621118	M	
+ALESHA	SPINK	19601028	M	
+ESTEBAN	NEZICH	19680410	F	
+ZAIDA	GATLIN	19180228	M	
+VIOLA	MAGGIE	19291214	M	
+JENE	GUNTHARP	19080326	M	
+STACY	KLEMAN	19451009	F	
+BART	TANNEHILL	19181018	F	
+JAN	HACKL	19200902	F	
+SHASTA	LOCASTRO	19711225	M	
+JAZMIN	IVESTER	19240403	M	
+BLAINE	FURLER	19820326	F	
+PETER	LICARI	19771107	F	
+LURLENE	GLASPIE	19970813	M	
+CLEO	KIRBIE	19900311	F	
+LELAH	LECKBEE	19520727	M	
+BERRY	LAZOTT	19400226	F	
+EVON	DELLIBOVI	19130403	M	
+JACINDA	MOSBY	19220906	M	
+MATTHEW	FINNEFROCK	19361106	F	
+AHMAD	MCALL	19191007	F	
+LAURYN	PERGRAM	19701007	M	
+LIEN	POPA	19440308	M	
+PARTHENIA	SWARY	19091003	M	
+BRINDA	TOMMOLINO	19651021	M	
+KASEY	DIETEMAN	19781027	M	
+ORALEE	LAWTON	19171208	M	
+MICKI	PUCIO	19651107	M	
+ERICK	CRATER	19940519	F	
+OSCAR	GALAGHER	19220604	F	
+AMAL	MCCUISTION	19130502	M	
+JOANNA	COLWELL	19290318	M	
+RANA	RIEHLE	19640410	M	
+GAYLENE	CAFFERTY	19230228	M	
+RICKY	TALLEUT	19540419	F	
+MARTIN	TROPEA	19410401	F	
+NOEL	SKOVIRA	19261105	F	
+INDIRA	CORFMAN	19250428	M	
+RACHEL	MENSCH	19590118	M	
+DELAINE	OPPEL	19981027	M	
+JALISA	BEIGERT	19120814	M	
+MONROE	DULUDE	19880114	F	
+SANTIAGO	PALITTI	19390424	F	
+JOHN	TROESCH	19700527	F	
+FRANCISCO	CAMMARANO	19111124	F	
+NORINE	ZETINO	19061106	M	
+COREEN	CHERNOW	19590527	M	
+TREY	TRULY	19640519	F	
+ROMAN	STEPHCO	19040912	F	
+LUCIO	DAHILL	19380611	F	
+BERNIE	CHIRAS	19790317	M	
+HARLEY	DOWNEN	19460613	F	
+MARCENE	BOZZELL	19751114	M	
+JAMISON	OLMOS	19870425	F	
+ADRIANNE	SHIFLEY	19410312	M	
+KARMA	HOLLINSHED	20030512	M	
+VIDA	STAUM	19580427	M	
+BIRGIT	PAVLICEK	19560604	M	
+NANCI	OREILY	19490318	M	
+CECIL	NAWROCKI	19360622	F	
+LEON	WETZSTEIN	19641016	F	
+CLAIR	REMSEN	19540918	M	
+LIZETH	CARBAUGH	19360325	M	
+DARIO	HIGASHIDA	19110910	F	
+LELAND	VASS	19550726	F	
+VERDELL	MOLLURA	19740208	M	
+ALIX	WHETZEL	19520426	M	
+JOAQUINA	LLOPIS	19860606	M	
+DEDRA	MARINERO	19680423	M	
+WILLIAM	HUGLEY	19521128	F	
+FLOYD	TSUTSUI	19010513	F	
+JAYMIE	REGLER	19901217	M	
+MAGAN	GULDE	19840626	M	
+JAYSON	TOELKE	19730822	F	


Mime
View raw message