KickJava   Java API By Example, From Geeks To Geeks.

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


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