KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > xquark > extractor > microsoft > Loader


1 /*
2  * This file belongs to the XQuark distribution.
3  * Copyright (C) 2003 Universite de Versailles Saint-Quentin.
4  *
5  * This program is free software; you can redistribute it and/or
6  * modify it under the terms of the GNU Lesser General Public
7  * License as published by the Free Software Foundation; either
8  * version 2.1 of the License, or (at your option) any later version.
9  *
10  * This program is distributed in the hope that it will be useful,
11  * but WITHOUT ANY WARRANTY; without even the implied warranty of
12  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
13  * Lesser General Public License for more details.
14  *
15  * You should have received a copy of the GNU Lesser General Public
16  * License along with this program; if not, write to the Free Software
17  * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307.
18  * You can also get it at http://www.gnu.org/licenses/lgpl.html
19  *
20  * For more information on this software, see http://www.xquark.org.
21  */
22
23 package org.xquark.extractor.microsoft;
24
25 import java.sql.*;
26 import java.sql.Connection JavaDoc;
27 import java.sql.SQLException JavaDoc;
28 import java.sql.Statement JavaDoc;
29
30 import org.xquark.extractor.metadata.QNameEncoder;
31 import org.xquark.jdbc.typing.DBMSInfo;
32
33 /**
34  * Implementation of {@link org.xquark.extractor.metadata.Loader} for Microsoft
35  * SQL Server. No additionnal features compared to base class.
36  */
37 public final class Loader extends org.xquark.extractor.metadata.Loader {
38
39     private static final String JavaDoc RCSRevision = "$Revision: 1.7 $";
40     private static final String JavaDoc RCSName = "$Name: $";
41
42     public Loader(Connection JavaDoc connection, DBMSInfo dbmsInfo, QNameEncoder encoder)
43     throws SQLException JavaDoc {
44         super(connection, dbmsInfo, encoder);
45     }
46     
47     protected String JavaDoc getDefaultSchema() throws SQLException JavaDoc {
48         Statement JavaDoc statement = null;
49         ResultSet rs = null;
50         try {
51             statement = _connection.createStatement();
52             rs = statement.executeQuery("select user");
53             rs.next();
54             return rs.getString(1);
55         } finally {
56             if (rs != null) rs.close();
57             if (statement != null) statement.close();
58         }
59     }
60 }
61
Popular Tags