Hibernate generates UUID attribute instead of daterange []

It must be premised that I did not want the range2 sub-table, because I have the Parlamentari table, with a “periodo_cariche” attribute of type Range < LocalDate > [], but I was told to map Parlamentari it in this way and hibernate generates the range2 table for me with redundant attributes that every time I have to delete by hand and the range attribute is not of the right type, but it generates a uuid for me, and therefore I cannot populate it, The execution starts, but when I insert in the browser url l 'address http: // localhost: 80 …, tells me that the query did not produce results, because, I suppose, range2 is empty, while the Parlamentari table is populated. In the database the “parlamentari” table contains the “periodo_cariche” attribute which is of type daterange[]. I am using the Spring Boot ide,

Update: I have manually modified the range2 table in the database by setting the type daterange [] for the range attribute. I entered the tuple and the error remained the same. Looking closer at the stackstrace, I found this error: STACKTRACE:

at 
com.giuggiola.controller.ParlamentareController.
home(ParlamentareController.java:33)

which corresponds to the line of code:

        Iterable<Parlamentare> parlamentari = parlamRepo.findAll();

While debugging I couldn’t figure out where the error is, so I think the error is in the jsp page, however I also put the controller class and the repository

OUTPUT BROWSER:

Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a 
fallback.

Thu May 05 14:39:31 CEST 2022
There was an unexpected error (type=Internal Server Error, status=500).
java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato 
è stato restituito dalla query.; nested exception is org.hibernate.HibernateException: 
java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato 
 è stato restituito dalla query.

Parlamentare.java

@Component
@Entity//(name = "Parlamentare")
@Table(name = "parlamentari")
@Data
@AllArgsConstructor
//@NoArgsConstructor
//@IdClass(PK.class)

@TypeDef(
    typeClass = PostgreSQLRangeType.class,
    defaultForType = Range.class
)
@TypeDef(
    name = "list-array",
    typeClass = ListArrayType.class
)
@TypeDef(
    name = "string-array", 
    typeClass = StringArrayType.class
)

//@IdClass(PK.class)
public class Parlamentare implements Serializable{

static final long serialVersionUID = 1;

@EmbeddedId
private PK pk;
//se tieni @embeddedId devi togliere i tre seguenti campi @id e commentarli
//se metti @idclass, togli embedded
/*
@Id
@Column(name = "nome")
 String nome;

@Id
@Column(name = "partito")
 String partito;

@Id
@Column(name = "circoscrizione")
 String circoscrizione;
*/
@Column(name = "data_nascita")
 Date data_nascita; 

@Column(name = "luogo")
 String luogo; 

@Column(name = "titolo_studi")
 String titolo_studi;

/*@Type( type = "string-array" )
@Column(
    name = "sensor_names", 
    columnDefinition = "text[]"
)
private String[] sensorNames;*/

@Type( type = "string-array" )
@Column(
    name = "mandati", 
    columnDefinition = "text[]"
)
private String[] mandati;

/*
@Column(name = "mandati")
 String[] mandati; 
*/

@Type( type = "string-array" )
@Column(
    name = "commissioni", 
    columnDefinition = "text[]"
)
private String[] commissioni;
/*
@Column(name = "commissioni")
 String[] commissioni;
 */
// cascade = CascadeType.ALL, 
    // orphanRemoval = true,
    // fetch=FetchType.EAGER)
//fetch=FetchType.EAGER)
//cascade = CascadeType.ALL, orphanRemoval = true)
//targetEntity = Range2.class,fetch=FetchType.EAGER)
/*
@Autowired
@OneToMany(mappedBy="parlamentare", targetEntity = Range2.class)
 @ElementCollection
 @CollectionTable(name = "parlamentari", joinColumns=@JoinColumn(name="parlamentare"))
 @Column(name="periodi_cariche")
 *//*
@ManyToMany(mappedBy="range", targetEntity=Range2.class)
@Type(type = "list-array")
@Column(
    name = "periodi_cariche",
    columnDefinition = "daterange[]"
)
private List<Range<LocalDate>> periodi_cariche = new ArrayList<Range<LocalDate>>();
 */

/*@JoinTable(name="Parlamentare_Range", joinColumns={@JoinColumn(name ="pkId", 
referencedColumnName ="pk")},
inverseJoinColumns={@JoinColumn(name ="pk_rid", referencedColumnName ="pk")})*/
  //(cascade=CascadeType.ALL, targetEntity=CoachGroup.class)

//-----------------------------------------------------------------------------

//  @OneToMany(mappedBy="parlamentare",  cascade=CascadeType.ALL, orphanRemoval=true, 
 // targetEntity=Range2.class)
 /* @JoinColumn(name="pk", referencedColumnName ="pk")
  @JoinTable(name="Range2", joinColumns={
          @JoinColumn(name ="nome", referencedColumnName ="nome"),
          @JoinColumn(name ="partito", referencedColumnName ="partito"),
          @JoinColumn(name ="circoscrizione", referencedColumnName ="circoscrizione"),
          @JoinColumn(name ="range")
                                        }
          )*/
  
  //--------------------------------------------------------------------------------------
/*  @JoinTable(name="Range2", joinColumns={@JoinColumn(name ="nome", 
 referencedColumnName ="nome"),
          @JoinColumn(name ="partito", referencedColumnName ="partito"),
          @JoinColumn(name ="circoscrizione", referencedColumnName ="circoscrizione"),
          @JoinColumn(name ="range")
  },
    inverseJoinColumns={@JoinColumn(name ="range", referencedColumnName ="range")})
    */
 /* @JoinTable(name="Parlamentare_Range", joinColumns={@JoinColumn(name ="range", 
 referencedColumnName ="range")},
    inverseJoinColumns={@JoinColumn(name ="periodi_cariche", referencedColumnName 
="periodi_cariche")})
    */
// @JoinColumn(name="range")
  //@EmbeddedId
//  private Range<LocalDate>[] periodi_cariche = new Range<LocalDate>[];
  


//-------------------------------------------------------------------------------
@OneToMany(mappedBy="parlamentare",  cascade=CascadeType.ALL, orphanRemoval=true, 
targetEntity=Range2.class)
  @Type(type = "list-array")
    @Column(
        name = "periodi_cariche",
        columnDefinition = "daterange[]"
    )
    private List<Range<LocalDate>> periodi_cariche = new ArrayList<Range<LocalDate>>();

Range2.java

@Entity
public class Range2 extends PostgreSQLRangeType
{

static final long serialVersionUID  = 1;

@EmbeddedId
@JoinTable(name="parlamentari",
joinColumns={
      @JoinColumn(name = "nome", insertable = false, updatable = false),
      @JoinColumn(name = "partito", insertable = false, updatable = false),
      @JoinColumn(name = "circoscrizione", insertable = false, updatable = false),
    })
//@ManyToOne(fetch=FetchType.LAZY, targetEntity=Parlamentare.class)
private PK pk;


//  @ManyToOne(cascade=CascadeType.PERSIST, 
targetEntity=Parlamentare.class)//cascade=CascadeType.ALL,

@ManyToOne(fetch=FetchType.LAZY, targetEntity=Parlamentare.class)
//@JoinTable(name="parlamentari",joinColumns={@JoinColumn(name="periodi_cariche", 
referencedColumnName="parlamentare")})
//  private Range<LocalDate> range;
private Parlamentare parlamentare;



private Range<LocalDate> range;


public Range<LocalDate> getRange() {
    return range;
}


public void setRange(Range<LocalDate> range) {
    this.range = range;
}


public // <T extends LocalDate> 
Range2(
        //T arg
        ) {
    //super(Range.class);
    new PostgreSQLRangeType();
    //Range<LocalDate> range ;//= new Range<LocalDate>();
}

PK.java

@Component
@Data
@AllArgsConstructor
@NoArgsConstructor
@EqualsAndHashCode
@Embeddable
@TypeDef(
    name = "string-array", 
    typeClass = StringArrayType.class
)
public class PK implements Serializable {

private static final long serialVersionUID = 1;

@Column(name="nome", nullable=false)
protected String nome;

@Column(name="partito", nullable=false)
protected String partito;

@Type( type = "string-array" )
@Column(
    name = "circoscrizione", 
    columnDefinition = "text[]"
)
private String[] circoscrizione;
...

[![table parlamentari][1]][1][![range2][2]][2][![periodo_cariche][3]][3]


APPLICATION.PROPERTIES

    
    server.port=****
    spring.mvc.view.prefix=/src/main/webapp/
    spring.mvc.view.suffix=.jsp

    spring.sql.init.platform=postgres
    spring.datasource.url=jdbc:postgresql://localhost:****/Parlamento
    spring.datasource.username=postgres
    spring.jpa.properties.hibernate.dialect = 
    org.hibernate.dialect.PostgreSQL10Dialect
    #spring.jpa.hibernate.ddl-auto=none
    spring.jpa.hibernate.ddl-auto = update
    spring.jpa.hibernate.use-new-id-generator-mappings=true
    spring.jpa.show-sql=true
   
   
 spring.jpa.properties.hibernate.jdbc.lob.non_contextual_creation=true

    spring.datasource.password=****
    spring.jpa.properties.hibernate.format_sql=true
    #spring.sql.init.mode=always
    #spring.sql.init.schema-locations=classpath:/schema.sql
    spring.sql.init.continue-on-error=true
    spring.profiles.active=@spring.profiles.active@
    logging.level.org.springframework.web: DEBUG

    # Keep the connection alive if idle for a long time (needed in 
    production)
    #spring.datasource.testWhileIdle = true
    spring.datasource.tomcat.abandon-when-percentage-full=1
    #spring.datasource.validationQuery = SELECT 1

    spring.datasource.xa.data-source-class-name= SELECT 1

    #spring.datasource.url=jdbc:postgresql://HOST:PORT/activitydb
    #spring.datasource.username=activityman
    #spring.datasource.password=activitymanpasses
    spring.jpa.database- 
    platform=org.hibernate.dialect.PostgreSQL10Dialect
    #spring.jpa.generate-ddl=true
     spring.main.allow-bean-definition-overriding=true

     #spring.datasource.type=org.apache.commons.dbcp.BasicDataSource
    spring.datasource.type=com.zaxxer.hikari.HikariDataSource

    #server.servlet.context-path=/
    #server.error.whitelabel.enabled=false


pom.xml
 

    <?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" 
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 
    https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.5.4</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.giuggiola</groupId>
	<artifactId>Parlamento</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>bootjpa</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>16</java.version>
	</properties>
	
	<dependencies>
	
	
	<!-- https://mvnrepository.com/artifact/com.zaxxer/HikariCP -->
    <dependency>
    <groupId>com.zaxxer</groupId>
    <artifactId>HikariCP</artifactId>
    <version>5.0.1</version>
    </dependency>
	
	
	
	<!-- 
    https://mvnrepository.com/artifact/org.springframework.boot/spring- 
    boot-starter-data-elasticsearch -->
    <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-elasticsearch</artifactId>
    <!--   <scope>runtime</scope>-->
     <version>2.6.3</version> 
    </dependency>
	
	
	
	


	
	
	
	
	
	<dependency>
    <groupId>com.google.guava</groupId>
    <artifactId>guava</artifactId>
    <version>19.0</version>
    </dependency>

	
	
    <!-- 
    https://mvnrepository.com/artifact/org.springframework.boot/spring- 
    boot-devtools -->
    <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-devtools</artifactId>
        <version>2.6.2</version>
    
    </dependency>
	
	  
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
	
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.postgresql</groupId>
			<artifactId>postgresql</artifactId>
			<scope>runtime</scope>
		</dependency>
		
		
		
		
		
		<dependency>
    <groupId>com.vladmihalcea</groupId>
    <artifactId>hibernate-types-55</artifactId>
    <version>2.14.0</version>
      </dependency> 
		
		<!-- 
     https://mvnrepository.com/artifact/org.apache.tomcat/tomcat-jasper 
     -->
    <dependency>
    <groupId>org.apache.tomcat</groupId>
    <artifactId>tomcat-jasper</artifactId>
    <version>9.0.52</version>
    </dependency>



    <!-- Thanks for using https://jar-download.com -->

    <dependency>
    <groupId>org.apache.tomcat.embed</groupId>
    <artifactId>tomcat-embed-jasper</artifactId>
    <scope>provided</scope>
    </dependency>

    <dependency>
    <groupId>javax.servlet</groupId>
    <artifactId>jstl</artifactId>
    </dependency>
		
		<!-- 
     https://mvnrepository.com/artifact/org.projectlombok/lombok -->
    <dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.22</version>
    <scope>provided</scope>
    </dependency>
 
    <dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok-maven</artifactId>
    <version>1.18.20.0</version>
    <type>pom</type>
       </dependency>


    <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <version>2.6.4</version>
    <scope>test</scope>
    </dependency>

    <!-- 
     
    https://mvnrepository.com/artifact/org.springframework.boot/spring- 
    boot-starter-parent -->
    <dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.6.4</version>
    <type>pom</type>
    </dependency>

	</dependencies>	
	
 
  	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
		
		
		
      <resources>
        <resource>
            <directory>src/main/resources</directory>
            <filtering>true</filtering>
        </resource>
     </resources>
   

	 </build>

    </project>

ParlamentareController.java

    @Controller
    @ComponentScan({"com.giuggiola.controller"})//poi toglilo
    public class ParlamentareController //extends 
    AbstractController<Parlamentare>
    {

	@Autowired
	 ParlamentareRepository parlamRepo;	
	
	//@RequestMapping("/parlamentari")
	@RequestMapping("/")
	public ModelAndView home(Parlamentare parlamentare) 
	{	
		ModelAndView mv= new ModelAndView();
		Iterable<Parlamentare> parlamentari = parlamRepo.findAll();
		mv.addObject("parlamentari",parlamentari);
		mv.setViewName("parlamentari.jsp");
		return mv;//"home.jsp";
	}
	
	@RequestMapping("/addParlamentare")
	@ResponseBody
	public ModelAndView addParlamentare(Parlamentare parlamentare)
	{
		ModelAndView mv = new ModelAndView();
		parlamRepo.save(parlamentare);
		mv.addObject("parlamentare",parlamentare);
		mv.setViewName("showParlamentare.jsp");
		return mv;//"home.jsp";	
	}
	
	//modifica 7-5-22 : ho messo PK pk al mosto di string nome negli 
    argomenti di input
	@RequestMapping("/getParlamentare")
	public ModelAndView getParlamentare(@RequestParam PK pk)
	{
		ModelAndView mv = new ModelAndView();
		Parlamentare parlamentare = 
     parlamRepo.findByPk(pk);//.orElse(new Parlamentare());
		mv.setViewName("showParlamentare.jsp");
		mv.addObject(parlamentare);
		return mv;	
	}	
	
	@RequestMapping("/getParlamentare3")
	public ModelAndView getParlamentare3(@RequestParam String partito)
	{
		ModelAndView mv = new ModelAndView();
		List<Parlamentare> parlamentari = 
     parlamRepo.findByPartito(partito);
		System.out.println(parlamRepo.findByPartito(partito));
		mv.addObject(parlamentari);
		mv.setViewName("lista_parlamentari.jsp");
		return mv;	
	}
	
	@RequestMapping("/getParlamentare4")
	public ModelAndView getParlamentare4(@RequestParam String[] 
     circoscrizione)
	{
		ModelAndView mv = new ModelAndView();
		List<Parlamentare> parlamentari = 
     parlamRepo.findByCircoscrizione(circoscrizione);
		 
    System.out.println(
     parlamRepo.findByCircoscrizione(circoscrizione));
		mv.addObject(parlamentari);
		mv.setViewName("lista_parlamentari.jsp");
		return mv;	
	}
	
	@RequestMapping("/updateParlamentare")//modificche con pk
	public ModelAndView updateParlamentare(@RequestParam PK pk, 
    Parlamentare nuovoparlamentare)
	{
		ModelAndView mv = new ModelAndView();
		Parlamentare vecchioparlamentare = 
     parlamRepo.findByPk(pk);//.orElse(null);
		parlamRepo.delete(vecchioparlamentare);
		
		if((pk.getNome()==nuovoparlamentare.getNome()) && 
     (pk.getPartito()==nuovoparlamentare.getPartito()) && 
     (pk.getCircoscrizione()==nuovoparlamentare.getCircoscrizione()))
		parlamRepo.save(nuovoparlamentare);
		Parlamentare parlamentare = nuovoparlamentare;
		mv.addObject(parlamentare);
		mv.setViewName("showParlamentare.jsp");
		return mv;	
	}
	
	
	@RequestMapping("/deleteParlamentare")
	public ModelAndView deleteParlamentare(Parlamentare parlamentare)
	{
		ModelAndView mv = new ModelAndView();
		parlamRepo.delete(parlamentare);
		Iterable<Parlamentare> parlamentari = parlamRepo.findAll();
		mv.addObject("parlamentari",parlamentari);
		mv.setViewName("parlamentareDeleted.jsp");
		return mv;	
	}	
	
	@RequestMapping("/parlamentari")//modifica /getparlamentari in 
    /parlamentari
	@ResponseBody
	public  ModelAndView getParlamentari() 
	{		
		ModelAndView mv = new ModelAndView();
		Iterable<Parlamentare> parlamentari = parlamRepo.findAll();
		mv.addObject("parlamentari",parlamentari);
        mv.setViewName("lista_parlamentari.jsp");	
        return mv;
	}
	
	
	@RequestMapping("/parlamentare/{nome}")
	@ResponseBody
	public Parlamentare getParlamentare5(@PathVariable("nome") String 
    nome) { 
		
		return parlamRepo.findByNome(nome);
	}

ParlamentareRepository.java

    @Repository
    //@Qualifier(value = "parlamRepo")
    public interface ParlamentareRepository extends 
    JpaRepository<Parlamentare, PK>{ //CrudRepository<Parlamentare,PK>
    //CrudRepository<Parlamentare,PK>{
	/*
	@PersistenceContext
	public EntityManager entityManager;
	*/
	@Query(value="select nome from Parlamentari where nome=?1 order by 
    nome",nativeQuery = true)
    public Parlamentare findByNome(String nome);
    
    @Query(value="select pk from Parlamentari where circoscrizione=?1 
    order by pk",nativeQuery = true)
    public Parlamentare findByPk(PK pk);
	
    @Query(value="select nome from Parlamentari where partito=?1 order 
    by nome",nativeQuery = true)
	public List<Parlamentare> findByPartito(String partito);
	
	@Query(value="select nome from Parlamentari where circoscrizione=?1 
    order by nome",nativeQuery = true)
	public List<Parlamentare> findByCircoscrizione(String[] 
    circoscrizione);//@Query
	
    }	
    }

[![structure of project][4]][4]


  [1]: https://i.stack.imgur.com/m1I4h.png
  [2]: https://i.stack.imgur.com/4Z2y7.png
  [3]: https://i.stack.imgur.com/fmrH1.png
  [4]: https://i.stack.imgur.com/34Zg2.png

parlamentari.jsp

    <%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" isELIgnored="false"%> 
    
    <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <!DOCTYPE html>

    <html>
     <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO- 
   8859-1">
    <!--  <meta charset="ISO-8859-1"> -->

    <title>Parlamentari</title>
     <%@ page isELIgnored="false"%>
    <script src="<c:url value="/resources/js/jquery-1.11.1.min.js" />"> 
    </script>
    <script src="<c:url value="/resources/js/bootstrap.min.js" />"> 
    </script>
    </head>
    <body>
    <h2>Aggiungi un parlamentare</h2>
    <form action="addParlamentare">
    <table>
     <tr>
       <td>Nome:</td>
       <td><input type="text" name="nome"><br></td>
     </tr>
     <tr>
         <td>Partito:</td>
       <td><input type="text" name="partito"><br></td>
      </tr>
      <tr>
      <td>Circoscrizione:</td>
      <td><input type="text" name="circoscrizione"><br></td>
      </tr>
      <tr>
      <td>Data di nascita:</td>
      <td><input type="text" name="data_nascita"><br></td>
     </tr>
     <tr>
     <td>Luogo:</td>
     <td><input type="text" name="luogo"><br></td>
     </tr>
     <tr>
       <td>Titolo di studi:</td>
     <td><input type="text" name="titolo_studi"><br></td>
     </tr>
     <tr>
        <td>Mandati:</td> 
        <c:forEach items="${parlamentari.mandati}" 
    var="parlamentare.mandati">
       <table>
        <tr>
       <td>Mandato:</td> 
     <!--   <td><c:import value="${parlamentare.mandati}"/></td> --> 
        <td><input type="text" name="parlamentare.mandati"><br></td>
       </tr>
       </table>
       </c:forEach>
        <!-- <input type="text" name="mandati"><br> -->
     </tr> 
     <tr>
     <td>Commissioni:</td>
     <c:forEach items="${parlamentari.commissioni}" 
    var="parlamentare.commissioni">
       <table>
        <tr>
       <td>Commissione:</td> 
      <!--  <td><c:import value="${parlamentare.commissione}"/></td> -->  
       <td><input type="text" name="parlamentare.commissioni"><br></td>
       </tr>
       </table>
       </c:forEach>
     <!--  
     <td><input type="text" name="commissioni"><br></td>
     -->
     </tr>
     <tr>
     <td>Periodi delle cariche:</td>
      <c:forEach items="${parlamentari.periodi_cariche}" 
    var="parlamentare.periodi_cariche">
       <table>
        <tr>
       <td>Periodi cariche:</td> 
      <!--    <td><c:import value="${parlamentare.periodi_cariche}"/> 
    </td>  -->
          <td><input type="text" name="parlamentare.periodo_carica"> 
    <br></td>
       </tr>
       </table>
       </c:forEach>
     <!--  
    <td><input type="text" name="periodi_cariche"><br></td>
    -->
    </tr>
    <tr>
     <td> <input type="submit"><br></td>
     </tr>
     </table>
    </form>

    <h2>Leggi un parlamentare:</h2>
    <form action="getParlamentare">
    <table>
    <tr>
      <td>Nome:</td>
      <td><input type="text" name="nome"><br></td>
      </tr>
     <tr>
     <td>Partito:</td>
     <td><input type="text" name="partito"><br></td>
     </tr>
     <tr>
     <td>Circoscrizione:</td>
     <td><input type="text" name="circoscrizione"><br></td>
     </tr>
     <tr>
     <td><input type="submit"><br></td>
     </tr>
     </table>
    </form>
 
    <h2>Ricerca parlamentare in base al nome:</h2>
    <form action="getParlamentare2">
    <table>
    <tr>
     <td>Nome:</td>
       <td><input type="text" name="nome"><br></td>
      </tr>
      <tr>
    <td> <input type="submit"><br></td>
     </tr>
     </table>
    </form>

    <h2>Ricerca parlamentare in base al partito:</h2>
    <form action="getParlamentare3">
    <table>
    <tr>
    <td>Partito:</td>
    <td><input type="text" name="partito"><br></td>
    </tr>
    <tr>
    <td><input type="submit"><br></td>
    </tr>
    </table>
    </form>
  
    <h2>Ricerca parlamentare in base alla circoscrizione:</h2>
    <form action="getParlamentare4">
    <table>
    <tr>
    <td>Circoscrizione:</td>
    <td> <input type="text" name="circoscrizione"><br></td>
    </tr>
    <tr>
    <td><input type="submit"><br></td>
    </tr>
    </table>
    </form>
 

    <h2>Aggiorna un parlamentare:</h2>
    <form action="updateParlamentare">

    <h3>Inserisci il nome del parlamentare da modificare:</h3>
    <table>
      <tr>
      <td>Nome:</td>
      <td>
      <input type="text" name="nome"><br>
      </td>
       </tr>
       <tr>
       <td>
           <input type="submit"><br>
       </td>
       </tr>
    </table>

    <h3>Registra i nuovi dati:</h3>
    <table>
    <tr>
     <td>Nome:</td>
    <td><input type="text" name="nome"><br></td>
    </tr>
    <tr>
     <td>Partito:</td>
    <td><input type="text" name="partito"><br></td>
    </tr>
    <tr>
     <td>Circoscrizione:</td>
    <td><input type="text" name="circoscrizione"><br></td>
    </tr>
    <tr>
    <td>Data di nascita:</td>
    <td><input type="text" name="data_nascita"><br></td>
     </tr>
     <tr>
     <td>Luogo:</td>
     <td><input type="text" name="luogo"><br></td>
     </tr>
    <tr>
     <td>Titolo di studi:</td>
     <td><input type="text" name="titolo_studi"><br></td>
     </tr>
     <tr>
     <td>Mandati:</td>
     <c:forEach items="${parlamentari.mandati}" 
    var="parlamentare.mandati">
       <table>
        <tr>
       <td>Mandato:</td> 
      <!--    <td><c:import value="${parlamentare.mandati}"/></td>  -->
       <td><input type="text" name="parlamentare.mandati"><br></td>
       </tr>
       </table>
       </c:forEach>
       <!--  
     <td><input type="text" name="mandati"><br></td>
     -->
    </tr>
    <tr>
     <td>Commissioni:</td>
      <c:forEach items="${parlamentari.commissioni}" 
    var="parlamentare.commissioni">
       <table>
        <tr>
       <td>Commissioni:</td> 
     <!--   <td><c:import value="${parlamentare.commissioni}"/></td>  - 
    ->
        <td><input type="text" name="parlamentare.commissioni"><br> 
     </td>
       </tr>
       </table>
       </c:forEach>
       <!-- 
     <td><input type="text" name="commissioni"><br></td>
      -->
     </tr>
     <tr>
     <td>Periodi delle cariche:</td>
      <c:forEach items="${parlamentari.periodi_cariche}" 
    var="parlamentare.periodi_cariche">
       <table>
        <tr>
       <td>Periodi cariche:</td> 
     <!--     <td><c:import value="${parlamentare.periodo_carica}"/> 
     </td> -->
         <td><input type="text" name="parlamentare.periodi_cariche"> 
    <br></td>
       </tr>
       </table>
       </c:forEach>
       <!--  
     <td><input type="text" name="periodi_cariche"><br></td>
     -->
     </tr>
     <tr>
      <td>
          <input type="submit"><br>
      </td>
      </tr>
     </table>
   </form>


    <h2>Elimina un parlamentare</h2>
    <form action="deleteParlamentare">
    <table>
    <tr>
    <td>Nome:</td>
    <td>
    <input type="text" name="nome"><br>
    </td>
    </tr>
    <tr>
      <td>
    <input type="submit"><br>
    </td>
    </tr>
    </table>
    </form>

    <h2>Lista dei parlamentari:</h2>
    <form action="getParlamentari">
      <c:forEach items="${parlamentari}" var="parlamentare">
      <table>
      <tr>
     <td>Nome:</td>
     <td><c:out value="${parlamentare.nome}"/></td>
     </tr>
     <tr>
     <td>Partito:</td>
     <td><c:out value="${parlamentare.partito}"/></td>
     </tr>
     <tr>
      <td>Circoscrizione:</td>
     <td><c:out value="${parlamentare.circoscrizione}"/><br></td>
     </tr>
     <tr>
      <td>Data di nascita:</td>
     <td><c:out value="${parlamentare.data_nascita}"/><br></td>
     </tr>
     <tr>
       <td>Luogo:</td>
     <td><c:out value="${parlamentare.luogo}"/><br></td>
     </tr>
     <tr>
     <td>Titolo di studi:</td>
      <td><c:out value="${parlamentare.titolo_studi}"/><br></td>
      </tr>
      <tr>
       <td>Mandati:</td>
       <c:forEach items="${parlamentari.mandati}" 
    var="parlamentare.mandati">
       <table>
        <tr>
       <td>Mandato:</td> 
       <td><c:out value="${parlamentare.mandati}"/></td>
       </tr>
       </table>
       </c:forEach>
       <!--  
       <td><c:out value="${parlamentare.mandati}"/><br></td>
      -->
     </tr>
     <tr>
         <td>Commissioni:</td>
        <c:forEach items="${parlamentari.commissioni}" 
     var="parlamentare.commissioni">
       <table>
        <tr>
       <td>Commissione:</td> 
       <td><c:out value="${parlamentare.commissioni}"/></td>
       </tr>
       </table>
       </c:forEach>
       <!--  
     <td><c:out value="${parlamentare.commissioni}"/><br></td>
     -->
     </tr>
     <tr>
     <td>Periodi delle cariche:</td>
     <c:forEach items="${parlamentari.periodi_cariche}" 
    var="parlamentare.periodi_cariche">
       <table>
        <tr>
       <td>Periodo carica:</td> 
       <td><c:out value="${parlamentare.periodi_cariche}"/></td>
       </tr>
       </table>
       </c:forEach>
       <!--  
     <td><c:out value="${parlamentare.periodi_cariche}"/><br></td>
     -->
     </tr>
     </table>
     </c:forEach>
     </form>

    </body>
    </html>

Please post the full stack trace

stacktrace of browser:

```

Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.

Mon May 09 14:56:06 CEST 2022
There was an unexpected error (type=Internal Server Error, status=500).
java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.; nested exception is org.hibernate.HibernateException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.
org.springframework.orm.jpa.JpaSystemException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.; nested exception is org.hibernate.HibernateException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:331)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233)
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:551)
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:152)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:174)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
at jdk.proxy4/jdk.proxy4.$Proxy92.findAll(Unknown Source)
at com.giuggiola.controller.ParlamentareController.home(ParlamentareController.java:33)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:567)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1064)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: org.hibernate.HibernateException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.
at com.vladmihalcea.hibernate.type.array.internal.AbstractArrayTypeDescriptor.wrap(AbstractArrayTypeDescriptor.java:96)
at com.vladmihalcea.hibernate.type.array.internal.ArraySqlTypeDescriptor$2.doExtract(ArraySqlTypeDescriptor.java:55)
at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253)
at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:243)
at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:329)
at org.hibernate.type.ComponentType.hydrate(ComponentType.java:670)
at org.hibernate.loader.Loader.extractKeysFromResultSet(Loader.java:803)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:727)
at org.hibernate.loader.Loader.getRowsFromResultSet(Loader.java:1039)
at org.hibernate.loader.Loader.processResultSet(Loader.java:990)
at org.hibernate.loader.Loader.doQuery(Loader.java:959)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
at org.hibernate.loader.Loader.doList(Loader.java:2843)
at org.hibernate.loader.Loader.doList(Loader.java:2825)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2657)
at org.hibernate.loader.Loader.list(Loader.java:2652)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414)
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1636)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1604)
at org.hibernate.query.Query.getResultList(Query.java:165)
at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:76)
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:396)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:567)
at org.springframework.data.repository.core.support.RepositoryMethodInvoker$RepositoryFragmentMethodInvoker.lambda$new$0(RepositoryMethodInvoker.java:289)
at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:137)
at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:121)
at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:529)
at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:285)
at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:599)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:163)
at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:138)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
… 58 more
Caused by: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.
… 106 more
Caused by: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.
at org.postgresql.jdbc.TypeInfoCache.getPGArrayElement(TypeInfoCache.java:609)
at org.postgresql.jdbc.PgArray.buildArray(PgArray.java:310)
at org.postgresql.jdbc.PgArray.getArrayImpl(PgArray.java:171)
at org.postgresql.jdbc.PgArray.getArray(PgArray.java:111)
at com.vladmihalcea.hibernate.type.array.internal.AbstractArrayTypeDescriptor.wrap(AbstractArrayTypeDescriptor.java:94)
… 105 more

stacktrace spring boot:

 ```

14:54:44.974 [Thread-0] DEBUG org.springframework.boot.devtools.restart.classloader.RestartClassLoader - Created RestartClassLoader org.springframework.boot.devtools.restart.classloader.RestartClassLoader@21c81bd8

. ____ _ __ _ _
/\ / __ _ () __ __ _ \ \ \
( ( )_
_ | '_ | '| | ’ / ` | \ \ \
\/ )| |)| | | | | || (| | ) ) ) )
’ |
| .__|| ||| |_, | / / / /
=========|
|==============|/=////
e[32m :: Spring Boot :: e[39m e[2m (v2.5.4)e[0;39m

e[2m2022-05-09 14:54:48.703e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mcom.giuggiola.ParlamentoApplication e[0;39m e[2m:e[0;39m Starting ParlamentoApplication using Java 16.0.2 on DESKTOP-0R8B1B7 with PID 3016 (C:\Users\PC\Documents\workspace-spring-tool-suite-4-4.11.1.RELEASE\Parlamento2\target\classes started by PC in C:\Users\PC\Documents\workspace-spring-tool-suite-4-4.11.1.RELEASE\Parlamento2)
e[2m2022-05-09 14:54:48.706e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mcom.giuggiola.ParlamentoApplication e[0;39m e[2m:e[0;39m The following profiles are active: @spring.profiles.active@
e[2m2022-05-09 14:54:49.353e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.e.DevToolsPropertyDefaultsPostProcessore[0;39m e[2m:e[0;39m Devtools property defaults active! Set ‘spring.devtools.add-properties’ to ‘false’ to disable
e[2m2022-05-09 14:54:49.354e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.e.DevToolsPropertyDefaultsPostProcessore[0;39m e[2m:e[0;39m For additional web related logging consider setting the ‘logging.level.web’ property to ‘DEBUG’
e[2m2022-05-09 14:55:00.394e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Multiple Spring Data modules found, entering strict repository configuration mode!
e[2m2022-05-09 14:55:00.447e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Bootstrapping Spring Data Elasticsearch repositories in DEFAULT mode.
e[2m2022-05-09 14:55:00.860e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.RepositoryConfigurationExtensionSupporte[0;39m e[2m:e[0;39m Spring Data Elasticsearch - Could not safely identify store assignment for repository candidate interface com.giuggiola.repository.ParlamentareRepository. If you want this repository to be a Elasticsearch repository, consider annotating your entities with one of these annotations: org.springframework.data.elasticsearch.annotations.Document (preferred), or consider extending one of the following types with your repository: org.springframework.data.elasticsearch.repository.ElasticsearchRepository, org.springframework.data.elasticsearch.repository.ElasticsearchRepository.
e[2m2022-05-09 14:55:00.863e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Finished Spring Data repository scanning in 398 ms. Found 0 Elasticsearch repository interfaces.
e[2m2022-05-09 14:55:00.876e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Multiple Spring Data modules found, entering strict repository configuration mode!
e[2m2022-05-09 14:55:00.878e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Bootstrapping Spring Data Reactive Elasticsearch repositories in DEFAULT mode.
e[2m2022-05-09 14:55:00.883e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.RepositoryConfigurationExtensionSupporte[0;39m e[2m:e[0;39m Spring Data Reactive Elasticsearch - Could not safely identify store assignment for repository candidate interface com.giuggiola.repository.ParlamentareRepository. If you want this repository to be a Reactive Elasticsearch repository, consider annotating your entities with one of these annotations: org.springframework.data.elasticsearch.annotations.Document (preferred), or consider extending one of the following types with your repository: org.springframework.data.elasticsearch.repository.ReactiveElasticsearchRepository.
e[2m2022-05-09 14:55:00.884e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Finished Spring Data repository scanning in 5 ms. Found 0 Reactive Elasticsearch repository interfaces.
e[2m2022-05-09 14:55:00.896e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Multiple Spring Data modules found, entering strict repository configuration mode!
e[2m2022-05-09 14:55:00.916e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Bootstrapping Spring Data JPA repositories in DEFAULT mode.
e[2m2022-05-09 14:55:00.960e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36m.s.d.r.c.RepositoryConfigurationDelegatee[0;39m e[2m:e[0;39m Finished Spring Data repository scanning in 38 ms. Found 1 JPA repository interfaces.
e[2m2022-05-09 14:55:02.930e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mo.s.b.w.embedded.tomcat.TomcatWebServer e[0;39m e[2m:e[0;39m Tomcat initialized with port(s): 8082 (http)
e[2m2022-05-09 14:55:02.981e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mo.apache.catalina.core.StandardService e[0;39m e[2m:e[0;39m Starting service [Tomcat]
e[2m2022-05-09 14:55:02.981e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36morg.apache.catalina.core.StandardEngine e[0;39m e[2m:e[0;39m Starting Servlet engine: [Apache Tomcat/9.0.52]
e[2m2022-05-09 14:55:04.007e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36morg.apache.jasper.servlet.TldScanner e[0;39m e[2m:e[0;39m At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
e[2m2022-05-09 14:55:04.054e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mo.a.c.c.C.[Tomcat].[localhost].[/] e[0;39m e[2m:e[0;39m Initializing Spring embedded WebApplicationContext
e[2m2022-05-09 14:55:04.054e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mw.s.c.ServletWebServerApplicationContexte[0;39m e[2m:e[0;39m Root WebApplicationContext: initialization completed in 14700 ms
e[2m2022-05-09 14:55:04.690e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mo.hibernate.jpa.internal.util.LogHelper e[0;39m e[2m:e[0;39m HHH000204: Processing PersistenceUnitInfo [name: default]
e[2m2022-05-09 14:55:04.818e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36morg.hibernate.Version e[0;39m e[2m:e[0;39m HHH000412: Hibernate ORM core version 5.4.32.Final
e[2m2022-05-09 14:55:05.404e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mo.hibernate.annotations.common.Version e[0;39m e[2m:e[0;39m HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
e[2m2022-05-09 14:55:05.654e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mcom.zaxxer.hikari.HikariDataSource e[0;39m e[2m:e[0;39m HikariPool-1 - Starting…
e[2m2022-05-09 14:55:06.362e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mcom.zaxxer.hikari.HikariDataSource e[0;39m e[2m:e[0;39m HikariPool-1 - Start completed.
e[2m2022-05-09 14:55:06.456e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36morg.hibernate.dialect.Dialect e[0;39m e[2m:e[0;39m HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL10Dialect
e[2m2022-05-09 14:55:07.822e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mHibernate Types e[0;39m e[2m:e[0;39m This framework is proudly powered by:


| | | | () | |
| |__| |
_ _ __ ___ _ __ ___ _ | | ___ _ __ ___ ___
| __ | | | | ’
\ / _ \ '
/ | / | / _ \ ’ \ / / _
| | | | || | |) | / | _ \ _ \ || / | | | (| __/
|
| ||_, | .
/ _
|| |
/|
/___
|| ||__|
/ | |
|
/||

At Hypersistence, we only build amazing tools, like Hibernate Types, Flexy Pool, or Hypersistence Optimizer.

What if there were a tool that could automatically detect JPA and Hibernate performance issues?

Hypersistence Optimizer is that tool! For more details, go to:

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Hibernate:

alter table if exists range2 
   add constraint FK86t158cdhu392usktb1kamxhh 
   foreign key (parlamentare_circoscrizione, parlamentare_nome, parlamentare_partito) 
   references parlamentari

e[2m2022-05-09 14:55:09.132e[0;39m e[33m WARNe[0;39m e[35m3016e[0;39m e[2m—e[0;39m e[2m[ restartedMain]e[0;39m e[36mo.h.t.s.i.ExceptionHandlerLoggedImpl e[0;39m e[2m:e[0;39m GenerationTarget encountered exception accepting command : Error executing DDL "
alter table if exists range2
add constraint FK86t158cdhu392usktb1kamxhh
foreign key (parlamentare_circoscrizione, parlamentare_nome, parlamentare_partito)
references parlamentari" via JDBC Statement

org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "
alter table if exists range2
add constraint FK86t158cdhu392usktb1kamxhh
foreign key (parlamentare_circoscrizione, parlamentare_nome, parlamentare_partito)
references parlamentari" via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:562) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:507) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:184) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:318) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:468) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1259) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) ~[spring-orm-5.3.9.jar:5.3.9]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:365) ~[spring-orm-5.3.9.jar:5.3.9]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory(AbstractEntityManagerFactoryBean.java:409) ~[spring-orm-5.3.9.jar:5.3.9]
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:396) ~[spring-orm-5.3.9.jar:5.3.9]
at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet(LocalContainerEntityManagerFactoryBean.java:341) ~[spring-orm-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1845) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1782) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:602) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:524) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.9.jar:5.3.9]
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1154) ~[spring-context-5.3.9.jar:5.3.9]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:908) ~[spring-context-5.3.9.jar:5.3.9]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.9.jar:5.3.9]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.5.4.jar:2.5.4]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754) ~[spring-boot-2.5.4.jar:2.5.4]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:434) ~[spring-boot-2.5.4.jar:2.5.4]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:338) ~[spring-boot-2.5.4.jar:2.5.4]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1343) ~[spring-boot-2.5.4.jar:2.5.4]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1332) ~[spring-boot-2.5.4.jar:2.5.4]
at com.giuggiola.ParlamentoApplication.main(ParlamentoApplication.java:66) ~[classes/:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
at org.springframework.boot.devtools.restart.RestartLauncher.run(RestartLauncher.java:49) ~[spring-boot-devtools-2.6.2.jar:2.6.2]
Caused by: org.postgresql.util.PSQLException: ERRORE: non è possibile implementare il vincolo di chiave esterna “fk86t158cdhu392usktb1kamxhh”
Dettaglio: Le colonne chiave “parlamentare_circoscrizione” e “nome” hanno tipi incompatibili: text[] e character varying.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2552) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2284) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) ~[postgresql-42.2.23.jar:42.2.23]
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) ~[postgresql-42.2.23.jar:42.2.23]
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-4.0.3.jar:na]
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-4.0.3.jar:na]
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
… 38 common frames omitted

e[2m2022-05-09 14:55:09.145e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mo.h.e.t.j.p.i.JtaPlatformInitiator      e[0;39m e[2m:e[0;39m HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
e[2m2022-05-09 14:55:09.212e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mj.LocalContainerEntityManagerFactoryBeane[0;39m e[2m:e[0;39m Initialized JPA EntityManagerFactory for persistence unit 'default'
e[2m2022-05-09 14:55:10.144e[0;39m e[33m WARNe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mJpaBaseConfiguration$JpaWebConfiguratione[0;39m e[2m:e[0;39m spring.jpa.open-in-view is enabled by default. Therefore, database queries may be performed during view rendering. Explicitly configure spring.jpa.open-in-view to disable this warning
e[2m2022-05-09 14:55:10.402e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36ms.w.s.m.m.a.RequestMappingHandlerAdaptere[0;39m e[2m:e[0;39m ControllerAdvice beans: 0 @ModelAttribute, 0 @InitBinder, 1 RequestBodyAdvice, 1 ResponseBodyAdvice
e[2m2022-05-09 14:55:10.521e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36ms.w.s.m.m.a.RequestMappingHandlerMappinge[0;39m e[2m:e[0;39m 11 mappings in 'requestMappingHandlerMapping'
e[2m2022-05-09 14:55:10.557e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mo.s.w.s.handler.SimpleUrlHandlerMapping e[0;39m e[2m:e[0;39m Patterns [/webjars/**, /**] in 'resourceHandlerMapping'
e[2m2022-05-09 14:55:10.568e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36m.m.m.a.ExceptionHandlerExceptionResolvere[0;39m e[2m:e[0;39m ControllerAdvice beans: 0 @ExceptionHandler, 1 ResponseBodyAdvice
e[2m2022-05-09 14:55:12.715e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mo.s.d.elasticsearch.support.VersionInfo e[0;39m e[2m:e[0;39m Version Spring Data Elasticsearch: 4.2.4
e[2m2022-05-09 14:55:12.715e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mo.s.d.elasticsearch.support.VersionInfo e[0;39m e[2m:e[0;39m Version Elasticsearch Client in build: 7.12.1
e[2m2022-05-09 14:55:12.716e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mo.s.d.elasticsearch.support.VersionInfo e[0;39m e[2m:e[0;39m Version Elasticsearch Client used: 7.12.1
e[2m2022-05-09 14:55:12.962e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mo.s.b.d.a.OptionalLiveReloadServer      e[0;39m e[2m:e[0;39m LiveReload server is running on port 35729
e[2m2022-05-09 14:55:13.048e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mo.s.b.w.embedded.tomcat.TomcatWebServer e[0;39m e[2m:e[0;39m Tomcat started on port(s): 8082 (http) with context path ''
e[2m2022-05-09 14:55:13.061e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[  restartedMain]e[0;39m e[36mcom.giuggiola.ParlamentoApplication     e[0;39m e[2m:e[0;39m Started ParlamentoApplication in 28.057 seconds (JVM running for 34.301)
e[2m2022-05-09 14:56:03.829e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.a.c.c.C.[Tomcat].[localhost].[/]      e[0;39m e[2m:e[0;39m Initializing Spring DispatcherServlet 'dispatcherServlet'
e[2m2022-05-09 14:56:03.829e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Initializing Servlet 'dispatcherServlet'
e[2m2022-05-09 14:56:03.830e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Detected StandardServletMultipartResolver
e[2m2022-05-09 14:56:03.830e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Detected AcceptHeaderLocaleResolver
e[2m2022-05-09 14:56:03.830e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Detected FixedThemeResolver
e[2m2022-05-09 14:56:03.831e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Detected org.springframework.web.servlet.view.DefaultRequestToViewNameTranslator@23222b60
e[2m2022-05-09 14:56:03.831e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Detected org.springframework.web.servlet.support.SessionFlashMapManager@523d7c1b
e[2m2022-05-09 14:56:03.831e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m enableLoggingRequestDetails='false': request parameters and headers will be masked to prevent unsafe logging of potentially sensitive data
e[2m2022-05-09 14:56:03.831e[0;39m e[32m INFOe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Completed initialization in 2 ms
e[2m2022-05-09 14:56:03.847e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m GET "/", parameters={}
e[2m2022-05-09 14:56:03.850e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36ms.w.s.m.m.a.RequestMappingHandlerMappinge[0;39m e[2m:e[0;39m Mapped to com.giuggiola.controller.ParlamentareController#home(Parlamentare)
Hibernate: 
    select
        parlamenta0_.circoscrizione as circoscr1_0_,
        parlamenta0_.nome as nome2_0_,
        parlamenta0_.partito as partito3_0_,
        parlamenta0_.commissioni as commissi4_0_,
        parlamenta0_.data_nascita as data_nas5_0_,
        parlamenta0_.luogo as luogo6_0_,
        parlamenta0_.mandati as mandati7_0_,
        parlamenta0_.titolo_studi as titolo_s8_0_ 
    from
        parlamentari parlamenta0_
e[2m2022-05-09 14:56:06.637e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Failed to complete request: org.springframework.orm.jpa.JpaSystemException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.; nested exception is org.hibernate.HibernateException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.
e[2m2022-05-09 14:56:06.648e[0;39m e[31mERRORe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.a.c.c.C.[.[.[/].[dispatcherServlet]   e[0;39m e[2m:e[0;39m Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.; nested exception is org.hibernate.HibernateException: java.lang.IllegalArgumentException: org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.] with root cause

org.postgresql.util.PSQLException: Nessun risultato è stato restituito dalla query.
	at org.postgresql.jdbc.TypeInfoCache.getPGArrayElement(TypeInfoCache.java:609) ~[postgresql-42.2.23.jar:42.2.23]
	at org.postgresql.jdbc.PgArray.buildArray(PgArray.java:310) ~[postgresql-42.2.23.jar:42.2.23]
	at org.postgresql.jdbc.PgArray.getArrayImpl(PgArray.java:171) ~[postgresql-42.2.23.jar:42.2.23]
	at org.postgresql.jdbc.PgArray.getArray(PgArray.java:111) ~[postgresql-42.2.23.jar:42.2.23]
	at com.vladmihalcea.hibernate.type.array.internal.AbstractArrayTypeDescriptor.wrap(AbstractArrayTypeDescriptor.java:94) ~[hibernate-types-55-2.14.0.jar:na]
	at com.vladmihalcea.hibernate.type.array.internal.ArraySqlTypeDescriptor$2.doExtract(ArraySqlTypeDescriptor.java:55) ~[hibernate-types-55-2.14.0.jar:na]
	at org.hibernate.type.descriptor.sql.BasicExtractor.extract(BasicExtractor.java:47) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:257) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:253) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.type.AbstractStandardBasicType.nullSafeGet(AbstractStandardBasicType.java:243) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.type.AbstractStandardBasicType.hydrate(AbstractStandardBasicType.java:329) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.type.ComponentType.hydrate(ComponentType.java:670) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.extractKeysFromResultSet(Loader.java:803) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:727) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.getRowsFromResultSet(Loader.java:1039) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.processResultSet(Loader.java:990) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.doQuery(Loader.java:959) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2843) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2825) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2657) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.Loader.list(Loader.java:2652) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1414) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1636) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1604) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.query.Query.getResultList(Query.java:165) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:76) ~[hibernate-core-5.4.32.Final.jar:5.4.32.Final]
	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:396) ~[spring-data-jpa-2.5.4.jar:2.5.4]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker$RepositoryFragmentMethodInvoker.lambda$new$0(RepositoryMethodInvoker.java:289) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:137) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:121) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:529) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:285) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:599) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:163) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:138) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80) ~[spring-data-commons-2.5.4.jar:2.5.4]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.9.jar:5.3.9]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.9.jar:5.3.9]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.9.jar:5.3.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137) ~[spring-tx-5.3.9.jar:5.3.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:174) ~[spring-data-jpa-2.5.4.jar:2.5.4]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.9.jar:5.3.9]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) ~[spring-aop-5.3.9.jar:5.3.9]
	at jdk.proxy4/jdk.proxy4.$Proxy92.findAll(Unknown Source) ~[na:na]
	at com.giuggiola.controller.ParlamentareController.home(ParlamentareController.java:33) ~[classes/:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:78) ~[na:na]
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
	at java.base/java.lang.reflect.Method.invoke(Method.java:567) ~[na:na]
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:197) ~[spring-web-5.3.9.jar:5.3.9]
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:141) ~[spring-web-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1064) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:655) ~[tomcat-servlet-api-9.0.52.jar:4.0.FR]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.3.9.jar:5.3.9]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) ~[tomcat-servlet-api-9.0.52.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.3.9.jar:5.3.9]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.9.jar:5.3.9]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.3.9.jar:5.3.9]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.9.jar:5.3.9]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.3.9.jar:5.3.9]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.3.9.jar:5.3.9]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.52.jar:9.0.52]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) ~[tomcat-util-9.0.52.jar:9.0.52]
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) ~[tomcat-util-9.0.52.jar:9.0.52]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util-9.0.52.jar:9.0.52]
	at java.base/java.lang.Thread.run(Thread.java:831) ~[na:na]

e[2m2022-05-09 14:56:06.656e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m "ERROR" dispatch for GET "/error", parameters={}
e[2m2022-05-09 14:56:06.725e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36ms.w.s.m.m.a.RequestMappingHandlerMappinge[0;39m e[2m:e[0;39m Mapped to org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController#errorHtml(HttpServletRequest, HttpServletResponse)
e[2m2022-05-09 14:56:06.801e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.w.s.v.ContentNegotiatingViewResolvere[0;39m e[2m:e[0;39m Selected 'text/html' given [text/html, text/html;q=0.8]
e[2m2022-05-09 14:56:06.810e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-1]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Exiting from "ERROR" dispatch, status 500
e[2m2022-05-09 14:56:11.164e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m GET "/favicon.ico", parameters={}
e[2m2022-05-09 14:56:11.172e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.w.s.handler.SimpleUrlHandlerMapping e[0;39m e[2m:e[0;39m Mapped to ResourceHttpRequestHandler [Classpath [META-INF/resources/], Classpath [resources/], Classpath [static/], Classpath [public/], ServletContext [/]]
e[2m2022-05-09 14:56:11.184e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.w.s.r.ResourceHttpRequestHandler    e[0;39m e[2m:e[0;39m Resource not found
e[2m2022-05-09 14:56:11.184e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Completed 404 NOT_FOUND
e[2m2022-05-09 14:56:11.185e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m "ERROR" dispatch for GET "/error", parameters={}
e[2m2022-05-09 14:56:11.187e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36ms.w.s.m.m.a.RequestMappingHandlerMappinge[0;39m e[2m:e[0;39m Mapped to org.springframework.boot.autoconfigure.web.servlet.error.BasicErrorController#error(HttpServletRequest)
e[2m2022-05-09 14:56:11.400e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.w.s.m.m.a.HttpEntityMethodProcessor e[0;39m e[2m:e[0;39m Using 'application/json;q=0.8', given [image/avif, image/webp, image/apng, image/svg+xml, image/*, */*;q=0.8] and supported [application/json, application/*+json, application/json, application/*+json, application/x-jackson-smile, application/cbor]
e[2m2022-05-09 14:56:11.401e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.w.s.m.m.a.HttpEntityMethodProcessor e[0;39m e[2m:e[0;39m Writing [{timestamp=Mon May 09 14:56:11 CEST 2022, status=404, error=Not Found, message=No message available, (truncated)...]
e[2m2022-05-09 14:56:11.570e[0;39m e[32mDEBUGe[0;39m e[35m3016e[0;39m e[2m---e[0;39m e[2m[nio-8082-exec-3]e[0;39m e[36mo.s.web.servlet.DispatcherServlet       e[0;39m e[2m:e[0;39m Exiting from "ERROR" dispatch, status 404






As far as I understand, this means that the column for which the ArraySqlTypeDescriptor tries to call getArray is not an array. I don’t know how your database schema looks like, but I guess it simply doesn’t
meet the expectations of your current configuration. Also, since this is a hibernate-types library issue, I would suggest you create an issue in the issue tracker of that project and ask for help there: Issues · vladmihalcea/hibernate-types · GitHub

I tried to insert the screenshots but it doesn’t let me put them.
table parlamentari in postgresql:

CREATE TABLE IF NOT EXISTS public.parlamentari
(
    nome character varying(100) COLLATE pg_catalog."default" NOT NULL,
    partito character varying(100) COLLATE pg_catalog."default" NOT NULL,
    circoscrizione character varying(100) COLLATE pg_catalog."default" NOT NULL,
    data_nascita date,
    luogo character varying(100) COLLATE pg_catalog."default",
    titolo_studi character varying(100) COLLATE pg_catalog."default",
    mandati character varying(1000)[] COLLATE pg_catalog."default",
    commissioni character varying(100)[] COLLATE pg_catalog."default",
    periodi_cariche daterange[],
    CONSTRAINT parlamentari_pkey PRIMARY KEY (nome, partito, circoscrizione),
    CONSTRAINT parlamentarinomekey UNIQUE (nome),
    CONSTRAINT parlamentaripartitonomekey UNIQUE (partito, nome)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.parlamentari
    OWNER to postgres;

GRANT ALL ON TABLE public.parlamentari TO postgres;

GRANT ALL ON TABLE public.parlamentari TO PUBLIC;

You will have to debug into com.vladmihalcea.hibernate.type.array.internal.AbstractArrayTypeDescriptor.wrap(AbstractArrayTypeDescriptor.java:94) to find out which column of the result set is expected to be an array but isn’t. Then you can further check whether there is an issue in the database or your model.