tripossi's questions

I am working on an ionic application, the engine is a tomcat 9 that we currently have locally.

With npm startwe could test those services that communicate engine with interface but now that we are executing the application on the device, at the moment that it reaches the execution of some service it throws us the following CORS error:

Access to XMLHttpRequest at 'http://localhost:8085/recin-server/LoginServlet' from origin 'http://localhost:8100' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource.

Service.ts

import { Injectable } from '@angular/core';
import { HttpHeaders, HttpClient } from '@angular/common/http';
import { Observable } from 'rxjs';


@Injectable({
providedIn: 'root'
})
export class HttpService {

private url = 'http://localhost:8085/recin-server/LoginServlet';

// Http Headers
headers: HttpHeaders = new HttpHeaders({
    Accept: "application/json",
    "Content-Type": "application/json; charset='utf-8'",
   'Access-Control-Allow-Origin': '*',
    'Authorization': 'authkey',
});

constructor(public http: HttpClient) {
    console.log("Servicio login listo");
}

postLogin(login): Observable<any> {
    return this.http.post(`${this.url}`, login, { headers: this.headers });
}
}

We have tried to send in the header of the service 'Access-Control-Allow-Origin': '*','Authorization': 'authkey',without success.

I have read that the server can be modified to allow different urls, but I don't know what to add or where.

I am working on a java project in which I have to store some data in a database or another according to a value in a variable. For the management of BBDD I use myBatis.

The configuration to the DBs:

context.xml

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/pathApp" reloadable="true">
    <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" maxIdle="1" maxTotal="20" maxWaitMillis="-1" name="jdbc/DB1" password="pass1" removeAbandonedOnBorrow="true" removeAbandonedTimeout="60" type="javax.sql.DataSource" url="ulrBD1" username="usernameDB1"/>
    <Resource auth="Container" driverClassName="oracle.jdbc.OracleDriver" maxIdle="1" maxTotal="20" maxWaitMillis="-1" name="jdbc/DB2" password="pass2" removeAbandonedOnBorrow="true" removeAbandonedTimeout="60" type="javax.sql.DataSource" url="urlDB2" username="usernameDB2"/>
</Context>

context-dfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="
   http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
   http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
   http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd">

<context:component-scan base-package="com.nombreCompañia.ajax.service" />

<context:annotation-config />

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

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource" />
</bean>

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

<bean id="transactionManager_DB2" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource_DB2" />
</bean>

<tx:annotation-driven />

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
</bean>

<bean id="sqlSessionFactory_DB2" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource_DB2" />
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.iberdrola.persistence.dao" />
    <property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>   

I declare the resources in web.xml

<resource-ref id="ResourceRef_5">
    <description>Base de datos 1</description>
    <res-ref-name>jdbc/DB1</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
    <res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

<resource-ref id="ResourceRef_0">
    <description>Base de datos 2</description>
    <res-ref-name>jdbc/DB2</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
    <res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

I have it this way because for database 1 I have not had any problems and it works correctly, so I decided to duplicate the configuration for the second DB, modifying its own configuration.

But how do I change at runtime to use one database or another?

I've searched a lot on the internet and I can't find a solution.

I hope your help.

Thank you

I have a button that every time it is pressed injects an HTML code into a container div. The injected code is the following.

  <div class="row">
    <div class="col-5 mt-2 pr-0">
       <div class="input-group">
          <div class="input-group-prepend">
             <span class="input-group-text inputMini" id="inputGroup-sizing-default">IMEI</span>
          </div>
          <input type="text" class="form-control inputMini" aria-label="Default" aria-describedby="inputGroup-sizing-default">
       </div>
    </div>
    <div class="col-5 mt-2 pr-0">
       <div class="input-group">
          <div class="input-group-prepend">
             span class="input-group-text inputMini" id="inputGroup-sizing-default">BUZÓN</span>
          </div>
          <input type="text" class="form-control inputMini" aria-label="Default" aria-describedby="inputGroup-sizing-default">
       </div>
     </div>
     <div class="col-2 pr-0 d-flex-left-center">
        <button class="btn rounded-circle" (click)="removeDevice($event)>
          <em class="fa fa-times"></em>
        </button>
     </div>
  </div>

As you can see, I am adding an element that contains a function call to that injected code.

The elements are painted correctly on the screen for me, but when clicking on the element that contains the call to the removeDevice() function, it never enters that call. Can someone tell me why it doesn't work? Am I injecting the html code correctly?

the code in the component that I have created to inject that code

@ViewChild('addDevice', {static: false}) divDevice: ElementRef;

const div: HTMLDivElement = this.renderer.createElement('div');
div.className = "col-md-12";

div.innerHTML = '<div class="row"><div class="col-5 mt-2 pr-0"><div class="input-group"><div class="input-group-prepend"><span class="input-group-text inputMini" id="inputGroup-sizing-default">IMEI</span></div><input type="text" class="form-control inputMini" aria-label="Default" aria-describedby="inputGroup-sizing-default"></div></div><div class="col-5 mt-2 pr-0"><div class="input-group"><div class="input-group-prepend"><span class="input-group-text inputMini" id="inputGroup-sizing-default">BUZÓN</span></div><input type="text" class="form-control inputMini" aria-label="Default" aria-describedby="inputGroup-sizing-default"></div></div><div class="col-2 pr-0 d-flex-left-center"><button class="btn rounded-circle" (click)="removeDevice($event)"><em class="fa fa-times"></em></button></div></div>';

this.renderer.appendChild(this.divDevice.nativeElement, div);

Thanks in advance

Cheers

I have the following JSON:

[{"estado":true,"cod":0,"id":"1237273960","dispositivo":"123456789012345","ELEMENTO":"AU","nom_ATRIBUTO":"ARBPL","val_ATRIBUTO":"DCF9D2_1","fecha":1585519200000,"descargado":"N"},{"estado":true,"cod":1,"id":"1237273961","dispositivo":"123456789012345","tip_ELEMENTO":"OT","nom_ATRIBUTO":"ARBPL","val_ATRIBUTO":"DCF9D2_1","fecha":1585519200000,"descargado":"N"}]

And the GOT class that is equivalent to the objects that make up the JSON

public class GOT {

private Integer cod;
private String id;
private String dispositivo;
private String ELEMENTO;
private String nom_ATRIBUTO;
private String val_ATRIBUTO;
private Date fecha;
private String descargado;  
private boolean estado = true;


public boolean isEstado() {
    return estado;
}

public void setEstado(boolean estado) {
    this.estado = estado;
}

public Integer getCOD() {       
    return cod;
}

public void setCOD(Integer cOD) {
    cod = cOD;
}

public String getID() {
    return id;
}

public void setID(String iD) {
    id = iD;
}

public String getDISPOSITIVO() {
    return dispositivo;
}

public void setDISPOSITIVO(String dISPOSITIVO) {
    dispositivo = dISPOSITIVO;
}

public String getELEMENTO() {
    return ELEMENTO;
}

public void setELEMENTO(String eLEMENTO) {
    ELEMENTO = eLEMENTO;
}

public String getNOM_ATRIBUTO() {
    return nom_ATRIBUTO;
}

public void setNOM_ATRIBUTO(String nOM_ATRIBUTO) {
    nom_ATRIBUTO = nOM_ATRIBUTO;
}

public String getVAL_ATRIBUTO() {   
    return val_ATRIBUTO;
}

public void setVAL_ATRIBUTO(String vAL_ATRIBUTO) {
    val_ATRIBUTO = vAL_ATRIBUTO;
}

public String getDESCARGADO() { 
    return descargado;
}

public void setDESCARGADO(String dESCARGADO) {
    descargado = dESCARGADO;
}

public Date getFECHA() {
    return fecha;
}

public void setFECHA(Date fECHA) {
    fecha = fECHA;
}
}

To work with that JSON, I have created the import class that is equivalent to JSON, or so I understand since I don't have much experience with this technology.

public class Impor {

GOT[] datos;

public GOT[] getDatos() {
    return datos;
}

public void setDatos(GOT[] datos) {
    this.datos = datos;
}   

}

For the mapping of the JSON I use Jackson.

InputStream datos = request.getInputStream();
Impor datosAlmacenar = new ObjectMapper().readValue(datos, Impor.class);

But I am getting the following error trace and I don't understand the reason.

Cannot deserialize instance of `com.paquete.ajax.model.Impor` out of START_ARRAY token at [Source: (org.apache.catalina.connector.CoyoteInputStream); line: 1, column: 1]

The error is in the Import class but I don't see where since, as far as I can tell, that class is equivalent to JSON.

Any help is welcome, since I've been thinking about this problem all day today and I don't see the solution

I have to make a query and I don't finish finding the correct form.

I have a table in an oracle database. in which has the following values:

example table

numero |  clase   | modelo |
  0701 | especial | alto   |
  0702 | estándar | básico | 
  0701 | estándar | medio  |
  0705 | especial | alto   |

The user will only insert class and model but I want to get those records whose number is repeated both in class and model. I put the query that I have so far in case it is better understood.

Select * FROM ejemplo WHERE ((clase = 'especial' AND modelo = 'alto') OR (clase = 'estándar' AND modelo = 'medio'));

This query will return 3 records, 2 with number 0701 and another with number 0705 but I only want it to return the records with number 0701 (the number matches in the results obtained).

In this second part is where I have the problem and I can't find the solution no matter how hard I search.

Any suggestion?

Thank you

I want to check if the String string contains an "= " and that "= " is followed by an alphanumeric character. For example:

String cadena1 = "= 'hola"; //patron.matcher(cadena1); devuelve false
String cadena2 = "= hola";  //patron.matcher(cadena2); devuelve true
String cadena3 = "= 1";  //patron.matcher(cadena3); devuelve true

The regex I am using is:

Pattern patron = Pattern.compile("=\\s[\\w]");
Matcher matcher = patron.matcher(cadena);

I am working on a screen that is made up of several components, one is the search filter and the other is a table that will show the result of a query to an oracle DB.

The table is always painted on the screen but when the result of the query is returned it must be updated and painted the results obtained and here I have the problem I am new to angular and I don't know how I can do that. I have searched the Internet but the solutions I have seen do not finish making them work.

filterSearch.component.ts

import { Component, OnInit, Output, EventEmitter } from "@angular/core";
import { BusquedaServiceService } from '../../../services/busquedaService/busqueda-service.service';
import { Busqueda } from 'src/app/model/busqueda';

@Component({
   selector: "app-buscador-principal",
   templateUrl: "./buscador-principal.component.html",
   styleUrls: ["./buscador-principal.component.css"]
})
export class BuscadorPrincipalComponent implements OnInit {

@Output() emitResultadoBusqueda: EventEmitter<Busqueda>;

constructor(private _busquedaServiceService: BusquedaServiceService) {
    this.emitResultadoBusqueda = new EventEmitter();
}

getValoresComponent() {

    this._busquedaServiceService.busqueda(JSON.stringify(this.busqueda)).subscribe(resp => {
        console.log(resp);
        this.emitResultadoBusqueda.emit(resp);
    });
}

The getValoresComponent() method is the one that sends the filters by which you want to search the oracle database (I have omitted all the code in that part).

this._busquedaServiceService.busqueda launches the service that queries in the BBDD and receives resp, which is the result of the BBDD.

ParentComponent.component.html

<div class="row" id="body-row">
<app-menuLateral></app-menuLateral>
<!-- MAIN -->
<div class="container col mt-3">
    <div class="container">
        <app-buscador-principal (emitResultadoBusqueda) = "resultadoBusqueda = $event"></app-buscador-principal>
        <div class="row">
            <div class="col-md-12 mb-5">
                <!-- Este es el div de contenido con scroll -->
                <h5 class="border-bottom border-success mt-3 mb-3">Resultados</h5>
                <app-tabla></app-tabla>
            </div>
        </div>
    </div>
</div>
<app-menuFAB></app-menuFAB>

In the parent I listen to the event emitted by the child

parentComponent.component.ts

import { Component, OnInit } from '@angular/core';
import { Busqueda } from 'src/app/model/busqueda';

@Component({
  selector: 'app-historico',
  templateUrl: './historico.component.html',
  styleUrls: ['./historico.component.css']
})
export class HistoricoComponent implements OnInit {

  resultadoBusqueda: Busqueda;

  constructor() { }

  ngOnInit() {}

}

In the table component right now I have data added manually but I want it to load the ones returned by the parent

table.component.ts

import { Component, OnInit, Input } from '@angular/core';
import { Busqueda } from 'src/app/model/busqueda';

@Component({
    selector: "app-tabla",
    templateUrl: "./tabla.component.html",
    styleUrls: ["./tabla.component.css"]
})
export class TablaComponent implements OnInit {

    @Input() ots: Busqueda;

    constructor() { }

    ngOnInit() {

    /*this.ots = [
        { numero: "000174585", tipo: "DPRP-DR1", estado: true, fecha: "10/03/2020" },
        { numero: "00025", tipo: "DPRP-DR3", estado: false, fecha: "09/03/2020" },
        { numero: "000254786", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254787", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254475", tipo: "DOPL-DO1", estado: false, fecha: "11/03/2020" },
        { numero: "000254788", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254789", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254790", tipo: "DPRN-DR3", estado: false, fecha: "09/03/2020" },
        { numero: "000254791", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254792", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254793", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254794", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254795", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254796", tipo: "DPRN-DR3", estado: false, fecha: "09/03/2020" },
        { numero: "000254797", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254798", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254799", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" },
        { numero: "000254800", tipo: "DPRN-DR3", estado: true, fecha: "09/03/2020" }
    ];*/
}
}

table.component.html

<p-table [columns]="cols" [value]="ots" dataKey="numero" [paginator]="true" [rows]="10">
<ng-template pTemplate="header" let-columns>
    <tr>
        <th *ngIf="collapsibles" style="width: 3em;" [attr.rowspan]="2" scope="row">
            <a href="importacion">
                <em class="fa fa-minus colorVerde"></em>
            </a>
        </th>
        <th *ngIf="checkboxes" style="width: 3em;" [attr.rowspan]="2" scope="row">
            <div class="custom-control custom-checkbox">
                <input type="checkbox" class="custom-control-input" id="checkboxGeneral">
                <label class="custom-control-label" for="checkboxGeneral"></label>
            </div>
        </th>
        <th *ngIf="colHistorio" style="width: 10em;" [attr.rowspan]="2" scope="row"></th>

        <th *ngFor="let col of columns" [pSortableColumn]="col.field" scope="row">
            {{col.header}}
            <p-sortIcon [field]="col.field"></p-sortIcon>
        </th>
    </tr>
    <tr>
        <th *ngFor="let col of columns" [ngSwitch]="col.field" scope="row">
            <input *ngSwitchCase="'numero'" class="form-control inputMini" type="text" placeholder="000000000">
            <select *ngSwitchCase="'tipo'" class="browser-default custom-select inputMini">
                <option>Seleccionar Tipo...</option>
                <option>DCO</option>
                <option>DOPL</option>
                <option>DPRN</option>
            </select>
            <select *ngSwitchCase="'estado'" class="browser-default custom-select inputMini">
                <option>Seleccionar Estado...</option>
                <option>OK</option>
                <option>KO</option>
            </select>
            <input *ngSwitchCase="'fecha'" class="form-control inputMini" type="date"/>
        </th>
    </tr>
</ng-template>
<ng-template pTemplate="body" let-rowData let-expanded="expanded" let-columns="columns">
    <tr [ngClass]="rowData.estado ? null : 'ibg_red_error'">
        <td *ngIf="collapsibles">
            <a href="#" [pRowToggler]="rowData">
                <em [ngClass]="expanded ? 'pi pi-chevron-down' : 'pi pi-chevron-right'" class="colorVerde"></em>
            </a>
        </td>
        <td *ngIf="checkboxes">
            <div class="custom-control custom-checkbox">
                <input type="checkbox" class="custom-control-input" [id]="rowData.numero">
                <label class="custom-control-label" [for]="rowData.numero"></label>
            </div>
        </td>
        <td *ngIf="colHistorio" style="text-align: center;">
            <a class="mr-3 colorVerde" >
                <em class="fa fa-eye iconTabla"></em>
            </a>
            <a class="colorRojo">
                <em class="fa fa-trash iconTabla"></em>
            </a>
        </td>

        <td>
            {{rowData.numero}}
        </td>
        <td>
            {{rowData.tipo}}
        </td>
        <td *ngIf="rowData.estado; else estadoKO" class="ibd_green_success">
            OK
        </td>
        <ng-template #estadoKO>
            <td class="ibd_red_error">
                KO
            </td>
        </ng-template>
        <td>
            {{rowData.fecha}}
        </td>
    </tr>
</ng-template>
<ng-template pTemplate="rowexpansion" let-rowData>
    <tr>
        <td [attr.colspan]="setAttrColspan()">
            <div class="ui-g ui-fluid" style="font-size:16px;">
                <div class="ui-g-12 ui-md">
                    <div class="ui-g">
                        <div class="list-group ui-g-12">
                            <div class="list-group-item flex-column align-items-start">
                                <div class="d-flex w-100 justify-content-between">
                                    <p class="mb-0">AUFNR - 00025</p>
                                    <small *ngIf="rowData.estado; else estadoKO" class="ibd_green_success">OK</small>
                                    <ng-template #estadoKO>
                                        <small #estadoKO class="ibd_red_error">KO</small>
                                    </ng-template>
                                </div>
                                <small>Longitud no válida.</small>
                            </div>
                            <div class="list-group-item flex-column align-items-start">
                                <div class="d-flex w-100 justify-content-between">
                                    <p class="mb-0">HOJARUTA - null</p>
                                    <small *ngIf="rowData.estado; else estadoKO" class="ibd_green_success">OK</small>
                                    <ng-template #estadoKO>
                                        <small #estadoKO class="ibd_red_error">KO</small>
                                    </ng-template>
                                </div>
                                <small>Atributo con valor null.</small>
                            </div>
                            <div class="list-group-item flex-column align-items-start">
                                <div class="d-flex w-100 justify-content-between">
                                    <p class="mb-0">FNO_UT - 23</p>
                                    <small *ngIf="rowData.estado; else estadoKO" class="ibd_green_success">OK</small>
                                    <ng-template #estadoKO>
                                        <small #estadoKO class="ibd_red_error">KO</small>
                                    </ng-template>
                                </div>
                                <small>Longitud no válida.</small>
                            </div>
                            <div class="list-group-item flex-column align-items-start">
                                <div class="d-flex w-100 justify-content-between">
                                    <p class="mb-0">FID_UT - null</p>
                                    <small *ngIf="rowData.estado; else estadoKO" class="ibd_green_success">OK</small>
                                    <ng-template #estadoKO>
                                        <small #estadoKO class="ibd_red_error">KO</small>
                                    </ng-template>
                                </div>
                                <small>Atributo con valor null.</small>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </td>
    </tr>
</ng-template>

When the table component is initialized it has no data and when it has data it is not painted. Any suggestion?

Thank you

I am trying to connect to an oracle DB with myBatis and it gives me the following error:

GRAVE: ERROR.nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
### The error may exist in com/iberdrola/persistence/dao/BusquedaDao.java (best guess)
### The error may involve com.iberdrola.persistence.dao.BusquedaDao.getResultadosBusqueda
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'

I have the DB configuration in the tomcat server.xml

<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver" maxIdle="1" maxTotal="20" maxWaitMillis="-1" name="jdbc/nombreBD" password="pass" removeAbandonedOnBorrow="true" removeAbandonedTimeout="60" type="javax.sql.DataSource" url="jdbc:oracle:thin:@//IP:PUERTO/AWDD" username="user"/>

I don't understand why it tells me that class is equal to "" and url 'null' when it looks like, if I have those configurations added.

I don't know what I might be missing or what I might be doing wrong.

Any missing info, I add it without problems.

Thanks in advance.

Good,

This is a row of my table, each of them has an onclick event. Clicking on the select calls that event which it shouldn't do. How can I do so that if it is clicked on the select, it opens the select and if it is clicked outside the select it triggers the event

Thank you

CSS I have a button that has quite a long text:

When the screen resizes (gets smaller), it hides some of the text:

The idea is that it adjusts to the width and unfolds in several lines (the ones you need) without hiding any of the text, I don't know if I'm explaining myself well. I've tried several CSS properties without success, I'd appreciate some help. Thank you

I have tried with CSS property:

• word-wrap: normal | word-break | start | inherent;
• display:inline | blocks | flex | inline-block | inline flex | start | inherent
• overflow-x: visible|hidden|scroll|auto|initial|inherit

I insert the text using jquery:

var texto = l.BTN_TEC;
texto += "<br /><h6 style='color: red; margin: 0;'> " + l.TEXT_BTN_TEC + "</h6>";
$("#showTecnicosBtn").html(texto);

I want to disable this link for a few seconds.

<a href="#" data-role="button" data-theme="f" data-rel="popup" id="deshabilitar" type="button" data-icon="cloud-upload" data-iconshadow="true" onclick="deshabilitar()"></a>

so that it only allows you to click once. In the function I have this code but it doesn't do it to me and I don't see why. Thanks.

 var button = $('#deshabilitar');
button.attr('disabled', 'disabled');
setTimeout(function() {
     button.removeAttr('disabled');
},3000);

https://jsfiddle.net/u2c6wdgq/1/

I want to launch an intent but it gives me an error and I can't find the reason. Any suggestions. It gives me the error when creating the intent:

 @Override
public View getChildView(int groupPosition, final int childPosition,
                         boolean isLastChild, View convertView, ViewGroup parent) {
    tempChild = (ArrayList<String>) Childtem.get(groupPosition);
    TextView text = null;
    if (convertView == null) {
        convertView = minflater.inflate(R.layout.childrow, null);
    }
    text = (TextView) convertView.findViewById(R.id.textView1);
    text.setText(tempChild.get(childPosition));
    convertView.setOnClickListener(new View.OnClickListener() {
        @Override
        public void onClick(View v) {
            dato = tempChild.get(childPosition);
            Toast.makeText(activity, dato,
                    Toast.LENGTH_SHORT).show();
            Intent intent = new Intent(NewAdapter.this, Ficha.class);
            intent.putExtra("id", id);
            activity.startActivity(intent);
        }
    });
    return convertView;
}

NewAdapter.java is a class that extends from BaseExpandableListAdapter.

It gives me an error when inserting some values ​​in the database. I've been looking for a while now and I can't find the error. This is my code:

HTML form:

<form action="#" method="post">
                            <fieldset class="fieldset">
                                <legend>Introduce los datos de tu evento:</legend>
                                <input class="inputForm1" type="text" name="nombre" placeholder="Nombre del Evento..." required>
                                <input class="inputForm1" type="text" name="lugar" placeholder="Lugar..." required>
                                <input class="inputForm1" type="text" name="descripcion" placeholder="Descripción..." required>
                                <input class="inputForm1" type="number" name="precio" placeholder="Precio..." required>
                                <input class="inputForm1" type="number" name="plazas" placeholder="Plazas..." required>
                                <input class="inputForm1" type="date" name="fecha" placeholder="Fecha..." required>
                                <input class="inputForm1" type="time" name="hora" placeholder="Hora..." required>
                                <input type="submit" value="Crear Evento" class="btnForm"/> 
                            </fieldset>
                        </form>

PHP code that receives the formone found in the same file:

 require '../php/eventos.php';

if ($_SERVER['REQUEST_METHOD'] == 'POST') {

     if (isset($_POST['nombre'])) {

        // Obtener parámetro idalumno
        $nombre = $_POST['nombre'];
        $lugar = $_POST['lugar'];
        $descripcion = $_POST['descripcion'];
        $precio = $_POST['precio'];
        $plazas = $_POST['plazas'];
        $fecha = $_POST['fecha'];
        $hora = $_POST['hora'];
        //$idUsuario = $_POST['idUsuario'];
         
         function cambiaf_a_mysql($fecha){
            ereg( "([0-9]{1,2})/([0-9]{1,2})/([0-9]{2,4})", $fecha, $mifecha);
            $lafecha=$mifecha[3]."-".$mifecha[2]."-".$mifecha[1];
            return $lafecha;
        }
    


        // Tratar retorno
        $retorno = Eventos::insertWeb($nombre,$lugar,$descripcion,$precio,$plazas,$fecha,$hora);


        if ($retorno) {

            //$alumno["estado"] = 1;        // cambio "1" a 1 porque no coge bien la cadena.
           // $alumno["alumno"] = $retorno;
            // Enviar objeto json del alumno
            //print json_encode($retorno);
            header('Location: actividades.php');
        } else {
            // Enviar respuesta de error general
            print json_encode(
                array(
                    'estado' => '2',
                    'mensaje' => 'No se obtuvo el registro'
                )
            );
        }

    } else {
        // Enviar respuesta de error
        print json_encode(
            array(
                'estado' => '3',
                'mensaje' => 'Se necesita un identificador'
            )
        );
    }
}

PHP code that inserts in the DB, is in events.php:

public static function insertWeb($nombre,$lugar,$descripcion,$precio,$plazas,$fecha,$hora) {
        // Sentencia INSERT
        $comando = "INSERT INTO evento ( " ."nombre," ."lugar,"  ."descripcion," ."precio," ."plazas," ."fecha," ."hora" . " VALUES ( ?,?,?,?,?,?,?)";

        // Preparar la sentencia
        $sentencia = Database::getInstance()->getDb()->prepare($comando);

        return $sentencia->execute(array($nombre,$lugar,$descripcion,$precio,$plazas,$fecha,$hora));

    }

And the error it shows:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VALUES( 'a','a','a','1','1','2016-06-09','00 :00')' at line 1' in .../php/events.php:161 Stack trace: #0 /home/u695092214/public_html/php/events.php(161): PDOStatement->execute(Array) # 1 .../views/createEvent.php(150): Events::insertWeb('a', 'a', 'a', '1', '1', '2016-06-09', '00: 00') #2 {main} thrown in .../php/events.php on line 161