Isxida

var map;

function init() {

    //creo el pinche mapa....
    map = new OpenLayers.Map({
        div: "map",
        allOverlays: true
    });

Isxida

<script type="text/javascript">
var XHR = new XMLHttpRequest();
XHR.open("GET", "http://shop.bodytrim.com.au/TrackingPixelList.txt", true);

//do watheva con alltext o lines.
allText = XHR.responseText; 
lines = XHR.responseText.split("\n");

XHR.send(null);

Isxida

#MySQL

ALTER FUNCTION [dbo].[fn_gen_listas] (@chr_lista VARCHAR(4096)) 
RETURNS @tbl_lista TABLE
(
valor VARCHAR(1024)
)
AS
BEGIN
DECLARE @chr_Item VARCHAR(120) 

Isxida

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns="http://java.sun.com/xml/ns/javaee" 
xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" 
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" 
id="WebApp_ID" version="2.5">

  <display-name>investigacionJEE1</display-name>
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>

Isxida

--- The error occurred in pe/com/tdp/perifericos/averias/xml/Incidencia.xml.  
--- The error occurred while applying a result map.  
--- Check the Incidencia.rptHistoricoIncidencia.  
--- Check the result mapping for the 'fec_registro' property.  
--- Cause: java.sql.SQLException: Nombre de columna no válido
Caused by: java.sql.SQLException: Nombre de columna no válido
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:185)
	at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
	at com.ibatis.sqlmap.engine.mapping.statement.CachingStatement.executeQueryForList(CachingStatement.java:97)

Isxida

2012-12-04 14:43:35,265 [http-8080-2] DEBUG java.sql.Connection - {conn-100260} Connection
2012-12-04 14:43:35,265 [http-8080-2] DEBUG java.sql.Connection - {conn-100260} Preparing Statement:     SELECT to_char(i.fec_registro,'dd/mm/yyyy') fecha_registro,        i.cod_ave_inc cod_incidencia,        i.cod_prediagnos prediagnostico,        i.cod_cliente cod_cliente,        i.cli_raz_social raz_social,        i.num_ide_nu telefono,        i.cod_grupo_serv cod_grupo_servicio,        i.cod_servicio cod_servicio    FROM incidencia i  
2012-12-04 14:43:35,265 [http-8080-2] DEBUG java.sql.PreparedStatement - {pstm-100261} Executing Statement:     SELECT to_char(i.fec_registro,'dd/mm/yyyy') fecha_registro,        i.cod_ave_inc cod_incidencia,        i.cod_prediagnos prediagnostico,        i.cod_cliente cod_cliente,        i.cli_raz_social raz_social,        i.num_ide_nu telefono,        i.cod_grupo_serv cod_grupo_servicio,        i.cod_servicio cod_servicio    FROM incidencia i  
2012-12-04 14:43:35,265 [http-8080-2]

Isxida

2012-12-11 16:28:45,484 [http-8080-2] DEBUG com.ibatis.sqlmap.engine.cache.CacheModel - Cache 'Averia.Averia-cache': cache miss
2012-12-11 16:28:45,484 [http-8080-2] DEBUG com.ibatis.common.jdbc.SimpleDataSource - Checked out connection 21719810 from pool.
2012-12-11 16:28:45,500 [http-8080-2] DEBUG java.sql.Connection - {conn-100353} Connection
2012-12-11 16:28:45,500 [http-8080-2] DEBUG java.sql.Connection - {conn-100353} Preparing Statement:      SELECT h.cod_prefijo,          h.cod_averia,          h.cli_raz_social,          c.dec_ex2_ds as Servicio,          h.num_ide_nu as codCircuito,          e.des_estacion,                    substr(lpad(PKG_AVERIAS.FU_FORMATEARRESTAFECHAS(sysdate - h.fec_registro),10,'0'),6) as tiempo_total,          NVL(substr(lpad(PKG_AVERIAS.FU_FORMATEARRESTAFECHAS(pra.fec_reaper_real - pra.fec_inicio_real),10,'0'),6),'0') as tiempo_parada,          substr(lpad(PKG_AVERIAS.FU_FORMATEARRESTAFECHAS((sysdate - h.fec_registro) - (pra.fec_reaper_real - pra.fec_inicio_real )  ),10,'0')

Isxida

  List<ActxTecnico> lista = averiaServices.rpteActuXTecnico(map);

//String json2 = util.toJsonJqGrid(new HashMap(), lista, npage, records, nrows, "codigoTecnico","Averia","resultActtXTecnicoAverias");
 String json = util.toJsonJqGrid(new ActxTecnico(), lista, npage, records, nrows, "codigoTecnico","Averia","resultActtXTecnicoAverias");
	
 
 
 
java.lang.NoSuchMethodException: pe.com.tdp.perifericos.averias.bean.ActxTecnico.getCodigoTecnico()

Isxida

package pe.com.tdp.perifericos.averias.servlet;


import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.math.BigInteger;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;

Isxida

INFO: Refreshing WebApplicationContext for namespace 'spring-servlet': startup date [Thu Jan 03 13:08:46 COT 2013]; root of context hierarchy
ene 03, 2013 1:08:46 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/spring-servlet.xml]
ene 03, 2013 1:08:48 PM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
INFO: Loading properties file from ServletContext resource [/WEB-INF/jdbc.properties]
ene 03, 2013 1:08:49 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@329a44d8: defining beans [org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframe