KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > apache > cayenne > dba > postgres > PostgresProcedureAction


1 /*****************************************************************
2  * Licensed to the Apache Software Foundation (ASF) under one
3  * or more contributor license agreements. See the NOTICE file
4  * distributed with this work for additional information
5  * regarding copyright ownership. The ASF licenses this file
6  * to you under the Apache License, Version 2.0 (the
7  * "License"); you may not use this file except in compliance
8  * with the License. You may obtain a copy of the License at
9  *
10  * http://www.apache.org/licenses/LICENSE-2.0
11  *
12  * Unless required by applicable law or agreed to in writing,
13  * software distributed under the License is distributed on an
14  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
15  * KIND, either express or implied. See the License for the
16  * specific language governing permissions and limitations
17  * under the License.
18  ****************************************************************/
19
20 package org.apache.cayenne.dba.postgres;
21
22 import java.sql.Connection JavaDoc;
23
24 import org.apache.cayenne.access.trans.ProcedureTranslator;
25 import org.apache.cayenne.dba.DbAdapter;
26 import org.apache.cayenne.dba.sqlserver.SQLServerProcedureAction;
27 import org.apache.cayenne.map.EntityResolver;
28 import org.apache.cayenne.query.ProcedureQuery;
29
30 /**
31  * Current implementation simply relies on SQLServerProcedureAction superclass behavior.
32  * Namely that CallableStatement.execute() rewinds result set pointer so
33  * CallableStatement.getMoreResults() shouldn't be invoked until the first result set is
34  * processed.
35  *
36  * @since 1.2
37  * @author Andrus Adamchik
38  */
39 class PostgresProcedureAction extends SQLServerProcedureAction {
40
41     PostgresProcedureAction(ProcedureQuery query, DbAdapter adapter,
42             EntityResolver entityResolver) {
43         super(query, adapter, entityResolver);
44     }
45
46     /**
47      * Creates a translator that adds parenthesis to no-param queries.
48      */
49     // see CAY-750 for the problem description
50 protected ProcedureTranslator createTranslator(Connection JavaDoc connection) {
51         ProcedureTranslator translator = new PostgresProcedureTranslator();
52         translator.setAdapter(getAdapter());
53         translator.setQuery(query);
54         translator.setEntityResolver(getEntityResolver());
55         translator.setConnection(connection);
56         return translator;
57     }
58
59     static class PostgresProcedureTranslator extends ProcedureTranslator {
60
61         protected String JavaDoc createSqlString() {
62
63             String JavaDoc sql = super.createSqlString();
64
65             // add empty parameter parenthesis
66 if (sql.endsWith("}") && !sql.endsWith(")}")) {
67                 sql = sql.substring(0, sql.length() - 1) + "()}";
68             }
69
70             return sql;
71         }
72     }
73 }
74
Popular Tags