Hibernate insert problem

can someone tell me what is wrong with this code.
it prints "Data Inserted Successfully" but does not insert the values to database

Expand|Select|Wrap|Line Numbers

  
<%!

int empno;double salary;String name; Session session1 = null;

%>

<body>

<%

String num1=request.getParameter("t1");

if(num1 != null)

{

empno=Integer.parseInt(num1);

name=request.getParameter("t2");

String sal=request.getParameter("t3");

salary=Integer.parseInt(sal);

try

{

Configuration cf=new Configuration();

cf.configure();

SessionFactory sessionFactory = cf.buildSessionFactory();

session1 =sessionFactory.openSession();

Transaction tr = session1.beginTransaction();

Emp e=new Emp(empno,name,salary);

tr.commit();

session1.save(e);
 
session1.close();

out.println("<h1>Data Inserted Successfully</h1>");

}

catch(Exception e)

{

System.out.println("e="+e.getMessage());

}

}

%>
 
<form>

  <table width="352" border="1">

    <tr>

      <th>Emp Number</th>

      <td><input name="t1" type="text"></td>

    </tr>

    <tr>

      <th> Name </th>

      <td><input name="t2" type="text"></td>

    </tr>

    <tr>

      <th>Salary </th>

      <td><input name="t3" type="text"></td>

    </tr>

    <tr>

      <th colspan="2"><input type="submit"value="Submit" >

      </th>

    </tr>

  </table>

</form>

</body>

</html>

Mar 1 '13 #1

Subscribe Post Reply

1507

r035198x

13,262

8TB

1.) Don't mix java with HTML. Use plain java classes for the hibernate parts.
2.) You are committing the transaction before saving the data.

Mar 6 '13 #2

Similar topics

MySQL INSERT problem

by: Caversham | last post by:

I am trying to insert data into the fields id and term of the table key. id is an auto-incrementing field. Each of the following forms fails:- INSERT INTO key (id, term) VALUES (0, 'dog') ...

PHP

Insert problem with linked server

by: Adrian | last post by:

Both servers running SQL 2000 I have set up on our local SQL server (using Enterprise Manager) a linked server running on our ISP. Just did new linked server and added remote password and login....

Microsoft SQL Server

sql insert problem

by: kieran | last post by:

INSERT INTO Comments_tbl (FullName_tsf, Email_tsf, NTuser_tsf, name_tsf, type_tsf, comments_tsf) VALUES ('Test Tester' , 'tester@test.com', 'ttest', 'test', 'help', 'need better help') I am...

Microsoft SQL Server

Linked server insert problem

by: Steve Kuekes | last post by:

I have two sql servers, I have defined each one as a linked server to the other. I can mostly access the servers from one another, but I get the following error on a sql insert. Insert...

Microsoft SQL Server

String.Insert() problem

by: Raed Sawalha | last post by:

dear : i have the following problem: string sAttachmentBody; int nCount = 0; int nMaxLineLength = 77; //sAttachmentBody.Length may reaches (560960 chars)

ASP.NET

Insert problem

by: simon | last post by:

I have couple asp.net controls on the page, including compare and range validators. When user click the insert button, the data are inserted into the database. It works on my computer and on...

ASP.NET

SqlDataSource Insert problem

by: Steven Blair | last post by:

When I hit a button inside my FormView which has Insert as its Command Name, my Insert statement is executed with the correct parameters (the events Inserting & Inserted are fired). But I need...

C# / C Sharp

DataSet insert problem

by: paulhux174 | last post by:

Hi, I've a dataGrid set up (the standard msdn example) with a SqlDataAdapter, and DataSet. The problem is that after inserting a new row using the LinkButton1_Click() (code below) then edit...

ASP.NET

ASP.net SQL Insert Problem

by: Brad Baker | last post by:

I'm trying to write a simple asp.net page which updates some data in a SQL database. At the top of the page I have the following code: <%@ Page Language="C#" Debug="true" %> <%@ import...

ASP.NET

INSERT problem

by: abracad_1999 | last post by:

I am trying to populate a table with the following insert query run through phpmyadmin. When I attempt to run it phpmyadmin just freezes. After a while "Fatal error: Maximum execution time of 300...

MySQL Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing