AccessPlatformpublic class AccessPlatform extends DatabasePlatform Purpose: Provides Microsoft Access specific behaviour. |
| Methods Summary |
|---|
| protected java.util.Hashtable | buildClassTypes()
Hashtable classTypeMapping = super.buildClassTypes();
// In access LONG means numeric not CLOB like in Oracle
classTypeMapping.put("LONG", Long.class);
classTypeMapping.put("TEXT", String.class);
return classTypeMapping;
| | protected java.util.Hashtable | buildFieldTypes()
Hashtable fieldTypeMapping;
fieldTypeMapping = new Hashtable();
fieldTypeMapping.put(Boolean.class, new FieldTypeDefinition("BIT", false));
fieldTypeMapping.put(Integer.class, new FieldTypeDefinition("LONG", false));
fieldTypeMapping.put(Long.class, new FieldTypeDefinition("DOUBLE", false));
fieldTypeMapping.put(Float.class, new FieldTypeDefinition("DOUBLE", false));
fieldTypeMapping.put(Double.class, new FieldTypeDefinition("DOUBLE", false));
fieldTypeMapping.put(Short.class, new FieldTypeDefinition("SHORT", false));
fieldTypeMapping.put(Byte.class, new FieldTypeDefinition("BYTE", false));
fieldTypeMapping.put(java.math.BigInteger.class, new FieldTypeDefinition("DOUBLE", false));
fieldTypeMapping.put(java.math.BigDecimal.class, new FieldTypeDefinition("DOUBLE", false));
fieldTypeMapping.put(Number.class, new FieldTypeDefinition("DOUBLE", false));
fieldTypeMapping.put(String.class, new FieldTypeDefinition("TEXT", 255));
fieldTypeMapping.put(Character.class, new FieldTypeDefinition("TEXT", 1));
fieldTypeMapping.put(Byte[].class, new FieldTypeDefinition("LONGBINARY", false));
fieldTypeMapping.put(Character[].class, new FieldTypeDefinition("MEMO", false));
fieldTypeMapping.put(byte[].class, new FieldTypeDefinition("LONGBINARY", false));
fieldTypeMapping.put(char[].class, new FieldTypeDefinition("MEMO", false));
fieldTypeMapping.put(java.sql.Blob.class, new FieldTypeDefinition("LONGBINARY", false));
fieldTypeMapping.put(java.sql.Clob.class, new FieldTypeDefinition("MEMO", false));
fieldTypeMapping.put(java.sql.Date.class, new FieldTypeDefinition("DATETIME", false));
fieldTypeMapping.put(java.sql.Time.class, new FieldTypeDefinition("DATETIME", false));
fieldTypeMapping.put(java.sql.Timestamp.class, new FieldTypeDefinition("DATETIME", false));
return fieldTypeMapping;
| | public int | getMaxFieldNameSize()INTERNAL:
returns the maximum number of characters that can be used in a field
name on this platform.
return 64;
| | public java.sql.Timestamp | getTimestampFromServer(oracle.toplink.essentials.internal.sessions.AbstractSession session, java.lang.String sessionName)INTERNAL:
Access do not support millisecond well, truncate the millisecond from the timestamp
if (getTimestampQuery() == null) {
java.sql.Timestamp currentTime = new java.sql.Timestamp(System.currentTimeMillis());
currentTime.setNanos(0);
return currentTime;
} else {
getTimestampQuery().setSessionName(sessionName);
return (java.sql.Timestamp)session.executeQuery(getTimestampQuery());
}
| | protected void | initializePlatformOperators()INTERNAL:
Initialize any platform-specific operators
super.initializePlatformOperators();
addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.ToUpperCase, "UCASE"));
addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.ToLowerCase, "LCASE"));
| | public boolean | isAccess()
return true;
| | public java.util.Hashtable | maximumNumericValues()INTERNAL:
Builds a table of maximum numeric values keyed on java class. This is used for type testing but
might also be useful to end users attempting to sanitize values.
NOTE: BigInteger & BigDecimal maximums are dependent upon their precision & Scale
Hashtable values = new Hashtable();
values.put(Integer.class, new Integer(Integer.MAX_VALUE));
values.put(Long.class, new Long(Long.MAX_VALUE));
values.put(Double.class, new Double(Double.MAX_VALUE));
values.put(Short.class, new Short(Short.MAX_VALUE));
values.put(Byte.class, new Byte(Byte.MAX_VALUE));
values.put(Float.class, new Float(123456789));
values.put(java.math.BigInteger.class, new java.math.BigInteger("999999999999999"));
values.put(java.math.BigDecimal.class, new java.math.BigDecimal("99999999999999999999.9999999999999999999"));
return values;
| | public java.util.Hashtable | minimumNumericValues()INTERNAL:
Builds a table of minimum numeric values keyed on java class. This is used for type testing but
might also be useful to end users attempting to sanitize values.
NOTE: BigInteger & BigDecimal minimums are dependent upon their precision & Scale
Hashtable values = new Hashtable();
values.put(Integer.class, new Integer(Integer.MIN_VALUE));
values.put(Long.class, new Long(Long.MIN_VALUE));
values.put(Double.class, new Double(Double.MIN_VALUE));
values.put(Short.class, new Short(Short.MIN_VALUE));
values.put(Byte.class, new Byte(Byte.MIN_VALUE));
values.put(Float.class, new Float(-123456789));
values.put(java.math.BigInteger.class, new java.math.BigInteger("-999999999999999"));
values.put(java.math.BigDecimal.class, new java.math.BigDecimal("-9999999999999999999.9999999999999999999"));
return values;
| | public void | printFieldNotNullClause(java.io.Writer writer)INTERNAL:
Append the receiver's field 'NOT NULL' constraint clause to a writer.
// Do nothing
| | public boolean | requiresNamedPrimaryKeyConstraints()INTERNAL:
This is used as some databases create the primary key constraint differently, i.e. Access.
return true;
| | public boolean | shouldUseJDBCOuterJoinSyntax()INTERNAL:
JDBC defines and outer join syntax, many drivers do not support this. So we normally avoid it.
return false;
|
|
