01: /*
02: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
03: *
04: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
05: *
06: * The contents of this file are subject to the terms of either the GNU
07: * General Public License Version 2 only ("GPL") or the Common
08: * Development and Distribution License("CDDL") (collectively, the
09: * "License"). You may not use this file except in compliance with the
10: * License. You can obtain a copy of the License at
11: * http://www.netbeans.org/cddl-gplv2.html
12: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
13: * specific language governing permissions and limitations under the
14: * License. When distributing the software, include this License Header
15: * Notice in each file and include the License file at
16: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
17: * particular file as subject to the "Classpath" exception as provided
18: * by Sun in the GPL Version 2 section of the License file that
19: * accompanied this code. If applicable, add the following below the
20: * License Header, with the fields enclosed by brackets [] replaced by
21: * your own identifying information:
22: * "Portions Copyrighted [year] [name of copyright owner]"
23: *
24: * Contributor(s):
25: *
26: * The Original Software is NetBeans. The Initial Developer of the Original
27: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
28: * Microsystems, Inc. All Rights Reserved.
29: *
30: * If you wish your version of this file to be governed by only the CDDL
31: * or only the GPL Version 2, indicate your decision by adding
32: * "[Contributor] elects to include this software in this distribution
33: * under the [CDDL or GPL Version 2] license." If you do not indicate a
34: * single choice of license, a recipient has the option to distribute
35: * your version of this file under either the CDDL, the GPL Version 2 or
36: * to extend the choice of license to its licensees as provided above.
37: * However, if you add GPL Version 2 code and therefore, elected the GPL
38: * Version 2 license, then the option applies only if the new code is
39: * made subject to such option by the copyright holder.
40: */
41:
42: package org.netbeans.modules.db.explorer.infos;
43:
44: import java.sql.ResultSet;
45: import java.util.HashMap;
46: import java.util.Vector;
47: import org.netbeans.api.db.explorer.DatabaseException;
48: import org.netbeans.lib.ddl.impl.DriverSpecification;
49: import org.netbeans.modules.db.explorer.nodes.DatabaseNode;
50:
51: public class ProcedureListNodeInfo extends DatabaseNodeInfo {
52: static final long serialVersionUID = -7911927402768472443L;
53:
54: public void initChildren(Vector children) throws DatabaseException {
55: try {
56: DriverSpecification drvSpec = getDriverSpecification();
57: drvSpec.getProcedures("%");
58: ResultSet rs = drvSpec.getResultSet();
59: if (rs != null) {
60: HashMap rset = new HashMap();
61: DatabaseNodeInfo info;
62: while (rs.next()) {
63: rset = drvSpec.getRow();
64:
65: //workaround for issue #21409 (http://db.netbeans.org/issues/show_bug.cgi?id=21409)
66: if (drvSpec.getDBName().indexOf("Oracle") != -1) {
67: String pac = (String) rset.get(new Integer(1));
68: if (pac != null)
69: rset.put(new Integer(3), pac + "."
70: + rset.get(new Integer(3)));
71: }
72:
73: info = DatabaseNodeInfo.createNodeInfo(this ,
74: DatabaseNode.PROCEDURE, rset);
75: if (info != null) {
76: info
77: .put(DatabaseNode.PROCEDURE, info
78: .getName());
79: children.add(info);
80: } else
81: throw new Exception(bundle().getString(
82: "EXC_UnableToCreateProcedureNodeInfo")); //NOI18N
83: rset.clear();
84: }
85: rs.close();
86: }
87: } catch (Exception e) {
88: DatabaseException dbe = new DatabaseException(e
89: .getMessage());
90: dbe.initCause(e);
91: throw dbe;
92: }
93: }
94:
95: }
|