@Entity
public class Item {

    @Id
    @GeneratedValue
    @Column(name = "ID")
    private int id;

    @Pattern(regexp="^[a-zA-Z0-9.\s]+$", message="only letters, numbers, spaces and {.!}!")
    private String name;

    // getter, setter
}

public interface ItemJpaRepository extends JpaRepository<Item, Integer>{}

@Service
@Transactional
public class ItemService {

    @Autowired
    ItemDAO itemDAO;

    @Autowired
    ItemJpaRepository itemJpaRepository;

    public void saveOrUpdateItem(){
        itemDAO.saveOrUpdateItem(); //working
        itemJpaRepository.save(entity) //not working
    }

    public void findAllItems(){
        System.out.println(itemJpaRepository.findAll());
    }
}

@Bean
public DataSource getDataSource() {
    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setDriverClassName("com.mysql.jdbc.Driver");
    dataSource.setUrl("jdbc:mysql://localhost:3306/shoppingcartspringmvcspringdatahibernate");
    dataSource.setUsername("root");
    dataSource.setPassword("Scholl1313.");
    //dataSource.setValidationQuery("select 1");

    return dataSource;
}

@Bean(name = "sessionFactory")
public SessionFactory getSessionFactory() {

    LocalSessionFactoryBuilder sessionBuilder = new LocalSessionFactoryBuilder(getDataSource());
    sessionBuilder.scanPackages("com.zdranganele.models");
    sessionBuilder.setProperty("hibernate.show_sql", "true");
    sessionBuilder.setProperty("hibernate.hbm2ddl.auto", "create");
    sessionBuilder.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
    return sessionBuilder.buildSessionFactory();
}

@Bean(name = "transactionManager")
public HibernateTransactionManager getTransactionManager() {

    HibernateTransactionManager transactionManager = new HibernateTransactionManager(getSessionFactory());
    return transactionManager;
}

@Bean
public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
    LocalContainerEntityManagerFactoryBean entityManagerFactoryBean = new LocalContainerEntityManagerFactoryBean();
    entityManagerFactoryBean.setDataSource(getDataSource());
    entityManagerFactoryBean.setPersistenceProviderClass(HibernatePersistenceProvider.class);
    entityManagerFactoryBean.setPackagesToScan("com.zdranganele.models");

    return entityManagerFactoryBean;
}