TOMCAT 8 - MEMORIA - CONFIGURACION

En el archivo catalina.bat

set JAVA_HOME=D:\app\jdk1.7x64
set JAVA_OPTS=-Dfile.encoding=UTF-8 -Xms328m -Xmx1024m -XX:PermSize=364m -XX:MaxPermSize=856m




MODO WINDOWS
-Xms328M
-Xmx1024M
-XX:PermSize=1024m
-XX:MaxPermSize=4096m

Initial memory pool : 1024
Maximun memory pool : 4096
Thred stack size : 2048

des-habilitar seguridad windows

Click start and type gpedit.msc to open the Policy Editor
Open Computer Configuration (left hand pane)
Open Windows Settings (left hand pane)
Open Security Settings (left hand pane)
Open Account Policies (left hand pane)
Open Password Policy (left hand pane)
Doubleclick on the Password must meet complexity requirements
Select Disabled
Press OK
Close the Policy Editor
Run gpupdate.exe

MAVEN - ignorar test

Por proyecto
=================
Project
Run as
Run Configuration

Ejercicio - Main - Goals - clean install -DskipTests



Por Codigo
===========
@Ignore

MYSQL restore database

mysql --user=root --database=sgdbsys --password= < d:\sgdbsys.sql

MYSQL - Listar objetos de esquemas

SELECT * FROM (
select TABLE_SCHEMA AS ESQUEMA, TABLE_TYPE AS TIPO, COUNT(1) AS CONTADOR from
INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA, TABLE_TYPE
UNION ALL
select ROUTINE_SCHEMA AS ESQUEMA, ROUTINE_TYPE AS TIPO, COUNT(1) AS CONTADOR from
INFORMATION_SCHEMA.ROUTINES GROUP BY ROUTINE_SCHEMA, ROUTINE_TYPE) det
WHERE det.ESQUEMA='sgesquemasys'

Configurar JDNI en app web (Weblogic, Spring, Hibernate)

Archivo Aplication Spring:

<bean id="BeanDataSourceErp" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:comp/env/jndi/dbErp" />
</bean>


Archivo web XML
<resource-ref>
<description>Oracle JNDI Data Source </description>
<res-ref-name>jndi/dbErp</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<mapped-name>jndi/dbErp</mapped-name>
</resource-ref>

Oracle - Trace

SELECT
S.LAST_ACTIVE_TIME,
S.MODULE,
S.SQL_TEXT,
S.SQL_PROFILE,
S.EXECUTIONS,
S.LAST_LOAD_TIME,
S.PARSING_USER_ID,
S.SERVICE
FROM
SYS.V_$SQL S,
SYS.ALL_USERS U
WHERE
S.PARSING_USER_ID=U.USER_ID
AND UPPER(U.USERNAME) IN ('SGCORESYS')
ORDER BY S.LAST_ACTIVE_TIME desc;