List of usage examples for org.hibernate.cfg Configuration setProperty
public Configuration setProperty(String propertyName, String value)
From source file:com.db4o.drs.test.hibernate.ReplicationConfiguratorTest.java
License:Open Source License
private void oneRound() { if (reuseUrl == null) { cfg = HibernateUtil.createNewDbConfig(); reuseUrl = cfg.getProperty(Environment.URL); } else {// w ww . j av a 2s. c o m Configuration configuration = new Configuration().configure(HibernateUtil.HSQL_CFG_XML); cfg = configuration.setProperty(Environment.URL, reuseUrl); } Util.addClass(cfg, CollectionHolder.class); ReplicationConfigurator.configure(cfg); sessionFactory = cfg.buildSessionFactory(); Session session = sessionFactory.openSession(); session.close(); tstReferenceType(); tstCollectionUpdate(); tstCollectionRemove(); }
From source file:com.db4o.drs.test.hibernate.TablesCreatorTest.java
License:Open Source License
protected Configuration validateCfg() { Configuration configuration = HibernateUtil.createNewDbConfig(); return configuration.setProperty("hibernate.hbm2ddl.auto", "validate"); }
From source file:com.egreen.tesla.server.api.database.RepositoryConfig.java
public SessionFactory init(List<Class> classes) { // Create the SessionFactory from hibernate.cfg.xml Configuration configuration = new AnnotationConfiguration(); configuration.setProperty("hibernate.connection.url", url); configuration.setProperty("hibernate.connection.username", username); configuration.setProperty("hibernate.connection.password", password); configuration.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect"); configuration.setProperty("hibernate.connection.driver_class", JDBC_DRIVER); configuration.setProperty("hibernate.show_sql", "true"); configuration.setProperty("hibernate.hbm2ddl.auto", "update"); for (Class class1 : classes) { configuration = configuration.addAnnotatedClass(class1); }//from w w w .j a va 2 s.com //ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(configuration.getProperties()).buildServiceRegistry(); return configuration.buildSessionFactory(); }
From source file:com.ephesoft.dcma.core.hibernate.DynamicHibernateDao.java
License:Open Source License
/** * Constructor./*ww w. j av a 2 s. com*/ * * @param cfgLocation String */ public DynamicHibernateDao(String cfgLocation) { Configuration configuration = new Configuration().configure(cfgLocation); String filePath = META_INF + File.separator + FOLDER_NAME + File.separator + FILE_NAME + ".properties"; Properties properties; InputStream propertyInStream = null; try { propertyInStream = new ClassPathResource(filePath).getInputStream(); properties = new Properties(); properties.load(propertyInStream); } catch (Exception e) { LOG.error(e.getMessage(), e); throw new HibernateException(e.getMessage(), e); } finally { if (propertyInStream != null) { try { propertyInStream.close(); } catch (IOException ioe) { LOG.info("Could not close property input stream in Dynamic Hibernate Dao."); } } } for (Object propertyKey : properties.keySet()) { String propertyKeyString = (String) propertyKey; if (!propertyKeyString.equalsIgnoreCase(PASSWORD)) { configuration.setProperty(propertyKeyString, properties.getProperty(propertyKeyString)); } else { PasswordDecryptor passwordDecryptor = new PasswordDecryptor( properties.getProperty(propertyKeyString)); try { configuration.setProperty(propertyKeyString, passwordDecryptor.getDecryptedString()); } catch (CryptographyException e) { LOG.error(e.getMessage(), e); throw new HibernateException(e.getMessage(), e); } } } try { if (sessionFactory != null) { sessionFactory.close(); } } catch (Exception e) { LOG.error("Could not close session factory", e); } sessionFactory = configuration.buildSessionFactory(); }
From source file:com.ewerp.mud.content.EjMudContentSessionFactory.java
License:Apache License
@Override public void init() { super.init(); Configuration cfg = new Configuration(); cfg.setProperty("hibernate.dialect", "org.hibernate.dialect.H2Dialect"); cfg.setProperty("hibernate.connection.driver_class", "org.h2.Driver"); cfg.setProperty("hibernate.connection.url", "jdbc:h2:/home/cboyden/db1;DB_CLOSE_DELAY=-1;MVCC=TRUE"); // cfg.setProperty("hibernate.connection.url", "jdbc:h2:mem:db1;DB_CLOSE_DELAY=-1;MVCC=TRUE"); cfg.setProperty("hibernate.connection.username", "sa"); cfg.setProperty("hibernate.connection.password", ""); cfg.setProperty("hibernate.connection.pool_size", "1"); cfg.setProperty("hibernate.hbm2ddl.auto", "create"); cfg.setProperty("cache.provider_class", "org.hibernate.cache.internal.NoCacheProvider"); cfg.addClass(com.ewerp.mud.content.Room.class); ServiceRegistry serviceRegistry = new ServiceRegistryBuilder().applySettings(cfg.getProperties()) .buildServiceRegistry();/*from w w w .j a va 2 s .co m*/ sessionFactory = cfg.buildSessionFactory(serviceRegistry); }
From source file:com.floreantpos.model.dao._RootDAO.java
License:Open Source License
public static Configuration getNewConfiguration(String configFileName) { Configuration configuration = new Configuration(); configuration.addClass(ActionHistory.class); configuration.addClass(AttendenceHistory.class); configuration.addClass(CashDrawerResetHistory.class); configuration.addClass(CookingInstruction.class); configuration.addClass(Discount.class); configuration.addClass(Gratuity.class); configuration.addClass(MenuCategory.class); configuration.addClass(MenuGroup.class); configuration.addClass(MenuItem.class); configuration.addClass(MenuItemModifierGroup.class); configuration.addClass(MenuItemShift.class); configuration.addClass(MenuModifier.class); configuration.addClass(MenuModifierGroup.class); configuration.addClass(PayoutReason.class); configuration.addClass(PayoutRecepient.class); configuration.addClass(Restaurant.class); configuration.addClass(Shift.class); configuration.addClass(Tax.class); configuration.addClass(Terminal.class); configuration.addClass(Ticket.class); configuration.addClass(KitchenTicket.class); configuration.addClass(TicketDiscount.class); configuration.addClass(TicketItem.class); configuration.addClass(TicketItemModifier.class); //configuration.addClass(TicketItemModifierGroup.class); configuration.addClass(TicketItemDiscount.class); configuration.addClass(KitchenTicketItem.class); configuration.addClass(PosTransaction.class); configuration.addClass(User.class); configuration.addClass(VirtualPrinter.class); configuration.addClass(TerminalPrinters.class); configuration.addClass(VoidReason.class); configuration.addClass(DrawerPullReport.class); configuration.addClass(PrinterConfiguration.class); configuration.addClass(UserPermission.class); configuration.addClass(UserType.class); configuration.addClass(Customer.class); configuration.addClass(PurchaseOrder.class); configuration.addClass(ZipCodeVsDeliveryCharge.class); configuration.addClass(ShopFloor.class); configuration.addClass(ShopFloorTemplate.class); configuration.addClass(ShopTable.class); configuration.addClass(ShopTableType.class); configuration.addClass(PrinterGroup.class); configuration.addClass(DrawerAssignedHistory.class); configuration.addClass(DataUpdateInfo.class); configuration.addClass(TableBookingInfo.class); configuration.addClass(CustomPayment.class); configuration.addClass(com.floreantpos.model.OrderType.class); configuration.addClass(DeliveryAddress.class); configuration.addClass(DeliveryInstruction.class); configuration.addClass(DeliveryCharge.class); configuration.addClass(DeliveryConfiguration.class); configuration.addClass(EmployeeInOutHistory.class); configuration.addClass(Currency.class); configuration.addClass(CashDrawer.class); configuration.addClass(CurrencyBalance.class); configuration.addClass(GlobalConfig.class); configuration.addClass(MenuItemSize.class); configuration.addClass(PizzaCrust.class); configuration.addClass(PizzaPrice.class); configuration.addClass(PizzaModifierPrice.class); configuration.addClass(Multiplier.class); configuration.addClass(ModifierMultiplierPrice.class); configureInventoryClasses(configuration); Database defaultDatabase = AppConfig.getDefaultDatabase(); configuration.setProperty("hibernate.dialect", defaultDatabase.getHibernateDialect()); //$NON-NLS-1$ configuration.setProperty("hibernate.connection.driver_class", //$NON-NLS-1$ defaultDatabase.getHibernateConnectionDriverClass()); configuration.setProperty("hibernate.connection.url", AppConfig.getConnectString()); //$NON-NLS-1$ configuration.setProperty("hibernate.connection.username", AppConfig.getDatabaseUser()); //$NON-NLS-1$ configuration.setProperty("hibernate.connection.password", AppConfig.getDatabasePassword()); //$NON-NLS-1$ configuration.setProperty("hibernate.hbm2ddl.auto", "update"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.connection.autocommit", "false"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.max_fetch_depth", "3"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.show_sql", "false"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.connection.isolation", //$NON-NLS-1$ String.valueOf(Connection.TRANSACTION_READ_COMMITTED)); configureC3p0ConnectionPool(configuration); return configuration; }
From source file:com.floreantpos.model.dao._RootDAO.java
License:Open Source License
private static void configureC3p0ConnectionPool(Configuration configuration) { //min pool size configuration.setProperty("hibernate.c3p0.min_size", "0"); //$NON-NLS-1$ //$NON-NLS-2$ //max pool size configuration.setProperty("hibernate.c3p0.max_size", "5"); //$NON-NLS-1$ //$NON-NLS-2$ // When an idle connection is removed from the pool (in second) configuration.setProperty("hibernate.c3p0.timeout", "300"); //$NON-NLS-1$ //$NON-NLS-2$ //Number of prepared statements will be cached configuration.setProperty("hibernate.c3p0.max_statements", "50"); //$NON-NLS-1$ //$NON-NLS-2$ //The number of milliseconds a client calling getConnection() will wait for a Connection to be //checked-in or acquired when the pool is exhausted. Zero means wait indefinitely. //Setting any positive value will cause the getConnection() call to time-out and break //with an SQLException after the specified number of milliseconds. configuration.setProperty("hibernate.c3p0.checkoutTimeout", "10000"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.c3p0.acquireRetryAttempts", "1"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.c3p0.acquireIncrement", "1"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.c3p0.maxIdleTime", "3000"); //$NON-NLS-1$ //$NON-NLS-2$ //idle time in seconds before a connection is automatically validated configuration.setProperty("hibernate.c3p0.idle_test_period", "3000"); //$NON-NLS-1$ //$NON-NLS-2$ configuration.setProperty("hibernate.c3p0.breakAfterAcquireFailure", "false"); //$NON-NLS-1$ //$NON-NLS-2$ }
From source file:com.floreantpos.util.DatabaseUtil.java
License:Open Source License
public static void checkConnection(String connectionString, String hibernateDialect, String hibernateConnectionDriverClass, String user, String password) throws DatabaseConnectionException { Configuration configuration = _RootDAO.getNewConfiguration(null); configuration = configuration.setProperty("hibernate.dialect", hibernateDialect); configuration = configuration.setProperty("hibernate.connection.driver_class", hibernateConnectionDriverClass); configuration = configuration.setProperty("hibernate.connection.url", connectionString); configuration = configuration.setProperty("hibernate.connection.username", user); configuration = configuration.setProperty("hibernate.connection.password", password); checkConnection(configuration);/*from w w w. j a va 2 s .c om*/ }
From source file:com.floreantpos.util.DatabaseUtil.java
License:Open Source License
public static boolean createDatabase(String connectionString, String hibernateDialect, String hibernateConnectionDriverClass, String user, String password, boolean exportSampleData) { try {//from w w w.j ava2s . c o m Configuration configuration = _RootDAO.getNewConfiguration(null); configuration = configuration.setProperty("hibernate.dialect", hibernateDialect); configuration = configuration.setProperty("hibernate.connection.driver_class", hibernateConnectionDriverClass); configuration = configuration.setProperty("hibernate.connection.url", connectionString); configuration = configuration.setProperty("hibernate.connection.username", user); configuration = configuration.setProperty("hibernate.connection.password", password); configuration = configuration.setProperty("hibernate.hbm2ddl.auto", "create"); configuration = configuration.setProperty("hibernate.c3p0.checkoutTimeout", "0"); //$NON-NLS-1$ //$NON-NLS-2$ SchemaExport schemaExport = new SchemaExport(configuration); schemaExport.create(true, true); _RootDAO.initialize(); Restaurant restaurant = new Restaurant(); restaurant.setId(Integer.valueOf(1)); restaurant.setName("Sample Restaurant"); restaurant.setAddressLine1("Somewhere"); restaurant.setTelephone("+0123456789"); RestaurantDAO.getInstance().saveOrUpdate(restaurant); Tax tax = new Tax(); tax.setName("US"); tax.setRate(Double.valueOf(6)); TaxDAO.getInstance().saveOrUpdate(tax); Shift shift = new Shift(); shift.setName(com.floreantpos.POSConstants.GENERAL); java.util.Date shiftStartTime = ShiftUtil.buildShiftStartTime(0, 0, 0, 11, 59, 1); java.util.Date shiftEndTime = ShiftUtil.buildShiftEndTime(0, 0, 0, 11, 59, 1); shift.setStartTime(shiftStartTime); shift.setEndTime(shiftEndTime); long length = Math.abs(shiftStartTime.getTime() - shiftEndTime.getTime()); shift.setShiftLength(Long.valueOf(length)); ShiftDAO.getInstance().saveOrUpdate(shift); UserType administrator = new UserType(); administrator.setName(com.floreantpos.POSConstants.ADMINISTRATOR); administrator.setPermissions(new HashSet<UserPermission>(Arrays.asList(UserPermission.permissions))); UserTypeDAO.getInstance().saveOrUpdate(administrator); UserType manager = new UserType(); manager.setName(com.floreantpos.POSConstants.MANAGER); manager.setPermissions(new HashSet<UserPermission>(Arrays.asList(UserPermission.permissions))); UserTypeDAO.getInstance().saveOrUpdate(manager); UserType cashier = new UserType(); cashier.setName(com.floreantpos.POSConstants.CASHIER); cashier.setPermissions(new HashSet<UserPermission>( Arrays.asList(UserPermission.CREATE_TICKET, UserPermission.SETTLE_TICKET, UserPermission.SPLIT_TICKET, UserPermission.VIEW_ALL_OPEN_TICKETS))); UserTypeDAO.getInstance().saveOrUpdate(cashier); UserType server = new UserType(); server.setName("SR. CASHIER"); server.setPermissions(new HashSet<UserPermission>(Arrays.asList(UserPermission.CREATE_TICKET, UserPermission.SETTLE_TICKET, UserPermission.SPLIT_TICKET))); //server.setTest(Arrays.asList(OrderType.BAR_TAB)); UserTypeDAO.getInstance().saveOrUpdate(server); User administratorUser = new User(); administratorUser.setUserId(123); administratorUser.setSsn("123"); administratorUser.setPassword("1111"); administratorUser.setFirstName("Admin"); administratorUser.setLastName("System"); administratorUser.setType(administrator); administratorUser.setActive(true); UserDAO dao = new UserDAO(); dao.saveOrUpdate(administratorUser); User managerUser = new User(); managerUser.setUserId(124); managerUser.setSsn("124"); managerUser.setPassword("2222"); managerUser.setFirstName("Lisa"); managerUser.setLastName("Carol"); managerUser.setType(manager); managerUser.setActive(true); dao.saveOrUpdate(managerUser); User cashierUser = new User(); cashierUser.setUserId(125); cashierUser.setSsn("125"); cashierUser.setPassword("3333"); cashierUser.setFirstName("Janet"); cashierUser.setLastName("Ann"); cashierUser.setType(cashier); cashierUser.setActive(true); dao.saveOrUpdate(cashierUser); User serverUser = new User(); serverUser.setUserId(126); serverUser.setSsn("126"); serverUser.setPassword("7777"); serverUser.setFirstName("John"); serverUser.setLastName("Doe"); serverUser.setType(server); serverUser.setActive(true); dao.saveOrUpdate(serverUser); User driverUser = new User(); driverUser.setUserId(127); driverUser.setSsn("127"); driverUser.setPassword("8888"); driverUser.setFirstName("Poll"); driverUser.setLastName("Brien"); driverUser.setType(server); driverUser.setDriver(true); driverUser.setActive(true); dao.saveOrUpdate(driverUser); OrderTypeDAO orderTypeDAO = new OrderTypeDAO(); OrderType orderType = new OrderType(); orderType.setName("DINE IN"); orderType.setShowTableSelection(true); orderType.setCloseOnPaid(true); orderType.setEnabled(true); orderType.setShouldPrintToKitchen(true); orderType.setShowInLoginScreen(true); orderTypeDAO.save(orderType); orderType = new OrderType(); orderType.setName("TAKE OUT"); orderType.setShowTableSelection(false); orderType.setCloseOnPaid(true); orderType.setEnabled(true); orderType.setPrepaid(true); orderType.setShouldPrintToKitchen(true); orderType.setShowInLoginScreen(true); orderTypeDAO.save(orderType); orderType = new OrderType(); orderType.setName("RETAIL"); orderType.setShowTableSelection(false); orderType.setCloseOnPaid(true); orderType.setEnabled(true); orderType.setShouldPrintToKitchen(false); orderType.setShowInLoginScreen(true); orderTypeDAO.save(orderType); orderType = new OrderType(); orderType.setName("HOME DELIVERY"); orderType.setShowTableSelection(false); orderType.setCloseOnPaid(false); orderType.setEnabled(true); orderType.setShouldPrintToKitchen(true); orderType.setShowInLoginScreen(true); orderType.setRequiredCustomerData(true); orderType.setDelivery(true); orderTypeDAO.save(orderType); DiscountDAO discountDao = new DiscountDAO(); Discount discount1 = new Discount(); discount1.setName("Buy 1 and get 1 free"); discount1.setType(1); discount1.setValue(100.0); discount1.setAutoApply(false); discount1.setMinimunBuy(2); discount1.setQualificationType(0); discount1.setApplyToAll(true); discount1.setNeverExpire(true); discount1.setEnabled(true); discountDao.saveOrUpdate(discount1); Discount discount2 = new Discount(); discount2.setName("Buy 2 and get 1 free"); discount2.setType(1); discount2.setValue(100.0); discount2.setAutoApply(true); discount2.setMinimunBuy(3); discount2.setQualificationType(0); discount2.setApplyToAll(true); discount2.setNeverExpire(true); discount2.setEnabled(true); discountDao.saveOrUpdate(discount2); Discount discount3 = new Discount(); discount3.setName("10% Off"); discount3.setType(1); discount3.setValue(10.0); discount3.setAutoApply(false); discount3.setMinimunBuy(1); discount3.setQualificationType(0); discount3.setApplyToAll(true); discount3.setNeverExpire(true); discount3.setEnabled(true); discountDao.saveOrUpdate(discount3); int terminalId = TerminalConfig.getTerminalId(); if (terminalId == -1) { Random random = new Random(); terminalId = random.nextInt(10000) + 1; } Terminal terminal = new Terminal(); terminal.setId(terminalId); terminal.setName(String.valueOf(terminalId)); //$NON-NLS-1$ TerminalDAO.getInstance().saveOrUpdate(terminal); CashDrawer cashDrawer = new CashDrawer(); cashDrawer.setTerminal(terminal); Currency currency = new Currency(); currency.setName("USD"); currency.setSymbol("$"); currency.setExchangeRate(1.0); currency.setMain(true); CurrencyDAO.getInstance().save(currency); currency = new Currency(); currency.setName("EUR"); currency.setSymbol("E"); currency.setExchangeRate(0.8); CurrencyDAO.getInstance().save(currency); currency = new Currency(); currency.setName("BRL"); currency.setSymbol("B"); currency.setExchangeRate(3.47); CurrencyDAO.getInstance().save(currency); currency = new Currency(); currency.setName("ARS"); currency.setSymbol("P"); currency.setExchangeRate(13.89); CurrencyDAO.getInstance().save(currency); currency = new Currency(); currency.setName("PYG"); currency.setSymbol("P"); currency.setExchangeRate(5639.78); CurrencyDAO.getInstance().save(currency); MenuItemSize menuItemSize = new MenuItemSize(); menuItemSize.setName("SMALL"); menuItemSize.setSortOrder(0); MenuItemSizeDAO.getInstance().save(menuItemSize); menuItemSize = new MenuItemSize(); menuItemSize.setName("MEDIUM"); menuItemSize.setSortOrder(1); MenuItemSizeDAO.getInstance().save(menuItemSize); menuItemSize = new MenuItemSize(); menuItemSize.setName("LARGE"); menuItemSize.setSortOrder(2); MenuItemSizeDAO.getInstance().save(menuItemSize); PizzaCrust crust = new PizzaCrust(); crust.setName("PAN"); crust.setSortOrder(0); PizzaCrustDAO.getInstance().save(crust); crust = new PizzaCrust(); crust.setName("HAND TOSSED"); crust.setSortOrder(1); PizzaCrustDAO.getInstance().save(crust); Multiplier multiplier = new Multiplier("Regular"); multiplier.setRate(0.0); multiplier.setSortOrder(0); multiplier.setTicketPrefix(""); multiplier.setDefaultMultiplier(true); multiplier.setMain(true); MultiplierDAO.getInstance().save(multiplier); multiplier = new Multiplier("No"); multiplier.setRate(0.0); multiplier.setSortOrder(1); multiplier.setTicketPrefix("No"); multiplier.setDefaultMultiplier(false); MultiplierDAO.getInstance().save(multiplier); multiplier = new Multiplier("Half"); multiplier.setRate(50.0); multiplier.setSortOrder(2); multiplier.setTicketPrefix("Half"); multiplier.setDefaultMultiplier(false); MultiplierDAO.getInstance().save(multiplier); multiplier = new Multiplier("Quarter"); multiplier.setRate(25.0); multiplier.setSortOrder(3); multiplier.setTicketPrefix("Quarter"); multiplier.setDefaultMultiplier(false); MultiplierDAO.getInstance().save(multiplier); multiplier = new Multiplier("Extra"); multiplier.setRate(200.0); multiplier.setSortOrder(4); multiplier.setTicketPrefix("Extra"); multiplier.setDefaultMultiplier(false); MultiplierDAO.getInstance().save(multiplier); multiplier = new Multiplier("Triple"); multiplier.setRate(300.0); multiplier.setSortOrder(5); multiplier.setTicketPrefix("Triple"); multiplier.setDefaultMultiplier(false); MultiplierDAO.getInstance().save(multiplier); multiplier = new Multiplier("Sub"); multiplier.setRate(100.0); multiplier.setSortOrder(6); multiplier.setTicketPrefix("Sub"); multiplier.setDefaultMultiplier(false); MultiplierDAO.getInstance().save(multiplier); if (!exportSampleData) { return true; } DataImportAction.importMenuItems(DatabaseUtil.class.getResourceAsStream("/floreantpos-menu-items.xml")); return true; } catch (Exception e) { PosLog.error(DatabaseUtil.class, e.getMessage()); logger.error(e); return false; } }
From source file:com.floreantpos.util.DatabaseUtil.java
License:Open Source License
public static boolean updateDatabase(String connectionString, String hibernateDialect, String hibernateConnectionDriverClass, String user, String password) { try {/* w w w .j a va 2s. c o m*/ Configuration configuration = _RootDAO.getNewConfiguration(null); configuration = configuration.setProperty("hibernate.dialect", hibernateDialect); configuration = configuration.setProperty("hibernate.connection.driver_class", hibernateConnectionDriverClass); configuration = configuration.setProperty("hibernate.connection.url", connectionString); configuration = configuration.setProperty("hibernate.connection.username", user); configuration = configuration.setProperty("hibernate.connection.password", password); configuration = configuration.setProperty("hibernate.hbm2ddl.auto", "update"); SchemaUpdate schemaUpdate = new SchemaUpdate(configuration); schemaUpdate.execute(true, true); _RootDAO.initialize(); return true; } catch (Exception e) { PosLog.error(DatabaseUtil.class, e.getMessage()); logger.error(e); return false; } }