com.mchange.v2.c3p0.test.ListTablesTest Maven / Gradle / Ivy
The newest version!
/*
* Distributed as part of c3p0 v.0.9.1.1
*
* Copyright (C) 2005 Machinery For Change, Inc.
*
* Author: Steve Waldman
*
* This library is free software; you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 2.1, as
* published by the Free Software Foundation.
*
* This software is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this software; see the file LICENSE. If not, write to the
* Free Software Foundation, Inc., 59 Temple Place, Suite 330,
* Boston, MA 02111-1307, USA.
*/
package com.mchange.v2.c3p0.test;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import com.mchange.v1.db.sql.*;
public final class ListTablesTest
{
public static void main(String[] argv)
{
try
{
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup(argv[0]);
System.err.println( ds.getClass() );
Connection con = null;
ResultSet rs = null;
try
{
con = ds.getConnection();
DatabaseMetaData md = con.getMetaData();
rs = md.getTables( null, null, "%", null);
while (rs.next())
System.out.println(rs.getString(3));
}
finally
{
ResultSetUtils.attemptClose( rs );
ConnectionUtils.attemptClose( con );
}
}
catch (Exception e)
{ e.printStackTrace(); }
}
}