\r
import javax.sql.DataSource;\r
\r
-import org.apache.commons.dbcp.BasicDataSource;\r
import org.apache.log4j.Logger;\r
import org.hibernate.cache.CacheProvider;\r
import org.hibernate.cache.NoCacheProvider;\r
import org.springframework.beans.factory.support.AbstractBeanDefinition;\r
import org.springframework.beans.factory.support.RootBeanDefinition;\r
\r
+import com.mchange.v2.c3p0.ComboPooledDataSource;\r
+\r
import eu.etaxonomy.cdm.api.application.CdmApplicationUtils;\r
import eu.etaxonomy.cdm.common.CdmUtils;\r
import eu.etaxonomy.cdm.common.XmlHelp;\r
}\r
}\r
\r
-\r
- private static String dataSourceClassName = BasicDataSource.class.getName();\r
+ /**\r
+ * The Datasource class that Spring will use to set up the connection to the database\r
+ */\r
+ private static String dataSourceClassName = ComboPooledDataSource.class.getName();\r
+ // we used dbcps BasicDataSource before\r
+// private static String dataSourceClassName = BasicDataSource.class.getName();\r
\r
-\r
//name\r
protected String dataSourceName;\r
\r
/**\r
* Returns the default CdmDataSource\r
* @return the default CdmDataSource\r
+ * @throws DataSourceNotFoundException \r
*/\r
- public final static CdmPersistentDataSource NewDefaultInstance(){\r
- try {\r
- return NewInstance("default");\r
- } catch (DataSourceNotFoundException e) {\r
- logger.error("Default datasource does not exist in config file");\r
- return null;\r
- }\r
+ public final static CdmPersistentDataSource NewDefaultInstance() throws DataSourceNotFoundException {\r
+ return NewInstance("default");\r
}\r
\r
\r
/**\r
* Returns the default CdmDataSource\r
* @return the default CdmDataSource\r
+ * @throws DataSourceNotFoundException \r
*/\r
- public final static CdmPersistentDataSource NewLocalHsqlInstance(){\r
- try {\r
- return NewInstance("localDefaultHsql");\r
- } catch (DataSourceNotFoundException e) {\r
- logger.error("Local datasource does not exist in config file");\r
- return null;\r
- }\r
+ public final static CdmPersistentDataSource NewLocalHsqlInstance() throws DataSourceNotFoundException{\r
+ return NewInstance("localDefaultHsql");\r
}\r
\r
/**\r
* @param strDataSource\r
* @return\r
*/\r
- public final static CdmPersistentDataSource NewInstance(String dataSourceName) \r
- throws DataSourceNotFoundException{\r
+ public final static CdmPersistentDataSource NewInstance(String dataSourceName) throws DataSourceNotFoundException{\r
if (exists(dataSourceName)){\r
return new CdmPersistentDataSource(dataSourceName);\r
}else{\r