io.logspace.agent.shaded.mchange.v2.c3p0.test.ProxyWrappersTest Maven / Gradle / Ivy
/*
* 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 io.logspace.agent.shaded.mchange.v2.c3p0.test;
import java.util.*;
import java.sql.*;
import javax.sql.*;
import io.logspace.agent.shaded.mchange.v2.c3p0.*;
import io.logspace.agent.shaded.mchange.v1.db.sql.*;
public final class ProxyWrappersTest
{
public static void main(String[] argv)
{
ComboPooledDataSource cpds = null;
Connection c = null;
try
{
cpds = new ComboPooledDataSource();
cpds.setDriverClass( "org.postgresql.Driver" );
cpds.setJdbcUrl( "jdbc:postgresql://localhost/c3p0-test" );
cpds.setUser("swaldman");
cpds.setPassword("test");
cpds.setMinPoolSize(5);
cpds.setAcquireIncrement(5);
cpds.setMaxPoolSize(20);
c = cpds.getConnection();
c.setAutoCommit( false );
Statement stmt = c.createStatement();
stmt.executeUpdate("CREATE TABLE pwtest_table (col1 char(5), col2 char(5))");
ResultSet rs = stmt.executeQuery("SELECT * FROM pwtest_table");
System.err.println("rs: " + rs);
System.err.println("rs.getStatement(): " + rs.getStatement());
System.err.println("rs.getStatement().getConnection(): " + rs.getStatement().getConnection());
}
catch( Exception e )
{ e.printStackTrace(); }
finally
{
try { if (c!= null) c.rollback(); }
catch (Exception e) { e.printStackTrace(); }
try { if (cpds!= null) cpds.close(); }
catch (Exception e) { e.printStackTrace(); }
}
}
}