Forum:

Spring

Spring Hibernate - Not Saving to Database Table via HibernateTemplate

Ranch Hand

Posts: 186

posted 5 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello, I am having a problem in which my Spring Hibernate Application is not storing created objects into a Database Table via the Hibernate template. Here is my code

Hibernate Mapping File:

Application Context:

<?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"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context.xsd">
    
    <bean id = "dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/edureka?useLegacyDatetimeCode=false&serverTimezone=Europe/Amsterdam&useSSL=false" />
        <property name="username" value="lamdo" />
        <property name="password" value="password" />
    </bean>
    
    <bean id= "mySessionFactory" class = "org.springframework.orm.hibernate5.LocalSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="mappingResources">
            <list>
                <value>mobilephone.hbm.xml</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
                <prop key="hibernate.hbm2ddl.auto">update</prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
    
    <bean id = "dao" class = "co.module12.MobilePhoneDAO">
        <property name="sessionFactory" ref = "mySessionFactory"/>
    </bean>

</beans>

POJO/Bean Class:

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package co.module12;

/**
 *
 * @author Lamdo
 */
public class MobilePhone {
    private String manfacturer;
    private String colour;
    private Double price;
    private String name;
    private Integer id;

public MobilePhone() {
        
    }

public String getManfacturer() {
        return manfacturer;
    }

public void setManfacturer(String manfacturer) {
        this.manfacturer = manfacturer;
    }

public String getColour() {
        return colour;
    }

public void setColour(String colour) {
        this.colour = colour;
    }

public Double getPrice() {
        return price;
    }

public void setPrice(Double price) {
        this.price = price;
    }

public String getName() {
        return name;
    }

public void setName(String name) {
        this.name = name;
    }
    
    public Integer getId() {
        return id;
    }

public void setId(Integer id) {
        this.id = id;
    }
    
    
    
    
}

DAO class:

Main class (Instantiation of Objects to be stored in DB Table):

import org.springframework.context.support.ClassPathXmlApplicationContext;

/**
 *
 * @author Lamdo
 */
public class Module12MainClass {
    public static void main(String[] args) {
        ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        MobilePhoneDAO dao = (MobilePhoneDAO)context.getBean("dao");
        
        /*Create Mobile Phone One to Map to mySQL database*/
        MobilePhone samsungOne = new MobilePhone();
        samsungOne.setColour("black");
        samsungOne.setManfacturer("Samsung");
        samsungOne.setName("Galaxy S9+");
        samsungOne.setPrice(55158.25);
        samsungOne.setId(1001);
        dao.saveMobile(samsungOne);
        
        /*Create Mobile Phone Two to Map to mySQL database*/
        MobilePhone lgPhone = new MobilePhone();
        lgPhone.setColour("gray");
        lgPhone.setManfacturer("LG");
        lgPhone.setName("G7");
        lgPhone.setPrice(58782.25);
        lgPhone.setId(1002);
        dao.saveMobile(lgPhone);
        
    }
    
}

Al Hobbs

Bartender

Posts: 669

I like...

posted 5 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Is your code throwing an exception or what?

Naziru Gelajo

Ranch Hand

Posts: 186

I like...

posted 5 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Al Hobbs wrote:Is your code throwing an exception or what?

No exception is being thrown. It just does not save object data to the table. It successfully creates the table with the proper columns however.

Al Hobbs

Bartender

Posts: 669

I like...

posted 5 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Have you looked at the logs to see what's happening? Also, are you using NetBeans? Looks like NetBeans.

Naziru Gelajo

Ranch Hand

Posts: 186

I like...

posted 5 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Al Hobbs wrote:Have you looked at the logs to see what's happening? Also, are you using NetBeans? Looks like NetBeans.

Yep, I am using Netbeans. This is the only thing I find in the logs:

Arun Singh Raaj

Ranch Hand

Posts: 240

posted 5 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

According to the logs, it is not creating the tables.
But as you said it created the tables, maybe the tables already exist in db.
plus I hope you have mysql jar added to the classpath.