KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > apache > cayenne > dba > sqlserver > SQLServerSniffer


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.sqlserver;
21
22 import java.sql.DatabaseMetaData JavaDoc;
23 import java.sql.SQLException JavaDoc;
24
25 import org.apache.cayenne.dba.DbAdapter;
26 import org.apache.cayenne.dba.DbAdapterFactory;
27
28 /**
29  * Detects SQLServer database from JDBC metadata.
30  *
31  * @since 1.2
32  * @author Andrus Adamchik
33  */

34 public class SQLServerSniffer implements DbAdapterFactory {
35
36     public DbAdapter createAdapter(DatabaseMetaData JavaDoc md) throws SQLException JavaDoc {
37         String JavaDoc dbName = md.getDatabaseProductName();
38         if (dbName == null || dbName.toUpperCase().indexOf("MICROSOFT SQL SERVER") < 0) {
39             return null;
40         }
41
42         SQLServerAdapter adapter = new SQLServerAdapter();
43
44         // detect whether generated keys are supported
45

46         boolean generatedKeys = false;
47         try {
48             generatedKeys = md.supportsGetGeneratedKeys();
49         }
50         catch (Throwable JavaDoc th) {
51             // catch exceptions resulting from incomplete JDBC3 implementation
52
// ** we have to catch Throwable, as unimplemented methods would result in
53
// "AbstractMethodError".
54
}
55
56         adapter.setSupportsGeneratedKeys(generatedKeys);
57         return adapter;
58     }
59 }
60
Popular Tags