Daniel Baccin danielbaccin

Se fizer certo, da certo!

danielbaccin / gist:187dc3f75be550a2c2c7e4c19ed637a5

Created January 3, 2018 12:38

add proxy tomcat

-Dhttp.proxyHost=localhost -Dhttp.proxyPort=8800

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 / gist:a5559c5b0b65e79edc1afb0ba132a20f

Created April 12, 2016 20:20

define versão do java de uma lista

update-alternatives --config [javac, java, javap, ...]

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 / 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 / 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 / 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 / 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 / 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 / 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