Bug 172540

Using c3p0 connection pool visual editor does not work.

In my vwp project i used the following DBCP configuration:

<Resource auth="Container"
            description="BBDD MySQL en local de el contexto de Clínica."
            driverClassName="com.mysql.jdbc.Driver"
            factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
            maxActive="20"
            maxIdle="10"
            maxWait="30000"
            name="jdbc/ds_clinica_Local"
            password="******"
            type="javax.sql.DataSource"
            url="jdbc:mysql://localhost:3306/clinica?autoReconnect=true"
            username="******"
            testOnBorrow="true"
            testWhileIdle="true"
            timeBetweenEvictionRunsMillis="10000"
            minEvictableIdleTimeMillis="60000"
            validationQuery="select 1"
  />

I change this configuration to use c3p0 connection pool with the following configuration:

<Resource name="jdbc/ds_clinica_Local"
            auth="Container"
            description="BBDD MySQL en local de el contexto de Clínica."
            driverClass="com.mysql.jdbc.Driver"
            factory="org.apache.naming.factory.BeanFactory"
            type="com.mchange.v2.c3p0.ComboPooledDataSource"
            maxPoolSize="20"
            minPoolSize="10"
            initialPoolSize="10"
            acquireIncrement="1"
            user="*******"
            password="****"
            jdbcUrl="jdbc:mysql://localhost:3306/clinica?autoReconnect=true"
            checkoutTimeout="5000"
            preferredTestQuery="select 1"
            idleConnectionTestPeriod="900"
  />

But visual editor of vwp pages doesn't work because cannot find properties that binding to a DataProvider.

SQL visual editor for RowSets doesn't work either because cannot find data source name of RowSet.