/*
* JFolder, Copyright 2001-2006 Gary Steinmetz
*
* Distributable under LGPL license.
* See terms of license at gnu.org.
*/
package org.jfolder.workflow.lifecycle;
//base classes
import java.util.ArrayList;
//project specific classes
import org.jfolder.workflow.query.BaseDBQueryVendor;
import org.jfolder.workflow.query.BaseDBQueryVendorProprietarySyntax;
import org.jfolder.workflow.query.StringQueryContainer;
//other classes
/*
public class OracleQueryVendorProprietarySyntax
implements BaseDBQueryVendorProprietarySyntax {
private final static String GET_PF_STRING_VALUE_FUNCTION =
"get_pf_string_value";
public OracleQueryVendorProprietarySyntax() {
}
public void constructStringIsEqualClause(StringBuffer inSb,
ArrayList inParameters, StringQueryContainer inSqc) {
String stringValue = inSqc.getStringValue();
if (stringValue != null && stringValue.length() > 0) {
inSb.append(GET_PF_STRING_VALUE_FUNCTION + "("
+ BaseDBQueryVendor.STRING_VALUE + ", "
+ BaseDBQueryVendor.LONG_STRING_VALUE + ") = ?");
inParameters.add(inSqc.getStringValue());
}
else {
inSb.append("((" + BaseDBQueryVendor.STRING_VALUE
+ " IS NULL) AND ("
+ BaseDBQueryVendor.LONG_STRING_VALUE + " IS NULL))");
}
}
public void constructStringIsLikeClause(StringBuffer inSb,
ArrayList inParameters, StringQueryContainer inSqc) {
inSb.append(GET_PF_STRING_VALUE_FUNCTION + "("
+ BaseDBQueryVendor.STRING_VALUE + ", "
+ BaseDBQueryVendor.LONG_STRING_VALUE + ") like ?");
inParameters.add(inSqc.getStringValue());
}
public void constructStringIsNotEqualClause(StringBuffer inSb,
ArrayList inParameters, StringQueryContainer inSqc) {
String stringValue = inSqc.getStringValue();
if (stringValue != null && stringValue.length() > 0) {
inSb.append(GET_PF_STRING_VALUE_FUNCTION + "("
+ BaseDBQueryVendor.STRING_VALUE + ", "
+ BaseDBQueryVendor.LONG_STRING_VALUE + ") <> ?");
inParameters.add(inSqc.getStringValue());
}
else {
inSb.append("((" + BaseDBQueryVendor.STRING_VALUE
+ " IS NOT NULL) OR ("
+ BaseDBQueryVendor.LONG_STRING_VALUE + " IS NOT NULL))");
}
}
public void constructStringIsNotLikeClause(StringBuffer inSb,
ArrayList inParameters, StringQueryContainer inSqc) {
inSb.append(GET_PF_STRING_VALUE_FUNCTION + "("
+ BaseDBQueryVendor.STRING_VALUE + ", "
+ BaseDBQueryVendor.LONG_STRING_VALUE + ") not like ?");
inParameters.add(inSqc.getStringValue());
}
}*/
|