コード例 #1
0
  /** Return a platform independant definition of the database table. */
  public static TableDefinition tableDefinition(Session session) {
    TableDefinition definition = TypeTester.tableDefinition();
    FieldDefinition fieldDef;

    definition.setName("BOOLEANS");
    fieldDef = new FieldDefinition("BOOLEANV", Boolean.class);
    fieldDef.setShouldAllowNull(false);
    definition.addField(fieldDef);

    fieldDef = new FieldDefinition("BOOLEANC", Boolean.class);
    fieldDef.setShouldAllowNull(false);
    definition.addField(fieldDef);

    return definition;
  }
コード例 #2
0
 @Override
 public void writeAddColumnClause(
     Writer writer, AbstractSession session, TableDefinition table, FieldDefinition field)
     throws IOException {
   writer.write("ADD (");
   field.appendDBString(writer, session, table);
   writer.write(")");
 }
  /**
   * This is Oracle specific Oracle does not allow blobs/longs to be primary keys, so the RAW type
   * needs to be used
   */
  public static TableDefinition buildPrimitiveByteArrayTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_PBYTEARRAYPK_TYPE");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("RAW");
    fieldID.setSize(16);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);

    return table;
  }
コード例 #4
0
  public static TableDefinition buildREADONLYCLASSTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_READONLY");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);

    return table;
  }
コード例 #5
0
  public static TableDefinition buildWHEELRIMTable() {
    // CREATE TABLE JPA_OR_WHEEL_RIM (ID NUMBER(10) NOT NULL, PRIMARY KEY (ID))
    TableDefinition table = new TableDefinition();
    table.setName("JPA_OR_WHEEL_RIM");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(10);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setShouldAllowNull(false);
    fieldID.setUnique(false);
    table.addField(fieldID);

    return table;
  }
コード例 #6
0
  public static TableDefinition buildCACHEABLE_TRUE_ENTITYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_CACHEABLE_TRUE");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setShouldAllowNull(false);
    fieldID.setIsPrimaryKey(true);
    fieldID.setUnique(false);
    fieldID.setIsIdentity(true);
    table.addField(fieldID);

    return table;
  }
コード例 #7
0
  public TableDefinition buildUnderbossTable() {
    TableDefinition table = new TableDefinition();
    table.setName("JPA_UNDERBOSS");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    // fieldID.setForeignKeyFieldName("JPA_MAFIOSO.ID");
    table.addField(fieldID);

    return table;
  }
コード例 #8
0
  @Override
  /**
   * EclipseLink does not support length dependent type mapping. Map varchar types with length >
   * MAX_VARCHAR_UNICODE_LENGTH to CLOB (i.e clob); shorter types to NVARCHAR (n) See also bugs
   * 317597, 317448
   */
  protected void printFieldTypeSize(
      Writer writer, FieldDefinition field, FieldTypeDefinition fieldType) throws IOException {
    String typeName = fieldType.getName();
    if ("NVARCHAR".equals(typeName)) {
      if (field.getSize() > MAX_VARTYPE_LENGTH) {
        fieldType = new FieldTypeDefinition("NCLOB", false);
      }
    } else if ("VARBINARY".equals(typeName)) {
      if (field.getSize() > MAX_VARTYPE_LENGTH || field.getSize() == 0) {
        fieldType = new FieldTypeDefinition("BLOB", false);
      }
    }

    super.printFieldTypeSize(writer, field, fieldType);
    if (fieldType.getTypesuffix() != null) {
      writer.append(" " + fieldType.getTypesuffix());
    }
  }
コード例 #9
0
  public static TableDefinition buildEMPLOYEETable() {
    TableDefinition table = new TableDefinition();
    // SECTION: TABLE
    table.setName("CMP3_XML_EMPLOYEE");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(true);
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("F_NAME");
    field1.setTypeName("VARCHAR");
    field1.setSize(40);
    field1.setShouldAllowNull(true);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field2.setName("L_NAME");
    field2.setTypeName("VARCHAR");
    field2.setSize(40);
    field2.setShouldAllowNull(true);
    field2.setIsPrimaryKey(false);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    table.addField(field2);

    org.eclipse.persistence.tools.schemaframework.FieldDefinition sin =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    sin.setName("SIN");
    sin.setTypeName("VARCHAR");
    sin.setSize(10);
    sin.setShouldAllowNull(true);
    sin.setIsPrimaryKey(false);
    sin.setUnique(false);
    sin.setIsIdentity(false);
    table.addField(sin);

    FieldDefinition fieldGender = new FieldDefinition();
    fieldGender.setName("GENDER");
    fieldGender.setTypeName("VARCHAR");
    fieldGender.setSize(1);
    fieldGender.setShouldAllowNull(true);
    fieldGender.setIsPrimaryKey(false);
    fieldGender.setUnique(false);
    fieldGender.setIsIdentity(false);
    table.addField(fieldGender);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field3.setName("START_DATE");
    field3.setTypeName("DATE");
    field3.setSize(23);
    field3.setShouldAllowNull(true);
    field3.setIsPrimaryKey(false);
    field3.setUnique(false);
    field3.setIsIdentity(false);
    table.addField(field3);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field4 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field4.setName("END_DATE");
    field4.setTypeName("DATE");
    field4.setSize(23);
    field4.setShouldAllowNull(true);
    field4.setIsPrimaryKey(false);
    field4.setUnique(false);
    field4.setIsIdentity(false);
    table.addField(field4);

    FieldDefinition field5 = new FieldDefinition();
    field5.setName("START_TIME");
    field5.setTypeName("TIME");
    field5.setSize(23);
    field5.setShouldAllowNull(true);
    field5.setIsPrimaryKey(false);
    field5.setUnique(false);
    field5.setIsIdentity(false);
    table.addField(field5);

    FieldDefinition field6 = new FieldDefinition();
    field6.setName("END_TIME");
    field6.setTypeName("TIME");
    field6.setSize(23);
    field6.setShouldAllowNull(true);
    field6.setIsPrimaryKey(false);
    field6.setUnique(false);
    field6.setIsIdentity(false);
    table.addField(field6);

    FieldDefinition fieldOvertimeStart = new FieldDefinition();
    fieldOvertimeStart.setName("START_OVERTIME");
    fieldOvertimeStart.setTypeName("TIME");
    fieldOvertimeStart.setSize(23);
    fieldOvertimeStart.setShouldAllowNull(true);
    fieldOvertimeStart.setIsPrimaryKey(false);
    fieldOvertimeStart.setUnique(false);
    fieldOvertimeStart.setIsIdentity(false);
    table.addField(fieldOvertimeStart);

    FieldDefinition fieldOvertimeEnd = new FieldDefinition();
    fieldOvertimeEnd.setName("END_OVERTIME");
    fieldOvertimeEnd.setTypeName("TIME");
    fieldOvertimeEnd.setSize(23);
    fieldOvertimeEnd.setShouldAllowNull(true);
    fieldOvertimeEnd.setIsPrimaryKey(false);
    fieldOvertimeEnd.setUnique(false);
    fieldOvertimeEnd.setIsIdentity(false);
    table.addField(fieldOvertimeEnd);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field8 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field8.setName("ADDR_ID");
    field8.setTypeName("NUMERIC");
    field8.setSize(15);
    field8.setShouldAllowNull(true);
    field8.setIsPrimaryKey(false);
    field8.setUnique(false);
    field8.setIsIdentity(false);
    field8.setForeignKeyFieldName("CMP3_XML_ADDRESS.ADDRESS_ID");
    table.addField(field8);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field9 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field9.setName("MANAGER_EMP_ID");
    field9.setTypeName("NUMERIC");
    field9.setSize(15);
    field9.setShouldAllowNull(true);
    field9.setIsPrimaryKey(false);
    field9.setUnique(false);
    field9.setIsIdentity(false);
    field9.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field9);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field10 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field10.setName("VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    FieldDefinition fieldPayScale = new FieldDefinition();
    fieldPayScale.setName("PAY_SCALE");
    fieldPayScale.setTypeName("VARCHAR");
    fieldPayScale.setSize(40);
    fieldPayScale.setIsPrimaryKey(false);
    fieldPayScale.setUnique(false);
    fieldPayScale.setIsIdentity(false);
    fieldPayScale.setShouldAllowNull(true);
    table.addField(fieldPayScale);

    return table;
  }
コード例 #10
0
  public static TableDefinition buildDEALERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_DEALER");

    FieldDefinition field = new FieldDefinition();
    field.setName("DEALER_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(true);
    table.addField(field);

    FieldDefinition field0 = new FieldDefinition();
    field0.setName("FK_EMP_ID");
    field0.setTypeName("NUMERIC");
    field0.setSize(15);
    field0.setShouldAllowNull(true);
    field0.setIsPrimaryKey(false);
    field0.setUnique(false);
    field0.setIsIdentity(false);
    field0.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field0);

    FieldDefinition field1 = new FieldDefinition();
    field1.setName("F_NAME");
    field1.setTypeName("VARCHAR");
    field1.setSize(40);
    field1.setShouldAllowNull(true);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    FieldDefinition field2 = new FieldDefinition();
    field2.setName("L_NAME");
    field2.setTypeName("VARCHAR");
    field2.setSize(40);
    field2.setShouldAllowNull(true);
    field2.setIsPrimaryKey(false);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    table.addField(field2);

    FieldDefinition field3 = new FieldDefinition();
    field3.setName("STATUS");
    field3.setTypeName("VARCHAR");
    field3.setSize(40);
    field3.setShouldAllowNull(true);
    field3.setIsPrimaryKey(false);
    field3.setUnique(false);
    field3.setIsIdentity(false);
    table.addField(field3);

    FieldDefinition field4 = new FieldDefinition();
    field4.setName("VERSION");
    field4.setTypeName("NUMERIC");
    field4.setSize(15);
    field4.setShouldAllowNull(true);
    field4.setIsPrimaryKey(false);
    field4.setUnique(false);
    field4.setIsIdentity(false);
    table.addField(field4);

    return table;
  }
コード例 #11
0
  public static TableDefinition buildCREDITLINESTable() {
    TableDefinition table = new TableDefinition();
    table.setName("EMP_CREDITLINES");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("EMP_ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setShouldAllowNull(false);
    fieldID.setIsPrimaryKey(false);
    fieldID.setUnique(false);
    fieldID.setIsIdentity(false);
    fieldID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(fieldID);

    FieldDefinition fieldBANK = new FieldDefinition();
    fieldBANK.setName("BANK");
    fieldBANK.setTypeName("VARCHAR");
    fieldBANK.setSize(4);
    fieldBANK.setShouldAllowNull(false);
    fieldBANK.setIsPrimaryKey(false);
    fieldBANK.setUnique(true);
    fieldBANK.setIsIdentity(false);
    table.addField(fieldBANK);

    FieldDefinition fieldACCOUNT = new FieldDefinition();
    fieldACCOUNT.setName("ACCOUNT");
    fieldACCOUNT.setTypeName("VARCHAR");
    fieldACCOUNT.setSize(10);
    fieldACCOUNT.setShouldAllowNull(false);
    fieldACCOUNT.setIsPrimaryKey(false);
    fieldACCOUNT.setUnique(false);
    fieldACCOUNT.setIsIdentity(false);
    table.addField(fieldACCOUNT);

    return table;
  }
コード例 #12
0
  public static TableDefinition buildCREDITCARDSTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XMLEmployee_CREDITCARDS");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("EMP_ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setShouldAllowNull(false);
    fieldID.setIsPrimaryKey(false);
    fieldID.setUnique(false);
    fieldID.setIsIdentity(false);
    fieldID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(fieldID);

    FieldDefinition fieldCARD = new FieldDefinition();
    fieldCARD.setName("CARD");
    fieldCARD.setTypeName("VARCHAR");
    fieldCARD.setSize(2);
    fieldCARD.setShouldAllowNull(false);
    fieldCARD.setIsPrimaryKey(false);
    fieldCARD.setUnique(true);
    fieldCARD.setIsIdentity(false);
    table.addField(fieldCARD);

    FieldDefinition fieldNUMB = new FieldDefinition();
    fieldNUMB.setName("NUMB");
    fieldNUMB.setTypeName("VARCHAR");
    fieldNUMB.setSize(10);
    fieldNUMB.setShouldAllowNull(false);
    fieldNUMB.setIsPrimaryKey(false);
    fieldNUMB.setUnique(false);
    fieldNUMB.setIsIdentity(false);
    table.addField(fieldNUMB);

    return table;
  }
コード例 #13
0
  public static TableDefinition buildSALARYTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_SALARY");

    FieldDefinition fieldEMP_ID = new FieldDefinition();
    fieldEMP_ID.setName("E_ID");
    fieldEMP_ID.setTypeName("NUMERIC");
    fieldEMP_ID.setSize(15);
    fieldEMP_ID.setSubSize(0);
    fieldEMP_ID.setIsPrimaryKey(true);
    fieldEMP_ID.setIsIdentity(false);
    fieldEMP_ID.setUnique(false);
    fieldEMP_ID.setShouldAllowNull(false);
    fieldEMP_ID.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(fieldEMP_ID);

    FieldDefinition fieldSALARY = new FieldDefinition();
    fieldSALARY.setName("SALARY");
    fieldSALARY.setTypeName("NUMBER");
    fieldSALARY.setSize(15);
    fieldSALARY.setSubSize(0);
    fieldSALARY.setIsPrimaryKey(false);
    fieldSALARY.setIsIdentity(false);
    fieldSALARY.setUnique(false);
    fieldSALARY.setShouldAllowNull(true);
    table.addField(fieldSALARY);

    return table;
  }
コード例 #14
0
  public static TableDefinition buildPROJECTTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_XML_PROJECT");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("PROJ_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(true);
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("PROJ_TYPE");
    field1.setTypeName("VARCHAR");
    field1.setSize(1);
    field1.setShouldAllowNull(true);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field2.setName("PROJ_NAME");
    field2.setTypeName("VARCHAR");
    field2.setSize(30);
    field2.setShouldAllowNull(true);
    field2.setIsPrimaryKey(false);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    table.addField(field2);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field3.setName("DESCRIP");
    field3.setTypeName("VARCHAR");
    field3.setSize(200);
    field3.setShouldAllowNull(true);
    field3.setIsPrimaryKey(false);
    field3.setUnique(false);
    field3.setIsIdentity(false);
    table.addField(field3);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field4 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field4.setName("LEADER_ID");
    field4.setTypeName("NUMERIC");
    field4.setSize(15);
    field4.setShouldAllowNull(true);
    field4.setIsPrimaryKey(false);
    field4.setUnique(false);
    field4.setIsIdentity(false);
    field4.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field4);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field5 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field5.setName("VERSION");
    field5.setTypeName("NUMERIC");
    field5.setSize(15);
    field5.setShouldAllowNull(true);
    field5.setIsPrimaryKey(false);
    field5.setUnique(false);
    field5.setIsIdentity(false);
    table.addField(field5);

    return table;
  }
コード例 #15
0
  public static TableDefinition buildPHONENUMBERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_PHONENUMBER");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("OWNER_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("TYPE");
    field1.setTypeName("VARCHAR");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field2.setName("AREA_CODE");
    field2.setTypeName("VARCHAR");
    field2.setSize(3);
    field2.setShouldAllowNull(true);
    field2.setIsPrimaryKey(false);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    table.addField(field2);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field3.setName("NUMB");
    field3.setTypeName("VARCHAR");
    field3.setSize(8);
    field3.setShouldAllowNull(true);
    field3.setIsPrimaryKey(false);
    field3.setUnique(false);
    field3.setIsIdentity(false);
    table.addField(field3);

    return table;
  }
コード例 #16
0
  public static TableDefinition buildADDRESSTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_ADDRESS");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ADDRESS_ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);

    FieldDefinition fieldSTREET = new FieldDefinition();
    fieldSTREET.setName("STREET");
    fieldSTREET.setTypeName("VARCHAR2");
    fieldSTREET.setSize(60);
    fieldSTREET.setSubSize(0);
    fieldSTREET.setIsPrimaryKey(false);
    fieldSTREET.setIsIdentity(false);
    fieldSTREET.setUnique(false);
    fieldSTREET.setShouldAllowNull(true);
    table.addField(fieldSTREET);

    FieldDefinition fieldCITY = new FieldDefinition();
    fieldCITY.setName("CITY");
    fieldCITY.setTypeName("VARCHAR2");
    fieldCITY.setSize(60);
    fieldCITY.setSubSize(0);
    fieldCITY.setIsPrimaryKey(false);
    fieldCITY.setIsIdentity(false);
    fieldCITY.setUnique(false);
    fieldCITY.setShouldAllowNull(true);
    table.addField(fieldCITY);

    FieldDefinition fieldPROVINCE = new FieldDefinition();
    fieldPROVINCE.setName("PROVINCE");
    fieldPROVINCE.setTypeName("VARCHAR2");
    fieldPROVINCE.setSize(60);
    fieldPROVINCE.setSubSize(0);
    fieldPROVINCE.setIsPrimaryKey(false);
    fieldPROVINCE.setIsIdentity(false);
    fieldPROVINCE.setUnique(false);
    fieldPROVINCE.setShouldAllowNull(true);
    table.addField(fieldPROVINCE);

    FieldDefinition fieldPOSTALCODE = new FieldDefinition();
    fieldPOSTALCODE.setName("P_CODE");
    fieldPOSTALCODE.setTypeName("VARCHAR2");
    fieldPOSTALCODE.setSize(67);
    fieldPOSTALCODE.setSubSize(0);
    fieldPOSTALCODE.setIsPrimaryKey(false);
    fieldPOSTALCODE.setIsIdentity(false);
    fieldPOSTALCODE.setUnique(false);
    fieldPOSTALCODE.setShouldAllowNull(true);
    table.addField(fieldPOSTALCODE);

    FieldDefinition fieldCOUNTRY = new FieldDefinition();
    fieldCOUNTRY.setName("COUNTRY");
    fieldCOUNTRY.setTypeName("VARCHAR2");
    fieldCOUNTRY.setSize(60);
    fieldCOUNTRY.setSubSize(0);
    fieldCOUNTRY.setIsPrimaryKey(false);
    fieldCOUNTRY.setIsIdentity(false);
    fieldCOUNTRY.setUnique(false);
    fieldCOUNTRY.setShouldAllowNull(true);
    table.addField(fieldCOUNTRY);

    FieldDefinition fieldType = new FieldDefinition();
    fieldType.setName("TYPE");
    fieldType.setTypeName("VARCHAR2");
    fieldType.setSize(150);
    fieldType.setSubSize(0);
    fieldType.setIsPrimaryKey(false);
    fieldType.setIsIdentity(false);
    fieldType.setUnique(false);
    fieldType.setShouldAllowNull(true);
    table.addField(fieldType);

    return table;
  }
コード例 #17
0
  public TableDefinition buildVHCL_CLMTable() {
    TableDefinition table = new TableDefinition();
    table.setName("VHCL_CLM");

    FieldDefinition fieldCLM_ID = new FieldDefinition();
    fieldCLM_ID.setName("CLM_ID");
    fieldCLM_ID.setTypeName("NUMBER");
    fieldCLM_ID.setSize(18);
    fieldCLM_ID.setSubSize(0);
    fieldCLM_ID.setIsPrimaryKey(true);
    fieldCLM_ID.setIsIdentity(false);
    fieldCLM_ID.setUnique(false);
    fieldCLM_ID.setShouldAllowNull(false);
    table.addField(fieldCLM_ID);

    FieldDefinition fieldPART = new FieldDefinition();
    fieldPART.setName("PART");
    fieldPART.setTypeName("VARCHAR2");
    fieldPART.setSize(30);
    fieldPART.setSubSize(0);
    fieldPART.setIsPrimaryKey(false);
    fieldPART.setIsIdentity(false);
    fieldPART.setUnique(false);
    fieldPART.setShouldAllowNull(true);
    table.addField(fieldPART);

    FieldDefinition fieldPART_DESC = new FieldDefinition();
    fieldPART_DESC.setName("PART_DESC");
    fieldPART_DESC.setTypeName("VARCHAR2");
    fieldPART_DESC.setSize(30);
    fieldPART_DESC.setSubSize(0);
    fieldPART_DESC.setIsPrimaryKey(false);
    fieldPART_DESC.setIsIdentity(false);
    fieldPART_DESC.setUnique(false);
    fieldPART_DESC.setShouldAllowNull(true);
    table.addField(fieldPART_DESC);

    ForeignKeyConstraint foreignKeyFK_VHCL_CLM_CLM_ID = new ForeignKeyConstraint();
    foreignKeyFK_VHCL_CLM_CLM_ID.setName("VHCL_CLM_CLAIM");
    foreignKeyFK_VHCL_CLM_CLM_ID.setTargetTable("CLAIM");
    foreignKeyFK_VHCL_CLM_CLM_ID.addSourceField("CLM_ID");
    foreignKeyFK_VHCL_CLM_CLM_ID.addTargetField("CLM_ID");
    table.addForeignKeyConstraint(foreignKeyFK_VHCL_CLM_CLM_ID);

    return table;
  }
コード例 #18
0
  public TableDefinition buildVHCL_POLTable() {
    TableDefinition table = new TableDefinition();
    table.setName("VHCL_POL");

    FieldDefinition fieldPOL_ID = new FieldDefinition();
    fieldPOL_ID.setName("POL_ID");
    fieldPOL_ID.setTypeName("NUMBER");
    fieldPOL_ID.setSize(18);
    fieldPOL_ID.setSubSize(0);
    fieldPOL_ID.setIsPrimaryKey(true);
    fieldPOL_ID.setIsIdentity(false);
    fieldPOL_ID.setUnique(false);
    fieldPOL_ID.setShouldAllowNull(false);
    table.addField(fieldPOL_ID);

    FieldDefinition fieldMODEL = new FieldDefinition();
    fieldMODEL.setName("MODEL");
    fieldMODEL.setTypeName("VARCHAR2");
    fieldMODEL.setSize(30);
    fieldMODEL.setSubSize(0);
    fieldMODEL.setIsPrimaryKey(false);
    fieldMODEL.setIsIdentity(false);
    fieldMODEL.setUnique(false);
    fieldMODEL.setShouldAllowNull(true);
    table.addField(fieldMODEL);

    ForeignKeyConstraint foreignKeyFK_VHCL_POL_POL_ID = new ForeignKeyConstraint();
    foreignKeyFK_VHCL_POL_POL_ID.setName("VHCL_POL_POLICY");
    foreignKeyFK_VHCL_POL_POL_ID.setTargetTable("POLICY");
    foreignKeyFK_VHCL_POL_POL_ID.addSourceField("POL_ID");
    foreignKeyFK_VHCL_POL_POL_ID.addTargetField("POL_ID");
    table.addForeignKeyConstraint(foreignKeyFK_VHCL_POL_POL_ID);

    return table;
  }
コード例 #19
0
ファイル: Actor.java プロジェクト: pmneo/eclipselink.runtime
  public static org.eclipse.persistence.tools.schemaframework.TableDefinition actorTable() {
    org.eclipse.persistence.tools.schemaframework.TableDefinition tabledefinition =
        new org.eclipse.persistence.tools.schemaframework.TableDefinition();

    // SECTION: TABLE
    tabledefinition.setName("ACTOR");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("FNAME");
    field.setType(String.class);
    field.setShouldAllowNull(true);
    field.setIsPrimaryKey(false);
    field.setUnique(false);
    field.setIsIdentity(false);
    tabledefinition.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("LNAME");
    field1.setType(String.class);
    field1.setShouldAllowNull(true);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    tabledefinition.addField(field1);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field2 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field2.setName("ID");
    field2.setType(java.math.BigDecimal.class);
    field2.setShouldAllowNull(false);
    field2.setIsPrimaryKey(true);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    tabledefinition.addField(field2);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field3 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field3.setName("PROGRAM_ID");
    field3.setType(java.math.BigDecimal.class);
    field3.setShouldAllowNull(false);
    field3.setIsPrimaryKey(true);
    field3.setUnique(false);
    field3.setIsIdentity(false);
    tabledefinition.addField(field3);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field4 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field4.setName("PROGRAM_TYPE");
    field4.setType(String.class);
    field4.setShouldAllowNull(false);
    field4.setIsPrimaryKey(true);
    field4.setUnique(false);
    field4.setIsIdentity(false);
    tabledefinition.addField(field4);
    return tabledefinition;
  }
コード例 #20
0
  public TableDefinition buildCLAIMTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CLAIM");

    FieldDefinition fieldCLM_ID = new FieldDefinition();
    fieldCLM_ID.setName("CLM_ID");
    fieldCLM_ID.setTypeName("NUMBER");
    fieldCLM_ID.setSize(18);
    fieldCLM_ID.setSubSize(0);
    fieldCLM_ID.setIsPrimaryKey(true);
    fieldCLM_ID.setIsIdentity(false);
    fieldCLM_ID.setUnique(false);
    fieldCLM_ID.setShouldAllowNull(false);
    table.addField(fieldCLM_ID);

    FieldDefinition fieldPOL_ID = new FieldDefinition();
    fieldPOL_ID.setName("POL_ID");
    fieldPOL_ID.setTypeName("NUMBER");
    fieldPOL_ID.setSize(18);
    fieldPOL_ID.setSubSize(0);
    fieldPOL_ID.setIsPrimaryKey(false);
    fieldPOL_ID.setIsIdentity(false);
    fieldPOL_ID.setUnique(false);
    fieldPOL_ID.setShouldAllowNull(true);
    table.addField(fieldPOL_ID);

    FieldDefinition fieldCLM_TYPE = new FieldDefinition();
    fieldCLM_TYPE.setName("CLM_TYPE");
    fieldCLM_TYPE.setTypeName("VARCHAR2");
    fieldCLM_TYPE.setSize(20);
    fieldCLM_TYPE.setSubSize(0);
    fieldCLM_TYPE.setIsPrimaryKey(false);
    fieldCLM_TYPE.setIsIdentity(false);
    fieldCLM_TYPE.setUnique(false);
    fieldCLM_TYPE.setShouldAllowNull(true);
    table.addField(fieldCLM_TYPE);

    FieldDefinition fieldAMOUNT = new FieldDefinition();
    fieldAMOUNT.setName("AMOUNT");
    fieldAMOUNT.setTypeName("FLOAT");
    fieldAMOUNT.setSize(18);
    fieldAMOUNT.setSubSize(4);
    fieldAMOUNT.setIsPrimaryKey(false);
    fieldAMOUNT.setIsIdentity(false);
    fieldAMOUNT.setUnique(false);
    fieldAMOUNT.setShouldAllowNull(true);
    table.addField(fieldAMOUNT);

    FieldDefinition fieldDISEASE = new FieldDefinition();
    fieldDISEASE.setName("DISEASE");
    fieldDISEASE.setTypeName("VARCHAR2");
    fieldDISEASE.setSize(50);
    fieldDISEASE.setSubSize(0);
    fieldDISEASE.setIsPrimaryKey(false);
    fieldDISEASE.setIsIdentity(false);
    fieldDISEASE.setUnique(false);
    fieldDISEASE.setShouldAllowNull(true);
    table.addField(fieldDISEASE);

    FieldDefinition fieldAREA = new FieldDefinition();
    fieldAREA.setName("AREA");
    fieldAREA.setTypeName("NUMBER");
    fieldAREA.setSize(18);
    fieldAREA.setSubSize(4);
    fieldAREA.setIsPrimaryKey(false);
    fieldAREA.setIsIdentity(false);
    fieldAREA.setUnique(false);
    fieldAREA.setShouldAllowNull(true);
    table.addField(fieldAREA);

    ForeignKeyConstraint foreignKeyFK_CLAIM_POL_ID = new ForeignKeyConstraint();
    foreignKeyFK_CLAIM_POL_ID.setName("CLAIM_POL");
    foreignKeyFK_CLAIM_POL_ID.setTargetTable("POLICY");
    foreignKeyFK_CLAIM_POL_ID.addSourceField("POL_ID");
    foreignKeyFK_CLAIM_POL_ID.addTargetField("POL_ID");
    table.addForeignKeyConstraint(foreignKeyFK_CLAIM_POL_ID);

    return table;
  }
コード例 #21
0
  public static TableDefinition buildEMPLOYEE_SEQTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_EMPLOYEE_SEQ");

    FieldDefinition fieldSEQ_COUNT = new FieldDefinition();
    fieldSEQ_COUNT.setName("SEQ_COUNT");
    fieldSEQ_COUNT.setTypeName("NUMBER");
    fieldSEQ_COUNT.setSize(15);
    fieldSEQ_COUNT.setSubSize(0);
    fieldSEQ_COUNT.setIsPrimaryKey(false);
    fieldSEQ_COUNT.setIsIdentity(false);
    fieldSEQ_COUNT.setUnique(false);
    fieldSEQ_COUNT.setShouldAllowNull(false);
    table.addField(fieldSEQ_COUNT);

    FieldDefinition fieldSEQ_NAME = new FieldDefinition();
    fieldSEQ_NAME.setName("SEQ_NAME");
    fieldSEQ_NAME.setTypeName("VARCHAR2");
    fieldSEQ_NAME.setSize(80);
    fieldSEQ_NAME.setSubSize(0);
    fieldSEQ_NAME.setIsPrimaryKey(true);
    fieldSEQ_NAME.setIsIdentity(false);
    fieldSEQ_NAME.setUnique(false);
    fieldSEQ_NAME.setShouldAllowNull(false);
    table.addField(fieldSEQ_NAME);

    return table;
  }
コード例 #22
0
  public static TableDefinition buildCMP3_ORDERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_MERGE_ORDER");

    FieldDefinition fieldCUST_ID = new FieldDefinition();
    fieldCUST_ID.setName("CUSTOMER_CUST_ID");
    fieldCUST_ID.setTypeName("NUMBER");
    fieldCUST_ID.setSize(15);
    fieldCUST_ID.setSubSize(0);
    fieldCUST_ID.setIsPrimaryKey(false);
    fieldCUST_ID.setIsIdentity(false);
    fieldCUST_ID.setUnique(false);
    fieldCUST_ID.setShouldAllowNull(true);
    table.addField(fieldCUST_ID);

    FieldDefinition fieldITEM_ID = new FieldDefinition();
    fieldITEM_ID.setName("ITEM_ID");
    fieldITEM_ID.setTypeName("NUMBER");
    fieldITEM_ID.setSize(15);
    fieldITEM_ID.setSubSize(0);
    fieldITEM_ID.setIsPrimaryKey(false);
    fieldITEM_ID.setIsIdentity(false);
    fieldITEM_ID.setUnique(false);
    fieldITEM_ID.setShouldAllowNull(true);
    fieldITEM_ID.setForeignKeyFieldName("CMP3_XML_MERGE_ITEM.ID");
    table.addField(fieldITEM_ID);

    FieldDefinition fieldORDER_ID = new FieldDefinition();
    fieldORDER_ID.setName("ORDER_ID");
    fieldORDER_ID.setTypeName("NUMBER");
    fieldORDER_ID.setSize(15);
    fieldORDER_ID.setSubSize(0);
    fieldORDER_ID.setIsPrimaryKey(true);
    fieldORDER_ID.setIsIdentity(false);
    fieldORDER_ID.setUnique(false);
    fieldORDER_ID.setShouldAllowNull(false);
    table.addField(fieldORDER_ID);

    FieldDefinition fieldQUANTITY = new FieldDefinition();
    fieldQUANTITY.setName("QUANTITY");
    fieldQUANTITY.setTypeName("NUMBER");
    fieldQUANTITY.setSize(15);
    fieldQUANTITY.setSubSize(0);
    fieldQUANTITY.setIsPrimaryKey(false);
    fieldQUANTITY.setIsIdentity(false);
    fieldQUANTITY.setUnique(false);
    fieldQUANTITY.setShouldAllowNull(false);
    table.addField(fieldQUANTITY);

    FieldDefinition fieldSHIP_ADDR = new FieldDefinition();
    fieldSHIP_ADDR.setName("SHIP_ADDR");
    fieldSHIP_ADDR.setTypeName("VARCHAR2");
    fieldSHIP_ADDR.setSize(80);
    fieldSHIP_ADDR.setSubSize(0);
    fieldSHIP_ADDR.setIsPrimaryKey(false);
    fieldSHIP_ADDR.setIsIdentity(false);
    fieldSHIP_ADDR.setUnique(false);
    fieldSHIP_ADDR.setShouldAllowNull(true);
    table.addField(fieldSHIP_ADDR);

    FieldDefinition field10 = new FieldDefinition();
    field10.setName("ORDER_VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    return table;
  }
コード例 #23
0
  public static TableDefinition buildPARTNERLINKTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_MW");

    FieldDefinition fieldMID = new FieldDefinition();
    fieldMID.setName("M");
    fieldMID.setTypeName("NUMERIC");
    fieldMID.setSize(15);
    fieldMID.setSubSize(0);
    fieldMID.setIsPrimaryKey(false);
    fieldMID.setIsIdentity(false);
    fieldMID.setUnique(false);
    fieldMID.setShouldAllowNull(true);
    fieldMID.setForeignKeyFieldName("XML_MAN.ID");
    table.addField(fieldMID);

    FieldDefinition fieldWID = new FieldDefinition();
    fieldWID.setName("W");
    fieldWID.setTypeName("NUMERIC");
    fieldWID.setSize(15);
    fieldWID.setSubSize(0);
    fieldWID.setIsPrimaryKey(false);
    fieldWID.setIsIdentity(false);
    fieldWID.setUnique(false);
    fieldWID.setShouldAllowNull(true);
    fieldWID.setForeignKeyFieldName("XML_WOMAN.ID");
    table.addField(fieldWID);

    return table;
  }
コード例 #24
0
  public static TableDefinition buildCMP3_PARTSLISTTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_MERGE_PARTSLIST");

    FieldDefinition fieldPARTSLIST_ID = new FieldDefinition();
    fieldPARTSLIST_ID.setName("ID");
    fieldPARTSLIST_ID.setTypeName("NUMBER");
    fieldPARTSLIST_ID.setSize(15);
    fieldPARTSLIST_ID.setSubSize(0);
    fieldPARTSLIST_ID.setIsPrimaryKey(true);
    fieldPARTSLIST_ID.setIsIdentity(false);
    fieldPARTSLIST_ID.setUnique(false);
    fieldPARTSLIST_ID.setShouldAllowNull(false);
    table.addField(fieldPARTSLIST_ID);

    FieldDefinition field10 = new FieldDefinition();
    field10.setName("VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    return table;
  }
コード例 #25
0
  public static TableDefinition buildPROJECT_EMPTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_XML_PROJ_EMP");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("PROJ_ID");
    field1.setTypeName("NUMERIC");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    field1.setForeignKeyFieldName("CMP3_XML_PROJECT.PROJ_ID");
    table.addField(field1);

    return table;
  }
コード例 #26
0
  public static TableDefinition buildCMP3_PARTSLIST_ITEMTable() {
    TableDefinition table = new TableDefinition();

    table.setName("CMP3_XML_MERGE_PARTSLIST_ITEM");

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field.setName("PARTSLIST_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(true);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_MERGE_ITEM.ID");
    table.addField(field);

    // SECTION: FIELD
    org.eclipse.persistence.tools.schemaframework.FieldDefinition field1 =
        new org.eclipse.persistence.tools.schemaframework.FieldDefinition();
    field1.setName("ITEM_ID");
    field1.setTypeName("NUMERIC");
    field1.setSize(15);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(true);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    field1.setForeignKeyFieldName("CMP3_XML_MERGE_PARTSLIST.ID");
    table.addField(field1);

    return table;
  }
コード例 #27
0
  public static TableDefinition buildRESPONSTable() {
    TableDefinition table = new TableDefinition();
    // SECTION: TABLE
    table.setName("CMP3_XML_RESPONS");

    // SECTION: FIELD
    FieldDefinition field = new FieldDefinition();
    field.setName("EMP_ID");
    field.setTypeName("NUMERIC");
    field.setSize(15);
    field.setShouldAllowNull(false);
    field.setIsPrimaryKey(false);
    field.setUnique(false);
    field.setIsIdentity(false);
    field.setForeignKeyFieldName("CMP3_XML_EMPLOYEE.EMP_ID");
    table.addField(field);

    // SECTION: FIELD
    FieldDefinition field1 = new FieldDefinition();
    field1.setName("DESCRIPTION");
    field1.setTypeName("VARCHAR");
    field1.setSize(200);
    field1.setShouldAllowNull(false);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    return table;
  }
コード例 #28
0
  public static TableDefinition buildCMP3_CUSTOMERTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_MERGE_CUSTOMER");

    FieldDefinition fieldCITY = new FieldDefinition();
    fieldCITY.setName("CITY");
    fieldCITY.setTypeName("VARCHAR2");
    fieldCITY.setSize(80);
    fieldCITY.setSubSize(0);
    fieldCITY.setIsPrimaryKey(false);
    fieldCITY.setIsIdentity(false);
    fieldCITY.setUnique(false);
    fieldCITY.setShouldAllowNull(true);
    table.addField(fieldCITY);

    FieldDefinition fieldCUST_ID = new FieldDefinition();
    fieldCUST_ID.setName("CUST_ID");
    fieldCUST_ID.setTypeName("NUMBER");
    fieldCUST_ID.setSize(15);
    fieldCUST_ID.setSubSize(0);
    fieldCUST_ID.setIsPrimaryKey(true);
    fieldCUST_ID.setIsIdentity(false);
    fieldCUST_ID.setUnique(false);
    fieldCUST_ID.setShouldAllowNull(false);
    table.addField(fieldCUST_ID);

    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR2");
    fieldNAME.setSize(80);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);

    FieldDefinition field10 = new FieldDefinition();
    field10.setName("CUST_VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    return table;
  }
コード例 #29
0
  public static TableDefinition buildWOMANTable() {
    TableDefinition table = new TableDefinition();
    table.setName("XML_WOMAN");

    FieldDefinition fieldID = new FieldDefinition();
    fieldID.setName("ID");
    fieldID.setTypeName("NUMERIC");
    fieldID.setSize(15);
    fieldID.setSubSize(0);
    fieldID.setIsPrimaryKey(true);
    fieldID.setIsIdentity(true);
    fieldID.setUnique(false);
    fieldID.setShouldAllowNull(false);
    table.addField(fieldID);

    FieldDefinition field1 = new FieldDefinition();
    field1.setName("F_NAME");
    field1.setTypeName("VARCHAR");
    field1.setSize(40);
    field1.setShouldAllowNull(true);
    field1.setIsPrimaryKey(false);
    field1.setUnique(false);
    field1.setIsIdentity(false);
    table.addField(field1);

    FieldDefinition field2 = new FieldDefinition();
    field2.setName("L_NAME");
    field2.setTypeName("VARCHAR");
    field2.setSize(40);
    field2.setShouldAllowNull(true);
    field2.setIsPrimaryKey(false);
    field2.setUnique(false);
    field2.setIsIdentity(false);
    table.addField(field2);

    return table;
  }
コード例 #30
0
  public static TableDefinition buildCMP3_ITEMTable() {
    TableDefinition table = new TableDefinition();
    table.setName("CMP3_XML_MERGE_ITEM");

    FieldDefinition fieldDESCRIPTION = new FieldDefinition();
    fieldDESCRIPTION.setName("DESCRIPTION");
    fieldDESCRIPTION.setTypeName("VARCHAR2");
    fieldDESCRIPTION.setSize(80);
    fieldDESCRIPTION.setSubSize(0);
    fieldDESCRIPTION.setIsPrimaryKey(false);
    fieldDESCRIPTION.setIsIdentity(false);
    fieldDESCRIPTION.setUnique(false);
    fieldDESCRIPTION.setShouldAllowNull(true);
    table.addField(fieldDESCRIPTION);

    FieldDefinition fieldITEM_ID = new FieldDefinition();
    fieldITEM_ID.setName("ID");
    fieldITEM_ID.setTypeName("NUMBER");
    fieldITEM_ID.setSize(15);
    fieldITEM_ID.setSubSize(0);
    fieldITEM_ID.setIsPrimaryKey(true);
    fieldITEM_ID.setIsIdentity(false);
    fieldITEM_ID.setUnique(false);
    fieldITEM_ID.setShouldAllowNull(false);
    table.addField(fieldITEM_ID);

    FieldDefinition fieldNAME = new FieldDefinition();
    fieldNAME.setName("NAME");
    fieldNAME.setTypeName("VARCHAR2");
    fieldNAME.setSize(80);
    fieldNAME.setSubSize(0);
    fieldNAME.setIsPrimaryKey(false);
    fieldNAME.setIsIdentity(false);
    fieldNAME.setUnique(false);
    fieldNAME.setShouldAllowNull(true);
    table.addField(fieldNAME);

    FieldDefinition field10 = new FieldDefinition();
    field10.setName("ITEM_VERSION");
    field10.setTypeName("NUMERIC");
    field10.setSize(15);
    field10.setShouldAllowNull(true);
    field10.setIsPrimaryKey(false);
    field10.setUnique(false);
    field10.setIsIdentity(false);
    table.addField(field10);

    FieldDefinition fieldIMAGE = new FieldDefinition();
    fieldIMAGE.setName("IMAGE");
    fieldIMAGE.setTypeName("BLOB");
    fieldIMAGE.setShouldAllowNull(true);
    table.addField(fieldIMAGE);

    return table;
  }