![]() The needed properties for every bean is provided so that it gets instantiated successfully. ![]() All it contains is the configuration for the beans that would be instantiated by Spring framework. I have provided the entire contents of this spring bean config below. This is the master configuration file that Spring reads to instantiate all needed beans. Here is the complete pom.xmlĪpplicationContext.xml (src/main/resources) This involves adding spring artifacts spring-orm and spring-context. The one additional step that was done here is to add spring related configuration in pom.xml. INSERT INTO DEPARTMENT (DEPT_ID,NAME,LOCATION_ID) values (40,'OPERATIONS',167) INSERT INTO DEPARTMENT (DEPT_ID,NAME,LOCATION_ID) values (30,'SALES',null) INSERT INTO DEPARTMENT (DEPT_ID,NAME,LOCATION_ID) values (20,'RESEARCH',124) ![]() INSERT INTO DEPARTMENT (DEPT_ID,NAME,LOCATION_ID) values (10,'ACCOUNTING',122) ![]() INSERT INTO EMPLOYEE_EXPENSE (EMP_EXP_ID,EMP_ID,YEAR,MONTH,EXPENSE_CLAIM,APPROVED_AMT,PAID_DATE) VALUES (9,7782,2002,9,1200,1200,to_timestamp('01-OCT-02','DD-MON-RR HH.MI.SSXFF AM')) ĬONSTRAINT "DEPARTMENT_PK" PRIMARY KEY ("DEPT_ID") The below script was used for itĬONSTRAINT "EMP_EXP_PK" PRIMARY KEY ("EMP_EXP_ID"),ĬONSTRAINT "FK_EMPLOYEE" FOREIGN KEY ("EMP_ID") REFERENCES "EMPLOYEE" ("EMP_ID") ENABLE An additional thing to do is – to create the new tables EMPLOYEE_EXPENSE and DEPARTMENTS and insert data. Installation and setup is exactly same like the previous project. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |