hecnabae's questions

It's a bit of a weird bug. When executing a query on certain tables of a MySQL database from the Java driver, the system throws the following error:

java.lang.IllegalArgumentException: HOUR_OF_DAY: 2 -> 3
at java.util.GregorianCalendar.computeTime(GregorianCalendar.java:2829)
at java.util.Calendar.updateTime(Calendar.java:3393)
at java.util.Calendar.getTimeInMillis(Calendar.java:1782)
at com.mysql.cj.result.SqlTimestampValueFactory.createFromTimestamp(SqlTimestampValueFactory.java:97)
at com.mysql.cj.result.SqlTimestampValueFactory.createFromTimestamp(SqlTimestampValueFactory.java:44)
...

However, when we run the same query on the Workbench, the query executes successfully.

We are using version 8.0.17 of mysql. Regarding the java driver, we are using version 8.0.17.

In this post we have seen that it may be a problem with the configuration of the serverTimeZone parameter of the database, however, in the connection string we already specified the timezone as Europe/Madrid:

<Resource name="jdbc/mysqldb" auth="Container" type="javax.sql.DataSource"
           maxTotal="200" maxIdle="30" maxWaitMillis="3000"
           username="..." password="..." driverClassName="com.mysql.cj.jdbc.Driver"
           url="jdbc:mysql://localhost:3306/bbdd"
           connectionProperties="zeroDateTimeBehavior=CONVERT_TO_NULL;useSSL=false;characterEncoding=utf8;useUnicode=true;useJDBCCompliantTimezoneShift=true;useLegacyDatetimeCode=false;serverTimezone=Europe/Madrid"/>

I am developing a Primefaces 6.2 application in which I use the datatable component in edit mode.

<p:remoteCommand name="refrescarTabla"
    actionListener="#{bean.dlgEditar.refrescarTabla}"
    update="pgTabla"/>
    <h:panelGroup id="pgTabla">
         <p:dataTable id="tabla" var="reg"
              value="#{bean.dlgEditar.datos}" editable="true" editMode="cell"
                                     widgetVar="cellDato">
         <p:ajax event="cellEdit"
              listener="#{bean.dlgEditar.alEditarRegistro}"
              oncomplete="refrescarTabla()"/>
        ...
        </p:datatable>
</h:panelGroup>

When I first edit a table cell, the component works correctly.

There are columns that depend on others, so when I make a change in a cell, I have to refresh the table (for this I use the remoteCommand component) to reflect the changes. From this moment the problem appears, and it is that if I try to edit a cell again, said cell loses focus in a matter of less than a second, so I cannot edit the value.

I have seen some recommendations like this post from BalusC on SO: https://stackoverflow.com/a/19927578/2131029 , however I have not been able to solve the problem.

EDITION 1

I just created an example that reproduces the problem: https://github.com/hecnabae/pf-datatable .

The example shows the ingredients of a recipe in table form. The fields it displays are name, amount, and percentage. When editing a field (amount is editable), the remotecommand is launched to update the table.

To reproduce the problem, we simply try to edit the quantity of one ingredient, and then click on the quantity of another ingredient (to edit it as well). We will see the effect of instant loss of focus.

I am trying to configure Tomcat 8.5.9 to boot in persistent session mode and store the session in MySql. For this I have followed the procedure described in the Tomcat documentation :

1. Create the tomcat_sessions table, as indicated in the documentation:

create table tomcat_sessions (
  session_id     varchar(100) not null primary key,
  valid_session  char(1) not null,
  max_inactive   int not null,
  last_access    bigint not null,
  app_name       varchar(255),
  session_data   mediumblob,
  KEY kapp_name(app_name)
);

2. Second, I have inserted the mysql-connector-java-5.1.40-bin.jar library into the tomcat classpath.

3. Finally I have modified the context.xml file as follows:

   <?xml version="1.0" encoding="UTF-8"?>
   <Context>
       <WatchedResource>WEB-INF/web.xml</WatchedResource>
       <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource>
   
       <Manager className="org.apache.catalina.session.PersistentManager"     
       debug="0"
       maxActiveSessions="-1"
       maxIdleBackup="-1"
       minIdleSwap="-1"
       maxIdleSwap="-1"
       processExpiresFrequency="1"
       saveOnRestart='true'
       >
   
           <Store className="org.apache.catalina.session.JDBCStore"        
               connectionName="root"
               connectionPassword="password"
               connectionURL="jdbc:mysql://localhost:3306/tomcat"
               driverName="com.mysql.jdbc.Driver"
               />
   </Manager>
   </Context>
   

When I run Tomcat, I get the following error:

16-Jan-2017 11:55:04.597 GRAVE [localhost-startStop-1] org.apache.catalina.core.StandardContext.startInternal The session manager failed to start
 org.apache.catalina.LifecycleException: Failed to start component [org.apache.catalina.session.PersistentManager[/manager]]
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5206)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:752)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:728)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1107)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1841)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.catalina.LifecycleException: Failed to start component [org.apache.catalina.session.JDBCStore[org.apache.catalina.session.PersistentManager[/manager]]]
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:167)
    at org.apache.catalina.session.PersistentManagerBase.startInternal(PersistentManagerBase.java:847)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    ... 12 more
Caused by: java.lang.NullPointerException
    at org.apache.catalina.session.JDBCStore.open(JDBCStore.java:906)
    at org.apache.catalina.session.JDBCStore.getConnection(JDBCStore.java:839)
    at org.apache.catalina.session.JDBCStore.startInternal(JDBCStore.java:1001)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    ... 14 more

I am developing an application with the following technologies:

• tom cat 8
• java 8
• primefaces 5.2.11

I'm having trouble hiding certain controls depending on the selected value of a SelectOneMenu within a modal dialog. The Primefaces documentation shows a very clear and simple example on how to update the page based on the selected value of the dropdown (although the context of the example is not done within a dialog): http://www.primefaces.org/showcase/ ui/ajax/dropdown.xhtml .

My code is the following:

<p:dialog
        header="Abrir Incidencia"
        id="dlgAbririncidenciaEstados"
        closable="false" closeOnEscape="false"
        width="1060" modal="true"
        widgetVar="dlgAbririncidenciaEstados">
    <h:outputText value="Tipo de incidencia"/>
    <p:selectOneMenu id="selIncidenciaTipoEstados"
        value="#{monitorizadorCentroControlador.abrirIncidenciaBean.incidenciaTipoSeleccionadoId}">
        <f:selectItems
            value="#{monitorizadorCentroControlador.abrirIncidenciaBean.listaIncidenciaTipos}"
            var="incidenciaTipo"
            itemLabel="#{incidenciaTipo.nombre}" itemValue="#{incidenciaTipo.id}"/>
                <p:ajax update="txtOperarioAfectado comboOperarioAfectado"
                        listener="#{monitorizadorCentroControlador.abrirIncidenciaBean.alCambiarTipoIncidencia}"/>
    </p:selectOneMenu>
    <p:outputLabel
        id="txtOperarioAfectado"
        rendered="#{monitorizadorCentroControlador.abrirIncidenciaBean.incidenciaTipoSeleccionadoId == 8}"
        value="#{monitorizadorCentroControlador.abrirIncidenciaBean.incidenciaTipoSeleccionadoId}"/>
    <p:autoComplete
        id="comboOperarioAfectado"
        completeMethod="#{monitorizadorCentroControlador.abrirIncidenciaBean.autocompletarOperario}"
        rendered="#{monitorizadorCentroControlador.abrirIncidenciaBean.incidenciaTipoSeleccionadoId == 8}"
        forceSelection="true"
        value="#{monitorizadorCentroControlador.abrirIncidenciaBean.operarioAfectadoSeleccionadoCodigo}"
        var="codigo" itemLabel="#{codigo}" itemValue="#{codigo}">
        <p:ajax event="itemSelect"
            listener="#{monitorizadorCentroControlador.abrirIncidenciaBean.alCambiarOperario}"
            update="dlgAbririncidenciaEstados"/>
            <p:column>
                <h:outputText value="#{codigo}"/>
            </p:column>
    </p:autoComplete>
</p:dialog>

On the other hand, the ajax event:

public void alCambiarTipoIncidencia(AjaxBehaviorEvent evt) {
    RequestContext.getCurrentInstance().update("dlgAbririncidenciaEstados");
}

My intention is for Primefaces to render the controls txtOperarioAfectadoand comboOperarioAfectadobased on the selected value of selIncidenciaTipoEstados. To test its operation, txtOperarioAfectadoI have assigned the value of incidenciaTipoSeleccionadoId. With the above code snippet that value is not updated. However, if I remove the rendered attribute of the control txtOperarioAfectado, the value is updated, which leads me to think that, at least on the server side, when the value of incidenciaTipoSeleccionadoIdis different from 8, the control is not rendered. However in the client it does not hide it. So my question is how can I hide the controls txtOperarioAfectadoand comboOperarioAfectadowhen the condition is not met monitorizadorCentroControlador.abrirIncidenciaBean.incidenciaTipoSeleccionadoId == 8?

What is the difference between the org.hibernate.Query method setMaxResultsand the setFetchSizeorg.hibernate.Query method?

You can see the original question here .

I am developing an application in JSF in which I use a <h:selectOneListbox .../>. for which I have defined a Converter.

Below I show a simplified block of said control, which contains a panelGridwith a button Guardarand a list selector:

<h:panelGrid cellpadding = "5" columns = "4" >
    <p:commandButton value="Guardar"
        update=":dmContadoresConsumoForm:edicionContadorConsumoPnl"
        disabled="#{!contadoresConsumoBean.contadorCentroEditable}"
        actionListener="#{contadoresConsumoBean.guardarContador}"/>
    <h:outputText value = "Producto" />
    <h:selectOneListbox
        id = "productoSel"
        size = "1"
        value = "#{contadoresConsumoBean.productoSeleccionado}"
        disabled = "#{!contadoresConsumoBean.contadorCentroEditable}"
        style = "width:100%" >
        <f:selectItem itemValue = "0"
            itemLabel = "" / >
        <f:selectItems
            value = "#{contadoresConsumoBean.productos}" 
            var = "producto"
            itemValue = "#{producto.id}"
            itemLabel = "#{producto.nombre}" />
    </h:selectOneListbox>

<!-- ... -->

</h:panelGrid>

I have defined a Converterfor objects of type Producto, whose code is as follows:

@ManagedBean(name = "productoConverter")
@SessionScoped
@FacesConverter(forClass = Producto.class)
public class ProductoConverter implements Converter {

    @Override
    public Object getAsObject(FacesContext context, UIComponent component, String value) {
        long id = -1;
        try{
            id = Long.parseLong(value);
        }
        catch(Exception e){
            return null;
        }
        Transaction t = HibernateUtil.getSessionFactory().getCurrentSession().beginTransaction();
        try{
            Producto e = new ProductoServiceImpl().find(id);
            t.commit();
            return e;
        }
        catch(Exception e){
            t.rollback();
            e.printStackTrace();
            return null;
        }
    }

    @Override
    public String getAsString(FacesContext context, UIComponent component, Object value) {
        if (value instanceof Producto){
            return ((Producto)value).getId().toString();
        }
        return null;
    }
}

The problem is that when I press the button to save changes, I get the error:

dmContadoresConsumoForm:productoSel: Error de validación: el valor no es válido

I've tried debugging Converterit and it seems to work fine.

I have a Java project that I am developing with IntelliJ and Gradle. I have defined the idea block in me build.gradlethat, in short, what it does is download the sources and javadoc of those libraries that are in some maven repository:

idea{
    module {
        downloadJavadoc = true // defaults to false
        downloadSources = true
    }
}

So far everything is correct. However, I have an external library, which is not found in any maven repository. To import this library I have defined, in the repositories block , the libs folder, in which I have dropped the library and its corresponding javadoc.

repositories {
    // repositorios maven
    flatDir {
        dirs 'libs'
    }
}

I have added the corresponding dependencies in the dependencies block . The project compiles correctly and loads the javadoc of those libraries that are downloaded from a maven repository, however it does not load the javadoc of the external library in question. Do I have to somehow define the javadoc of said library in my build.gradle?

Thanks in advance.

I would like to know how I can prevent the control from EditTextdisplaying the keyboard every time it receives focus or the user hovers over the control.

The reason for this is that I want to use said control to show a calendar dialog every time it receives the focus or the user hovers over the control, so that the control will get the value of the date (I already have this last part implemented ).

In principle, according to the Android documentationandroid:inputType="none" , setting the field's type attribute EditTextmakes the text non-editable, so the expected behavior is that the android keyboard is not displayed . However, the keyboard still appears each time the control receives focus or the user clicks on the control.

Here is the xml code to define the control:

<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingLeft="16dp"
    android:paddingRight="16dp">

    <android.support.v4.widget.NestedScrollView
        android:layout_width="match_parent"
        android:layout_height="wrap_content">

        <!-- Controles --> 

        <android.support.design.widget.TextInputLayout
            android:id="@+id/tiFechaCaducidad"
            android:layout_width="match_parent"
            android:layout_height="wrap_content">

            <EditText
                android:id="@+id/etFechaCaducidad"
                android:layout_width="match_parent"
                android:layout_height="wrap_content"
                android:hint="@string/fechacaducidad"
                android:singleLine="true"
                android:inputType="none"
                android:drawableRight="@drawable/ic_arrow_drop_down" />
        </android.support.design.widget.TextInputLayout>

    </android.support.v4.widget.NestedScrollView>
</android.support.design.widget.CoordinatorLayout>

Swagger throws the error TypeError: property is undefinedthrough the Javascript console when it tries to render the "swagger.json" file generated by the swagger-core module that I have integrated into the API that I am developing with Jersey (Java).

It seems that this error has to do with the following method:

public ArrayList<ProductoStock> generarEntradaStock(EntradaRecurso entrada)

If I modify the header of that method so that, for example, it returns a ArrayList<Integer>, swagger-ui correctly generates the documentation.

For the development of this application I am using swagger-core 1.5, specifically the library io.swagger:swagger-jersey-jaxrs:1.5.0for Jersey (Java), which correctly generates the "swagger.json" file, and the latest version of swagger-ui (2.1.3).

I am developing an Android application that contains a dynamically generated menu, so the menu is generated by programming:

private void cargarAvisosMenu() 
{
    // Menu
    final Menu menu = this.mNavigationView.getMenu();


    // Carga de datos
    CentroSelection selection = new CentroSelection();
    CentroCursor cur = selection.query(getApplicationContext().getContentResolver());

    // Recorro el cursor de centros
    while (cur.moveToNext()) {
        boolean avisosTipoA = false;
        boolean avisosTipoB = false;

        Centro c = Centro.getFromCursor(cur);
        if (c.getIsTipoAVisible() && c.getComponenteTipoA().getControlesTipoAPendientes() > 0) {
            avisosTipoA = true;
        }
        if (c.getIsTipoBVisible() && c.getComponenteTipoB().getControlesTipoBPendientes() > 0){
            avisosTipoB = true;
        }

        if (avisosTipoA || avisosTipoB) {
            // Añado la sección y los items.
            final SubMenu subMenu = menu.addSubMenu(c.getNombre());
            if (avisosTipoA) {
                subMenu.add("TipoA").setIcon(R.drawable.ic_tipoA);
            }
            if (avisosTipoB) {
                subMenu.add("TipoB").setIcon(R.drawable.ic_tipoB);
            }
        }
    }
}

My intention is to add a counter indicating the number of notifications (gmail style).

According to the documentation this is possible, either through an xml menu, using the attribute app:actionLayout, or using the function MenuItemCompat.setActionView(). Since the menu that I am developing is dynamic, I have opted for the second option, so that the code would be as follows:

private void cargarAvisosMenu() 
{
    // Menu
    final Menu menu = this.mNavigationView.getMenu();


    // Carga de datos
    CentroSelection selection = new CentroSelection();
    CentroCursor cur = selection.query(getApplicationContext().getContentResolver());

    // Recorro el cursor de centros
    while (cur.moveToNext()) {
        boolean avisosTipoA = false;
        boolean avisosTipoB = false;

        Centro c = Centro.getFromCursor(cur);
        if (c.getIsTipoAVisible() && c.getComponenteTipoA().getControlesTipoAPendientes() > 0) {
            avisosTipoA = true;
        }
        if (c.getIsTipoBVisible() && c.getComponenteTipoB().getControlesTipoBPendientes() > 0){
            avisosTipoB = true;
        }

        if (avisosTipoA || avisosTipoB) {
            // Añado la sección y los items.
            final SubMenu subMenu = menu.addSubMenu(c.getNombre());
            if (avisosTipoA) {
                subMenu.add("TipoA").setIcon(R.drawable.ic_tipoA);
            }
            if (avisosTipoB) {
                // subMenu.add("TipoB").setIcon(R.drawable.ic_tipoB);
                int itemId = subMenu.add("TipoB").getItemId();
                View menuItem = MenuItemCompat.setActionView(subMenu.findItem(itemId), R.layout.menu_notificaciones).getActionView();
                ((ImageView) menuItem.findViewById(R.id.ivMenuNotificaciones)).setBackground(getDrawable(R.drawable.ic_barcode));
                ((TextView) menuItem.findViewById(R.id.tvMenuNotificaciones)).setText("TipoB");
                ((TextView) menuItem.findViewById(R.id.tvContadorNotificaciones)).setText("100");
            }
        }
    }
}

And the "menu_notifications.xml" file:

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingLeft="16dp"
    android:paddingRight="16dp"
    android:orientation="horizontal">
    <ImageView
        android:id="@+id/ivMenuNotificaciones"
        android:layout_width="64dp"
        android:layout_height="match_parent" />
    <TextView
        android:id="@+id/tvMenuNotificaciones"
        android:layout_width="wrap_content"
        android:layout_height="match_parent" />
    <TextView
        android:id="@+id/tvContadorNotificaciones"
        android:layout_width="wrap_content"
        android:layout_height="match_parent"
        android:layout_gravity="right"/>
</LinearLayout>

However the menu does not load the "menu_notifications" view.

Is there a difference between creating an index using the command ensureIndex()and the createIndex()MongoDB command?

When invoking a query with specified name the system throws the exception: org.hibernate.MappingException: Named query not known. I've given it several turns but I can't find where the problem is.

Consumption.java

@Entity
@Table( name = "consumo" )
@NamedQueries( {
        @NamedQuery(
                name = "Consumo.findConsumoPasoHistorico",
                query = "SELECT c FROM Consumo c WHERE c.fecha < :fechaTope ORDER BY c.fecha, c.id" )
} )
public class Consumo implements Serializable {

    @Id
    @Basic( optional = false )
    @Column( name = "id" )
    @GeneratedValue( strategy = GenerationType.IDENTITY )
    private Long id;

    @Temporal( TemporalType.TIMESTAMP )
    @Column( name = "fecha" )
    private Date fecha;

    @Column( name = "valor" )
    private double valor;

    @Temporal( TemporalType.TIMESTAMP )
    @Column( name = "created" )
    private Date created;

    @Temporal( TemporalType.TIMESTAMP )
    @Column( name = "updated" )
    private Date updated;

    //Getters y setters
}

The method from which I call the function:

public List<Consumo> findConsumoPasoHistorico(Date fechaTope) {
    Query query = getSession().getNamedQuery("Consumo.findConsumoPasoHistorico");
    query.setParameter("fechaTope", fechaTope);
    return query.list();
}

I have made sure that the configuration file hibernate.cfg.xmlcontains the reference to map the Consumption class:

<mapping class="es.kestrel.monitorizador.modelo.Consumo"/>