ROO: how to create composit primary key in Entity

Posted by Paul on Stack Overflow See other posts from Stack Overflow or by Paul
Published on 2010-05-07T12:45:02Z Indexed on 2010/05/07 12:48 UTC
Read the original article Hit count: 534

Filed under:

entity

|

primary

|

key

Hi,

What can I do if I need to create entity for a table in production DB (Oracle 10g) with composite primary key.

For example: [CODE]

CREATE TABLE TACCOUNT
(
  BRANCHID     NUMBER(3)                        NOT NULL,
  ACC          VARCHAR2(18 BYTE)                NOT NULL,
  DATE_OPEN    DATE                             NOT NULL,
  DATE_CLOSE   DATE,
  NOTE         VARCHAR2(38 BYTE)
);
CREATE UNIQUE INDEX PK_TACCOUNT ON TACCOUNT
(BRANCHID, ACC);

I don't want to change the structure of this table.

Is it possible to create an "id" field using roo commands?

I use Spring Roo 1.0.2.RELEASE [rev 638]

Paul

© Stack Overflow or respective owner

Related posts about entity

Entity Framework + AutoMapper ( Entity to DTO and DTO to Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. i got some problems using EF with AutoMapper. =/ for example : i got 2 related entities ( Customers and Orders ) and theyr DTO classes : class CustomerDTO { public string CustomerID {get;set;} public string CustomerName {get;set;} public IList< OrderDTO Orders {get;set;} } class… >>> More
What .Net Namespace contains Entity for use in a generic repository?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a question that I'm ashamed to ask, but I'm going to have a go at it anyway. I am creating a generic repository in asp.net mvc. I came across an example on this website which I find to be exactly what I was looking for, but there is one problem. It references an object - Entity - and I don't… >>> More
Entity Framework version 1- Brief Synopsis and Tips – Part 1

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
To Do Eager loading use Projections (for e.g. from c in context.Contacts select c, c.Addresses) or use Include Query Builder Methods (Include(“Addresses”)) If there is multi-level hierarchical Data then to eager load all the relationships use Include Query Builder methods like customers.Include("Order… >>> More
Hibernate unknown entity (not missing @Entity or import javax.persistence.Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a really simple class... import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name = "users") public class User { … >>> More
Prevent Custom Entity being deleted from Entity Framework during Update Model Wizard

as seen on Stack Overflow - Search for 'Stack Overflow'
In Entity Framework v1 If you create a Custom Entity to map it to a Stored Procedure during FunctionImport and then Select "Update Model from Database" the Update Model Wizard removes the Custom Entity (as added Manually in the SSDL XML prior to functionImport) from the SSDL. Does anyone know if… >>> More

Related posts about primary

How Can I Reference Multiple Primary Keys For A Vector Type Primary Key

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have the following scenario: a table of projects and a table of persons, working on one or serveral projects. Also, I have a project id column (of type int), in the first table, which is a primary key there and I have a vector of project ids, as a column of type int, in my second table (persons)… >>> More
MySQL: Changing order of auto-incremented primary keys?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a table with a auto-incremented primary key: user_id. For a currently theoretical reason, I might need to change a user_id to be something else than it was when originally created through auto-incrementation. This means there's a possibility that the keys will not be in incremental order… >>> More
Optimize MySQL query (ngrams, COUNT(), GROUP BY, ORDER BY)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database with thousands of companies and their locations. I have implemented n-grams to optimize search. I am making one query to retrieve all the companies that match with the search query and another one to get a list with their locations and the number of companies in each location. The… >>> More
Ancillary Objects: Separate Debug ELF Files For Solaris

as seen on Oracle Blogs - Search for 'Oracle Blogs'
We introduced a new object ELF object type in Solaris 11 Update 1 called the Ancillary Object. This posting describes them, using material originally written during their development, the PSARC arc case, and the Solaris Linker and Libraries Manual. ELF objects contain allocable sections,… >>> More
Who could ask for more with LESS CSS? (Part 3 of 3–Clrizr)

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Welcome back! In the first two posts in this series, I covered some of the awesome features in CSS precompilers such as SASS and LESS, as well as how to get an initial project setup up and running in ASP.Net MVC 4. In this post, I will cover an actual advanced example of using LESS in a project,… >>> More