sábado, 31 de enero de 2015

Cliente GitHub detrás de un proxy

Agregar las siguientes líneas en el archivo .gitconfig en el directorio de usuario:

[http]
  proxy = http://<user>:<pass>@<proxy address>:<proxy port>

[https]
  proxy = https://<user>:<pass>@<proxy address>:<proxy port>

martes, 20 de enero de 2015

RC: 73 A connection with a remote socket was reset by that socket

"Many times this issue can be seen in firewall environment and has been seen with network DNS problems and/or network config problems. One of the most common is when a passive device (router, switch, hub, etc.) is in between the client & the server. If the port on the passive device is set to Auto-Negotiate, it will automatically defer to the active device (the NIC in the client) to set the connection speed. If the NIC is also set to Auto-Negotiate (default in most OS's) this often causes excessive delays and interruptions in connectivity. This is because the NIC is looking to the network appliance to set the connection speed and vice-versa, it takes some time before the network device will find a suitable connection speed (not always optimal, just suitable) and begin data transfer. This repeats every time a data packet is sent across the network. While the negotiating period is relatively short by human standards (usually in the nanosecond range) it adds up over time when trying to send a large amount of data at a high speed and causes the connection to be broken. The best work around for that is to hard code both the NIC and the network port for a specific setting. This is usually 100Mb Full Duplex for a standard CAT-5 copper connection, although older equipment may require reconfiguration of 10/100 NICs to allow for that speed. Another possible workaround for this issue is to estimate the file transfer time and increase the IDLETIMEOUT to a level higher than that time."

IBM

miércoles, 14 de enero de 2015

Iterar objetos de un tipo tabla

DECLARE
  v_Return TRANSACCION_TBL;
BEGIN
  v_Return := PKG.GET_TRANSACCIONES();
  
  FOR counter IN v_Return.first .. v_Return.last
  LOOP
    DBMS_OUTPUT.PUT_LINE('ID: '||v_Return(counter).id_transaccion);
    DBMS_OUTPUT.PUT_LINE('NOMBRE: '||v_Return(counter).nombre);
  END LOOP;
END;