public JDBCInsertRelationsCommand(JDBCStoreManager manager) 
{
      this.log = Logger.getLogger(
            this.getClass().getName() + 
            "." + 
            manager.getMetaData().getName());
}

 public  void execute(RelationData relationData) 
{
      if(relationData.addedRelations.size() == 0) {
         return;
      }
      Connection con = null;
      PreparedStatement ps = null;
      JDBCCMRFieldBridge cmrField = relationData.getLeftCMRField();
      try {
         // get the sql
         String sql = getSQL(relationData);
         boolean debug = log.isDebugEnabled();
         if(debug)
            log.debug("Executing SQL: " + sql);
         // get the connection
         DataSource dataSource = cmrField.getDataSource();
         con = dataSource.getConnection();
         // get a prepared statement
         ps = con.prepareStatement(sql);
         Iterator pairs = relationData.addedRelations.iterator();
         while(pairs.hasNext()) {
            RelationPair pair = (RelationPair)pairs.next();
            // set the parameters
            setParameters(ps, relationData, pair);
            int rowsAffected = ps.executeUpdate();
         }
      } catch(Exception e) {
         throw new EJBException("Could insert relations into " +
               cmrField.getQualifiedTableName(), e);
      } finally {
         JDBCUtil.safeClose(ps);
         JDBCUtil.safeClose(con);
      }
}

 protected static String getSQL(RelationData relationData) 
{
      JDBCCMRFieldBridge left = relationData.getLeftCMRField();
      JDBCCMRFieldBridge right = relationData.getRightCMRField();
      StringBuffer sql = new StringBuffer(200);
      sql.append(SQLUtil.INSERT_INTO).append(left.getQualifiedTableName());
      sql.append('(');
         SQLUtil.getColumnNamesClause(left.getTableKeyFields(), sql);
      sql.append(SQLUtil.COMMA);
         SQLUtil.getColumnNamesClause(right.getTableKeyFields(), sql);
      sql.append(')');
      sql.append(SQLUtil.VALUES).append('(');
            SQLUtil.getValuesClause(left.getTableKeyFields(), sql);
            sql.append(SQLUtil.COMMA);
            SQLUtil.getValuesClause(right.getTableKeyFields(), sql);
      sql.append(')');
      return sql.toString();
}

 protected static  void setParameters(PreparedStatement ps,
    RelationData relationData,
    RelationPair pair) 
{
      int index = 1;
      // left keys
      Object leftId = pair.getLeftId();
      JDBCCMPFieldBridge[] leftFields = (JDBCCMPFieldBridge[]) relationData.getLeftCMRField().getTableKeyFields();
      for(int i = 0; i <  leftFields.length; ++i)
         index = leftFields[i].setPrimaryKeyParameters(ps, index, leftId);
      // right keys
      Object rightId = pair.getRightId();
      JDBCCMPFieldBridge[] rightFields = (JDBCCMPFieldBridge[]) relationData.getRightCMRField().getTableKeyFields();
      for(int i = 0; i <  rightFields.length; ++i)
         index = rightFields[i].setPrimaryKeyParameters(ps, index, rightId);
}