zVUNN2BX

1try {
2            Configuration configuration = new Configuration().configure("hibernate.cfg.xml");      
3            factory = configuration.buildSessionFactory();
4        } catch (Throwable ex) {
5            System.err.println("Failed to create sessionFactory object." + ex);
6        }
7	
8<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
9    <property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
10    <property name="hibernate.connection.url">jdbc:mysql://localhost:3310/mydb?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false</property>
11    <property name="hibernate.connection.username">root</property>
12    <property name="hibernate.connection.password">qet</property>
13    <property name="format_sql">true</property>
14    <property name="hibernate.hbm2ddl.import_files_sql_extractor">org.hibernate.tool.hbm2ddl.MultipleLinesSqlCommandExtractor</property>
15    <property name="hibernate.hbm2ddl.auto">create</property>
16    <property name="hibernate.hbm2ddl.import_files">/database/initial.sql</property>
17	
18-- Settings
19      CREATE TABLE IF NOT EXISTS `settings` (
20  `idsettings` int(11) NOT NULL AUTO_INCREMENT,
21  `fpCoreBanking` varchar(100) DEFAULT NULL,
22  `imgCoreBanking` varchar(100) DEFAULT NULL,
23  `fpCustomerUI` varchar(100) DEFAULT NULL,
24  `imgCustomerUI` varchar(100) DEFAULT NULL,
25  `fpAdminUI` varchar(100) DEFAULT NULL,
26  `imgAdminUI` varchar(100) DEFAULT NULL,
27  `gitlabUrl` varchar(45) DEFAULT NULL,
28  `gitlabToken` varchar(45) DEFAULT NULL,
29  `profileProject` varchar(45) DEFAULT NULL,
30  `webCSRProject` varchar(45) DEFAULT NULL,
31  `webAdminProject` varchar(45) DEFAULT NULL,
32  `webClientProject` varchar(45) DEFAULT NULL,
33  `dockerHostname` varchar(45) DEFAULT NULL,
34  `dockerIP` varchar(45) DEFAULT NULL,
35  `dockerPort` int(11) DEFAULT NULL,
36  `user` varchar(45) DEFAULT NULL,
37  `seleniumName` varchar(45) DEFAULT NULL,
38  `networkName` varchar(45) DEFAULT NULL,
39  PRIMARY KEY (`idsettings`)
40) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
41
42    INSERT INTO `settings` (`idsettings`, `fpCoreBanking`, `imgCoreBanking`, `fpCustomerUI`, `imgCustomerUI`, `fpAdminUI`, `imgAdminUI`, `gitlabUrl`, `gitlabToken`, `profileProject`, `webCSRProject`, `webAdminProject`, `webClientProject`, `dockerHostname`, `dockerIP`, `dockerPort`, `user`, `seleniumName`, `networkName`) VALUES ('7', 'docker.impactzero.pt/atp/dockers/fp-builder', 'docker.impactzero.pt/atp/dockers/profile-core', 'docker.impactzero.pt/atp/dockers/webpd-builder', 'docker.impactzero.pt/atp/dockers/tomcat-server', 'docker.impactzero.pt/atp/dockers/webpd-builder', 'docker.impactzero.pt/atp/dockers/tomcat-server', 'https://gitlab.impactzero.pt/', '2kA8mSX97P-dsJKSVMYT', 'atp-demo / Profile', 'atp-demo / WebCSR', 'atp-demo / WebADMIN', 'atp / atp-winrm-client', 'ATP', '192.168.56.101', '2375', 'admin', 'atp_selenium', 'atpnetwork');