Fernando's questions

I'm using netbeans in an application that uses JPA+EclipseLink, and trying that when the "persist" method generates an error, I can catch it from the class and handle it. The error in question is due to duplicate key and for some reason, I can't catch it, as if the "catch" didn't work: @Override public void insertPtovta(Ptovta ptovta) throws ServletException { try { em.persist(ptovta); } catch (Exception e) { log.debug(e); throw new ServletException("Ocurrio un Error en metodo buscaUsuario !", e); } }

This is part of the message that netbeans throws:

Warning: Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.1.v20150605-31e8258): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: duplicate key violates uniqueness constraint "unq_ptovta_0" Detail: The key (idtype, letter, ptovta)=(2, A, 1) already exists. Error Code: 0 Call: INSERT INTO ptovta (COPIES, DESTINATION, PRINTS, LETTER, PTOVTA, ROW, TYPE, LAST, idtype) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind = > [9 parameters bound] Query: InsertObjectQuery(kompass.coopkit.model.Ptovta@1d5) at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)

The error message is clearly visible in the glassfish log. Any idea how to catch it? Thank you very much in advance! Cheers

I have a model with 2 tables, Cuentasand Movimien. merge()When the table method is called Movimien, it tries to perform a inserton the table Cuentas. I am not clear if the relations raise them correctly. Could someone give me a hand with this?

Below is the model of the table Movimien, which when doing the update triggers the insertin the table Cuenta:

@Entity
@Table(name = "movimien")
public class Movimien implements Serializable {

private static final long serialVersionUID = 1L;

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
private Date fecha;
private short cuentaid;
private float importe;
private String concepto;

 @JoinColumn(name = "cuentaid", insertable = false, updatable = false)
@ManyToOne
private Cuenta cuenta;

public Movimien() {
    this.cuenta = new Cuenta();
}

public int getId() {
    return id;
}

public void setId(int id) {
    this.id = id;
}

public Date getFecha() {
    return fecha;
}

public void setFecha(Date fecha) {
    this.fecha = fecha;
}

public short getCuentaid() {
    return cuentaid;
}

public void setCuentaid(short cuentaid) {
    this.cuentaid = cuentaid;
}

public float getImporte() {
    return importe;
}

public void setImporte(float importe) {
    this.importe = importe;
}

public String getConcepto() {
    return concepto;
}

public void setConcepto(String concepto) {
    this.concepto = concepto;
}

public Cuenta getCuenta() {
    return cuenta;
}

public void setCuenta(Cuenta cuenta) {
    this.cuenta = cuenta;
}

@Override
public int hashCode() {
    int hash = 7;
    hash = 53 * hash + this.id;
    return hash;
}

@Override
public boolean equals(Object obj) {
    if (this == obj) {
        return true;
    }
    if (obj == null) {
        return false;
    }
    if (getClass() != obj.getClass()) {
        return false;
    }
    final Movimien other = (Movimien) obj;
    if (this.id != other.id) {
        return false;
    }
    return true;
}}

And the model of the table Cuenta, which is fired insertwhen a is done updateon the table Movimien:

@Entity
@Table(name = "cuentas")
public class Cuenta implements Serializable {

private static final long serialVersionUID = 1L;

@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
private String nombre;
private short tipo;

@OneToMany(mappedBy="cuenta")  //Con mappedBy estamos indicando quién es el dueño de la relación.
private List<Movimien> movimien;

// Constructor - Requerido para lo EJB
public Cuenta() {
    this.nombre="";
    this.tipo = 0;
}

public int getId() {
    return id;
}

public void setId(int id) {
    this.id = id;
}

public String getNombre() {
    return nombre;
}

public void setNombre(String nombre) {
    this.nombre = nombre;
}

public short getTipo() {
    return tipo;
}

public void setTipo(short tipo) {
    this.tipo = tipo;
}


@Override
public int hashCode() {
    int hash = 7;
    hash = 97 * hash + this.id;
    return hash;
}

@Override
public boolean equals(Object obj) {
    if (this == obj) {
        return true;
    }
    if (obj == null) {
        return false;
    }
    if (getClass() != obj.getClass()) {
        return false;
    }
    final Cuenta other = (Cuenta) obj;
    if (this.id != other.id) {
        return false;
    }
    return true;
}}

Any idea what could be the reason for this behavior?

for several days I have the problem, that when I call the jquery autocomplete function it does not show me anything, and I have already reviewed the questions that others have already formulated, but I still do not realize what the problem is, I suppose that because I am not very clear JavaScript. Thanks in advance to anyone who can help me out!

The function is working, in fact I have tried to follow it with the debugger and it seems to work. In my view, a JSP page, I have this code:

<script language="javascript" type="text/javascript">
        $(function () {
            $("#cuenta").autocomplete({
                source: function (request, response) {
                    alert("pepe");
                    $.ajax({
                        type: "POST",
                        url: "CuentaBusca",
                        contentType: "application/json; charset=utf-8",
                        dataType: "json",
                        minLength: 2,
                        delay: 100,
                        success: function (data) {
                            console.log( data);
                            response(data);
                        },
                        select: function (event, ui) {
                            return false;
                        }
                    });
                }
            });
        });
    </script>

The console.log shows me the following output:

And in the servlet I have the following code, which also works:

  protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
     PrintWriter out = response.getWriter();


    DBConexion conex = null;
    try {
        conex = new DBConexion();
    } catch (SQLException ex) {
        throw new ServletException("Sucedio un Error al Realizar la Conexion a la Base de Datos !", ex);
    }

    Connection conn = conex.getConexion();

    try {

        PreparedStatement ps = conn.prepareStatement("select id,nombre from cuentas order by nombre");
        ResultSet rs = ps.executeQuery();

        JsonObject json_response = new JsonObject();
        JsonArray data_json = new JsonArray();

        while (rs.next()) {
            JsonObject json = new JsonObject();

            json.addProperty("id", rs.getInt("id"));
            json.addProperty("nombre", rs.getString("nombre"));
            data_json.add(json);
        }
        json_response.add("aaData", data_json);

        response.setContentType("application/Json");
        response.getWriter().write(json_response.toString());

    } catch (SQLException ex) {
        throw new ServletException("Sucedio un Error al Realizar la Conexion a la Base de Datos !", ex);

    }

    // Cierra la Conexion 
    try {
        conex.closeConexion();
    } catch (SQLException ex) {
        throw new ServletException("Sucedio un Error al Cerrar la Conexion en la Base de Datos !", ex);
    }
}

I suspect that I am returning in the wrong format from the servlet, but I couldn't find a clearer explanation. Any ideas?

Regards, Ferdinand

For several days he has not been able to find why a view, made with Java Server Pages and Bootstrap 3, is not displayed correctly. I have reviewed the code and I cannot figure out what the error is, the Bootstrap libraries load them correctly and so does jQuery.

The problem is that on large screens, you see a weird line break separating the Gender field and seeing a line below its label, making the form look awkward. Something like that:

I attach the code (to see the error click on "Full Screen"):

<!DOCTYPE html><html>
    <head>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <link rel="icon" href="favicon.ico">
        <title>ABM de Afiliados</title>
        <link href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
        <!-- Jquery -->
        <script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
        
        <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>


    </head>
    <body>
        <div class="container">
            <div class="masthead">
                <h3 class="text-muted">UOM</h3>          
            </div>

            <div class="panel panel-info">
                <div class="panel-heading">
                    <h3 class="panel-title">Crear Afiliado</h3>
                </div>

                <div class="panel-body">
                    <form action="afiliado" method="post">

                        <div class="form-group">
                            <label class="col-sm-1 control-label">Nº DNI</label>
                            <div class="col-sm-2">
                                <input type="text" class="form-control" name="dni" required="required" value="" placeholder="D.N.I.">
                            </div>
                        </div>       

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="nombre">Nombre</label>
                            <div class="col-sm-2">
                                <input type="text" class="form-control" name="nombre" required id="nombre" value="" placeholder="">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="domicilio">Domicilio</label>
                            <div class="col-sm-2">
                                <input type="text" class="form-control" name="domicilio" required id="domicilio" value="" placeholder="">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="localidad">Localidad</label>
                            <div class="col-sm-2">
                                <input type="text" class="form-control" name="localidad" required id="localidad" value="" placeholder="">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="telefono">Telefono</label>
                            <div class="col-sm-2">
                                <input type="text" class="form-control" name="telefono" required id="telefono" value="" placeholder="">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="mail">Mail</label>
                            <div class="col-sm-2">
                                <input type="text" class="form-control" name="mail" required id="mail" value="" placeholder="">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="cuil">CUIL</label>
                            <div class="col-sm-2">
                                <input type="text" class="form-control" name="cuil" required id="cuil" value="" placeholder="">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="fecnac">Fecha Nacimiento</label>
                            <div class="col-sm-2">
                                <input type="date" class="form-control" name="fecnac" required id="fecnac" value="" placeholder="">
                            </div>
                        </div>

                        <div class="form-group">
                            <label class="col-sm-1 control-label" for="sexo">Sexo</label>
                            <div class="col-sm-2">
                                <SELECT size=1 cols=2 NAME="sexo" id="sexo">
                                    <OPTION value=1 selected="Masculino"> Masculino</option>
                                    <OPTION value=2> Femenino</option>
                                </select>
                            </div>
                        </div>

                        <button type="submit" class="btn btn-default">Guardar</button> 
                    </form>
                </div>
            </div>

        </div>
    </body>

</html>

If someone tries to save the attached code as an HTML page, you can see what I mean. Does anyone have an idea how I can fix it?