Databases
StackOverflow2013
Postsdbo
POMany to one entity using JPA
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMany to one entity using JPA
    primarykey
    data
    text
    <p>I am trying to create an entity for the table structure given belos</p> <pre><code>(id, name, task, leader_id) </code></pre> <p>this table gives the information about the team users for the particular task and their leader for the team.</p> <p>I wrote the entity like this</p> <pre><code>@Column(name = "id", insertable = false, nullable = false, updatable = true) private Integer id; @Col umn(name = "name", nullable = false) private String tokenName; @Column(name = "task", nullable = false) private String task; @ManyToOne(cascade = ALL, fetch = LAZY) @JoinColumn(name = "leader_id") private User leader; </code></pre> <p>I created the ddl through hibernate3:hbm2ddl and it looks like this</p> <pre><code>alter table user drop foreign key FK60FD5D6395C4EEC2; drop table if exists user; create table user ( id integer not null auto_increment, task varchar(255), name varchar(255) not null, leader_id integer, primary key (id) ); alter table user add index FK60FD5D6395C4EEC2 (leader_id), add constraint FK60FD5D6395C4EEC2 foreign key (leader_id) references user (id); </code></pre> <p>while exporting this schema through maven-sql-plugin, I am getting the following error</p> <pre><code>[ERROR] Failed to execute: alter table user drop foreign key FK60FD5D6395C4EEC2 [INFO] ------------------------------------------------------------------------ [ERROR] BUILD ERROR [INFO] ------------------------------------------------------------------------ [INFO] Column "FOREIGN" not found; SQL statement: alter table user drop foreign key FK60FD5D6395C4EEC2 [42122-158] </code></pre> <p>Where I am doing wrong?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USGnanam
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIt seems hbm2ddl is generating invalid SQL for your database. Are you sure you specified the appropriate dialect. What's your database, and which dialect did you specify?
      singulars
      1. POMany to one entity using JPA
      1. USJB Nizet
    2. CO@JB Nizet org.hibernate.dialect.H2Dialect
      singulars
      1. POMany to one entity using JPA
      1. USGnanam
    3. COAnd your database is?
      singulars
      1. POMany to one entity using JPA
      1. USJB Nizet
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload