public ClassDescriptor buildChildDescriptor() { RelationalDescriptor descriptor = new RelationalDescriptor(); descriptor.setJavaClass(Child.class); descriptor.addTableName("OTOJT_CHILD"); descriptor.addPrimaryKeyFieldName("OTOJT_CHILD.CHILD_ID"); descriptor.useSoftCacheWeakIdentityMap(); descriptor.setIdentityMapSize(50); descriptor.setSequenceNumberFieldName("OTOJT_CHILD.CHILD_ID"); descriptor.setSequenceNumberName("OTOJT_CHILD_SEQ"); descriptor.setAlias("OTOJT_Child"); // Query Manager. descriptor.getQueryManager().checkCacheForDoesExist(); // Mappings. DirectToFieldMapping firstNameMapping = new DirectToFieldMapping(); firstNameMapping.setAttributeName("firstName"); firstNameMapping.setFieldName("F_NAME"); firstNameMapping.setNullValue(""); descriptor.addMapping(firstNameMapping); DirectToFieldMapping idMapping = new DirectToFieldMapping(); idMapping.setAttributeName("id"); idMapping.setFieldName("CHILD_ID"); descriptor.addMapping(idMapping); DirectToFieldMapping lastNameMapping = new DirectToFieldMapping(); lastNameMapping.setAttributeName("lastName"); lastNameMapping.setFieldName("L_NAME"); lastNameMapping.setNullValue(""); descriptor.addMapping(lastNameMapping); DirectToFieldMapping genderMapping = new DirectToFieldMapping(); genderMapping.setAttributeName("gender"); genderMapping.setFieldName("GENDER"); ObjectTypeConverter genderMappingConverter = new ObjectTypeConverter(); genderMappingConverter.addConversionValue("F", "Female"); genderMappingConverter.addConversionValue("M", "Male"); genderMapping.setConverter(genderMappingConverter); descriptor.addMapping(genderMapping); DirectToFieldMapping birthdayMapping = new DirectToFieldMapping(); birthdayMapping.setAttributeName("birthday"); birthdayMapping.setFieldName("BIRTHDAY"); descriptor.addMapping(birthdayMapping); OneToOneMapping parentMapping = new OneToOneMapping(); parentMapping.setAttributeName("parent"); parentMapping.setReferenceClass(Employee.class); parentMapping.dontUseIndirection(); parentMapping.setRelationTableMechanism(new RelationTableMechanism()); parentMapping.getRelationTableMechanism().setRelationTableName("OTOJT_CHILD_PARENT"); parentMapping .getRelationTableMechanism() .addSourceRelationKeyFieldName("OTOJT_CHILD_PARENT.CHILD_ID", "OTOJT_CHILD.CHILD_ID"); parentMapping .getRelationTableMechanism() .addTargetRelationKeyFieldName("OTOJT_CHILD_PARENT.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); // parentMapping.addForeignKeyFieldName("OTOJT_CHILD.PARENT_EMP_ID", // "OTOJT_EMPLOYEE.EMP_ID"); parentMapping.readOnly(); descriptor.addMapping(parentMapping); return descriptor; }
public ClassDescriptor buildPojoEmployeeDescriptor() { RelationalDescriptor descriptor = new RelationalDescriptor(); descriptor.setJavaClass( org.eclipse.persistence.testing.tests.simplepojoclient.PojoEmployee.class); descriptor.addTableName("POJO_EMPLOYEE"); descriptor.addPrimaryKeyFieldName("POJO_EMPLOYEE.EMP_ID"); // Descriptor Properties. descriptor.useSoftCacheWeakIdentityMap(); descriptor.setIdentityMapSize(100); descriptor.useRemoteSoftCacheWeakIdentityMap(); descriptor.setRemoteIdentityMapSize(100); descriptor.setAlias("PojoEmployee"); // Query Manager. descriptor.getQueryManager().checkCacheForDoesExist(); // Event Manager. // Mappings. DirectToFieldMapping empIdMapping = new DirectToFieldMapping(); empIdMapping.setAttributeName("empId"); empIdMapping.setGetMethodName("getEmpId"); empIdMapping.setSetMethodName("setEmpId"); empIdMapping.setFieldName("POJO_EMPLOYEE.EMP_ID"); descriptor.addMapping(empIdMapping); DirectToFieldMapping fNameMapping = new DirectToFieldMapping(); fNameMapping.setAttributeName("fName"); fNameMapping.setGetMethodName("getFName"); fNameMapping.setSetMethodName("setFName"); fNameMapping.setFieldName("POJO_EMPLOYEE.F_NAME"); descriptor.addMapping(fNameMapping); DirectToFieldMapping genderMapping = new DirectToFieldMapping(); genderMapping.setAttributeName("gender"); genderMapping.setGetMethodName("getGender"); genderMapping.setSetMethodName("setGender"); genderMapping.setFieldName("POJO_EMPLOYEE.GENDER"); ObjectTypeConverter genderMappingConverter = new ObjectTypeConverter(); genderMappingConverter.addConversionValue(new Character('F'), "Female"); genderMappingConverter.addConversionValue(new Character('M'), "Male"); genderMapping.setConverter(genderMappingConverter); descriptor.addMapping(genderMapping); DirectToFieldMapping lNameMapping = new DirectToFieldMapping(); lNameMapping.setAttributeName("lName"); lNameMapping.setGetMethodName("getLName"); lNameMapping.setSetMethodName("setLName"); lNameMapping.setFieldName("POJO_EMPLOYEE.L_NAME"); descriptor.addMapping(lNameMapping); DirectToFieldMapping managerIdMapping = new DirectToFieldMapping(); managerIdMapping.setAttributeName("managerId"); managerIdMapping.setGetMethodName("getManagerId"); managerIdMapping.setSetMethodName("setManagerId"); managerIdMapping.setFieldName("POJO_EMPLOYEE.MANAGER_ID"); descriptor.addMapping(managerIdMapping); return descriptor; }
public ClassDescriptor buildEmployeeDescriptor() { RelationalDescriptor descriptor = new RelationalDescriptor(); descriptor.setJavaClass(Employee.class); descriptor.addTableName("OTOJT_EMPLOYEE"); descriptor.addTableName("OTOJT_SALARY"); descriptor.addPrimaryKeyFieldName("OTOJT_EMPLOYEE.EMP_ID"); // Descriptor Properties. descriptor.useSoftCacheWeakIdentityMap(); descriptor.setIdentityMapSize(100); descriptor.setSequenceNumberFieldName("OTOJT_EMPLOYEE.EMP_ID"); descriptor.setSequenceNumberName("OTOJT_EMP_SEQ"); VersionLockingPolicy lockingPolicy = new VersionLockingPolicy(); lockingPolicy.setWriteLockFieldName("OTOJT_EMPLOYEE.VERSION"); descriptor.setOptimisticLockingPolicy(lockingPolicy); descriptor.setAlias("OTOJT_Employee"); // Cache Invalidation Policy // Query Manager. descriptor.getQueryManager().checkCacheForDoesExist(); // Named Queries. // Event Manager. // Mappings. DirectToFieldMapping firstNameMapping = new DirectToFieldMapping(); firstNameMapping.setAttributeName("firstName"); firstNameMapping.setFieldName("OTOJT_EMPLOYEE.F_NAME"); firstNameMapping.setNullValue(""); descriptor.addMapping(firstNameMapping); DirectToFieldMapping idMapping = new DirectToFieldMapping(); idMapping.setAttributeName("id"); idMapping.setFieldName("OTOJT_EMPLOYEE.EMP_ID"); descriptor.addMapping(idMapping); DirectToFieldMapping lastNameMapping = new DirectToFieldMapping(); lastNameMapping.setAttributeName("lastName"); lastNameMapping.setFieldName("OTOJT_EMPLOYEE.L_NAME"); lastNameMapping.setNullValue(""); descriptor.addMapping(lastNameMapping); DirectToFieldMapping salaryMapping = new DirectToFieldMapping(); salaryMapping.setAttributeName("salary"); salaryMapping.setFieldName("OTOJT_SALARY.SALARY"); descriptor.addMapping(salaryMapping); DirectToFieldMapping genderMapping = new DirectToFieldMapping(); genderMapping.setAttributeName("gender"); genderMapping.setFieldName("OTOJT_EMPLOYEE.GENDER"); ObjectTypeConverter genderMappingConverter = new ObjectTypeConverter(); genderMappingConverter.addConversionValue("F", "Female"); genderMappingConverter.addConversionValue("M", "Male"); genderMapping.setConverter(genderMappingConverter); descriptor.addMapping(genderMapping); DirectCollectionMapping responsibilitiesListMapping = new DirectCollectionMapping(); responsibilitiesListMapping.setAttributeName("responsibilitiesList"); responsibilitiesListMapping.useTransparentList(); responsibilitiesListMapping.setReferenceTableName("OTOJT_RESPONS"); responsibilitiesListMapping.setDirectFieldName("OTOJT_RESPONS.DESCRIP"); responsibilitiesListMapping.addReferenceKeyFieldName( "OTOJT_RESPONS.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); descriptor.addMapping(responsibilitiesListMapping); OneToOneMapping addressMapping = new OneToOneMapping(); addressMapping.setAttributeName("address"); addressMapping.setReferenceClass(Address.class); addressMapping.useBasicIndirection(); addressMapping.privateOwnedRelationship(); // addressMapping.addForeignKeyFieldName("OTOJT_EMPLOYEE.ADDR_ID", // "OTOJT_ADDRESS.ADDRESS_ID"); addressMapping.setRelationTableMechanism(new RelationTableMechanism()); addressMapping.getRelationTableMechanism().setRelationTableName("OTOJT_EMP_ADDRESS"); addressMapping .getRelationTableMechanism() .addSourceRelationKeyFieldName("OTOJT_EMP_ADDRESS.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); addressMapping .getRelationTableMechanism() .addTargetRelationKeyFieldName("OTOJT_EMP_ADDRESS.ADDR_ID", "OTOJT_ADDRESS.ADDRESS_ID"); descriptor.addMapping(addressMapping); // Joel:EJBQLTesting OneToOneMapping managerMapping = new OneToOneMapping(); managerMapping.setAttributeName("manager"); managerMapping.setReferenceClass(Employee.class); managerMapping.useBasicIndirection(); // managerMapping.addForeignKeyFieldName("OTOJT_EMPLOYEE.MANAGER_ID", // "OTOJT_EMPLOYEE.EMP_ID"); managerMapping.setRelationTableMechanism(new RelationTableMechanism()); managerMapping.getRelationTableMechanism().setRelationTableName("OTOJT_EMP_MANAGER"); managerMapping .getRelationTableMechanism() .addSourceRelationKeyFieldName("OTOJT_EMP_MANAGER.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); managerMapping .getRelationTableMechanism() .addTargetRelationKeyFieldName("OTOJT_EMP_MANAGER.MANAGER_ID", "OTOJT_EMPLOYEE.EMP_ID"); descriptor.addMapping(managerMapping); // OneToManyMapping managedEmployeesMapping = new OneToManyMapping(); ManyToManyMapping managedEmployeesMapping = new ManyToManyMapping(); managedEmployeesMapping.setAttributeName("managedEmployees"); managedEmployeesMapping.setReferenceClass(Employee.class); managedEmployeesMapping.useTransparentList(); // managedEmployeesMapping.addTargetForeignKeyFieldName("OTOJT_EMPLOYEE.MANAGER_ID", // "OTOJT_EMPLOYEE.EMP_ID"); managedEmployeesMapping.setRelationTableName("OTOJT_EMP_MANAGER"); managedEmployeesMapping.addSourceRelationKeyFieldName( "OTOJT_EMP_MANAGER.MANAGER_ID", "OTOJT_EMPLOYEE.EMP_ID"); managedEmployeesMapping.addTargetRelationKeyFieldName( "OTOJT_EMP_MANAGER.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); managedEmployeesMapping.readOnly(); descriptor.addMapping(managedEmployeesMapping); // OneToManyMapping childrenMapping = new OneToManyMapping(); ManyToManyMapping childrenMapping = new ManyToManyMapping(); childrenMapping.setAttributeName("children"); childrenMapping.setReferenceClass(Child.class); childrenMapping.addAscendingOrdering("birthday"); childrenMapping.useTransparentList(); childrenMapping.privateOwnedRelationship(); // childrenMapping.addTargetForeignKeyFieldName("OTOJT_CHILD.PARENT_EMP_ID", // "OTOJT_EMPLOYEE.EMP_ID"); childrenMapping.setRelationTableName("OTOJT_CHILD_PARENT"); childrenMapping.addSourceRelationKeyFieldName( "OTOJT_CHILD_PARENT.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); childrenMapping.addTargetRelationKeyFieldName( "OTOJT_CHILD_PARENT.CHILD_ID", "OTOJT_CHILD.CHILD_ID"); descriptor.addMapping(childrenMapping); ManyToManyMapping projectsMapping = new ManyToManyMapping(); projectsMapping.setAttributeName("projects"); projectsMapping.setReferenceClass(Project.class); projectsMapping.useTransparentList(); projectsMapping.setRelationTableName("OTOJT_PROJ_EMP"); projectsMapping.addSourceRelationKeyFieldName("OTOJT_PROJ_EMP.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); projectsMapping.addTargetRelationKeyFieldName( "OTOJT_PROJ_EMP.PROJ_ID", "OTOJT_PROJECT.PROJ_ID"); descriptor.addMapping(projectsMapping); OneToOneMapping projectLedMapping = new OneToOneMapping(); projectLedMapping.setAttributeName("projectLed"); projectLedMapping.setReferenceClass(Project.class); projectLedMapping.useBasicIndirection(); projectLedMapping.setRelationTableMechanism(new RelationTableMechanism()); projectLedMapping.getRelationTableMechanism().setRelationTableName("OTOJT_PROJ_LEADER"); projectLedMapping .getRelationTableMechanism() .addSourceRelationKeyFieldName("OTOJT_PROJ_LEADER.EMP_ID", "OTOJT_EMPLOYEE.EMP_ID"); projectLedMapping .getRelationTableMechanism() .addTargetRelationKeyFieldName("OTOJT_PROJ_LEADER.PROJ_ID", "PROJ_ID"); projectLedMapping.readOnly(); descriptor.addMapping(projectLedMapping); return descriptor; }