This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 172540 - Using c3p0 connection pool visual editor does not work.
Summary: Using c3p0 connection pool visual editor does not work.
Status: RESOLVED WONTFIX
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 blocker (vote)
Assignee: issues@obsolete
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-18 07:45 UTC by mariano_lopez
Modified: 2011-11-28 09:03 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description mariano_lopez 2009-09-18 07:45:29 UTC
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.
Comment 1 Jan Chalupa 2011-11-28 09:03:06 UTC
Obsolete issue. Closing.