Question: hibernate Foreign key

Ads

 
 
 

Share on Google+Share on Google+

gautamshetkar
hibernate Foreign key
1 Answer(s)      6 years and 2 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.

Ads
View Answers

March 1, 2011 at 12:49 PM


Have a look at the given link:

Hibernate Tutorials


Ads









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
HIBERNATE
HIBERNATE   What is difference between Jdbc and Hibernate
hibernate
hibernate  what is hibernate flow
hibernate
hibernate  what is hibernate listeners
Tutorials   
Java Spring Hibernate Struts Training Hibernate maven dependency example What is the difference between JPA and Hibernate? How to turn off hbm2ddl? Hibernate hbm2ddl.auto values Hibernate table not mapped error - solution Hibernate error class is not mapped Hibernate Envers custom revinfo table Hibernate Envers - REVINFO table doesn't exist How to enable second level cache in Hibernate 5? How to enable second level cache in Hibernate 5? java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based! org.hibernate.validator cannot be resolved error java.lang.ClassNotFoundException: org.hibernate.cache.TimestampsRegion java.lang.ClassNotFoundException: org.hibernate.cache.TimestampsRegion property hibernate.cache.region.factory_class is not given Hibernate example step by step in Eclipse with MySQL How to make Struts Hibernate and Spring Based Login/Registration Application? What is the use of Hibernate Native SQL? What is the use of Hibernate is used? How to integrate Struts and Hibernate in an application? How to create the program in Java for getting the forgotten Password Form? How to write create JPA Many-to-Many Relationship in Java? What is the DAO Layer in any application? What is Spring Struts Hibernate DAO Layer? How to write Example code for CRUD application in hibernate annotation? Where to update the Hibernate tools? Query conversion convert into hql how to convert sql into hql package org.hibernate.util does not exist C3P0 with Hibernate What do you understand by JPA? Hibernate Query Checker Jpa many to many relationship What do you understand by Hibernate in Java? What are criteria Queries in Hibernate? How to use Associations and Joins in Hibernate? Hibernate 4 Example with Eclipse How to learn Hibernate? What is Hibernate Framework? hibernate faq 15/03/14 hibernate 15/03/2014 Hibernate Criteria Wildcard how to add mulitiple projections this is a hibernate question this is a hibernate question this is a hibernate question how to writw connection pool coding Hibernate 4.3 and JPA 2.1 support How to create Hibernate session factory name?

Ads

 
Advertisement null

Ads