01: /*
02: * Licensed to the Apache Software Foundation (ASF) under one or more
03: * contributor license agreements. See the NOTICE file distributed with
04: * this work for additional information regarding copyright ownership.
05: * The ASF licenses this file to You under the Apache License, Version 2.0
06: * (the "License"); you may not use this file except in compliance with
07: * the License. You may obtain a copy of the License at
08: *
09: * http://www.apache.org/licenses/LICENSE-2.0
10: *
11: * Unless required by applicable law or agreed to in writing, software
12: * distributed under the License is distributed on an "AS IS" BASIS,
13: * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14: * See the License for the specific language governing permissions and
15: * limitations under the License.
16: */
17:
18: package org.apache.cocoon.components.language.markup.xsp;
19:
20: import java.sql.SQLException;
21: import java.sql.PreparedStatement;
22: import java.sql.ResultSet;
23: import java.sql.CallableStatement;
24: import java.sql.Connection;
25:
26: /**
27: * Database specific EsqlQuery
28: * @author <a href="mailto:tcurdt@apache.org">Torsten Curdt</a>
29: * @version CVS $Id: SybaseEsqlQuery.java 433543 2006-08-22 06:22:54Z crossley $
30: */
31: final public class SybaseEsqlQuery extends AbstractEsqlQuery {
32:
33: public SybaseEsqlQuery(Connection connection, String query) {
34: super (connection, query);
35: }
36:
37: /**
38: * Only newInstance may use this contructor
39: * @param resultSet
40: */
41: private SybaseEsqlQuery(final ResultSet resultSet) {
42: super (resultSet);
43: }
44:
45: /**
46: * Create a EsqlQuery of the same type
47: * @param resultSet
48: */
49: public AbstractEsqlQuery newInstance(ResultSet resultSet) {
50: return (new SybaseEsqlQuery(resultSet));
51: }
52:
53: public String getQueryString() throws SQLException {
54: if (getMaxRows() > -1) {
55: String original = super .getQueryString().trim();
56: int command = original.indexOf(' ');
57: return (new StringBuffer().append(
58: original.substring(0, command)).append(" TOP ")
59: .append(getMaxRows() + 1 + getSkipRows()).append(
60: original.substring(command)).toString());
61: } else {
62: return (super .getQueryString());
63: }
64: }
65:
66: public PreparedStatement prepareStatement() throws SQLException {
67: return (setPreparedStatement(getConnection().prepareStatement(
68: getQueryString(), ResultSet.TYPE_SCROLL_INSENSITIVE,
69: ResultSet.CONCUR_READ_ONLY)));
70: }
71:
72: public CallableStatement prepareCall() throws SQLException {
73: return ((CallableStatement) setPreparedStatement(getConnection()
74: .prepareCall(getQueryString(),
75: ResultSet.TYPE_SCROLL_INSENSITIVE,
76: ResultSet.CONCUR_READ_ONLY)));
77: }
78:
79: public void getResultRows() throws SQLException {
80: final int skip = getSkipRows();
81: if (skip > 0) {
82: getResultSet().absolute(skip);
83: }
84: setPosition(skip);
85: }
86:
87: }
|