users@glassfish.java.net

Re: SQLSyntaxException

From: <glassfish_at_javadesktop.org>
Date: Wed, 20 Aug 2008 23:52:58 PDT

Hi marina, thanks for the reply.
The only column annotations of note are below:

from Products.java
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Column(name = "PRODUCT_ID")
    private Integer productId;

from Orders.java
    @Basic(optional = false)
    @JoinColumn(name = "PRODUCT_ID", referencedColumnName = "PRODUCT_ID")
    @ManyToOne
    private Products productId;

These both point to the correct column name in the table, so I think they are correct.

mcalex
[Message sent by forum member 'mcalex' (mcalex)]

http://forums.java.net/jive/thread.jspa?messageID=294535