KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > apache > ojb > broker > platforms > PlatformDerbyImpl


1 package org.apache.ojb.broker.platforms;
2
3 /* Copyright 2002-2005 The Apache Software Foundation
4  *
5  * Licensed under the Apache License, Version 2.0 (the "License");
6  * you may not use this file except in compliance with the License.
7  * You may obtain a copy of the License at
8  *
9  * 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 import java.sql.PreparedStatement JavaDoc;
19 import java.sql.SQLException JavaDoc;
20 import java.sql.Types JavaDoc;
21
22 /**
23  * This class defines specific behavior for the Derby platform.
24  */
25 public class PlatformDerbyImpl extends PlatformDefaultImpl
26 {
27     /**
28      * {@inheritDoc}
29      */
30     public byte getJoinSyntaxType()
31     {
32         return SQL92_NOPAREN_JOIN_SYNTAX;
33     }
34
35     /**
36      * {@inheritDoc}
37      */
38     public boolean supportsMultiColumnCountDistinct()
39     {
40         // Currently Derby supports COUNT DISTINCT only for one column
41 return false;
42     }
43
44     /**
45      * {@inheritDoc}
46      */
47     public void setObjectForStatement(PreparedStatement JavaDoc ps, int index, Object JavaDoc value, int jdbcType) throws SQLException JavaDoc
48     {
49         if (((jdbcType == Types.CHAR) || (jdbcType == Types.VARCHAR)) &&
50             (value instanceof Character JavaDoc))
51         {
52             // [tomdz]
53 // Currently, Derby doesn't like Character objects in the PreparedStatement
54 // when using PreparedStatement#setObject(index, value, jdbcType) method
55 // (see issue DERBY-773)
56 // So we make a String object out of the Character object and use that instead
57 super.setObjectForStatement(ps, index, value.toString(), jdbcType);
58         }
59         else
60         {
61             super.setObjectForStatement(ps, index, value, jdbcType);
62         }
63     }
64
65     /**
66      * {@inheritDoc}
67      */
68     public String JavaDoc getLastInsertIdentityQuery(String JavaDoc tableName)
69     {
70         // matthias.roth@impart.ch
71 // the function is used by the org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl
72 // this call must be made before commit the insert command, so you
73 // must turn off autocommit by seting the useAutoCommit="2"
74 // or use useAutoCommit="1" or use a connection with autoCommit set false
75 // by default (e.g. in managed environments)
76 // transaction demarcation is mandatory
77 return "values IDENTITY_VAL_LOCAL()";
78     }
79 }
80
Popular Tags