Skip to content

Instantly share code, notes, and snippets.

View danielbaccin's full-sized avatar

Daniel Baccin danielbaccin

16 followers · 6 following
View GitHub Profile
@danielbaccin
danielbaccin / gist:187dc3f75be550a2c2c7e4c19ed637a5
Created January 3, 2018 12:38
add proxy tomcat
-Dhttp.proxyHost=localhost -Dhttp.proxyPort=8800
@danielbaccin
danielbaccin / gist:80b060771f62efff073c81a4f5dcad1d
Created February 6, 2017 14:15
aumentando numero de conexões no oracle
--rodar esse comando como system
ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
--reiniciar o serviço do listener (OracleXETNSListener):
@danielbaccin
danielbaccin / gist:a5559c5b0b65e79edc1afb0ba132a20f
Created April 12, 2016 20:20
define versão do java de uma lista
update-alternatives --config [javac, java, javap, ...]
@danielbaccin
danielbaccin / gist:d340cac2b50658cbaf85ede9aee3781e
Created April 7, 2016 13:36
conf tomcat para exibir request e response http
-Dcom.sun.xml.ws.transport.http.client.HttpTransportPipe.dump=true
-Dcom.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.dump=true
-Dcom.sun.xml.ws.transport.http.HttpAdapter.dump=true
-Dcom.sun.xml.internal.ws.transport.http.HttpAdapter.dump=true
@danielbaccin
danielbaccin / gist:78d81c28f11bd5ca8aa8
Created December 16, 2015 14:57
registros com msm cnpj firebird
select forcod, forcgc from FORNECEDOR where forcgc in(
select forcgc from FORNECEDOR group by forcgc having count(forcgc) > 1)
@danielbaccin
danielbaccin / gist:dedfec0c8eb551ac8a19
Last active January 14, 2016 19:26
intall postgresql no ubuntu
sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
sudo passwd postgres
su postgres
psql -c "ALTER USER postgres WITH PASSWORD 'nova_senha'" -d template1
http://blog.patrickmaciel.com/instalando-o-postgresql-9-3-no-ubuntu-14-04-lts/
http://alcemirprogramador.blogspot.com.br/2013/07/liberando-acesso-remoto-postgresql.html
@danielbaccin
danielbaccin / gist:5a3527bd64b1852dcfba
Last active December 6, 2015 03:57
intall java oracle
#Oracle JDK 7
sudo apt-get install python-software-properties
sudo add-apt-repository ppa:webupd8team/java
sudo apt-get update
sudo apt-get install oracle-java7-installer
#install git
sudo apt-get install git
#generate public key
@danielbaccin
danielbaccin / reprocessa vendas consolidadas
Last active November 23, 2015 13:49
reprocessa vendas consolidadas
TRUNCATE TABLE VENDA_CONSOLIDADA_PRODUTO;
TRUNCATE TABLE VENDA_CONSOLIDADA_FINALIZADORA;
TRUNCATE TABLE VENDA_CONSOLIDADA_LOJA;
INSERT INTO VENDA_CONSOLIDADA_PRODUTO (ID, LOJCOD, VCPDAT, PROCOD, VCPQTD, VCPVLRTOT)
SELECT nextval('SQ_VENDA_CONSOLIDADA_PRODUTO')
, T.LOJCOD
, T.TRNDAT AS VCPDAT
@danielbaccin
danielbaccin / updating table using subquery
Created November 5, 2015 13:25
updating table rows in postgres using subquery
UPDATE produto
SET stf_codigo = subquery.situacao
FROM (select p.procod as produto, s.stf_codigo as situacao from produto p
inner join situacao_fiscal s on (p.trbid = s.trbid)) AS subquery
WHERE produto.procod = subquery.produto;
http://stackoverflow.com/questions/6256610/updating-table-rows-in-postgres-using-subquery
@danielbaccin
danielbaccin / gist:dfe2bef903703e999e96
Created November 3, 2015 17:30
backup and restore postgresql
Gerar dump: pg_dump -h 127.0.0.1 -p 5432 -U postgres bembomsupermercados > bembomsupermercados.sql
Restaurar o banco: psql -h localhost -p 5432 -U postgres -f /home/daniel/bembomsupermercados.sql -W bembomsupermercados