com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'xxx'

Question

Entity class 1

       @Entity
       @Table(name = "TICKETS")
       public class Ticket {

       ....

      @Column(name = "MERCHANT_NBR")
      private String merchant_nbr;

      @ManyToOne(fetch = FetchType.LAZY)
      @JoinColumn(name = "merchant_nbr", nullable = false)
      private Merchant merchant;

     @ManyToOne(fetch = FetchType.LAZY)
     @JoinColumn(name ="merchantNBR", nullable = false)
     private merchantDetails merchantDetails;

Entity class 2

  @Entity
  @Table(name="MERCHANT_DETAILS")
  public class merchantDetails {

    @Id
    @Column(name="MERCHANT_NBR")
    private String merchantNBR;

    @OneToMany(fetch = FetchType.LAZY)
    private Set<Ticket> ticket;

error its giving...invalid column 'merchantNBR'.But I have a column by that name.

   com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'merchantNBR'.

the column name is MERCHANT_NBR and not merchantNBR as it's showed in your hibernate annotation — PacMan
– PacMan, Commented Jun 30, 2016 at 16:48
thanks for your reply. When I change that, it gives this: "Repeated column in mapping for entity: com.triton.model.Ticket column: merchant_nbr" . does not hibernate allow mapping to two different table from one column? — Rishi
– Rishi, Commented Jun 30, 2016 at 17:11
Yes. 'MERCHANT_NBR' is used to connect both merchantDetails(merchantNBR) and Ticket(merchant_nbr).Also Ticket is connected with Merchant table with the same column. — Rishi
– Rishi, Commented Jun 30, 2016 at 17:27

PacMan · Accepted Answer · 2016-06-30 17:36:12Z

1

so it's a join column not a column and for that you have to use the proper annotation for joining two entities which is @JoinColumn see this it may be helpful

@joinColumn(name = "MERCHANT_NBR" ,referencedColumnName="merchantNBR")
      private String merchant_nbr;

here i supposed that you've changed the column name in entitie class 2 from

@Column(name="MERCHANT_NBR") to `@Column(name="merchantNBR")`

answered Jun 30, 2016 at 17:36

PacMan

1,3582 gold badges13 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rishi Over a year ago

I did that change. But it still giving me the error of 'repeated column in mapping for entity for Ticket column merchant_nbr...'

PacMan Over a year ago

are you sure that they have a different name ??

Rishi Over a year ago

Let me change the names and check once more if I am making any mistakes in the column names..which I think is the case. Thanks for the replies !

Collectives™ on Stack Overflow

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'xxx'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related