%line | %branch | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
org.apache.torque.adapter.DBInterbase |
|
|
1 | package org.apache.torque.adapter; |
|
2 | ||
3 | /* |
|
4 | * Copyright 2001-2005 The Apache Software Foundation. |
|
5 | * |
|
6 | * Licensed under the Apache License, Version 2.0 (the "License") |
|
7 | * you may not use this file except in compliance with the License. |
|
8 | * 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, software |
|
13 | * distributed under the License is distributed on an "AS IS" BASIS, |
|
14 | * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
|
15 | * See the License for the specific language governing permissions and |
|
16 | * limitations under the License. |
|
17 | */ |
|
18 | ||
19 | import java.sql.Connection; |
|
20 | import java.sql.SQLException; |
|
21 | import java.sql.Statement; |
|
22 | ||
23 | /** |
|
24 | * This code should be used for an Interbase database pool. |
|
25 | * |
|
26 | * @author <a href="mailto:frank@opticode.co.za">Frank Conradie</a> |
|
27 | * @version $Id: DBInterbase.java 239630 2005-08-24 12:25:32Z henning $ |
|
28 | */ |
|
29 | 0 | public class DBInterbase extends DB |
30 | { |
|
31 | /** |
|
32 | * This method is used to ignore case. |
|
33 | * |
|
34 | * @param in The string to transform to upper case. |
|
35 | * @return The upper case string. |
|
36 | */ |
|
37 | public String toUpperCase(String in) |
|
38 | { |
|
39 | 0 | return new StringBuffer("UPPER(").append(in).append(")").toString(); |
40 | } |
|
41 | ||
42 | /** |
|
43 | * This method is used to ignore case. |
|
44 | * |
|
45 | * @param in The string whose case to ignore. |
|
46 | * @return The string in a case that can be ignored. |
|
47 | */ |
|
48 | public String ignoreCase(String in) |
|
49 | { |
|
50 | 0 | return new StringBuffer("UPPER(").append(in).append(")").toString(); |
51 | } |
|
52 | ||
53 | /** |
|
54 | * This method is used to ignore case in an ORDER BY clause. |
|
55 | * Usually it is the same as ignoreCase, but some databases |
|
56 | * (Interbase for example) does not use the same SQL in ORDER BY |
|
57 | * and other clauses. |
|
58 | * |
|
59 | * @param in The string whose case to ignore. |
|
60 | * @return The string in a case that can be ignored. |
|
61 | */ |
|
62 | public String ignoreCaseInOrderBy(String in) |
|
63 | { |
|
64 | 0 | return in; |
65 | } |
|
66 | ||
67 | /** |
|
68 | * Gets the string delimiter (usually '\''). |
|
69 | * |
|
70 | * @return The delimiter. |
|
71 | */ |
|
72 | public char getStringDelimiter() |
|
73 | { |
|
74 | 0 | return '\''; |
75 | } |
|
76 | ||
77 | /** |
|
78 | * @see org.apache.torque.adapter.DB#getIDMethodType() |
|
79 | */ |
|
80 | public String getIDMethodType() |
|
81 | { |
|
82 | 0 | return NO_ID_METHOD; |
83 | } |
|
84 | ||
85 | /** |
|
86 | * @see org.apache.torque.adapter.DB#getIDMethodSQL(Object obj) |
|
87 | */ |
|
88 | public String getIDMethodSQL(Object obj) |
|
89 | { |
|
90 | 0 | return null; |
91 | } |
|
92 | ||
93 | /** |
|
94 | * Locks the specified table. |
|
95 | * |
|
96 | * @param con The JDBC connection to use. |
|
97 | * @param table The name of the table to lock. |
|
98 | * @exception SQLException No Statement could be created or executed. |
|
99 | */ |
|
100 | public void lockTable(Connection con, String table) throws SQLException |
|
101 | { |
|
102 | 0 | Statement statement = con.createStatement(); |
103 | ||
104 | 0 | StringBuffer stmt = new StringBuffer(); |
105 | 0 | stmt.append("SET TRANSACTION ") |
106 | .append("ISOLATION LEVEL READ COMMITTED ") |
|
107 | .append("NO RECORD_VERSION WAIT ") |
|
108 | .append("RESERVING ") |
|
109 | .append(table) |
|
110 | .append(" FOR PROTECTED WRITE"); |
|
111 | ||
112 | 0 | statement.executeQuery(stmt.toString()); |
113 | 0 | } |
114 | ||
115 | /** |
|
116 | * Unlocks the specified table. |
|
117 | * |
|
118 | * @param con The JDBC connection to use. |
|
119 | * @param table The name of the table to unlock. |
|
120 | * @exception SQLException No Statement could be created or executed. |
|
121 | */ |
|
122 | public void unlockTable(Connection con, String table) throws SQLException |
|
123 | { |
|
124 | // Tables in Interbase are unlocked when a commit is issued. |
|
125 | // The user may have issued a commit but do it here to be |
|
126 | // sure. |
|
127 | 0 | con.commit(); |
128 | 0 | } |
129 | } |
This report is generated by jcoverage, Maven and Maven JCoverage Plugin. |