rponte

-- obtem parametros da NLS (National Language Support) da sessão do usuário
select * from NLS_SESSION_PARAMETERS

-- altera NLS_LANGUAGE
ALTER SESSION SET NLS_LANGUAGE='BRAZILIAN PORTUGUESE'

rponte

# verifica encoding do arquivo
$ file -I script_perebento.sql
$ file -bI script_perebento.sql

# converte arquivo de ISO-8859-1 para UTF-8
$ iconv -f ISO-8859-1 -t UTF-8 script_perebento.sql > script_bonitao.sql

rponte

-- run as a privileged user

select dbms_xdb.gethttpport as port from dual;
 
begin
 dbms_xdb.sethttpport('8081');  
end;

rponte

-- Tendo problemas com "ORA-12519, TNS:no appropriate service handler found"?
-- dica: http://en.newinstance.it/2007/06/01/ora-12519-tnsno-appropriate-service-handler-found/
-- Basta rodar este comando e reiniciar o listener (OracleXETNSListener):

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;

rponte

-- comando para listar usuarios conectados no oracle

SELECT s.username, s.program, s.logon_time
FROM v$session s, v$process p, sys.v_$sess_io si
WHERE s.paddr = p.addr(+)
AND si.sid(+) = s.sid
AND s.username = 'MEU_USUARIO';

-- Kill oracle sessions
-- http://www.oracle-base.com/articles/misc/KillingOracleSessions.php

rponte

JSF E O PROBLEMA DE N CHAMADAS A UM MÉTODO GETTER

• 2o MAU HABITO DOS DESENVOLVEDORES JSF (http://www.slideshare.net/tarsobessa/os-10-maus-hbitos-dos-desenvolvedores-jsf)

Imagine que o método abaixo possui um value-binding numa h:dataTable por exemplo.

public List<Cargo> getCargos() 
    return service.findAll(); // processo custoso
}

rponte

package br.com.triadworks.sample.view.jsf;

import org.apache.commons.lang.StringUtils;
import org.aspectj.lang.ProceedingJoinPoint;
import br.com.triadworks.sample.view.util.FacesUtils;

public class ExceptionHandler {
	/**
	 * Default error message
	 */

rponte

-- create a custom database on SQLSERVER2005

CREATE DATABASE MyDb ON PRIMARY
	(NAME = MyDb_Data,
		FILENAME = 'C:\SQLServerData\Data\MyDb_Data.mdf',
		SIZE = 250MB, MAXSIZE = UNLIMITED, FILEGROWTH = 5%)
	LOG ON (NAME = MyDb_Log,
		FILENAME = 'C:\SQLServerData\Log\MyDb_Log.ldf',
		SIZE = 50MB,
		MAXSIZE = 200MB,

rponte

-- create and alter database on SQLSERVER2005

CREATE DATABASE SysPDVWeb;
go
alter database MyDb
	modify file
	(name = 'MyDb',
		size = 20mb,
		filegrowth = 5%);
go

rponte

-- drop login on SQLSERVER2005
drop login syspdvweb;

-- check login at database
SELECT	name, sid, type, 
	type_desc 
    FROM sys.server_principals
   WHERE type = 'S';