01: /*
02: * Copyright 2006-2007 The Kuali Foundation.
03: *
04: * Licensed under the Educational Community License, Version 1.0 (the "License");
05: * you may not use this file except in compliance with the License.
06: * You may obtain a copy of the License at
07: *
08: * http://www.opensource.org/licenses/ecl1.php
09: *
10: * Unless required by applicable law or agreed to in writing, software
11: * distributed under the License is distributed on an "AS IS" BASIS,
12: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13: * See the License for the specific language governing permissions and
14: * limitations under the License.
15: */
16: package org.kuali.core.dbplatform;
17:
18: import org.apache.ojb.broker.query.Criteria;
19: import org.kuali.core.dao.jdbc.KualiDBPlatformBase;
20:
21: /**
22: * This class is just for Oracle DB code - should be used only as last resort
23: */
24: public class KualiDBPlatformOracle extends KualiDBPlatformBase
25: implements KualiDBPlatform {
26: public void applyLimit(Integer limit, Criteria criteria) {
27: if (limit != null) {
28: criteria.addSql("rownum <= " + limit.intValue());
29: }
30: }
31:
32: public Long getNextAvailableSequenceNumber(String sequenceName) {
33: return getJdbcTemplate().queryForLong(
34: new StringBuffer("select ").append(sequenceName)
35: .append(".nextval").append(" from dual")
36: .toString());
37: }
38:
39: public String getStrToDateFunction() {
40: return "TO_DATE";
41: }
42:
43: public String getDateFormatString(String dateFormatString) {
44: return "'" + dateFormatString + "'";
45: }
46:
47: public String getCurTimeFunction() {
48: return "sysdate";
49: }
50:
51: public String getUpperCaseFunction() {
52: return "UPPER";
53: }
54: }
|