All about Sergej Smoljanov

Spring boot with JDBC

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

7 years ago

Spring

JPA show_SQL query

I try add to properties application.properties:

also just one options

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.

7 years ago

Spring

Hibernate /JPA and Spring Data statistics join 2 tables. Result from talbe 1 daily values

Sorry one correct
instead .
but question still actual

7 years ago

Object Relational Mapping

Hibernate /JPA and Spring Data statistics join 2 tables. Result from talbe 1 daily values

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

I created entities classes:

for using spring data i create:

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

7 years ago

Object Relational Mapping

Craig Walls' book Spring in Action

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.

7 years ago

Spring

Pro Spring by Rob Harrop, Jan Machacek

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.

7 years ago

Book Reviews

spring aop not supporing aspectJ annotation

Also you can change BeforeAspect (your custom aspect class like this)

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()")

7 years ago

Spring

spring aop not supporing aspectJ annotation

I change location of file. (pay note of package, and i change Student to be interface and Studentimpl become class.

@Before("execution( ** com.Student.addCustomer(..))")
or
@Before("execution(** com.Student.addCustomer())")

7 years ago

Spring

Different Objects referring to same property|field

By default spring use singleton scope.
this mean that when you retrieve bean

if you want - you can change this behavior.
you must specify other scope:
scope="prototype" add in xml in bean definition

or

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.

7 years ago

Spring

Spring + Hibernate No Session found for current thread

My solution was
add
@EnableTransactionManagement to class RootConfig
also add next bean to this class

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;
   }
}

7 years ago

Spring

Spring + Hibernate No Session found for current thread

Java based spring mvc configuration

Dispatcher

Web config. ViewResolver bean

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

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>
           
           <a href ="<c:url value = "/"/>">Home</a>
       </div>
       ${message}
       <div>
           
           <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?

7 years ago

Spring

Passed OCPJP 7 with 95%

Congratulations

7 years ago

Certification Results

I passed the OCPJP7 exam with 81%.

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)

7 years ago

Certification Results

1Z0-804 exam: my personal feedback and some thoughts

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

7 years ago

Programmer Certification (OCPJP)

Passed OCP7 Programmer II

Congratulations!!!

7 years ago

Certification Results

Sergej Smoljanov

Recent posts by Sergej Smoljanov