Sergej Smoljanov

Incorrect database name 'springbootdb '
Have you create schema? have you  'springbootdb '  created?

I try add to properties application.properties:
spring.datasource.url=jdbc:mysql://localhost:3306/springbootdb?useLegacyDatetimeCode=false&serverTimezone=America/New_York spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect spring.jpa.hibernate.ddl-auto=create-drop spring.datasource.username=root spring.datasource.password=

also just one options
spring.jpa.show-sql=true

i get result that also show me sql

Hibernate: insert into journal (created, summary, title, id) values (?, ?, ?, ?)

A value of create-drop will create your tables, and then drop them when you close the sessionFactory.

Sorry one correct
mappedBy = "material" instead mappedBy = "id".
but question still actual

I want to get result as
List of @Entity of study_material which will contain List<stydy_material_history> with entities - the max values from study_material_history per day (using rep_date) (for each study_material respectively)

I have 2 tables in mysql
create table study_material(    id  int NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT 'ID MATERIAL',    book_name varchar(100) not null COMMENT 'Material name (book name, video name ect.)',    total_page int not null default 0 COMMENT 'Number of pages in book' ) create table stydy_material_history(    id int not null AUTO_INCREMENT primary key comment 'id historical',    id_study_material int not null comment 'ID MATERIAL from study_material table',    current_page int not null  comment 'Page that was when result was saving',    rep_date DATETIME comment 'Date when result was saved' )

I created entities classes:
@Entity @Table(name = "study_material") public class StudyMaterial implements Serializable {    Long id;    String book_name;    int total_page;    private List<StudyMaterialHistoryCurrentState> historyCurentState = new  ArrayList<>();    @OneToMany (fetch = FetchType.LAZY, cascade = CascadeType.ALL, mappedBy = "id")    public List<StudyMaterialHistoryCurrentState> getHistory() {        return historyCurentState; }    @Id    @GeneratedValue(strategy = GenerationType.IDENTITY)    @Column(name = "id")    public Long getId() {        return id;    }    @Column(name = "book_name" )    public String getBook_name() {        return book_name;    }    @Column(name = "total_page")    public int getTotal_page() {        return total_page;    }    //Setters omitted }
@Entity @Table(name="stydy_material_history") public class StudyMaterialHistoryCurrentState implements Serializable{ private Long id; private Long id_study_material; private Integer current_page; private Date rep_date; StudyMaterial material;    @ManyToOne    @JoinColumn(name = "id_study_material")    public StudyMaterial getMaterial() {        return material;    }    @Id    @GeneratedValue(strategy = GenerationType.IDENTITY)    @Column(name = "id")    public Long getId() {        return id;    }    @Column(name ="current_page")    public Integer getCurrent_page() {        return current_page;    }    @Column(name ="rep_date", columnDefinition="DATETIME")    @Temporal(TemporalType.TIMESTAMP)    public Date getRep_date() {        return rep_date;    }    //setters ommited }
for using spring data i create:
public interface StudyMaterialRepository extends CrudRepository<StudyMaterial, Long> { }
@Service("StudyMaterialService") @Repository @Transactional public class StudyMaterialDaoImpl{    @Resource    StudyMaterialRepository repository;    @PersistenceContext    private EntityManager entityManager;    @Transactional(readOnly = true)    @Override    public List<StudyMaterial> findAll() {        return Lists.newArrayList(repository.findAll());    } }
to reiterate question
how can i get via findAll()
List of StudyMaterial that will contain List of StudyMaterialHistoryCurrentState than will contains  items that is maximum rep_date per day.
I can`t understand where and how i must changes to get such result
assuming that both tables are filled with data next is sql variant i want express
SELECT *  FROM study_material AS t1  JOIN stydy_material_history t2  ON t1.id = t2.id_study_material  JOIN (       SELECT id_study_material,          max( rep_date ) AS max_rep_date       FROM stydy_material_history       GROUP BY DATE( rep_date ) , id_study_material  ) AS t3  ON t2.id_study_material = t3.id_study_material AND t2.rep_date = t3.max_rep_date

http://www.apress.com/us/book/9781430261513
i have read both books. my opinion than pro spring better - almost all examples from Pro Spring is repeatable. In Spring in action there is more places where I stuck and have spend much time to get where is problem, i think that this book not for novice (Also I think than there is interesting topics in this book).
If you try only one source - choose book i suggested.
Also you already have Spring in Action - try it.

Amazing book. I am reading it now. (4 edition)
https://www.amazon.com/Pro-Spring-Clarence-Ho/dp/143026151X/ref=dp_ob_title_bk
What is plus - code from it work. You can repeat code and it work, book is simple to read and work with.
I wish all books be like this one.

Also you can change BeforeAspect (your custom aspect class like this)
package com; import org.aspectj.lang.JoinPoint; import org.aspectj.lang.annotation.Aspect; import org.aspectj.lang.annotation.Before; import org.aspectj.lang.annotation.Pointcut; @Aspect public class BeforeAspect { @Pointcut("execution (* com.Student.addCustomer())") public void m(){} @Before(value = "com.BeforeAspect.m()") public void logBefore(JoinPoint jp) { System.out.println("logbefore"); System.out.println("method "+jp.getSignature().getName()); } }

note:
@Pointcut("execution (* com.Student.addCustomer())") - you place your pointcut outside @Before and now you can use it as below
and this
@Before(value = "com.BeforeAspect.m()")

I change location of file. (pay note of package, and i change Student to be interface and Studentimpl become class.
package com; public interface Student { public void addCustomer(); public String addCustomername(String stud); }

package com; public class Studentimpl implements Student { @Override public void addCustomer() { // TODO Auto-generated method stub System.out.println("addcustomer"); } @Override public String addCustomername(String stud) { // TODO Auto-generated method stub System.out.println("addcustomername"); return "hello"; } }

@Before("execution( ** com.Student.addCustomer(..))")
or
@Before("execution(** com.Student.addCustomer())")
package com; import org.aspectj.lang.JoinPoint; import org.aspectj.lang.annotation.Aspect; import org.aspectj.lang.annotation.Before; @Aspect public class BeforeAspect { @Before("execution( ** com.Student.addCustomer(..))") public void logBefore(JoinPoint jp) { System.out.println("logbefore"); System.out.println("method "+jp.getSignature().getName()); } }

package com; import org.springframework.aop.framework.ProxyFactory; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class Demo { public static void main(String [] arg){ ApplicationContext context = new ClassPathXmlApplicationContext("com/xmlfiles/beans.xml"); Student studs=(Student) context.getBean("stud"); // System.out.println(studs.addCustomers()); //studs.addCustomername("aaa"); studs.addCustomer(); } }

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns = "http://www.springframework.org/schema/beans" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xmlns:context = "http://www.springframework.org/schema/context" xmlns:aop = "http://www.springframework.org/schema/aop" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <aop:aspectj-autoproxy /> <bean id="stud" class="com.Studentimpl"/> <bean  class="com.BeforeAspect"/> </beans>

By default spring use singleton scope.
this mean that when you retrieve bean
Asian ali = context.getBean("asian", Asian.class); Asian ali2 = context.getBean("asian", Asian.class); System.out.println(ali ==ali2;

if you want  - you can change this behavior.
you must specify other scope:
scope="prototype" add in xml in bean definition
<bean id = "asian" scope="prototype" ............
or
@Component @Scope("prototype") public class Asian implements Person {

http://docs.spring.io/spring/docs/current/spring-framework-reference/htmlsingle/#beans-factory-scopes - you can read more here

Also pay attention when you inject object with prototype in singleton bean.
And pay note when you try configure
@PreDestroy method, container do not manage prototype bean destroy behavior.

My solution was
add
@EnableTransactionManagement to class RootConfig
also add next bean to this class
   @Bean    public PlatformTransactionManager getPlatformTransactionManager(@Autowired SessionFactory sessionFactory) {        PlatformTransactionManager tm = new HibernateTransactionManager(sessionFactory);        return tm;    }

also i change HibernatePersist this way and this will work for me

package com.myspringapp.config.persistance; import com.myspringapp.config.businessobjects.BusinessObject; import java.util.List; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.springframework.context.annotation.Primary; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import org.springframework.transaction.annotation.Transactional; @Primary @Repository public class HibernatePersist implements PersistBusinessObject {    public HibernatePersist() {    }    private SessionFactory sessionFactory;    @Autowired    public void setSessionFactory(SessionFactory sessionFactory) {        this.sessionFactory = sessionFactory;        System.out.println("Session factory succcessful seted inside HebernatePersist");        sessionFactory.openSession();    }    @Transactional    @Override    public void saveObject(BusinessObject businessObject) {        Session session = sessionFactory.getCurrentSession();        //   session.beginTransaction();        session.save(businessObject);        //   session.getTransaction().commit();    }    @Transactional    @Override    public List<BusinessObject> getListOfObjects() {        Session session = sessionFactory.getCurrentSession();        //    session.beginTransaction();        List<BusinessObject> list = session.createQuery("from BusinessObject").list();        // in hibernate 5 must be changed to session.createQuery("from Student").getResultList()        //   session.getTransaction().commit();        return list;    }    @Transactional    @Override    public BusinessObject getObjectById(long id) {        Session session = sessionFactory.getCurrentSession();        //   session.beginTransaction();        BusinessObject businessObject = (BusinessObject) session.get(BusinessObject.class, (Long) id);        //  session.getTransaction().commit();        return businessObject;    } }

Java based spring mvc configuration

Dispatcher
package com.myspringapp.config.basicconfig; import org.springframework.web.servlet.support.AbstractAnnotationConfigDispatcherServletInitializer; public class WebAppInitializer extends AbstractAnnotationConfigDispatcherServletInitializer  { @Override protected Class<?>[] getRootConfigClasses() { // Return domain beans System.out.println("getRootConfigClasses()"); //return new Class[]{RootConfig.class, DataConfig.class}; return new Class[]{RootConfig.class}; } @Override protected Class<?>[] getServletConfigClasses() { // Return web beans System.out.println("getServletConfigClasses()"); return new Class[]{WebConfig.class}; } @Override protected String[] getServletMappings() { // Map servlet to path System.out.println("getServletMappings()"); return new String []{"/"}; } }

Web config. ViewResolver bean
package com.myspringapp.config.basicconfig; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.ComponentScan; import org.springframework.context.annotation.Configuration; import org.springframework.web.servlet.ViewResolver; import org.springframework.web.servlet.config.annotation.EnableWebMvc; import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter; import org.springframework.web.servlet.view.InternalResourceViewResolver; @ComponentScan("com.myspringapp.controllers") @Configuration @EnableWebMvc public class WebConfig extends WebMvcConfigurerAdapter{ @Bean public ViewResolver viewResolver(){ InternalResourceViewResolver resolver = new InternalResourceViewResolver(); resolver.setPrefix("/WEB-INF/views/"); resolver.setSuffix(".jsp"); return resolver; } }

RootConfig. Bean for DataSource , LocalSessionFactoryBean , BeanPostProcessor
package com.myspringapp.config.basicconfig; import com.mysql.jdbc.Connection; import java.sql.SQLException; import java.util.Properties; import java.util.logging.Level; import java.util.logging.Logger; import javax.sql.DataSource; import org.hibernate.SessionFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.config.BeanPostProcessor; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.ComponentScan; import org.springframework.context.annotation.Configuration; import org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor; import org.springframework.jndi.JndiTemplate; import org.springframework.orm.hibernate4.HibernateTransactionManager; import org.springframework.orm.hibernate4.LocalSessionFactoryBean; @ComponentScan({"com.myspringapp.config.persistance", "com.myspringapp.config.businessobjects"}) @Configuration class RootConfig {      @Bean    public DataSource getDataSource() {        DataSource dataSource = null;        JndiTemplate jndi = new JndiTemplate();        try {            dataSource = jndi.lookup("java:comp/env/jdbc/JCGExampleDB1", DataSource.class);        } catch (Exception e) {            e.printStackTrace();        }        try (java.sql.Connection con = dataSource.getConnection();) {            System.out.println("Connection is successful when init bean dataSource");        } catch (SQLException ex) {            Logger.getLogger(RootConfig.class.getName()).log(Level.SEVERE, null, ex);        }        return dataSource;    }    @Bean    public LocalSessionFactoryBean sessionFactory() {        LocalSessionFactoryBean localSessionFactoryBean = new LocalSessionFactoryBean();        localSessionFactoryBean.setDataSource(getDataSource());        localSessionFactoryBean.setPackagesToScan(new String[]{"com.myspringapp.config.persistance", "com.myspringapp.config.businessobjects"});        Properties property = new Properties();        property.setProperty("dialect", "org.hibernate.dialect.MySQL5Dialect");        localSessionFactoryBean.setHibernateProperties(property);        System.out.println("insite creation LocalSessionFactoryBean bean");        return localSessionFactoryBean;    }    // for exception handling    @Bean    public BeanPostProcessor persistenceTranslation() {        return new PersistenceExceptionTranslationPostProcessor();    }     }
Interface for persistence logic
package com.myspringapp.config.persistance; import com.myspringapp.config.businessobjects.BusinessObject; import java.util.List; /** * * @author Media */ public interface PersistBusinessObject {    public void saveObject(BusinessObject businessObject);        public List<BusinessObject> getListOfObjects();        public BusinessObject getObjectById(long id); }
How i try use hibernate to save object
package com.myspringapp.config.persistance; import com.myspringapp.config.businessobjects.BusinessObject; import java.util.List; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.springframework.context.annotation.Primary; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; @Primary @Repository public class HebernatePersist implements PersistBusinessObject {    public HebernatePersist() {    }    private SessionFactory sessionFactory;    @Autowired    public void setSessionFactory(SessionFactory sessionFactory) {        this.sessionFactory = sessionFactory;        System.out.println("Session factory succcessful seted inside HebernatePersist");    }        @Override    public void saveObject(BusinessObject businessObject) {        Session session = sessionFactory.getCurrentSession();        session.beginTransaction();        session.save(businessObject);        session.getTransaction().commit();    }      @Override    public List<BusinessObject> getListOfObjects() {        Session session = sessionFactory.getCurrentSession();        session.beginTransaction();        List<BusinessObject> list = session.createQuery("from BusinessObject").list();        // in hibernate 5 must be changed to session.createQuery("from Student").getResultList()        session.getTransaction().commit();        return list;    }      @Override    public BusinessObject getObjectById(long id) {                Session session = sessionFactory.getCurrentSession();        session.beginTransaction();        BusinessObject businessObject = (BusinessObject) session.get(BusinessObject.class, (Long) id);        session.getTransaction().commit();        return businessObject;    }     }
Controller:
package com.myspringapp.controllers; import com.myspringapp.config.businessobjects.BusinessObject; import com.myspringapp.config.persistance.PersistBusinessObject; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import static org.springframework.web.bind.annotation.RequestMethod.*; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.ui.Model; @Controller public class SympleViewController {    @Autowired    PersistBusinessObject persistBusinessObject;                @RequestMapping(value = "/", method = GET)    public String home() {        System.out.println("inside home() method of SympleViewController.class");        return "home";    }    // create business object view    @RequestMapping(value = "/createBusinessObject", method = GET)    public String createBusinessObject(Model model) {        System.out.println("inside home() method of createBusinessObject.class");        BusinessObject bo = new BusinessObject();        model.addAttribute(bo);        return "createBusinessObject";    }    // list business object view        @RequestMapping(value = "/listBusinessObject", method = GET)    public String listBusinessObject( Model model) {        System.out.println("inside home() method of createBusinessObject.class");        model.addAttribute("listOfObjects", persistBusinessObject.getListOfObjects());        return "listBusinessObject";    }          // create business object view    @RequestMapping(value = "/createBusinessObject", method = POST)    public String createBusinessObjectSaving(BusinessObject businessObject, Model model) {        System.out.println("inside home() method of createBusinessObject.class");        persistBusinessObject.saveObject(businessObject);        model.addAttribute("message", "previous object was saved");        return "redirect:/createBusinessObject";    } }
Object that i want for save:
package com.myspringapp.config.businessobjects; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name = "mybusinessobjects") public class BusinessObject {        @Id    @GeneratedValue(strategy = GenerationType.IDENTITY)    @Column(name = "myId")    private long id;        @Column(name = "mynameOfObject")    private String nameOfObject;        @Column(name = "mytypeOfObject")    private String typeOfObject;        @Column(name = "mydescriptionOfObject")    private String descriptionOfObject;    public BusinessObject(String nameOfObject, String typeOfObject, String descriptionOfObject) {        this.nameOfObject = nameOfObject;        this.typeOfObject = typeOfObject;        this.descriptionOfObject = descriptionOfObject;    }        //default constructor for spring bean instantiation    public BusinessObject(){}    /**     * @return the id     */    public long getId() {        return id;    }    /**     * @param id the id to set     */    public void setId(long id) {        this.id = id;    }    /**     * @return the nameOfObject     */    public String getNameOfObject() {        return nameOfObject;    }    /**     * @param nameOfObject the nameOfObject to set     */    public void setNameOfObject(String nameOfObject) {        this.nameOfObject = nameOfObject;    }    /**     * @return the typeOfObject     */    public String getTypeOfObject() {        return typeOfObject;    }    /**     * @param typeOfObject the typeOfObject to set     */    public void setTypeOfObject(String typeOfObject) {        this.typeOfObject = typeOfObject;    }    /**     * @return the descriptionOfObject     */    public String getDescriptionOfObject() {        return descriptionOfObject;    }    /**     * @param descriptionOfObject the descriptionOfObject to set     */    public void setDescriptionOfObject(String descriptionOfObject) {        this.descriptionOfObject = descriptionOfObject;    }         }
View
JSP where i place form for saving object
<%@page contentType="text/html" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"    "http://www.w3.org/TR/html4/loose.dtd"> <%@ taglib prefix="c"           uri="http://java.sun.com/jsp/jstl/core" %> <%@taglib uri = "http://www.springframework.org/tags/form" prefix = "sf" %> <html>    <head>        <link rel="shortcut icon" href="https://spring.io/img/favicon-ca31b78daf0dd9a106bbf3c6d87d4ec7.png">        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">        <title>createBusinessObject</title>    </head>    <body>        <h1>On this page you can create new business object</h1>        <div>            <!-- link for home page -->            <a href ="<c:url value = "/"/>">Home</a>        </div>        ${message}        <div>            <!-- form for creating business object -->            <sf:form commandName="businessObject">                id  <sf:input path ="id"/></br>                nameOfObject <sf:input path ="nameOfObject"/></br>                typeOfObject <sf:input path ="typeOfObject"/></br>                descriptionOfObject <sf:input path ="descriptionOfObject"/></br>                 <input type ="submit" value ="Register"/> <br></br>            </sf:form>        </div>    </body> </html>

finally when i try save object i get:

org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcher] in context with path [/Spring_Demo_Aplication] threw exception [Request processing failed; nested exception is org.springframework.orm.hibernate4.HibernateSystemException: No Session found for current thread; nested exception is org.hibernate.HibernateException: No Session found for current thread] with root cause
org.hibernate.HibernateException: No Session found for current thread
at org.springframework.orm.hibernate4.SpringSessionContext.currentSession(SpringSessionContext.java:106)
at org.hibernate.internal.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:1013)
at com.myspringapp.config.persistance.HebernatePersist.saveObject(HebernatePersist.java:44)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)

And cant figure where error i made. How can i solve this problem?

Congratulations

Congratulations. Make choose in specialization. And study technology as needed.
If you not work read requirements and prepare for job interview.

I finished ocjp this year and now study Springs framework (it also has it own certification so may be latter will try to get it)

Congratulations!
I agree with you about errata in study guides.

Congratulations!!!