KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > mchange > v2 > c3p0 > test > ListTablesTest


1 /*
2  * Distributed as part of c3p0 v.0.9.1
3  *
4  * Copyright (C) 2005 Machinery For Change, Inc.
5  *
6  * Author: Steve Waldman <swaldman@mchange.com>
7  *
8  * This library is free software; you can redistribute it and/or modify
9  * 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
24 package com.mchange.v2.c3p0.test;
25
26 import java.sql.*;
27 import javax.sql.*;
28 import javax.naming.*;
29 import com.mchange.v1.db.sql.*;
30
31 public final class ListTablesTest
32 {
33     public static void main(String JavaDoc[] argv)
34     {
35     try
36         {
37         InitialContext ctx = new InitialContext();
38         DataSource ds = (DataSource) ctx.lookup(argv[0]);
39         System.err.println( ds.getClass() );
40         Connection con = null;
41         ResultSet rs = null;
42         try
43             {
44             con = ds.getConnection();
45             DatabaseMetaData md = con.getMetaData();
46             rs = md.getTables( null, null, "%", null);
47             while (rs.next())
48                 System.out.println(rs.getString(3));
49             }
50         finally
51             {
52             ResultSetUtils.attemptClose( rs );
53             ConnectionUtils.attemptClose( con );
54             }
55         }
56     catch (Exception JavaDoc e)
57         { e.printStackTrace(); }
58     }
59 }
60
Popular Tags