Source code: org/objectstyle/cayenne/dba/sybase/SybaseAdapter.java
1 /* ====================================================================
2 *
3 * The ObjectStyle Group Software License, Version 1.0
4 *
5 * Copyright (c) 2002-2003 The ObjectStyle Group
6 * and individual authors of the software. All rights reserved.
7 *
8 * Redistribution and use in source and binary forms, with or without
9 * modification, are permitted provided that the following conditions
10 * are met:
11 *
12 * 1. Redistributions of source code must retain the above copyright
13 * notice, this list of conditions and the following disclaimer.
14 *
15 * 2. Redistributions in binary form must reproduce the above copyright
16 * notice, this list of conditions and the following disclaimer in
17 * the documentation and/or other materials provided with the
18 * distribution.
19 *
20 * 3. The end-user documentation included with the redistribution, if
21 * any, must include the following acknowlegement:
22 * "This product includes software developed by the
23 * ObjectStyle Group (http://objectstyle.org/)."
24 * Alternately, this acknowlegement may appear in the software itself,
25 * if and wherever such third-party acknowlegements normally appear.
26 *
27 * 4. The names "ObjectStyle Group" and "Cayenne"
28 * must not be used to endorse or promote products derived
29 * from this software without prior written permission. For written
30 * permission, please contact andrus@objectstyle.org.
31 *
32 * 5. Products derived from this software may not be called "ObjectStyle"
33 * nor may "ObjectStyle" appear in their names without prior written
34 * permission of the ObjectStyle Group.
35 *
36 * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
37 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
38 * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
39 * DISCLAIMED. IN NO EVENT SHALL THE OBJECTSTYLE GROUP OR
40 * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
41 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
42 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
43 * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
44 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
45 * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
46 * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
47 * SUCH DAMAGE.
48 * ====================================================================
49 *
50 * This software consists of voluntary contributions made by many
51 * individuals on behalf of the ObjectStyle Group. For more
52 * information on the ObjectStyle Group, please see
53 * <http://objectstyle.org/>.
54 *
55 */
56 package org.objectstyle.cayenne.dba.sybase;
57
58 import java.sql.PreparedStatement;
59 import java.sql.SQLException;
60 import java.sql.Types;
61
62 import org.objectstyle.cayenne.access.types.ByteArrayType;
63 import org.objectstyle.cayenne.access.types.CharType;
64 import org.objectstyle.cayenne.access.types.ExtendedTypeMap;
65 import org.objectstyle.cayenne.dba.JdbcAdapter;
66 import org.objectstyle.cayenne.dba.PkGenerator;
67
68 /**
69 * DbAdapter implementation for <a href="http://www.sybase.com">Sybase RDBMS</a>.
70 *
71 * @author Andrei Adamchik
72 */
73 public class SybaseAdapter extends JdbcAdapter {
74
75 /**
76 * Installs appropriate ExtendedTypes as converters for passing values
77 * between JDBC and Java layers.
78 */
79 protected void configureExtendedTypes(ExtendedTypeMap map) {
80 super.configureExtendedTypes(map);
81
82 // create specially configured CharType handler
83 map.registerType(new CharType(true, false));
84
85 // create specially configured ByteArrayType handler
86 map.registerType(new ByteArrayType(true, false));
87 }
88
89 /**
90 * Creates and returns a primary key generator.
91 * Overrides superclass implementation to return an
92 * instance of SybasePkGenerator.
93 */
94 protected PkGenerator createPkGenerator() {
95 return new SybasePkGenerator();
96 }
97 /**
98 *
99 */
100
101 public void bindParameter(
102 PreparedStatement statement,
103 Object object,
104 int pos,
105 int sqlType,
106 int precision)
107 throws SQLException, Exception {
108
109 // Sybase driver doesn't like CLOBs and BLOBs as parameters
110 if (object == null) {
111 if (sqlType == Types.CLOB) {
112 sqlType = Types.VARCHAR;
113 } else if (sqlType == Types.BLOB) {
114 sqlType = Types.VARBINARY;
115 }
116 }
117
118 super.bindParameter(statement, object, pos, sqlType, precision);
119 }
120
121 }