Questions[hibernate]

I have two tables in the database, one COUNTRIES and the other CITIES, they have a relationship of ONE to MANY, a country has many cities. I require a query that obtains all the countries with their cities, but if the country does not have associated cities, it should also be in the response of the query. I am doing the following query

select distinct p FROM Pais p LEFT JOIN p.ciudades c

This query meets the objective, however when I look at the log I find that n + 1queries are made according to the number of existing countries. To avoid multiple queries I do afetch join

select distinct p FROM Pais p JOIN FETCH p.ciudades

With this sentence, when looking at the log, you only see one query made, this reduces nthe number of queries made with respect to the previous sentence, but it does not bring me the countries that do not have associated cities.

How can I bring the countries that do not have associated cities but in such a way that only one query is made and not n +1queries?

I'm trying to load values ​​to a select (or likebobox) dynamically from the server side with Spring Boot. I am also validating this form with the help of Hibernate Validator.

I'm having a very annoying problem that I can't explain why it's happening. In my form I have two comboboxes (or select), the first one is setting the values, while the second one (the dynamic one) is not. I even tried to put everything manually, but the annoying problem persists.

   <form:form id="form" modelAttribute="nuevoEvento" method="POST">
    <div class="containerLeft">
        <table>
                <tbody>
                    <tr>
                        <td><Label>Nombre del evento</Label></td>
                        <td><form:input type="text" path="titulo" /></td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="titulo"/></td></tr>
                    <tr>
                        <td><Label>Tipo de Evento</Label></td>
                        <td><form:select class="combobox" path="tipoEvento">
                                <form:option value="N/A">Seleccione el tipo</form:option>
                                <form:option value="Importante">Importante</form:option>
                                <form:option value="Informativo">Informativo</form:option>
                                <form:option value="Privado">Privado</form:option>
                            </form:select></td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="tipoEvento"/></td></tr>
                    <tr>
                        <td><Label>Salon del evento</Label></td>
                        <td>
                        <form:select class="combobox" path="salonId">
                            <form:options items="${listaSalones}"></form:options>
                        </form:select>
                        </td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="salonId"/></td></tr>
                    <tr>
                        <td><Label>Dia del evento</Label></td>
                        <td><form:input type="text" path="fechaEvento" id="txtfecha" readonly="readonly"/></td>
                    </tr>
                    <tr><td colspan=2 style="text-align:center;color:#84FCFF;"><form:errors path="fechaEvento"/></td></tr>
                </tbody>
            </table>
            <input type="hidden" name="usuario" value="${principal.name}" />

The model class of this form is the following:

@TimeRangeConstraints.List({
@TimeRangeConstraints(
    fechaEvento="fechaEvento",
    horaInicio="horaInicio",
    horaCulminacion="horaCulminacion"
)
})
public class NuevoEvento {
@NotEmpty(message="Como se llamara el evento?")
@Size(max=40, message="Titulo invalido")
private String titulo;
@StringComboBoxConstraints
private String tipoEvento;
private String salonId;
private String url;
@NotEmpty(message="Seleccione la fecha del evento")
private String fechaEvento;
@NotEmpty(message="A que hora inicia el evento?")
private String horaInicio;
@NotEmpty(message="A que hora termina el evento?")
private String horaCulminacion;

public NuevoEvento() {}

public String getTitulo() {
    return titulo;
}

public void setTitulo(String titulo) {
    this.titulo = titulo;
}

public String getTipoEvento() {
    return tipoEvento;
}

public void setTipoEvento(String tipoEvento) {
    this.tipoEvento = tipoEvento;
}

public String getUrl() {
    return url;
}

public void setUrl(String url) {
    this.url = url;
}

public String getFechaEvento() {
    return fechaEvento;
}

public void setFechaEvento(String fechaEvento) {
    this.fechaEvento = fechaEvento;
}

public String getHoraInicio() {
    return horaInicio;
}

public void setHoraInicio(String horaInicio) {
    this.horaInicio = horaInicio;
}

public String getHoraCulminacion() {
    return horaCulminacion;
}

public void setHoraCulminacion(String horaCulminacion) {
    this.horaCulminacion = horaCulminacion;
}

public String getSalonId() {
    return salonId;
}

public void setSalon(String salon) {
    this.salonId = salon;
}

}

The attribute that is bothering is salonId... now, how am I loading those elements? Here they are, from the controller:

@Controller
@RequestMapping("/usuarios")
public class UserController {

@Autowired
SalonRepository salon;
@Autowired
UsuarioSalonRepository userSalon;

@GetMapping("/home")
public String goHome(Model model, Principal principal) {
    System.out.println(principal.getName() + " HA INICIADO SESION!!!");
    User logueado = (User)((Authentication)principal).getPrincipal();
    String userInfo = WebUtils.toString(logueado);
    model.addAttribute("userInfo",userInfo);
    model.addAttribute("principal",principal);
    return "/basics/home";
}

@GetMapping("/crearEvento")
public String irCrear(Model model, Principal principal) {
    model.addAttribute("nuevoEvento",new NuevoEvento());
    model.addAttribute("principal",principal);
    model.addAttribute("listaSalones",getSalones());
    return "/Usuarios/crearEvento";
}

@PostMapping("/crearEvento")
public String crearEvento(@Valid NuevoEvento nuevoEvento, BindingResult result,
        Model model, Principal principal) {
    System.out.println("CONTROLSITO: " + nuevoEvento.getSalonId());
    System.out.println("Nombre: " + nuevoEvento.getTitulo());
    System.out.println("Tipo: " + nuevoEvento.getTipoEvento());
    System.out.println("Id Salon: " + nuevoEvento.getSalonId());
    System.out.println("Dia: " + nuevoEvento.getFechaEvento());
    System.out.println("Hora Inicio: " + nuevoEvento.getHoraInicio());
    System.out.println("Hora Fin: " + nuevoEvento.getHoraCulminacion());
    System.out.println("URL: " + nuevoEvento.getUrl());
    if(result.hasErrors()) {
        model.addAttribute("principal",principal);
        return "/Usuarios/crearEvento";
    }else
        return "index";
}

@RequestMapping("/misEventos")
public String misEventos(Model model, Principal principal) {
    return "/Usuarios/misEventos";
}

@RequestMapping("/editarEvento")
public String irEditar(Model model, Principal principal) {
    return "/Usuarios/editarEvento";
}

@RequestMapping("/borrarEvento")
public String irBorrar(Model model, Principal principal) {
    return "/Usuarios/borrarEvento";
}

public Map<Integer,String> getSalones(){
    Map<Integer,String> salones = new LinkedHashMap<Integer,String>();
    Iterable<Salon> ls = salon.findAll();
    salones.put(0, "Seleccione un salon");
    int i = 1;
    for(Salon salon: ls) {
        salones.put(i, salon.getNombre());
        i++;
    }
    return salones;
}

}

If I submit, you can view the data that you enter, but not that of that "salonId" select...

It must be a silly mistake, but believe me I can't see where this is wrong

I need a couple of exclusive Queries to check an "availability" factor within a db.

The query is okay so far I have been raising it in various ways and I think this is the most correct but it keeps giving me an error

    from Usuario judge where judge.juez = 1 and judge.idusuario  not in Usuariomaraton

Could someone tell me what is wrong with the query that is why I am not able to extract what I am looking for (All users that have judge value 1 and are not in the Usuariomaraton table).

I want to create an entity on which inserts or updates of any kind should not be made, I can think of two ways to do this:

Using insertable=false and updatable=false tag on each column

@Entity
@Table(name = users)
class Users {
    @Column(name= 'name' insertable=false, updatable=false)
    String name;
}

I don't like this although it works because I have to put those labels in all the columns and I would like to do it at the class level, for this I can think of using the @Inmutable annotation of hibernate

@Entity
@Inmutable
@Table(name = users)
class Users {
    @Column(name= 'name')
    String name;
}

This tag allows me to do a get on the entity but not be able to modify those values ​​later.

Does the immutable tag override hibernate persistence or can it be saved somehow? Is there any other tag that I can use at the class level in an entity that allows me to modify objects of the entity but not insert or update in the database?

I am developing a Java Web application with Spring MVC and Hibernate, I am new to developing with these frameworks and I am trying to list some records but I get the following:

org.hibernate.HibernateException: getCriteriaBuilder is not valid without active transaction

Complete exception:

org.hibernate.HibernateException: getCriteriaBuilder is not valid without active transaction
at org.hibernate.context.internal.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:351)
at com.sun.proxy.$Proxy36.getCriteriaBuilder(Unknown Source)
at com.edwin.spring.dao.PersonDAOImpl.listPersons(PersonDAOImpl.java:34)
at com.edwin.spring.service.PersonServiceImpl.listPersons(PersonServiceImpl.java:31)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
at com.sun.proxy.$Proxy35.listPersons(Unknown Source)
at com.edwin.spring.controllers.PersonController.list(PersonController.java:35)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:625)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1372)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)

The exception is thrown in the PersonDAOImpl class in this line

CriteriaBuilder builder = sessionFactory.getCurrentSession().getCriteriaBuilder();

PersonDAOImpl.java

@Repository("personDao")
public class PersonDAOImpl implements PersonDAO {

    @Autowired
    private SessionFactory sessionFactory;

    @Override
    public void save(Person person) {
        sessionFactory.getCurrentSession().saveOrUpdate(person);
    }

    @Override
    public void delete(Person person) {
        sessionFactory.getCurrentSession().delete(person);
    }

    @Override
    public List<Person> listPersons() {
        CriteriaBuilder builder = sessionFactory.getCurrentSession().getCriteriaBuilder();
        CriteriaQuery<Person> criteria = builder.createQuery(Person.class);
        Root<Person> employeeRoot=criteria.from(Person.class);
        criteria.select(employeeRoot);
        return sessionFactory.getCurrentSession().createQuery(criteria).getResultList();
    }
}

It doesn't seem to work because the call is not in a transaction but I use the @TransactionalSpring annotation on the Service:

@Service
@Transactional
public class PersonServiceImpl implements PersonService {

    @Autowired
    private PersonDAO personDao;

     @Override
     public void save(Person person) {
         personDao.save(person);
     }

     @Override
     public void delete(Person person) {
         personDao.delete(person);
     }

     @Override
     public List<Person> listPersons() {
         return personDao.listPersons();
     }

     @Override
     public Person getById(Integer id) {
         return personDao.getById(id);
     }

}

This is the controller

@Controller
@RequestMapping("/persons")
public class PersonController {
    private static final Logger logger = LoggerFactory.getLogger(PersonController.class);

    @Autowired
    private PersonService personService;

    @RequestMapping(value = {"/", "/all", "/list"}, method = RequestMethod.GET)
    public String list(Model model) {
        logger.info("Se ingresa al método de listar personas");
        List<Person> persons = personService.listPersons();
        logger.info("listando personas, hay un total de " + persons.size());
        model.addAttribute("persons", persons.size());
        return "persons";
    }
}

This is the web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">

<!-- The definition of the Root Spring Container shared by all Servlets 
    and Filters -->
<context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>/WEB-INF/spring/root-context.xml</param-value>
</context-param>

<!-- Creates the Spring Container shared by all Servlets and Filters -->
<listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<!-- Processes application requests -->
<servlet>
    <servlet-name>appServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
</servlet>

<servlet-mapping>
    <servlet-name>appServlet</servlet-name>
    <url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>

The servlet-contex.xml file

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

<!-- DispatcherServlet Context: defines this servlet's request-processing 
    infrastructure -->

<!-- Enables the Spring MVC @Controller programming model -->
<annotation-driven />

<!-- Handles HTTP GET requests for /resources/** by efficiently serving 
    up static resources in the ${webappRoot}/resources directory -->
<resources mapping="/resources/**" location="/resources/" />

<!-- Resolves views selected for rendering by @Controllers to .jsp resources 
    in the /WEB-INF/views directory -->
<beans:bean
    class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <beans:property name="prefix" value="/WEB-INF/views/" />
    <beans:property name="suffix" value=".jsp" />
</beans:bean>

<context:component-scan base-package="com.edwin.spring" />

<!-- Datasource -->
<context:property-placeholder location="classpath:hibernate.properties" />

<beans:bean
    class="org.springframework.jdbc.datasource.DriverManagerDataSource"
    id="dataSource">
    <beans:property name="driverClassName" value="${jdbc.driver}" />
    <beans:property name="url" value="${jdbc.url}" />
    <beans:property name="username" value="${jdbc.user}" />
    <beans:property name="password" value="${jdbc.password}" />
</beans:bean>

<!--SessionFactory -->
<beans:bean id="hibernateSessionFactory"
    class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
    <beans:property name="dataSource" value="#{dataSource}" />
    <beans:property name="packagesToScan" value="com.edwin.spring.model" />
    <beans:property name="hibernateProperties">
        <beans:props>
            <beans:prop key="hibernate.dialect">${hibernate.dialect}</beans:prop>
            <beans:prop key="hibernate.connection.pool_size">1</beans:prop>
            <beans:prop key="hibernate.show_sql">${hibernate.show_sql}</beans:prop>
            <beans:prop key="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory
            </beans:prop>
            <!--<prop key="hibernate.hbm2ddl.auto">create-drop</prop> -->
            <beans:prop key="hibernate.format_sql">true</beans:prop>
            <beans:prop key="hibernate.generate_statistics">true</beans:prop>
            <beans:prop key="hibernate.use_sql_comments">true</beans:prop>
            <beans:prop key="hibernate.current_session_context_class">thread</beans:prop>
            <beans:prop key="hibernate.cglib.use_reflection_optimizer">true</beans:prop>
            <beans:prop key="hibernate.hibernate.cache.use_query_cache">true</beans:prop>
            <beans:prop key="hibernate.enable_lazy_load_no_trans">true</beans:prop>
            <beans:prop key="hibernate.transaction.flush_before_completion">true</beans:prop>
        </beans:props>
    </beans:property>
</beans:bean>

<tx:annotation-driven transaction-manager="transactionManager"/>

<beans:bean class="org.springframework.orm.hibernate5.HibernateTransactionManager"
    id="transactionManager">
    <beans:property name="sessionFactory" ref="hibernateSessionFactory"/>
</beans:bean>

</beans:beans>

And finally the hibernate.properties file that is in src/main/resources

#DB properties:
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring
jdbc.user=root
jdbc.password=1234

#Hibernate Configuration:
hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect
hibernate.show_sql=true
hibernate.format_sql=true

I have tried to place the @Transactionalin the method directly and it hasn't worked either, I don't know what is happening or if something is misconfigured, thanks in advance :).