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.util.*;
26: import java.sql.*;
27: import javax.sql.*;
28: import com.mchange.v2.c3p0.*;
29: import com.mchange.v1.db.sql.*;
30:
31: public final class ProxyWrappersTest {
32: public static void main(String[] argv) {
33: ComboPooledDataSource cpds = null;
34: Connection c = null;
35: try {
36: cpds = new ComboPooledDataSource();
37: cpds.setDriverClass("org.postgresql.Driver");
38: cpds.setJdbcUrl("jdbc:postgresql://localhost/c3p0-test");
39: cpds.setUser("swaldman");
40: cpds.setPassword("test");
41: cpds.setMinPoolSize(5);
42: cpds.setAcquireIncrement(5);
43: cpds.setMaxPoolSize(20);
44:
45: c = cpds.getConnection();
46: c.setAutoCommit(false);
47: Statement stmt = c.createStatement();
48: stmt
49: .executeUpdate("CREATE TABLE pwtest_table (col1 char(5), col2 char(5))");
50: ResultSet rs = stmt
51: .executeQuery("SELECT * FROM pwtest_table");
52: System.err.println("rs: " + rs);
53: System.err.println("rs.getStatement(): "
54: + rs.getStatement());
55: System.err.println("rs.getStatement().getConnection(): "
56: + rs.getStatement().getConnection());
57: } catch (Exception e) {
58: e.printStackTrace();
59: } finally {
60: try {
61: if (c != null)
62: c.rollback();
63: } catch (Exception e) {
64: e.printStackTrace();
65: }
66: try {
67: if (cpds != null)
68: cpds.close();
69: } catch (Exception e) {
70: e.printStackTrace();
71: }
72: }
73: }
74: }
|