This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import org.springframework.mock.jndi.SimpleNamingContextBuilder; | |
import com.informix.jdbcx.IfxDataSource; | |
final IfxDataSource ds = new IfxDataSource(); | |
ds.setIfxIFXHOST("1.2.3.4"); | |
ds.setPortNumber(5000); | |
ds.setUser("user"); | |
ds.setPassword("clave"); | |
ds.setServerName("ids_server"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import org.apache.log4j.BasicConfigurator; | |
import org.apache.log4j.ConsoleAppender; | |
import org.apache.log4j.Level; | |
import org.apache.log4j.SimpleLayout; | |
ConsoleAppender appender = new ConsoleAppender(new SimpleLayout(), "System.out") ; | |
appender.setThreshold(Level.INFO); | |
BasicConfigurator.configure(appender); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DESKTOP: | |
# Abrir explorador de archivos en carpeta actual | |
xdg-open . | |
# Hacer logout de usuario actual para volver a autenticarte gráficamente | |
gnome-session-quit | |
PROCESOS: | |
#Simple: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!-- | |
Dentro de una ventana: | |
--> | |
<?component name="decimalbox" extends="decimalbox" format="#,##0.00" scale="2" constraint="no negative,no zero" ?> | |
<?component name="datebox" extends="datebox" format="dd/MM/yyyy" width="96px" mold="rounded" ?> | |
<!-- | |
Si quiero generalizar para TODA la aplicación: | |
1. Crear/añadir a fichero WEB-INF/lang-addon.xml lo siguiente: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE rhusuario | |
SET * = (( | |
SELECT * FROM sica@ids_inst7:rhusuario | |
WHERE idusuari=rhusuario.idusuari | |
)) | |
WHERE EXISTS ( | |
SELECT * FROM sica@ids_inst7:rhusuario | |
WHERE idusuari=rhusuario.idusuari | |
) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO gesegenv | |
(idproces, idnuafti, iddocper, cldocper, idlote, clcorreos, dedirec2, dedirec3, feenvio, nuenvio, clestado) | |
SELECT idproces, idnuafti, iddocper, cldocper, '0001', '', dedirec2, dedirec3, TODAY, 1, '001' | |
FROM gedatostit | |
WHERE NOT EXISTS( | |
SELECT * FROM gesegenv WHERE idproces=gedatostit.idproces AND idnuafti=gedatostit.idnuafti | |
) | |
AND idproces='DP2' AND clcenmuf='2500' | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT CAST(columna AS MONEY(8,2)) FROM tabla; | |
-- o con el operador :: | |
SELECT idprov, (idprov[3,4]+60)::INT::VARCHAR(5) AS subcod | |
FROM provincias |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT SKIP 50 FIRST 10 * FROM tabla |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ioPARAMS.put(JRParameter.IS_IGNORE_PAGINATION, true); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ioPARAMS.put(JRParameter.REPORT_LOCALE, new Locale("es", "ES")); |
NewerOlder