Issues with running the db

[Bechir Mihoub]

I am not sure how to fix this. My error is

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'passengerController': Unsatisfied dependency expressed through field 'service'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'passengerService': Unsatisfied dependency expressed through field 'repo'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'passengerRepository': Cannot create inner bean '(inner bean)#7db4363b' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#7db4363b': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [ca/bechir/config/JpaConfig.class]: Invocation of init method failed; nested exception is org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]

My passengerservice

package ca.bechir.passenger;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.List;
import java.util.Optional;

import org.springframework.beans.factory.annotation.Autowired;

@Service
@Transactional
public class PassengerService {
@Autowired
private PassengerRepository repo;

public List<Passenger> listAll() {
	return (List<Passenger>) repo.findAll();
}

public void save(Passenger passenger) {
	repo.save(passenger);
}

public Passenger get(long id) {
	Optional<Passenger> result = repo.findById(id);
	return result.get();
}

public void delete(long id) {
	repo.deleteById(id);
}

public List<Passenger> search(String keyword) {
	return repo.search(keyword);
}
}

My pom

<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>
  <groupId>ca.bechir</groupId>
  <artifactId>PassengerManager</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
 
  <properties>
  <spring.version>5.1.5.RELEASE</spring.version>
  <hibernate.version>5.4.1.Final</hibernate.version>
  </properties>
  
  
  
  <dependencies>
           <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-context</artifactId>
  <version>${spring.version}</version>
           </dependency>
        
               <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-orm</artifactId>
  <version>${spring.version}</version>
               </dependency>
               
               <dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-webmvc</artifactId>
  <version>${spring.version}</version>
                </dependency>
                
                <dependency>
  <groupId>org.springframework.data</groupId>
  <artifactId>spring-data-jpa</artifactId>
  <version>2.1.5.RELEASE</version>
               </dependency>
               
                <dependency>
  <groupId>org.hibernate</groupId>
  <artifactId>hibernate-core</artifactId>
  <version>${hibernate.version}</version>
               </dependency>
               
                <dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>8.0.14</version>
  <scope>runtime</scope>
               </dependency>
               
                <dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>javax.servlet-api</artifactId>
  <version>3.1.0</version>
  <scope>provided</scope>
               </dependency>
               
               <dependency>
  <groupId>javax.servlet.jsp</groupId>
  <artifactId>javax.servlet.jsp-api</artifactId>
  <version>2.3.1</version>
  <scope>provided</scope>
               </dependency>
               
               <dependency>
  <groupId>jstl</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
               </dependency>
  </dependencies>
  <build>
    <sourceDirectory>src</sourceDirectory>
    <plugins>
      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>3.8.0</version>
        <configuration>
          <release>11</release>
        </configuration>
      </plugin>
      <plugin>
        <artifactId>maven-war-plugin</artifactId>
        <version>3.2.3</version>
        <configuration>
          <warSourceDirectory>WebContent</warSourceDirectory>
        </configuration>
      </plugin>
    </plugins>
  </build>
</project>

[Himai Minh]

Hi, Bechir,
Maybe, you need to specify what Java version is in your pom.xml:
For example, if you use Java 11.

<properties>
   ....
  <java.version>11</java.version>
</properties>

Also, if you are using IntelliJ, select File -> Settings-> Build,Execution, Deployment -> Compiler -> Java Compiler. Make sure project bytecode version is set to your current version of Java, such as 11.
Select File-> Project Structure -> Project , select the right project SDK and right project language level, such as 11 in this case.
Under Platform Settings -> SDKs , make sure the right version of Java is selected.


If that still does not work, you can commit your code in github and show us.

[Bechir Mihoub]

I'm using eclipse and I specified what version of java im using. Here is the github link to help you. https://github.com/typeveron/database-java

[Himai Minh]

Hi, Bechir
First of all, you need to rearrange your project structure. I am using intelliJ.
My new structure is:
src -> main -> java -> ca.bechir
resources -> META-INF ->persistence.xml
webapp-> WEB-INF ->views
You may need to mark webapp as web resource content as shown: https://www.jetbrains.com/help/idea/web-application-static-content.html
Also, right click on resources to mark the directory as root.

If you are using Eclipse, you may need to recreate the file structures as well.
You may want to use IntelliJ Ultimate free trial version.

[Himai Minh]

Hi Bechir,
After you rearrange the project structure as shown in my previous post, you may need to fix WebApplicationInitializer:

public class WebAppInitializer implements WebApplicationInitializer {

	@Override
	public void onStartup(ServletContext servletContext) throws ServletException {
		AnnotationConfigWebApplicationContext appContext = new AnnotationConfigWebApplicationContext();
               //add this
		appContext.setServletContext(servletContext);
		appContext.register(BechirMvcConfig.class);
               //add this
		appContext.refresh();
		ServletRegistration.Dynamic dispatcher = servletContext.addServlet (
				"SpringDispatcher", new DispatcherServlet(appContext));
		dispatcher.setLoadOnStartup(1);
		dispatcher.addMapping("/");
	}

}

[Himai Minh]

You may need to fix persistence.xml :

<persistence xmlns="http://xmlns.jcp.org/xml/ns/persistence"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd"
  version="2.1">
  <persistence-unit name="BechDB">
   //add this line
      <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
  <properties>
//in my MySQL database, I need to add ?useSSL=false
   <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/bechdb?useSSL=false"/>
   <property name="javax.persistence.jdbc.user" value="root"/>
   //this is just my own password
   <property name="javax.persistence.jdbc.password" value="sesame"/>
   <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
   <property name="hibernate.show_sql" value="true"/>
   <property name="hibernate.format_sql" value="true"/>
   //add this
    <property name="hibernate.hbm2ddl.auto" value="create-drop"/>
   </properties>
  </persistence-unit>
</persistence>

[Himai Minh]

Then, add this dependency in pom.xml
<dependency>
           <groupId>org.hibernate</groupId>
           <artifactId>hibernate-entitymanager</artifactId>
           <version>5.0.4.Final</version>
       </dependency>

[Himai Minh]

Hi, Bechir,
One more note.
Also, put a / in front of WEB-INF

@Configuration
@ComponentScan("ca.bechir")
public class BechirMvcConfig {
	@Bean(name = "viewResolver")
	public InternalResourceViewResolver getViewResolver() {
		InternalResourceViewResolver viewResolver = new InternalResourceViewResolver();
		viewResolver.setPrefix("/WEB-INF/views/");
		viewResolver.setSuffix(".jsp");
		return viewResolver;
		}
}

[Himai Minh]

Hi, Bechir,
I need your help to fix the SQL statement:
Caused by: java.lang.IllegalArgumentException: The string <SELECT c FROM Passenger c WHERE c.name LIKE '%' || keyword || '%''OR c.email LIKE '%' || :keyword || '%'OR c.birthdate LIKE '%' || :keyword || '%'OR c.address LIKE '%' || :keyword || '%'OR c.family LIKE '%' || :keyword || '%'OR c.paymentCard LIKE '%' || :keyword || '%'> starts a quoted range at 268, but never ends it.

[Himai Minh]

Hi, Bechir,
For your reference, I attach my fixes in this post below.

[Himai Minh]

Hi, Bechir,
Your PassengerRepository may be like this:

public interface PassengerRepository extends CrudRepository<Passenger, Long> {

	@Query(value="SELECT c FROM Passenger c WHERE c.name LIKE '%' "
			+ "OR c.email LIKE '%'"+ "OR c.birthdate LIKE '%'"
			+ "OR c.address LIKE '%'" + "OR c.family LIKE '%'"
			+ "OR c.paymentCard LIKE '%'", nativeQuery = true)
	public List<Passenger> search(@Param("keyword") String keyword);
}

Let me know how it goes.

[Bechir Mihoub]

Is there any way to configure static content resources on eclipse?

[Bechir Mihoub]

I also can't run your project on eclipse.

[Himai Minh]

You can try to use IntelliJ Ultimate (free trial version).
In Eclipse, you may want to build a dynamic web project with the Web content.

I think for Eclipse, you need to install STS plugin to build any Spring framework project.

[Bechir Mihoub]

I'm not really able to rearrange the structure and have it be the same in eclipse. I did make a dynamic web project with maven in eclipse. I'm also confused as to mark web resource content I mean what do I mark with regards to the project?

[Himai Minh]

Hi, Bechir,
When you create a dynamic web project in Eclipse, do  you see the WebContent folder? If so, put your views folder inside that folder.
Packaging is important, otherwise the Spring framework container cannot find the components.

[Bechir Mihoub]

Yeah I have a web content folder with meta-inf and web-inf folders.