+ /**
+ * @see javax.servlet.Servlet#init(javax.servlet.ServletConfig)
+ */
+ public void init(ServletConfig arg0) throws ServletException {
+ super.init(arg0);
+ MirPropertiesConfiguration.setContext(arg0.getServletContext());
+ MirPropertiesConfiguration.setContextPath("/"+arg0.getServletName());
+ try {
+ configuration = MirPropertiesConfiguration.instance();
+ } catch (PropertiesConfigExc e) {
+ throw new ServletException(e);
+ }
+
+ String dbUser=configuration.getString("Database.Username");
+ String dbPassword=configuration.getString("Database.Password");
+ String dbHost=configuration.getString("Database.Host");
+ String dbAdapName=configuration.getString("Database.Adaptor");
+
+ DatabaseAdaptor adaptor;
+ try {
+ adaptor = (DatabaseAdaptor)Class.forName(dbAdapName).newInstance();
+ } catch (Exception e) {
+ throw new ServletException("Could not load DB adapator: "+
+ e.toString());
+ }
+
+ String min,max,log,reset,dbname,dblogfile;
+
+ min=configuration.getString("Database.poolMin");
+ System.out.println(min);
+ max=configuration.getString("Database.poolMax");
+ System.out.println(max);
+ dbname=configuration.getString("Database.Name");
+ System.out.println(dbname);
+ log=configuration.getStringWithHome("Database.PoolLog");
+ System.out.println(log);
+ reset=configuration.getString("Database.poolResetTime");
+ System.out.println(reset);
+ dblogfile=configuration.getStringWithHome("Database.Logfile");
+ System.out.println(dblogfile);
+
+ String dbDriver;
+ String dbUrl;
+ try{
+ dbDriver=adaptor.getDriver();
+ dbUrl=adaptor.getURL(dbUser,dbPassword, dbHost);
+ } catch (Exception e) {
+ throw new ServletException(e);
+ }
+
+ JDBCPoolMetaData meta = new JDBCPoolMetaData();
+ meta.setDbname(dbname);
+ meta.setDriver(dbDriver);
+ meta.setURL(dbUrl);
+ meta.setUserName(dbUser);
+ meta.setPassword(dbPassword);
+ meta.setJNDIName("mir");
+ meta.setMaximumSize(10);
+ meta.setMinimumSize(1);
+ meta.setPoolPreparedStatements(false);
+ meta.setCacheEnabled(false);
+ meta.setCacheSize(15);
+ meta.setDebugging(false);
+ meta.setLogFile(dblogfile+".pool");
+
+ SQLManager manager = SQLManager.getInstance();
+ JDBCPool pool = null;
+ if(manager != null){
+ pool = manager.createPool(meta);
+ }
+ }
+