Insert new records in database without deleting existing records

[Durga Sanju]

Hi,

I need to know how can we insert new records into our table using hibernate. Actually when using hibernate query to insert record, it will delete the existing records and insert the new records. But i want to insert the new records along with the existing records.

Any information on this will be really helpful for me.

[Sridhar Santhanakrishnan]

Actually when using hibernate query to insert record, it will delete the existing records and insert the new records

Is it so? I have used Hibernate queries and I have never had such problems. More details might help.

[Durga Sanju]

Wat i meant was when i close my application and launch it again, the insert query inserts only new set of records deleting the existing records

[Durga Sanju]

.save() query inserts every time only new records when i relaunch my application resulting in deletion of existing rows.

Thanks for explanation on this

[Shannon McGee]

Hi Durga,

Is the primary key the same? If so, you will over-write the existing records (if you are re-setting a counter, or something).
You may want to look into the annotation @GeneratedValue, an easy way to set up auto-incrementing in JPA.

-Shannon

[Durga Sanju]

Hi Shannon,

I'm very new to hibernate. Can You please help me with an example for that.


Thanks,
-Durga

[Christian Dillinger]

Please post your hibernate.cfg.xml. I think you use a wrong value for hbm2ddl-property.

[Durga Sanju]

hi,

I got the following exception

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: /Save.jsp(3,5) Page directive must not have multiple occurrences of pageencoding
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:102)
org.apache.jasper.compiler.Validator$DirectiveVisitor.visit(Validator.java:194)
org.apache.jasper.compiler.Node$PageDirective.accept(Node.java:608)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2361)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2411)
org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2417)
org.apache.jasper.compiler.Node$Root.accept(Node.java:495)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2361)
org.apache.jasper.compiler.Validator.validateDirectives(Validator.java:1696)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:167)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:332)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:312)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:299)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

i have included code of all the required files. Please tell wat's wrong with the code


//hibernate.cfg.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>

<!-- Database Connection Strings -->
	<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
	<property name="hibernate.connection.url">jdbc:mysql://Mysql:3306/mysql</property>
	<property name="hibernate.connection.username">root</property>
	<property name="hibernate.connection.password">1234qwer$</property>
	<property name="show_sql">true</property>
	<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
	
<!-- Mapping resources files -->
	<mapping resource="story.hbm.xml"/>
	<mapping resource="writer.hbm.xml"/>

</session-factory>
</hibernate-configuration>

//Story.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>

<class name="Story" table="STORY">
<id  name="id" column="ID" type="int">
<generator class="increment">
</generator>
</id>

<property name="info" column="INFO" type="string"></property>
</class>

</hibernate-mapping>

//Writer.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

<class name="Writer" table="WRITER">

<id name="id" column="ID" type="int" > 
<generator class="increment"></generator>
</id>

<list name="stories" cascade="all">
<key  column="parent_id" ></key>
<index column="idx"></index>
<one-to-many class="Story"/>
</list>

<property name="name" column="NAME" type="string"></property>

</class>

</hibernate-mapping>

//save.jsp

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
	Session sess=null;
	SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
	sess=sessionFactory.openSession();
	System.out.println("Inserting Record");
	Writer wr = new Writer();
	wr.setName("Das");
	ArrayList list = new ArrayList();
	list.add(new Story("Story Name 1"));
	list.add(new Story("Story Name 2"));
	wr.setStories(list);
	Transaction transaction = null;
	try {
	transaction = sess.beginTransaction();
	sess.save(wr);
	transaction.commit();
	} catch (Exception e) { 
	if (transaction != null) {
	transaction.rollback();
	throw e;
	}
	} finally { 
	sess.close();
	}

%>
</body>
</html>

//Writer POJO class

import java.util.List;

public class Writer {
    private int id;
    private String name;
    @SuppressWarnings("unchecked")
    private List stories;
    public void setId(int i) {
        id = i;
    }
    public int getId() {
        return id;
    }
    public void setName(String n) {
        name = n;
    }
    public String getName() {
        return name;
    }
    @SuppressWarnings("unchecked")
    public void setStories(List l) {
        stories = l;
    }
    @SuppressWarnings("unchecked")
    public List getStories() {
        return stories;
    }
}

//Story POJO Class

public class Story {

	private int id;
	private String info;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getInfo() {
		return info;
	}
	public void setInfo(String info) {
		this.info = info;
	}
	public Story(String info)
	{
		this.info=info;
	}
}

[Durga Sanju]

I found the error...

I included that page encoding directive twice in my JSP..

.

I got the following error in my JSP now...

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP:

An error occurred at line: 11 in the generated java file
Only a type can be imported. org.hibernate.Transaction resolves to a package

An error occurred at line: 12 in the generated java file
Only a type can be imported. org.hibernate.Session resolves to a package

An error occurred at line: 13 in the generated java file
Only a type can be imported. org.hibernate.SessionFactory resolves to a package

An error occurred at line: 14 in the generated java file
Only a type can be imported. org.hibernate.HibernateException resolves to a package

An error occurred at line: 22 in the jsp file: /Save.jsp
Session cannot be resolved to a type
19: </head>
20: <body>
21: <%
22: Session sess=null;
23: SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
24: sess=sessionFactory.openSession();
25: System.out.println("Inserting Record");


An error occurred at line: 23 in the jsp file: /Save.jsp
SessionFactory cannot be resolved to a type
20: <body>
21: <%
22: Session sess=null;
23: SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
24: sess=sessionFactory.openSession();
25: System.out.println("Inserting Record");
26: Writer wr = new Writer();


An error occurred at line: 23 in the jsp file: /Save.jsp
Configuration cannot be resolved to a type
20: <body>
21: <%
22: Session sess=null;
23: SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
24: sess=sessionFactory.openSession();
25: System.out.println("Inserting Record");
26: Writer wr = new Writer();


An error occurred at line: 29 in the jsp file: /Save.jsp
The constructor Story(String) is undefined
26: Writer wr = new Writer();
27: wr.setName("Das");
28: ArrayList list = new ArrayList();
29: list.add(new Story("Story Name 1"));
30: list.add(new Story("Story Name 2"));
31: wr.setStories(list);
32: Transaction transaction = null;


An error occurred at line: 30 in the jsp file: /Save.jsp
The constructor Story(String) is undefined
27: wr.setName("Das");
28: ArrayList list = new ArrayList();
29: list.add(new Story("Story Name 1"));
30: list.add(new Story("Story Name 2"));
31: wr.setStories(list);
32: Transaction transaction = null;
33: try {


An error occurred at line: 32 in the jsp file: /Save.jsp
Transaction cannot be resolved to a type
29: list.add(new Story("Story Name 1"));
30: list.add(new Story("Story Name 2"));
31: wr.setStories(list);
32: Transaction transaction = null;
33: try {
34: transaction = sess.beginTransaction();
35: sess.save(wr);


Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:334)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:312)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:299)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

i didnt change any code after that

[Ankit Garg]

Please show us the *complete* code of your Save.jsp. The errors that you are showing to us are related to the page directive, and the code that you have given doesn't have any page directive. Once your JSP is working we can move on to solving your Hibernate problem...

[Durga Sanju]

hi,

below is the jsp code....

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="java.sql.*"%>
<%@page import="java.util.List"%>
<%@page import="java.util.ArrayList"%>
<%@page import="java.util.Iterator"%>
<%@page import="org.hibernate.Transaction"%>
<%@page import="org.hibernate.Session"%>
<%@page import="org.hibernate.SessionFactory"%>
<%@page import="org.hibernate.HibernateException"%>
<%@page import="org.hibernate.cfg.*" %>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
Session sess=null;
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
sess=sessionFactory.openSession();
System.out.println("Inserting Record");
Writer wr = new Writer();
wr.setName("Das");
ArrayList list = new ArrayList();
list.add(new Story("Story Name 1"));
list.add(new Story("Story Name 2"));
wr.setStories(list);
Transaction transaction = null;
try {
transaction = sess.beginTransaction();
sess.save(wr);
transaction.commit();
} catch (Exception e) {
if (transaction != null) {
transaction.rollback();
throw e;
}
} finally {
sess.close();
}

%>
</body>
</html>

[comanitza st.]

hi
i have the same problem, and it seems hibernate creates a new table every time my app starts, i tried setting my hbm2ddl to just about everything, like: validate, update, create-drop, create, i even tryed to remove it from the config, but to no result, please help me.

thank you.

[comanitza st.]

ooops, found my bug, and was a silly one indeed, i use ant to compile/build my files, and i touth that it will override my hibernate.cfg.xml, but it didnt, so i bassicly edited the one in my src folder, not in classes.
the good news it's that "hbm2ddl.auto" set to "update" works.

thank you.

comanitza