diff --git a/empire-db/src/main/java/org/apache/empire/db/DBRecord.java b/empire-db/src/main/java/org/apache/empire/db/DBRecord.java
index 8a1f1cc..0f337be 100644
--- a/empire-db/src/main/java/org/apache/empire/db/DBRecord.java
+++ b/empire-db/src/main/java/org/apache/empire/db/DBRecord.java
@@ -21,7 +21,9 @@
 import java.lang.reflect.InvocationTargetException;
 import java.sql.Connection;
 import java.util.Collection;
+import java.util.HashSet;
 import java.util.List;
+import java.util.Set;
 
 import org.apache.commons.beanutils.BeanUtilsBean;
 import org.apache.commons.beanutils.PropertyUtilsBean;
@@ -32,6 +34,7 @@
 import org.apache.empire.data.ColumnExpr;
 import org.apache.empire.data.Record;
 import org.apache.empire.db.exceptions.FieldIsReadOnlyException;
+import org.apache.empire.db.expr.compare.DBCompareExpr;
 import org.apache.empire.exceptions.BeanPropertyGetException;
 import org.apache.empire.exceptions.InvalidArgumentException;
 import org.apache.empire.exceptions.ObjectNotValidException;
@@ -833,7 +836,7 @@
     }
 
     /**
-     * Loads a record from the database identified by it's primary key. 
+     * Reads a record from the database identified by it's primary key. 
      * After successful reading the record will be valid and all values will be accessible.
      * @see org.apache.empire.db.DBTable#readRecord(DBRecord, Object[], Connection)
      * 
@@ -850,7 +853,7 @@
     }
 
     /**
-     * Loads a record from the database identified by it's primary key. 
+     * Reads a record from the database identified by it's primary key. 
      * After successful reading the record will be valid and all values will be accessible.
      * @see org.apache.empire.db.DBTable#readRecord(DBRecord, Object[], Connection)
      * 
@@ -869,6 +872,33 @@
     }
 
     /**
+     * Reads a record from the database identified by one or more constraints. 
+     * 
+     * In oder to concatenate constraints use the and() operator from the first constraint
+     * e.g. FIRSTNAME.is("Joe").and(LASTNAME.is("Doe"))
+     * 
+     * @param table the rowset from which to read the record
+     * @param whereConstraints the constraint(s) (which must all be on the table)
+     * @param conn a valid connection to the database.
+     */
+    public void read(DBRowSet table, DBCompareExpr whereConstraints, Connection conn)
+    {
+        if (whereConstraints==null)
+            throw new InvalidArgumentException("whereConstraints", null);
+        // check constraints
+        Set<DBColumn> columns = new HashSet<DBColumn>();
+        whereConstraints.addReferencedColumns(columns);
+        for (DBColumn c : columns)
+            if (!table.equals(c.getRowSet()))
+                throw new InvalidArgumentException("whereConstraints", c.getFullName());
+        // read now
+        DBCommand cmd = table.getDatabase().createCommand();
+        cmd.select(table.getColumns());
+        cmd.where(whereConstraints);
+        table.readRecord(this, cmd, conn);
+    }
+
+    /**
      * Updates the record and saves all changes in the database.
      * 
      * @see org.apache.empire.db.DBTable#updateRecord(DBRecord, Connection)
diff --git a/empire-db/src/main/java/org/apache/empire/db/oracle/DBDatabaseDriverOracle.java b/empire-db/src/main/java/org/apache/empire/db/oracle/DBDatabaseDriverOracle.java
index c25e7b9..5e32c1d 100644
--- a/empire-db/src/main/java/org/apache/empire/db/oracle/DBDatabaseDriverOracle.java
+++ b/empire-db/src/main/java/org/apache/empire/db/oracle/DBDatabaseDriverOracle.java
@@ -78,6 +78,9 @@
     {
         // Info
         log.info("DBDatabaseDriverOracle created. Boolean Type is " + booleanType);
+        // Additional reserved names 
+        this.reservedSQLKeywords.add("date");
+        this.reservedSQLKeywords.add("number");
     }
 
     public boolean isOracle8Compatibilty()