I added the jar to the build path and built the project but still get the error: "C3P0Registry cannot be resolved".
On Jul 29, 2:50 am, "brett.wooldridge" <[email protected]> wrote: > You have to add the CP30 jar to your project's Build Path. Right- > click on project-> Properties -> Java Build Path -> Libraries. > > -Brett > > On Jul 29, 1:34 am, Tobe <[email protected]> wrote: > > > > > @Brett > > I'm using Eclipse and did the things you've posted. I also added the 2 > > jars in the run configurations, but by compiling the source I get > > errors for "C3P0Registry". > > > On Jul 28, 2:09 pm, "brett.wooldridge" <[email protected]> > > wrote: > > > > I run MySQL with a C3P0 connection pool in front of it. This is what > > > I did [almost] verbatim. This is assuming you're running Jetty and > > > servlets/RPC. > > > > 1. In your war/WEB-INF/lib put the c3p0 jar. Get C3P0 from > > > herehttp://sourceforge.net/projects/c3p0. > > > > 2. In your war/WEB-INF/lib put the mysql-connector JDBC jar. Get from > > > herehttp://www.mysql.com/products/connector. > > > > 3. In war/WEB-INF create a file called jetty-web.xml with these > > > contents: > > > > <?xml version="1.0"?> > > > <!DOCTYPE Configure PUBLIC "-//Mort Bay Consulting//DTD Configure//EN" > > > "http://jetty.mortbay.org/configure.dtd";> > > > > <Configure class="org.mortbay.jetty.webapp.WebAppContext"> > > > <New id="yourDS" > > > class="com.mchange.v2.c3p0.ComboPooledDataSource"> > > > <Set name="driverClass">com.mysql.jdbc.Driver</Set> > > > <Set name="jdbcUrl">jdbc:mysql://localhost:3306/yourdb? > > > cacheResultSetMetadata=true</Set> > > > <Set name="user">root</Set> > > > <Set name="password"></Set> > > > <Set name="initialPoolSize">10</Set> > > > <Set name="minPoolSize">50</Set> > > > <Set name="maxPoolSize">500</Set> > > > <Set name="idleConnectionTestPeriod">300</Set> > > > <Set name="maxIdleTime">1800</Set> > > > <Set name="maxIdleTimeExcessConnections">600</Set> > > > <Set name="maxConnectionAge">1800</Set> > > > <Set name="maxStatementsPerConnection">50</Set> > > > <Set name="preferredTestQuery">SELECT 1</Set> > > > <Set name="acquireRetryAttempts">3</Set> > > > <Set name="acquireRetryDelay">10</Set> > > > <Set name="checkoutTimeout">20000</Set> > > > <Set name="numHelperThreads">4</Set> > > > <Set name="dataSourceName">yourDS</Set> > > > </New> > > > </Configure> > > > > 4. Somewhere in your code where you manage the JDBC DataSource do: > > > > DataSource myDS = C3P0Registry.pooledDataSourceByName("yourDS"); > > > > I've led you to the water, now it's time to drink. The rest is up to > > > you. > > > > Brett --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Web Toolkit" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Web-Toolkit?hl=en -~----------~----~----~----~------~----~------~--~---
