List of usage examples for org.hibernate SessionFactory getCurrentSession
Session getCurrentSession() throws HibernateException;
From source file:database.AcornSatDataLoader.java
License:Open Source License
/** * Main method used to load ACORN-SAT data only. * On an existing database, this may duplicate data. * @param args: no parameters/*from ww w . j a va 2 s . com*/ */ public static void main(String[] args) { AnnotationConfiguration config = new AnnotationConfiguration(); config.setNamingStrategy(ImprovedNamingStrategy.INSTANCE); config.configure("database/hibernate.cfg.xml"); new SchemaExport(config).create(true, true); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction(); LoadAcornSatData(session); session.getTransaction().commit(); }
From source file:database.BitreDataLoader.java
License:Open Source License
/** * Main method used to load BITRE data only. * On an existing database, this may duplicate data. * @param args: no parameters//w w w . jav a 2 s .c o m */ public static void main(String[] args) { AnnotationConfiguration config = new AnnotationConfiguration(); config.setNamingStrategy(ImprovedNamingStrategy.INSTANCE); config.configure("database/hibernate.cfg.xml"); new SchemaExport(config).create(true, true); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction(); LoadBitreData(session); session.getTransaction().commit(); }
From source file:database.BomDataLoader.java
License:Open Source License
/** * Main method used to load BoM (observed trends) data only. * On an existing database, this may duplicate data. * @param args: no parameters/*from ww w . jav a 2s .c o m*/ */ public static void main(String[] args) { AnnotationConfiguration config = new AnnotationConfiguration(); config.setNamingStrategy(ImprovedNamingStrategy.INSTANCE); config.configure("database/hibernate.cfg.xml"); new SchemaExport(config).create(true, true); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction(); LoadBomData(session); session.getTransaction().commit(); }
From source file:database.CsiroDataLoader.java
License:Open Source License
/** * Main method used to load CSIRO and CMAR data only. * On an existing database, this may duplicate data. * @param args: no parameters//from w w w . j a v a2 s . c om */ public static void main(String[] args) { AnnotationConfiguration config = new AnnotationConfiguration(); config.setNamingStrategy(ImprovedNamingStrategy.INSTANCE); config.configure("database/hibernate.cfg.xml"); new SchemaExport(config).create(true, true); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction(); LoadCsiroData(session); session.getTransaction().commit(); }
From source file:database.DatabaseLoader.java
License:Open Source License
/** * Main method loading all the initial data in the database using Hibernate * Running this is equivalent to importing the 'seaports_dump.sql' SQL script * in an empty 'seaports' database, minus the engineering model examples. * @param args: no parameters/*from ww w . j a v a2 s. c o m*/ */ public static void main(String[] args) { AnnotationConfiguration config = new AnnotationConfiguration(); config.setNamingStrategy(ImprovedNamingStrategy.INSTANCE); config.configure("database/hibernate.cfg.xml"); new SchemaExport(config).create(true, true); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction(); User guillaume = new User("gprevost", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_ADMINISTRATOR, "guillaume.prevost@rmit.edu.au", "Guillaume", "Prevost"); User jane = new User("jmullett", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "jane.mullett@rmit.edu.au", "Jane", "Mullett"); User alexei = new User("atrundle", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "alexei.trundle@rmit.edu.au", "Alexei", "Trundle"); User helen = new User("hscott", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "helen.scott@rmit.edu.au", "Helen", "Scott"); User darryn = new User("dmcevoy", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "darryn.mcevoy@rmit.edu.au", "Darryn", "McEvoy"); User ravi = new User("rsrini", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "ravi.sreenivasamurthy@rmit.edu.au", "Ravi", "Srini"); User user = new User("user", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "email@company.com", "User", "User"); User admin = new User("admin", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_ADMINISTRATOR, "email@company.com", "Admin", "Admin"); session.save(guillaume); session.save(jane); session.save(alexei); session.save(helen); session.save(darryn); session.save(ravi); session.save(user); session.save(admin); // Regions & Ports Region r1 = new Region("East Coast South", "149.0547914184899,-28.24548513942176 148.9609907444339,-35.25426489702431 155.2660617233398,-35.19627668034501 154.8867619045885,-27.90208550082615 149.0547914184899,-28.24548513942176"); Region r2 = new Region("Southern Slopes Vic East", "145.3189141977523,-33.8991314327851 145.0790050622273,-39.34717405549549 153.0808752795217,-39.39167277749677 152.564341927145,-34.0115196362042 145.3189141977523,-33.8991314327851"); Region r3 = new Region("Southern and Southwestern Flatlands West", "112.7632954156051,-26.52537830109324 112.2397686001995,-35.9640923319097 125.4390964302563,-36.01229549528745 124.759915381913,-26.54545205884348 112.7632954156051,-26.52537830109324"); Region r4 = new Region("Monsoonal North", ""); Region r5 = new Region("Wet Tropics", ""); Region r6 = new Region("Rangelands", ""); Region r7 = new Region("Central Slopes", ""); Region r8 = new Region("Murray Basin", ""); session.save(r1); session.save(r2); session.save(r3); session.save(r4); session.save(r5); session.save(r6); session.save(r7); session.save(r8); Seaport port1 = new Seaport("AUYBA", "Port of Yamba", r1); Seaport port2 = new Seaport("AUNTL", "Port of Newcastle", r1, "Newcastle"); Seaport port3 = new Seaport("AUSYD", "Sydney Ports", r1, "Sydney"); //Seaport port4 = new Seaport("AUBTB", "Port of Botany Bay", r1); //Seaport port5 = new Seaport("AUCFS", "Coffs Harbour", r1); Seaport port6 = new Seaport("AUBSJ", "Lakes Entrance", r2, "Bairnsdale"); Seaport port7 = new Seaport("AUPKL", "Port Kembla", r2, "Wollongong"); Seaport port8 = new Seaport("AUQDN", "Port of Eden", r2); Seaport port9 = new Seaport("AUXMC", "Port of Mallacoota", r2); Seaport port10 = new Seaport("AUWHL", "Port Welshpool", r2); Seaport port11 = new Seaport("AUEPR", "Esperance Ports", r3); Seaport port12 = new Seaport("AUALH", "Albany Port", r3, "Albany"); Seaport port13 = new Seaport("AUBUY", "Bunbury Port", r3, "Bunbury"); Seaport port14 = new Seaport("AUGET", "Geraldton Port", r3, "Geraldton"); Seaport port15 = new Seaport("AUFRE", "Fremantle Ports", r3, "Perth"); session.save(port1); session.save(port2); session.save(port3); //session.save(port4); //session.save(port5); session.save(port6); session.save(port7); session.save(port8); session.save(port9); session.save(port10); session.save(port11); session.save(port12); session.save(port13); session.save(port14); session.save(port15); // Loads the various datasets CsiroDataLoader.LoadCsiroData(session); EngineeringModelDataLoader.LoadEngineeringModelData(session); BomDataLoader.LoadBomData(session); AcornSatDataLoader.LoadAcornSatData(session); AbsDataLoader.LoadAbsData(session); BitreDataLoader.LoadBitreData(session); session.getTransaction().commit(); }
From source file:database.EngineeringModelDataLoader.java
License:Open Source License
/** * Main method used to load engineering model variables only. * On an existing database, this may duplicate data. * @param args: no parameters//from w ww . j a v a 2 s . c o m */ public static void main(String[] args) { AnnotationConfiguration config = new AnnotationConfiguration(); config.setNamingStrategy(ImprovedNamingStrategy.INSTANCE); config.configure("database/hibernate.cfg.xml"); //new SchemaExport(config).create(true,true); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction(); LoadEngineeringModelData(session); session.getTransaction().commit(); }
From source file:database.TestDatabaseLoader.java
License:Open Source License
/** * Main method loading all the test data in the test database using Hibernate. * Running this is equivalent to importing the 'seaports_test_dump.sql' SQL * script in an empty 'seaports' database, minus the engineering model examples. * @param args: no parameters/*from w ww.j ava 2 s .co m*/ */ public static void main(String[] args) { AnnotationConfiguration config = new AnnotationConfiguration(); config.setNamingStrategy(ImprovedNamingStrategy.INSTANCE); config.configure("database/hibernate-test.cfg.xml"); new SchemaExport(config).create(true, true); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction(); // Regions & Ports Region r1 = new Region("East Coast South", "149.0547914184899,-28.24548513942176 148.9609907444339,-35.25426489702431 155.2660617233398,-35.19627668034501 154.8867619045885,-27.90208550082615 149.0547914184899,-28.24548513942176"); Region r2 = new Region("Southern Slopes Vic East", "145.3189141977523,-33.8991314327851 145.0790050622273,-39.34717405549549 153.0808752795217,-39.39167277749677 152.564341927145,-34.0115196362042 145.3189141977523,-33.8991314327851"); Region r3 = new Region("Southern and Southwestern Flatlands West", "112.7632954156051,-26.52537830109324 112.2397686001995,-35.9640923319097 125.4390964302563,-36.01229549528745 124.759915381913,-26.54545205884348 112.7632954156051,-26.52537830109324"); Region r4 = new Region("Monsoonal North", ""); Region r5 = new Region("Wet Tropics", ""); Region r6 = new Region("Rangelands", ""); Region r7 = new Region("Central Slopes", ""); Region r8 = new Region("Murray Basin", ""); session.save(r1); session.save(r2); session.save(r3); session.save(r4); session.save(r5); session.save(r6); session.save(r7); session.save(r8); Seaport port1 = new Seaport("AUYBA", "Port of Yamba", r1); Seaport port2 = new Seaport("AUNTL", "Port of Newcastle", r1, "Newcastle"); Seaport port3 = new Seaport("AUSYD", "Sydney Ports", r1, "Sydney"); //Seaport port4 = new Seaport("AUBTB", "Port of Botany Bay", r1); //Seaport port5 = new Seaport("AUCFS", "Coffs Harbour", r1); Seaport port6 = new Seaport("AUBSJ", "Lakes Entrance", r2, "Bairnsdale"); Seaport port7 = new Seaport("AUPKL", "Port Kembla", r2, "Wollongong"); Seaport port8 = new Seaport("AUQDN", "Port of Eden", r2); Seaport port9 = new Seaport("AUXMC", "Port of Mallacoota", r2); Seaport port10 = new Seaport("AUWHL", "Port Welshpool", r2); Seaport port11 = new Seaport("AUEPR", "Esperance Ports", r3); Seaport port12 = new Seaport("AUALH", "Albany Port", r3, "Albany"); Seaport port13 = new Seaport("AUBUY", "Bunbury Port", r3, "Bunbury"); Seaport port14 = new Seaport("AUGET", "Geraldton Port", r3, "Geraldton"); Seaport port15 = new Seaport("AUFRE", "Fremantle Ports", r3, "Perth"); session.save(port1); session.save(port2); session.save(port3); //session.save(port4); //session.save(port5); session.save(port6); session.save(port7); session.save(port8); session.save(port9); session.save(port10); session.save(port11); session.save(port12); session.save(port13); session.save(port14); session.save(port15); CsiroDataLoader.LoadCsiroData(session); EngineeringModelDataLoader.LoadEngineeringModelData(session); BomDataLoader.LoadBomData(session); AcornSatDataLoader.LoadAcornSatData(session); AbsDataLoader.LoadAbsData(session); BitreDataLoader.LoadBitreData(session); // Add Users User p1 = new User("testuser1", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "email@company.com", "testuser1", "testuser1"); User p2 = new User("testuser2", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "email@company.com", "testuser2", "testuser2"); User p3 = new User("testuser3", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "email@company.com", "testuser3", "testuser3"); User p4 = new User("testuser4", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_USER, "email@company.com", "testuser4", "testuser4"); User p5 = new User("testadmin1", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_ADMINISTRATOR, "email@company.com", "testadmin1", "testadmin1"); User p6 = new User("testadmin2", DEFAULT_PASSWORD, true, true, UserLoginService.ROLE_ADMINISTRATOR, "email@company.com", "testadmin2", "testadmin2"); session.save(p1); session.save(p2); session.save(p3); session.save(p4); session.save(p5); session.save(p6); DateFormat dateFormatter = new SimpleDateFormat("yyyy-MM-dd"); Date date = null; try { date = dateFormatter.parse("2013-04-10"); } catch (ParseException e) { } // Add Workboards & User Stories UserStory user1wb = new UserStory(); user1wb.setName("User 1 Workboard"); user1wb.setMode("active"); user1wb.setAccess("private"); user1wb.setCreationDate(date); user1wb.setOwner(p1); user1wb.setSeaport(port3); UserStory user1us1 = new UserStory(); user1us1.setName("User 1 Story 1"); user1us1.setMode("passive"); user1us1.setAccess("private"); user1us1.setCreationDate(date); user1us1.setOwner(p1); user1us1.setSeaport(port7); UserStory user1us2 = new UserStory(); user1us2.setName("User 1 Story 2 (Public)"); user1us2.setMode("passive"); user1us2.setAccess("public"); user1us2.setCreationDate(date); user1us2.setOwner(p1); user1us2.setSeaport(port3); UserStory user1us3 = new UserStory(); user1us3.setName("User 1 Story 3 (Published)"); user1us3.setMode("published"); user1us3.setAccess("public"); user1us3.setCreationDate(date); user1us3.setPublishDate(date); user1us3.setOwner(p1); user1us3.setSeaport(port3); UserStory user2wb = new UserStory(); user2wb.setName("User 2 Workboard (Empty)"); user2wb.setMode("active"); user2wb.setAccess("private"); user2wb.setCreationDate(date); user2wb.setOwner(p2); user2wb.setSeaport(port7); UserStory user2us = new UserStory(); user2us.setName("User 2 Story (Empty)"); user2us.setMode("passive"); user2us.setAccess("private"); user2us.setCreationDate(date); user2us.setOwner(p2); user2us.setSeaport(port3); session.save(user1wb); session.save(user1us1); session.save(user1us2); session.save(user1us3); session.save(user2wb); session.save(user2us); // Add Data Elements date = new Date(); String content = "This is a test for Data Element"; DataElementFile de1 = new DataElementFile(date, "Test 1", true, 0, DisplayType.PLAIN, user1wb, "csv", content.getBytes()); content = "This is the second test"; DataElementFile de2 = new DataElementFile(date, "Test 2", true, 0, DisplayType.PLAIN, user1wb, "xml", content.getBytes()); content = "This is the third test"; DataElementFile de3 = new DataElementFile(date, "Test 3", true, 0, DisplayType.PLAIN, user1wb, "txt", content.getBytes()); content = "User Story's Data Element content test"; DataElementFile de4 = new DataElementFile(date, "Test 4", true, 1, DisplayType.PLAIN, user1us1, "txt", content.getBytes()); DataElementText text1 = new DataElementText(date, "Comment text 1", true, 2, DisplayType.PLAIN, user1us1, "This is a text comment"); DataElementFile de5 = new DataElementFile(date, "Test 5", true, 3, DisplayType.PLAIN, user1us1, "txt", content.getBytes()); DataElementText text2 = new DataElementText(date, "Comment text 2", true, 4, DisplayType.PLAIN, user1us1, "This is a second text comment"); DataElementFile de6 = new DataElementFile(date, "Test 6", true, 1, DisplayType.PLAIN, user1us2, "txt", content.getBytes()); session.save(de1); session.save(de2); session.save(de3); session.save(de4); session.save(text1); session.save(de5); session.save(text2); session.save(de6); // CSIRO Data Element ArrayList<CsiroData> csiroDataList = new ArrayList<CsiroData>(); csiroDataList.add((CsiroData) (session.get(CsiroData.class, 1))); csiroDataList.add((CsiroData) (session.get(CsiroData.class, 2))); csiroDataList.add((CsiroData) (session.get(CsiroData.class, 3))); csiroDataList.add((CsiroData) (session.get(CsiroData.class, 4))); DataElementCsiro deCsiro = new DataElementCsiro(date, "CSIRO Data Element Test", true, 0, DisplayType.TABLE, user1wb, csiroDataList); session.save(deCsiro); // CMAR Data Element ArrayList<CmarData> cmarDataList = new ArrayList<CmarData>(); cmarDataList.add((CmarData) (session.get(CmarData.class, 1))); DataElementCmar deCmar = new DataElementCmar(date, "CMAR Data Element Test", true, 0, DisplayType.TABLE, user1wb, cmarDataList, true); session.save(deCmar); // Engineering Model Data Element /*DataElementEngineeringModel deEngModel = new DataElementEngineeringModel(date, "Data Element for " + engVar, true, 0, user1wb, engineeringModelDataList); session.save(deEngModel);*/ // Vulnerability Data Element WeatherEvent we = new WeatherEvent("Heavy rain", 2006, true, "Impact of the event", "1;2;4;0;0;1;5;3;2;0;1;4", "Other consequences", false, "Changes implemented"); session.save(we); session.save(new DataElementVulnerability(date, "Vulnerability Assessment", true, 0, DisplayType.GRAPH, user1wb, we)); // Commit all the transaction session.getTransaction().commit(); }
From source file:DataLayer.CtrlCasellaDB.java
@Override public Casella get(Integer idPartida, Integer numeroFila, Integer numeroColumna) throws Exception { AnnotationConfiguration config = new AnnotationConfiguration(); config.addAnnotatedClass(Partida.class); config.addAnnotatedClass(Casella.class); config.addAnnotatedClass(Jugador.class); config.addAnnotatedClass(UsuariRegistrat.class); config.addAnnotatedClass(Joc2048.class); config.configure("hibernate.cfg.xml"); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction();//w w w . j a va 2s . co m List<Casella> l = session .createQuery("from Casella where idPartida = :idP and numeroFila = :nF and numeroColumna = :nC") .setParameter("idP", idPartida).setParameter("nF", numeroFila).setParameter("nC", numeroColumna) .list(); session.getTransaction().commit(); factory.close(); if (!l.isEmpty()) { return l.get(0); } throw new Exception("casellaNoExisteix"); }
From source file:DataLayer.CtrlCasellaDB.java
@Override public boolean exists(Integer idPartida, Integer numeroFila, Integer numeroColumna) { AnnotationConfiguration config = new AnnotationConfiguration(); config.addAnnotatedClass(Partida.class); config.addAnnotatedClass(Casella.class); config.addAnnotatedClass(Jugador.class); config.addAnnotatedClass(UsuariRegistrat.class); config.addAnnotatedClass(Joc2048.class); config.configure("hibernate.cfg.xml"); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction();/*from ww w . j av a 2s.com*/ List<Casella> l = session .createQuery("from Casella where idPartida = :idP and numeroFila = :nF and numeroColumna = :nC") .setParameter("idP", idPartida).setParameter("nF", numeroFila).setParameter("nC", numeroColumna) .list(); session.getTransaction().commit(); factory.close(); return !l.isEmpty(); }
From source file:DataLayer.CtrlCasellaDB.java
@Override public Set<Casella> all() { AnnotationConfiguration config = new AnnotationConfiguration(); config.addAnnotatedClass(Partida.class); config.addAnnotatedClass(Casella.class); config.addAnnotatedClass(Jugador.class); config.addAnnotatedClass(UsuariRegistrat.class); config.addAnnotatedClass(Joc2048.class); config.configure("hibernate.cfg.xml"); SessionFactory factory = config.buildSessionFactory(); Session session = factory.getCurrentSession(); session.beginTransaction();//from www. ja v a 2s . com List<Casella> l = session.createQuery("from Casella").list(); session.getTransaction().commit(); factory.close(); Set<Casella> r = new HashSet(); for (Casella c : l) { r.add(c); } return r; }