I am wondering how this will affect other fields in my tables where I might happen to store a 1 or a 0 but instead of booleans they represent an ID from another table. Will it only substitute if the mapping calls for a boolean and it sees a 1 or a 0?
When in doubt, go to the source. The net.sf.hibernate.type.BooleanType mapper simply uses the PreparedStatement.setBoolean(int, b) method. Maybe Oracle's driver handles this part of it.
Chapter 5. Basic O/R Mapping
5.2.2 Basic value types
Type mappings from Java primitives or wrapper classes to appropriate (vendor-specific) SQL column types. boolean, yes_no and true_false are all alternative encodings for a Java boolean or java.lang.Boolean.
I am needing a field in my MySQL database that represents whether or not the user is currently active.