I am new to c3p0 and I have a problem.

The only way I can see to set the jdbcUrl on the data source is by setting the setJdbcUrl property, but in this case the value would be hard coded on the class.

I would prefer if i can set it in the configuration c3p0-config.xml file.

I have see that you can do it in the web.xml file for a j2EE application and there are some other ways to do it if you are running other frameworks, but what i want to do is just a stand alone class that get connected (using the connection pool), and I would need to be able to change the jdbcURL.

If any body knows how to do it I would appreciate if the tell me. I have been looking at this for the enter day.