Package org.jboss.ejb.plugins.cmp.jdbc.metadata

Examples of org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCTypeMappingMetaData


      if(entity.getMetaData().hasRowLocking())
      {
         JDBCEntityPersistenceStore manager = entity.getManager();
         JDBCTypeFactory typeFactory = manager.getJDBCTypeFactory();
         JDBCTypeMappingMetaData typeMapping = typeFactory.getTypeMapping();
         JDBCFunctionMappingMetaData rowLockingTemplate = typeMapping.getRowLockingTemplate();
         if(rowLockingTemplate == null)
         {
            throw new DeploymentException("Row locking template is not defined for mapping: " + typeMapping.getName());
         }

         selectSql = rowLockingTemplate.getFunctionSql(new Object[]{selectColumns, tableName, whereColumns, null},
            new StringBuffer()).toString();
      }
View Full Code Here


   {
      Connection con = null;
      Statement st = null;
      try
      {       
         JDBCTypeMappingMetaData typeMapping = (JDBCTypeMappingMetaData)server.getAttribute(metaDataName, "TypeMappingMetaData");
         if (typeMapping == null)
            throw new IllegalStateException("Cannot obtain type mapping from: " + metaDataName);

         JDBCMappingMetaData objectMetaData = typeMapping.getTypeMappingMetaData(Object.class);
         binarySqlType = objectMetaData.getJdbcType();
        
         if (!SQLUtil.tableExists(getTableName(), ds))
         {
            con = ds.getConnection();

            String dateType = typeMapping.getTypeMappingMetaData(Timestamp.class).getSqlType();
            String longType = typeMapping.getTypeMappingMetaData(Long.class).getSqlType();
            String objectType = objectMetaData.getSqlType();

            // The create table DDL
            StringBuffer createTableDDL = new StringBuffer("create table " + getTableName() + " (" +
                    " " + getColumnTimerID() + " varchar(80) not null," +
                    " " + getColumnTargetID() + " varchar(250) not null," +
                    " " + getColumnInitialDate() + " " + dateType + " not null," +
                    " " + getColumnTimerInterval() + " " + longType + "," +
                    " " + getColumnInstancePK() + " " + objectType + "," +
                    " " + getColumnInfo() + " " + objectType + ", ");

            // Add the primary key constraint using the pk-constraint-template
            JDBCFunctionMappingMetaData pkConstraint = typeMapping.getPkConstraintTemplate();
            String name = SQLUtil.unquote(getTableName(), ds) + "_PK";
            name = SQLUtil.fixConstraintName(name, ds);
            String[] templateParams = new String[] {
                  name,
                  getColumnTimerID() + ", " + getColumnTargetID()
View Full Code Here

      if(entity.getMetaData().hasRowLocking())
      {
         JDBCEntityPersistenceStore manager = entity.getManager();
         JDBCTypeFactory typeFactory = manager.getJDBCTypeFactory();
         JDBCTypeMappingMetaData typeMapping = typeFactory.getTypeMapping();
         JDBCFunctionMappingMetaData rowLockingTemplate = typeMapping.getRowLockingTemplate();
         if(rowLockingTemplate == null)
         {
            throw new DeploymentException("Row locking template is not defined for mapping: " + typeMapping.getName());
         }

         selectSql = rowLockingTemplate.getFunctionSql(new Object[]{selectColumns, tableName, whereColumns, null},
            new StringBuffer()).toString();
      }
View Full Code Here

      if(entity.getMetaData().hasRowLocking())
      {
         JDBCEntityPersistenceStore manager = entity.getManager();
         JDBCTypeFactory typeFactory = manager.getJDBCTypeFactory();
         JDBCTypeMappingMetaData typeMapping = typeFactory.getTypeMapping();
         JDBCFunctionMappingMetaData rowLockingTemplate = typeMapping.getRowLockingTemplate();

         if(rowLockingTemplate == null)
         {
            throw new DeploymentException("Row locking template is not defined for mapping: " + typeMapping.getName());
         }

         sql = rowLockingTemplate.getFunctionSql(
            new Object[]{selectColumns, entity.getQualifiedTableName(), whereColumns, null}, new StringBuffer()
         ).toString();
View Full Code Here

      this.manager = manager;
      rowLocking = manager.getMetaData().hasRowLocking();

      JDBCEntityBridge entity = (JDBCEntityBridge) manager.getEntityBridge();

      JDBCTypeMappingMetaData typeMapping = this.manager.getJDBCTypeFactory().getTypeMapping();
      AliasManager aliasManager = new AliasManager(
         typeMapping.getAliasHeaderPrefix(),
         typeMapping.getAliasHeaderSuffix(),
         typeMapping.getAliasMaxLength()
      );

      String alias = aliasManager.getAlias(entity.getEntityName());

      StringBuffer select = new StringBuffer(200);
      SQLUtil.getColumnNamesClause(entity.getPrimaryKeyFields(), alias, select);

      StringBuffer from = new StringBuffer();
      from.append(entity.getQualifiedTableName())
         .append(' ')
         .append(alias);

      // set the preload fields
      JDBCReadAheadMetaData readAhead = q.getReadAhead();
      if(readAhead.isOnFind())
      {
         setEagerLoadGroup(readAhead.getEagerLoadGroup());
         if(getEagerLoadMask() != null)
         {
            SQLUtil.appendColumnNamesClause(entity.getTableFields(), getEagerLoadMask(), alias, select);

            List onFindCMRList = JDBCAbstractQueryCommand.getLeftJoinCMRNodes(
               entity, entity.getQualifiedTableName(), readAhead.getLeftJoins(), null);

            if(!onFindCMRList.isEmpty())
            {
               setOnFindCMRList(onFindCMRList);
               JDBCAbstractQueryCommand.leftJoinCMRNodes(alias, onFindCMRList, aliasManager, from);
               JDBCAbstractQueryCommand.appendLeftJoinCMRColumnNames(onFindCMRList, aliasManager, select);
            }
         }
      }

      StringBuffer where = new StringBuffer();
      SQLUtil.getWhereClause(entity.getPrimaryKeyFields(), alias, where);

      // generate the sql
      StringBuffer sql = new StringBuffer(300);
      if(rowLocking && readAhead.isOnFind() && getEagerLoadMask() != null)
      {
         JDBCFunctionMappingMetaData rowLockingTemplate = typeMapping.getRowLockingTemplate();
         rowLockingTemplate.getFunctionSql(
            new Object[]{
               select,
               from,
               where.length() == 0 ? null : where,
View Full Code Here

/*  61 */     this.manager = manager;
/*  62 */     this.rowLocking = manager.getMetaData().hasRowLocking();
/*     */
/*  64 */     JDBCEntityBridge entity = (JDBCEntityBridge)manager.getEntityBridge();
/*     */
/*  66 */     JDBCTypeMappingMetaData typeMapping = this.manager.getJDBCTypeFactory().getTypeMapping();
/*  67 */     AliasManager aliasManager = new AliasManager(typeMapping.getAliasHeaderPrefix(), typeMapping.getAliasHeaderSuffix(), typeMapping.getAliasMaxLength());
/*     */
/*  73 */     String alias = aliasManager.getAlias(entity.getEntityName());
/*     */
/*  75 */     StringBuffer select = new StringBuffer(200);
/*  76 */     SQLUtil.getColumnNamesClause(entity.getPrimaryKeyFields(), alias, select);
/*     */
/*  78 */     StringBuffer from = new StringBuffer();
/*  79 */     from.append(entity.getQualifiedTableName()).append(' ').append(alias);
/*     */
/*  84 */     JDBCReadAheadMetaData readAhead = q.getReadAhead();
/*  85 */     if (readAhead.isOnFind())
/*     */     {
/*  87 */       setEagerLoadGroup(readAhead.getEagerLoadGroup());
/*  88 */       if (getEagerLoadMask() != null)
/*     */       {
/*  90 */         SQLUtil.appendColumnNamesClause(entity.getTableFields(), getEagerLoadMask(), alias, select);
/*     */
/*  92 */         List onFindCMRList = JDBCAbstractQueryCommand.getLeftJoinCMRNodes(entity, entity.getQualifiedTableName(), readAhead.getLeftJoins(), null);
/*     */
/*  95 */         if (!onFindCMRList.isEmpty())
/*     */         {
/*  97 */           setOnFindCMRList(onFindCMRList);
/*  98 */           JDBCAbstractQueryCommand.leftJoinCMRNodes(alias, onFindCMRList, aliasManager, from);
/*  99 */           JDBCAbstractQueryCommand.appendLeftJoinCMRColumnNames(onFindCMRList, aliasManager, select);
/*     */         }
/*     */       }
/*     */     }
/*     */
/* 104 */     StringBuffer where = new StringBuffer();
/* 105 */     SQLUtil.getWhereClause(entity.getPrimaryKeyFields(), alias, where);
/*     */
/* 108 */     StringBuffer sql = new StringBuffer(300);
/* 109 */     if ((this.rowLocking) && (readAhead.isOnFind()) && (getEagerLoadMask() != null))
/*     */     {
/* 111 */       JDBCFunctionMappingMetaData rowLockingTemplate = typeMapping.getRowLockingTemplate();
/* 112 */       rowLockingTemplate.getFunctionSql(new Object[] { select, from, where.length() == 0 ? null : where, null }, sql);
/*     */     }
/*     */     else
/*     */     {
/* 124 */       sql.append("SELECT ").append(select).append(" FROM ").append(from).append(" WHERE ").append(where);
View Full Code Here

/*     */   {
/* 131 */     Connection con = null;
/* 132 */     Statement st = null;
/*     */     try
/*     */     {
/* 135 */       JDBCTypeMappingMetaData typeMapping = (JDBCTypeMappingMetaData)this.server.getAttribute(this.metaDataName, "TypeMappingMetaData");
/* 136 */       if (typeMapping == null) {
/* 137 */         throw new IllegalStateException("Cannot obtain type mapping from: " + this.metaDataName);
/*     */       }
/* 139 */       JDBCMappingMetaData objectMetaData = typeMapping.getTypeMappingMetaData(Object.class);
/* 140 */       this.binarySqlType = objectMetaData.getJdbcType();
/*     */
/* 142 */       if (!SQLUtil.tableExists(getTableName(), this.ds))
/*     */       {
/* 144 */         con = this.ds.getConnection();
/*     */
/* 146 */         String dateType = typeMapping.getTypeMappingMetaData(Timestamp.class).getSqlType();
/* 147 */         String longType = typeMapping.getTypeMappingMetaData(Long.class).getSqlType();
/* 148 */         String objectType = objectMetaData.getSqlType();
/*     */
/* 151 */         StringBuffer createTableDDL = new StringBuffer("create table " + getTableName() + " (" + " " + getColumnTimerID() + " varchar(80) not null," + " " + getColumnTargetID() + " varchar(250) not null," + " " + getColumnInitialDate() + " " + dateType + " not null," + " " + getColumnTimerInterval() + " " + longType + "," + " " + getColumnInstancePK() + " " + objectType + "," + " " + getColumnInfo() + " " + objectType + ", ");
/*     */
/* 160 */         JDBCFunctionMappingMetaData pkConstraint = typeMapping.getPkConstraintTemplate();
/* 161 */         String[] templateParams = { getTableName() + "_PK", getColumnTimerID() + ", " + getColumnTargetID() };
/*     */
/* 165 */         pkConstraint.getFunctionSql(templateParams, createTableDDL);
/*     */
/* 168 */         createTableDDL.append(" )");
View Full Code Here

/*      */
/*  326 */     if (this.entity.getMetaData().hasRowLocking())
/*      */     {
/*  328 */       JDBCEntityPersistenceStore manager = this.entity.getManager();
/*  329 */       JDBCTypeFactory typeFactory = manager.getJDBCTypeFactory();
/*  330 */       JDBCTypeMappingMetaData typeMapping = typeFactory.getTypeMapping();
/*  331 */       JDBCFunctionMappingMetaData rowLockingTemplate = typeMapping.getRowLockingTemplate();
/*  332 */       if (rowLockingTemplate == null)
/*      */       {
/*  334 */         throw new DeploymentException("Row locking template is not defined for mapping: " + typeMapping.getName());
/*      */       }
/*      */
/*  337 */       this.selectSql = rowLockingTemplate.getFunctionSql(new Object[] { selectColumns, this.tableName, whereColumns, null }, new StringBuffer()).toString();
/*      */     }
/*      */     else
View Full Code Here

/*     */
/*  65 */     if (entity.getMetaData().hasRowLocking())
/*     */     {
/*  67 */       JDBCEntityPersistenceStore manager = entity.getManager();
/*  68 */       JDBCTypeFactory typeFactory = manager.getJDBCTypeFactory();
/*  69 */       JDBCTypeMappingMetaData typeMapping = typeFactory.getTypeMapping();
/*  70 */       JDBCFunctionMappingMetaData rowLockingTemplate = typeMapping.getRowLockingTemplate();
/*     */
/*  72 */       if (rowLockingTemplate == null)
/*     */       {
/*  74 */         throw new DeploymentException("Row locking template is not defined for mapping: " + typeMapping.getName());
/*     */       }
/*     */
/*  77 */       this.sql = rowLockingTemplate.getFunctionSql(new Object[] { selectColumns, entity.getQualifiedTableName(), whereColumns, null }, new StringBuffer()).toString();
/*     */     }
/*     */     else
View Full Code Here

TOP

Related Classes of org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCTypeMappingMetaData

Copyright © 2018 www.massapicom. All rights reserved.
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.