Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Hibernate hibernate Foreign key
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


gautamshetkar
hibernate Foreign key
1 Answer(s)      3 years and 8 months ago
Posted in : Hibernate


sir, I am using hibernate in netbeans. I have 2 following tables

CREATE TABLE persons ( P_Id int(11) NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255) DEFAULT NULL, Address varchar(255) DEFAULT NULL, City varchar(255) DEFAULT NULL, PRIMARY KEY (P_Id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$

CREATE TABLE orders ( O_Id int(11) NOT NULL, OrderNo int(11) NOT NULL, P_Id int(11) DEFAULT NULL, PRIMARY KEY (O_Id), KEY P_Id (P_Id), CONSTRAINT orders_ibfk_1 FOREIGN KEY (P_Id) REFERENCES persons (P_Id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1$$

I want to insert data using set methods in orders table in feild P_Id which is foreign key. How to insert? Thank you in advance.


Advertisement
View Answers

March 1, 2011 at 12:49 PM


Have a look at the given link:

Hibernate Tutorials



Related Tutorials/Questions & Answers:
hibernate Foreign key
hibernate Foreign key  sir, I am using hibernate in netbeans. I have...), KEY P_Id (P_Id), CONSTRAINT orders_ibfk_1 FOREIGN KEY (P_Id) REFERENCES... using set methods in orders table in feild P_Id which is foreign key. How to insert
Foreign key update table
Foreign key update table  How to update table that has the foreign key in SQL..?   ALTER TABLE YourTable ADD CONSTRAINT FK_YourForeignKey FOREIGN KEY (YourForeignKeyColumn) REFERENCES YourPrimaryTable
Advertisements
Foreign key in mysql
Foreign key in mysql  Hi I am creating a website and linking..., there are foreign keys in some of the tables - does anyone know how to link the foreign key of one table into another table within phpmyadmin so the database
foreign key error in sql
foreign key error in sql  create table matchdetails(mid varchar2(10... varchar2(10),sixes varchar2(10),primary key(mid.pid), foreign key(mid... on foreign key can any one tell me plz how to reference matchdetails
crud operations with foreign key constraint.
crud operations with foreign key constraint.  I neeed to know how to perform crud operations in mysql with foreign key constraint using mvc architecture i.e using servlet jsp and bean. please provide all the code so that i can
Mysql Alter Foreign Key
Mysql Alter Foreign Key       A Foreign Key is a field that marks to the primary key of another  table. The use of the foreign key is used to ensure referential
how to use foreign key in java
how to use foreign key in java  I have two tables in my MySQL... varchar(30), CONSTRAINT fkid FOREIGN KEY(idfk) REFERENCES table1(id) ON DELETE CASCADE ) The point is that table2 has a foreign key referencing the primary key
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key
how tohow to create a table with primary key and foreign keyhow to create a table with primary key and foreign key  how to create a table using java language with primary key and foreign key   Hi Friend, A foreign
alter table add foreign key mysql
alter table add foreign key mysql  Hi, How to add foreign key in mysql using the query 'alter table add foreign key mysql' Thanks   Hi, We can use the following query: ALTER TABLE emp_address ADD FOREIGN KEY (emp_id
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
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
Create primary key using hibernate
Create primary key using hibernate  How to create primary key using hibernate?   The id element describes the primary key for the persistent class and how the key value is generated.   <id name="id
How to create primary key using hibernate?
How to create primary key using hibernate?  Hi, How to create primary key using hibernate? Thanks
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 tried like this, I have created a table without primary key. By default mssql has
Define sequence generated primary key in hibernate
Define sequence generated primary key in hibernate  How to define sequence generated primary key in hibernate?   Use value "sequence" for class attribute for generator tag. <id column="USER_ID" name="id" type
can we update table in hibernate with out primary key in table?
can we update table in hibernate with out primary key in table?  can we update table in hibernate with out primary key in table
java.sql.BatchUpdateException: Duplicate entry '135-16448' for key 1 - Hibernate
java.sql.BatchUpdateException: Duplicate entry '135-16448' for key 1  ... (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Hibernate: insert into hardware_system_configuration.filesystems (filesystem_name.... java.sql.BatchUpdateException: Duplicate entry '135-16448' for key 1
get information about foreign keys - JDBC
get information about foreign keys  How to get the information about foreign keys in Java
Get information about foreign keys used in a table.
Get information about foreign keys used in a table.  How can I get information about foreign keys used in a table
primary key and unique key
primary key and unique key  Whats is mean by primary key and unique key
primary key and unique key
primary key and unique key  hello, What's the difference between a primary key and a unique key?   hii, Unique key: column restricts entry of duplicate values but entry of null values is allowed. Primary key
Define candidate key, alternate key, composite key.
Define candidate key, alternate key, composite key.  Define candidate key, alternate key, composite key
Understanding Hibernate <generator> element
a table and column (by default hibernate_unique_key and next_hi respectively... the primary key value. foreign uses the identifier... Understanding Hibernate <generator> element
I determine where a given table is referenced via foreign keys.
I determine where a given table is referenced via foreign keys.  How can I determine where a given table is referenced via foreign keys
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
How to design key, design key, key
How to design key       It has been made easy now to design a key by this example, just...: Take "cccccc" color and choose Pen tool (P key), Make points. Select
HIBERNATE COMPOSITE ID - Hibernate
default NULL, `timeOut` time default NULL, PRIMARY KEY (`sno`), KEY `FK_attendance` (`empRef`), CONSTRAINT `FK_attendance` FOREIGN KEY (`empRef...HIBERNATE COMPOSITE ID  Hi, I have a database table structure
difference between a primary key and a unique key?
difference between a primary key and a unique key?  What's the difference between a primary key and a unique key?   Hi, The column holding the primary key constraint cannot accept null values.whereas column holding
Automatic key press
Automatic key press  Hi Please any one help me is it possible automatic key press in j2me
HIBERNATE
HIBERNATE   What is difference between Jdbc and Hibernate
hibernate
hibernate  what is hibernate flow
Advertisements
 

 

 

DMCA.com