<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
        <property name="driverClass" value=..../>
        <property name="jdbcUrl" value=..../>
        <property name="user" value=..../>
        <property name="password" value=..../>

        <property name="initialPoolSize" value=..../>
        <property name="minPoolSize" value=.... />
        <property name="maxPoolSize" value=.... />
        <property name="acquireIncrement" value=..../>
        <property name="maxStatements" value=.... />
        <property name="idleConnectionTestPeriod" value=.... />
        <property name="loginTimeout" value=.... />
        <property name="debugUnreturnedConnectionStackTraces" value=.... />
        <property name="statementCacheNumDeferredCloseThreads" value=....>
        <property name="unreturnedConnectionTimeout" value=.... />
    </bean>

 try {
        Cpnnection con = DriverManager.getConnection(
                   "jdbc:" + this.dbms + ":" +
                   this.dbName +
                   ";create=true",
                   connectionProps);
        stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("...");
catch(...){
...
}