01: /*
02: * Distributed as part of c3p0 v.0.9.1.2
03: *
04: * Copyright (C) 2005 Machinery For Change, Inc.
05: *
06: * Author: Steve Waldman <swaldman@mchange.com>
07: *
08: * This library is free software; you can redistribute it and/or modify
09: * it under the terms of the GNU Lesser General Public License version 2.1, as
10: * published by the Free Software Foundation.
11: *
12: * This software is distributed in the hope that it will be useful,
13: * but WITHOUT ANY WARRANTY; without even the implied warranty of
14: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15: * GNU Lesser General Public License for more details.
16: *
17: * You should have received a copy of the GNU Lesser General Public License
18: * along with this software; see the file LICENSE. If not, write to the
19: * Free Software Foundation, Inc., 59 Temple Place, Suite 330,
20: * Boston, MA 02111-1307, USA.
21: */
22:
23: package com.mchange.v2.c3p0.test;
24:
25: import java.sql.*;
26: import javax.sql.*;
27: import javax.naming.*;
28: import com.mchange.v1.db.sql.*;
29:
30: public final class ListTablesTest {
31: public static void main(String[] argv) {
32: try {
33: InitialContext ctx = new InitialContext();
34: DataSource ds = (DataSource) ctx.lookup(argv[0]);
35: System.err.println(ds.getClass());
36: Connection con = null;
37: ResultSet rs = null;
38: try {
39: con = ds.getConnection();
40: DatabaseMetaData md = con.getMetaData();
41: rs = md.getTables(null, null, "%", null);
42: while (rs.next())
43: System.out.println(rs.getString(3));
44: } finally {
45: ResultSetUtils.attemptClose(rs);
46: ConnectionUtils.attemptClose(con);
47: }
48: } catch (Exception e) {
49: e.printStackTrace();
50: }
51: }
52: }
|