Examples of SQLData

java.sql.SQLData
An interface for the custom mapping of an SQL User Defined Type (UDT) to a Java Class. The Java Class object will be added to the Connection's type map with the SQL Name of the UDT which it maps.
Usually within an implementation of SQLData, there is a corresponding field for every attribute of an SQL type, or only one field if the type is SQL DISTINCT. When the UDT is returned within a ResultSet, it is accessed with the ResultSet.getObject method and is returned as an Object which is an instance of the class defined by the SQLData mapping. The application can use this object just like any other Java object and can store changes back into the database using the PreparedStatement.setObject method which performs the reverse mapping into the SQL UDT.
It is standard for an implementation for a custom mapping to be generated by a tool. The tool usually requires the name of the SQL UDT, the name of the class which it is going to be mapped to, and the field names to which the UDT attributes will be mapped. The tool can then implement the SQLData readSQL and writeSQL methods. readSQL reads attributes from an SQLInput object, and writeSQL writes them. This is done via SQLInput and SQLOutput method calls respectively
Ordinarily a programmer would not call SQLData methods directly. Similarly SQLInput and SQLOutput methods are not usually called directly.
model.SQLData

Examples of java.sql.SQLData

            Struct structuredType = (Struct)o;
            String typeName = structuredType.getSQLTypeName();
            Class<?> c = map.get(typeName);
            if(c != null) {
                try {
                    SQLData data = (SQLData)c.newInstance();
                    SQLInputImpl input = new SQLInputImpl(structuredType.getAttributes(), map);
                    data.readSQL(input, typeName);
                    return data;
                } catch (IllegalAccessException e) {
                    throw new SQLException(e.getMessage());
                } catch (InstantiationException e) {
                    throw new SQLException(e.getMessage());

View Full Code Here

Examples of model.SQLData

import model.JPAResourceClassModel;
import model.SQLData;


public class GridFTPEndpointsGenerator {
  private static SQLData createSQLData() {
    SQLData data = new SQLData();
    data.setTableName("GRIDFTP_ENDPOINT");
    data.getFieldData().put("DATA_MOVEMENT_INTERFACE_ID", Arrays.asList(new String[]{"VARCHAR", "(255)", "NOT", "NULL"}));
    data.getFieldData().put("ENDPOINT", Arrays.asList(new String[]{"VARCHAR", "(255)", "NOT", "NULL"}));
    data.getPrimaryKeys().add("DATA_MOVEMENT_INTERFACE_ID");
    data.getPrimaryKeys().add("ENDPOINT");
    data.getForiegnKeys().put("DATA_MOVEMENT_INTERFACE_ID", new SQLData.ForiegnKeyData("GRIDFTP_DATA_MOVEMENT(DATA_MOVEMENT_INTERFACE_ID)","GridftpDataMovement","GridftpDataMovementResource"));
    return data;
  }

View Full Code Here

Examples of model.SQLData

    data.getPrimaryKeys().add("ENDPOINT");
    data.getForiegnKeys().put("DATA_MOVEMENT_INTERFACE_ID", new SQLData.ForiegnKeyData("GRIDFTP_DATA_MOVEMENT(DATA_MOVEMENT_INTERFACE_ID)","GridftpDataMovement","GridftpDataMovementResource"));
    return data;
  }
  public static void testSqlGen() {
    SQLData data = createSQLData();
    SQLGenerator sqlGenerator = new SQLGenerator();
    System.out.println(sqlGenerator.generateSQLCreateQuery(data));
  }

View Full Code Here

Examples of model.SQLData

    SQLGenerator sqlGenerator = new SQLGenerator();
    System.out.println(sqlGenerator.generateSQLCreateQuery(data));
  }
  
  public static void testJPAClassGen() {
    SQLData data = createSQLData();
    JPAClassGenerator jpaClassGenerator = new JPAClassGenerator();
    jpaClassGenerator.setJpaClassPackageName("org.apache.aiaravata.application.catalog.data.model");
    JPAClassModel model = jpaClassGenerator.createJPAClassModel(data);
    System.out.println(jpaClassGenerator.generateJPAClass(model));
    System.out.println(jpaClassGenerator.generateJPAPKClass(model.pkClassModel));

View Full Code Here

Examples of model.SQLData

    System.out.println(jpaClassGenerator.generateJPAPKClass(model.pkClassModel));
    System.out.println(jpaClassGenerator.generatePersistenceXmlEntry(model));
  }
  
  public static void testJPAResourceClassGen() {
    SQLData data = createSQLData();
    JPAClassGenerator jpaClassGenerator = new JPAClassGenerator();
    JPAClassModel model = jpaClassGenerator.createJPAClassModel(data);
    JPAResourceClassGenerator jpaResourceClassGenerator = new JPAResourceClassGenerator();
    jpaResourceClassGenerator.setExceptionClassName("AppCatalogException");
    jpaResourceClassGenerator.setJpaUtilsClassName("AppCatalogJPAUtils");

View Full Code Here

Examples of model.SQLData

import model.JPAResourceClassModel;
import model.SQLData;


public class ComputeResourceDescriptionGenerator {
  private static SQLData createSQLData() {
    SQLData data = new SQLData();
    data.setTableName("COMPUTE_RESOURCE");
    data.getFieldData().put("RESOURCE_ID", Arrays.asList(new String[]{"VARCHAR", "(255)", "NOT", "NULL"}));
    data.getFieldData().put("HOST_NAME", Arrays.asList(new String[]{"VARCHAR", "(255)", "NOT", "NULL"}));
    data.getFieldData().put("RESOURCE_DESCRIPTION", Arrays.asList(new String[]{"VARCHAR", "(255)"}));
    data.getPrimaryKeys().add("RESOURCE_ID");
    return data;
  }

View Full Code Here

Examples of model.SQLData

    data.getFieldData().put("RESOURCE_DESCRIPTION", Arrays.asList(new String[]{"VARCHAR", "(255)"}));
    data.getPrimaryKeys().add("RESOURCE_ID");
    return data;
  }
  public static void testSqlGen() {
    SQLData data = createSQLData();
    SQLGenerator sqlGenerator = new SQLGenerator();
    System.out.println(sqlGenerator.generateSQLCreateQuery(data));
  }

View Full Code Here

Examples of model.SQLData

    SQLGenerator sqlGenerator = new SQLGenerator();
    System.out.println(sqlGenerator.generateSQLCreateQuery(data));
  }
  
  public static void testJPAClassGen() {
    SQLData data = createSQLData();
    JPAClassGenerator jpaClassGenerator = new JPAClassGenerator();
    jpaClassGenerator.setJpaClassPackageName("org.apache.aiaravata.application.catalog.data.model");
    JPAClassModel model = jpaClassGenerator.createJPAClassModel(data);
    System.out.println(jpaClassGenerator.generateJPAClass(model));
    System.out.println(jpaClassGenerator.generateJPAPKClass(model.pkClassModel));

View Full Code Here

Examples of model.SQLData

    System.out.println(jpaClassGenerator.generateJPAPKClass(model.pkClassModel));
    System.out.println(jpaClassGenerator.generatePersistenceXmlEntry(model));
  }
  
  public static void testJPAResourceClassGen() {
    SQLData data = createSQLData();
    JPAClassGenerator jpaClassGenerator = new JPAClassGenerator();
    JPAClassModel model = jpaClassGenerator.createJPAClassModel(data);
    JPAResourceClassGenerator jpaResourceClassGenerator = new JPAResourceClassGenerator();
    jpaResourceClassGenerator.setExceptionClassName("AppCatalogException");
    jpaResourceClassGenerator.setJpaUtilsClassName("AppCatalogJPAUtils");

View Full Code Here

Examples of model.SQLData

import model.JPAResourceClassModel;
import model.SQLData;


public class LocalDataMovementGenerator {
  private static SQLData createSQLData() {
    SQLData data = new SQLData();
    data.setTableName("LOCAL_DATA_MOVEMENT");
    data.getFieldData().put("DATA_MOVEMENT_INTERFACE_ID", Arrays.asList(new String[]{"VARCHAR", "(255)", "NOT", "NULL"}));
    data.getPrimaryKeys().add("DATA_MOVEMENT_INTERFACE_ID");
    return data;
  }

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.