hibernate annotations with composite primary key
I want to know how to use hibernate annotations in case of composite primary key in one table.
I tried like this, I have created a table without primary key. By default mssql has created a composite primary key with all the columns of the table.
table: create table student(sid number(5),sname varchar2(20),age number(3));
And i have created 2 pojo classes like this,
Student.java:
@Entity
@Table(name="student_tbl")
@IdClass(StudentID.class)
public class Student implements Serializable{
/**
*
*/
private static final long serialVersionUID = -7007299156855950071L;
private StudentID id;
public StudentID getId() {
return id;
}
public void setId(StudentID id) {
this.id = id;
}
}
import javax.persistence.Column;
import javax.persistence.Embeddable;
import javax.persistence.OneToMany;
@Embeddable
public class StudentID {
long sid;
String name;
double age;
@OneToMany
public long getSid() {
return sid;
}
public void setSid(long sid) {
this.sid = sid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getAge() {
return age;
}
public void setAge(double age) {
this.age = age;
}
}
And i have created a Store.java to store a record inside the mssql database.
import org.hibernate.Session;
import org.hibernate.Transaction;
public class Store {
public static void main(String[] args) {
Session session=HibernateSessionFactory.getSession();
Transaction tx=session.beginTransaction();
Student studentObject=new Student();
StudentID studentIDObject=new StudentID();
studentIDObject.setSid(123456l);
studentIDObject.setName("suresh");
studentIDObject.setAge(24d);
studentObject.setId(studentIDObject);
session.save(studentObject);
tx.commit();
session.close();
}
}
When i ran the above java file, i got following exception,
%%%% Error Creating SessionFactory %%%%
org.hibernate.AnnotationException: No identifier specified for entity: com.tbss.Student
at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:672)
at org.hibernate.cfg.AnnotationConfiguration.processArtifactsOfType(AnnotationConfiguration.java:546)
at org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:291)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1333)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
at com.tbss.HibernateSessionFactory.(HibernateSessionFactory.java:32)
at com.tbss.Store.main(Store.java:8)
%%%% Error Creating SessionFactory %%%%
org.hibernate.AnnotationException: No identifier specified for entity: com.tbss.Student
at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:672)
at org.hibernate.cfg.AnnotationConfiguration.processArtifactsOfType(AnnotationConfiguration.java:546)
at org.hibernate.cfg.AnnotationConfiguration.secondPassCompile(AnnotationConfiguration.java:291)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1333)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
at com.tbss.HibernateSessionFactory.rebuildSessionFactory(HibernateSessionFactory.java:71)
at com.tbss.HibernateSessionFactory.getSession(HibernateSessionFactory.java:54)
at com.tbss.Store.main(Store.java:8)
Exception in thread "main" java.lang.NullPointerException
at com.tbss.Store.main(Store.java:9)
Please help me in resolving this problem. And please send the answer to following mail id
View Answers
Ads
Related Tutorials/Questions & Answers:
hibernate annotations with composite primary key
hibernate annotations with
composite primary key I want to know how to use
hibernate annotations in case of
composite primary key in one table.
I... created a
composite primary key with all the columns of the table.
table
composinte primary key in hibernate
primary key with all the columns of the table and
hibernate s/w has created two pojo...composinte
primary key in hibernate I am facing following problem,
Inside the database(mssql), i have created a table without
primary key
Advertisements
Adding A Primary Key to an Existing Table
Adding A
Primary Key to an Existing Table Been trying to add a
primary key to a MySQL table using Java for two days with no success. I'm new...
KEY (SerialNo)");
out.println("
Primary key added
SQL Alter Table Primary Key
SQL Alter Table
Primary Key
Alter a Table
Primary Key in SQL modifies the existing table and adds a
primary key.
Create Table Stu_Table
SQL statement to create
changing primary key of parent table
changing
primary key of parent table I want to change one
primary key from a table where
primary key is auto created? How can I do that? I have tried
UPDATE person SET personid=3494 WHERE personid=8483;
and i get the following
SQL PRIMARY KEY Constraint
SQL
PRIMARY KEY Constraint
The
PRIMARY KEY constraint is used to uniquely identifies each...
values. It should contain NULL values. The Table contain a
primary key
JDBC insert that returns primary key
JDBC insert that returns
primary key How to write code for jdbc insert that returns
primary key?
Help me fast
Thanks
Hi,
Following code can be used:
//Add record into database
String queryInsert = "insert
Mysql add primary key
Mysql add
primary key
Mysql add
Primary Key is used to add
primary key on the column... of this tutorial illustrate an example from 'Mysql Add
Primary Key'. To understand
SQL Primary Key
SQL
Primary Key
The
Primary Key in SQL is used to uniquely identifies each records in a
database table. The
Primary Key of the Table does not include NULL values
Mysql Alter Table Primary Key
Mysql Alter Table
Primary Key
Mysql Alter Table
Primary Key is used to remove the
primary key from the
table and add
primary key to the existing other column of table
SQL PRIMARY KEY Constraint
SQL
PRIMARY KEY Constraint
The
PRIMARY KEY constraint is used to uniquely... a unique
values. It should contain NULL values. The Table contain a
primary key
Mysql Alter Column Primary Key
Mysql Alter Column
Primary Key
Mysql Alter Column
Primary Key is used to modify table and redefine the
Primary Key Column in a table.
Understand with Example
How to auto increment primary key in mysql...
How to auto increment
primary key in mysql... How to auto increment
primary key in mysql...
and one more thing i need to get auto increment value in front end each time for inserting the value[JSP
Hibernate generator Element
In this tutorial you will learn about the
hibernate's generator element , which is used to auto generate the
primary key value
hibernate Foreign key
(255) DEFAULT NULL,
City varchar(255) DEFAULT NULL,
PRIMARY KEY (P_Id...) NOT NULL,
OrderNo int(11) NOT NULL,
P_Id int(11) DEFAULT NULL,
PRIMARY KEY (O_Id...
hibernate Foreign key sir,
I am using
hibernate in netbeans.
I have
SQL Auto increment Primary Key
SQL Auto increment
Primary Key
SQL Auto increment
Primary Key is used to allow a unique... increment
Primary Key'. To understand this example we use a query 'use
Hibernate unique key validation example
Hibernate unique
key validation example Hi,
How to preform unique
key validation in
Hibernate application?
Thanks
Hi,
You write a program to check for the presence of the
key in database before performing add
Hibernate Annotations Example
Hibernate Annotations Example
In this section we will see how we can develop
Hibernate Annotations based
example program. After completing this tutorial you will be able to use
Hibernate Annotations in your project and develop
hibernate annotations
hibernate annotations I am facing following problem, I have created 2 tables (student and address) with foreign
key in address table. I am using
hibernate annotations to insert records into these tables. But it is trying
Hibernate 4 Annotations
Hibernate 4
Annotations
In this tutorial you will learn about the use of
annotations in
Hibernate.
To create an example in
Hibernate using Annotation reader... property.
@GeneratedValue : Specified the
primary key generation strategy