| Methods Summary |
|---|
| protected void | appendBoolean(java.lang.Boolean bool, java.io.Writer writer)Appends a Boolean value.
Refer to : http://www.postgresql.org/docs/8.0/static/datatype-boolean.html
In PostgreSQL the following are the values that
are value for a boolean field
Valid literal values for the "true" state are:
TRUE, 't', 'true', 'y', 'yes', '1'
Valid literal values for the false" state are :
FALSE, 'f', 'false', 'n', 'no', '0'
To be consistent with the other data platforms we are using the values
'1' and '0' for true and false states of a boolean field.
if (bool.booleanValue()) {
writer.write("\'1\'");
} else {
writer.write("\'0\'");
}
|
| protected java.util.Hashtable | buildFieldTypes()
Hashtable fieldTypeMapping = new Hashtable();
fieldTypeMapping.put(Boolean.class, new FieldTypeDefinition("BOOLEAN", false));
fieldTypeMapping.put(Integer.class, new FieldTypeDefinition("INTEGER", false));
fieldTypeMapping.put(Long.class, new FieldTypeDefinition("BIGINT", false));
fieldTypeMapping.put(Float.class, new FieldTypeDefinition("FLOAT"));
fieldTypeMapping.put(Double.class, new FieldTypeDefinition("FLOAT", false));
fieldTypeMapping.put(Short.class, new FieldTypeDefinition("SMALLINT", false));
fieldTypeMapping.put(Byte.class, new FieldTypeDefinition("SMALLINT", false));
fieldTypeMapping.put(java.math.BigInteger.class, new FieldTypeDefinition("BIGINT", false));
fieldTypeMapping.put(java.math.BigDecimal.class, new FieldTypeDefinition("DECIMAL",38));
fieldTypeMapping.put(Number.class, new FieldTypeDefinition("DECIMAL",38));
fieldTypeMapping.put(String.class, new FieldTypeDefinition("VARCHAR", 255));
fieldTypeMapping.put(Character.class, new FieldTypeDefinition("CHAR", 1));
fieldTypeMapping.put(Byte[].class, new FieldTypeDefinition("BYTEA"));
fieldTypeMapping.put(Character[].class, new FieldTypeDefinition("TEXT"));
fieldTypeMapping.put(byte[].class, new FieldTypeDefinition("BYTEA"));
fieldTypeMapping.put(char[].class, new FieldTypeDefinition("TEXT"));
fieldTypeMapping.put(java.sql.Blob.class, new FieldTypeDefinition("BYTEA"));
fieldTypeMapping.put(java.sql.Clob.class, new FieldTypeDefinition("TEXT"));
fieldTypeMapping.put(java.sql.Date.class, new FieldTypeDefinition("DATE", false));
fieldTypeMapping.put(java.sql.Time.class, new FieldTypeDefinition("TIME", false));
fieldTypeMapping.put(java.sql.Timestamp.class, new FieldTypeDefinition("TIMESTAMP", false));
return fieldTypeMapping;
|
| public oracle.toplink.essentials.queryframework.ValueReadQuery | buildSelectQueryForNativeSequence(java.lang.String seqName, java.lang.Integer size)INTERNAL:
Build the identity query for native sequencing.
ValueReadQuery selectQuery = new ValueReadQuery();
selectQuery.setSQLString("select currval(\'" + seqName + "\')");
return selectQuery;
|
| public java.lang.String | getAssignmentString()INTERNAL
Used for stored function calls.
return ":= ";
|
| protected java.lang.String | getCreateTempTableSqlBodyForTable(oracle.toplink.essentials.internal.helper.DatabaseTable table)INTERNAL:
// returning null includes fields of the table in body
// see javadoc of DatabasePlatform#getCreateTempTableSqlBodyForTable(DataBaseTable)
// for details
return null;
|
| protected java.lang.String | getCreateTempTableSqlPrefix()INTERNAL:
return "CREATE GLOBAL TEMPORARY TABLE ";
|
| protected java.lang.String | getCreateTempTableSqlSuffix()INTERNAL:
// http://pgsqld.active-venture.com/sql-createtable.html
return " ON COMMIT PRESERVE ROWS";
|
| protected java.lang.String | getDBSequenceName(java.lang.String tableName, java.lang.String pkFieldName)
StringBuffer seqName = new StringBuffer(tableName);
seqName.append("_").append(pkFieldName).append("_seq");
return seqName.toString();
|
| public java.lang.String | getInOutputProcedureToken()This method is used to print the output parameter token when stored
procedures are called
return "OUT";
|
| public int | getMaxFieldNameSize()INTERNAL:
returns the maximum number of characters that can be used in a field
name on this platform.
// The system uses no more than NAMEDATALEN-1 characters of an identifier; longer names can be written in commands,
// but they will be truncated. By default, NAMEDATALEN is 64 so the maximum identifier length is 63 (but at the time PostgreSQL
// is built, NAMEDATALEN can be changed in src/include/postgres_ext.h).
// http://www.postgresql.org/docs/7.3/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
return 63;
|
| public java.lang.String | getProcedureBeginString()INTERNAL:
Used for sp calls.
return "AS $$ BEGIN ";
|
| public java.lang.String | getProcedureCallHeader()INTERNAL:
Used for sp calls.
return "EXECUTE ";
|
| public java.lang.String | getProcedureEndString()INTERNAL:
Used for sp calls.
return "; END ; $$ LANGUAGE plpgsql;";
|
| public oracle.toplink.essentials.queryframework.ValueReadQuery | getTimestampQuery()INTERNAL:
This method returns the query to select the timestamp from the server
for Derby.
if (timestampQuery == null) {
timestampQuery = new ValueReadQuery();
timestampQuery.setSQLString("SELECT NOW()");
}
return timestampQuery;
|
| protected void | initializePlatformOperators()INTERNAL:
Initialize any platform-specific operators
super.initializePlatformOperators();
addOperator(ExpressionOperator.simpleLogicalNoParens(ExpressionOperator.Concat, "||"));
addOperator(ExpressionOperator.simpleTwoArgumentFunction(ExpressionOperator.Nvl, "NULLIF"));
addOperator(operatorLocate());
|
| public boolean | isPostgreSQL()INTERNAL:
Answers whether platform is Derby
return true;
|
| protected oracle.toplink.essentials.expressions.ExpressionOperator | operatorLocate()INTERNAL:
Override the default locate operator
ExpressionOperator result = new ExpressionOperator();
result.setSelector(ExpressionOperator.Locate);
Vector v = new Vector(3);
v.addElement("STRPOS(");
v.addElement(", ");
v.addElement(")");
result.printsAs(v);
result.bePrefix();
result.setNodeClass(RelationExpression.class);
return result;
|
| public void | platformSpecificSequencingInitialization(oracle.toplink.essentials.sessions.DatabaseSession session)INTERNAL:
Platform specific sequencing initialization.
This internal method should only be called by SequencingManager.
For PostgreSQL database for id fields that are defined as "SERIAL" the database creates
an implicit sequence. The name of the sequence provided by the database is of the form
__seq.
As part of the insert statement we need to get the correct sequence to be able to get
the next value. This code ensures that we have our internal structures pointing to the
correct sequence name for the runtime code to work correctly.
The current version of postgresql allows only 1 SERIAL field to be defined per table.
Boolean isDefaultSequenceNative = null;
// We need to iterate over all the entities
Iterator iterator = session.getProject().getDescriptors().values().iterator();
Sequence sequence;
HashSet toBeRemoved = new HashSet();
while (iterator.hasNext()) {
ClassDescriptor descriptor = (ClassDescriptor)iterator.next();
// Ensure that the entity uses sequencing
if (descriptor.usesSequenceNumbers()) {
String currSequenceName = descriptor.getSequenceNumberName();
sequence = getSequence(currSequenceName);
boolean shouldVerifySequenceName;
boolean usesDefaultSequence = sequence == null || sequence instanceof DefaultSequence;
if(usesDefaultSequence) {
// is defaultSequence is a NativeSequence?
if(isDefaultSequenceNative == null) {
isDefaultSequenceNative = new Boolean(getDefaultSequence() instanceof NativeSequence);
}
shouldVerifySequenceName = isDefaultSequenceNative.booleanValue();
} else {
shouldVerifySequenceName = sequence instanceof NativeSequence;
}
if(shouldVerifySequenceName) {
DatabaseTable tbl = (DatabaseTable)descriptor.getTables().firstElement();
String tableName = tbl.getQualifiedName();
String pkFieldName = descriptor.getSequenceNumberField().getName();
String seqName = getDBSequenceName(tableName, pkFieldName);
if(!currSequenceName.equals(seqName)) {
descriptor.setSequenceNumberName(seqName);
if(sequence != null) {
Sequence newSequence = (Sequence)sequence.clone();
newSequence.setName(seqName);
addSequence(newSequence);
toBeRemoved.add(currSequenceName);
}
}
}
}
}
Iterator itToBeRemoved = toBeRemoved.iterator();
while(itToBeRemoved.hasNext()) {
removeSequence((String)itToBeRemoved.next());
}
|
| public void | printFieldIdentityClause(java.io.Writer writer)INTERNAL:
Append the receiver's field 'identity' constraint clause to a writer
try {
writer.write(" SERIAL");
} catch (IOException ioException) {
throw ValidationException.fileError(ioException);
}
|
| public void | printFieldTypeSize(java.io.Writer writer, oracle.toplink.essentials.tools.schemaframework.FieldDefinition field, oracle.toplink.essentials.internal.databaseaccess.FieldTypeDefinition fieldType, oracle.toplink.essentials.internal.sessions.AbstractSession session, java.lang.String qualifiedFieldName)
if(!shouldAcquireSequenceValueAfterInsert(session, qualifiedFieldName)) {
writer.write(fieldType.getName());
if ((fieldType.isSizeAllowed()) && ((field.getSize() != 0) || (fieldType.isSizeRequired()))) {
writer.write("(");
if (field.getSize() == 0) {
writer.write(new Integer(fieldType.getDefaultSize()).toString());
} else {
writer.write(new Integer(field.getSize()).toString());
}
if (field.getSubSize() != 0) {
writer.write(",");
writer.write(new Integer(field.getSubSize()).toString());
} else if (fieldType.getDefaultSubSize() != 0) {
writer.write(",");
writer.write(new Integer(fieldType.getDefaultSubSize()).toString());
}
writer.write(")");
}
}
|
| public void | printFieldUnique(java.io.Writer writer, boolean isUnique, oracle.toplink.essentials.internal.sessions.AbstractSession session, java.lang.String qualifiedFieldName)
if(!shouldAcquireSequenceValueAfterInsert(session, qualifiedFieldName)) {
if (isUnique) {
if (supportsPrimaryKeyConstraint()) {
writer.write(" UNIQUE");
}
}
}
|
| protected void | setPrimitiveParameterValue(java.sql.PreparedStatement statement, int index, java.lang.Object parameter)Set a primitive parameter.
Postgres jdbc client driver give problem when doing a setObject() for wrapper types.
Ideally this code should be in the DatabasePlatform so that all platforms can use
this.
if (parameter instanceof Number) {
Number number = (Number) parameter;
if (number instanceof Integer) {
statement.setInt(index, number.intValue());
} else if (number instanceof Long) {
statement.setLong(index, number.longValue());
} else if (number instanceof Short) {
statement.setShort(index, number.shortValue());
} else if (number instanceof Byte) {
statement.setByte(index, number.byteValue());
} else if (number instanceof Double) {
statement.setDouble(index, number.doubleValue());
} else if (number instanceof Float) {
statement.setFloat(index, number.floatValue());
} else if (number instanceof BigDecimal) {
statement.setBigDecimal(index, (BigDecimal) number);
} else if (number instanceof BigInteger) {
statement.setBigDecimal(index, new BigDecimal((BigInteger) number));
} else {
statement.setObject(index, parameter);
}
} else if (parameter instanceof String) {
statement.setString(index, (String)parameter);
} else if (parameter instanceof Boolean) {
statement.setBoolean(index, ((Boolean) parameter).booleanValue());
} else {
statement.setObject(index, parameter);
}
|
| public boolean | shouldNativeSequenceAcquireValueAfterInsert()INTERNAL:
Indicates whether NativeSequence should retrieve
sequence value after the object has been inserted into the db
This method is to be used *ONLY* by sequencing classes
return true;
|
| public boolean | shouldPrintOutputTokenAtStart()This is required in the construction of the stored procedures with
output parameters
//TODO: Check with the reviewer where this is used
return false;
|
| public boolean | shouldUseJDBCOuterJoinSyntax()JDBC defines and outer join syntax, many drivers do not support this. So we normally avoid it.
return false;
|
| public boolean | supportsGlobalTempTables()INTERNAL:
return true;
|
| public boolean | supportsNativeSequenceNumbers()
return true;
|
