From: <glassfish_at_javadesktop.org>
Date: Wed, 29 Aug 2007 10:16:31 PDT

I change my database design and my relationship statement in hopes the application would store the data.. I found I was using two reserved words in my database table names. No luck.... Grrrrrr

Document.java

[code]
        @ManyToMany(cascade={CascadeType.ALL})
        @JoinTable(name="DOCUMENT_COLLECTION",
                        joinColumns=_at_JoinColumn(name="DC_DOCUMENT_ID", referencedColumnName="DOCUMENT_ID"),
                        inverseJoinColumns={_at_JoinColumn(name="DC_COLLECTION_SITE", referencedColumnName="SITE_ID"),
                                                            @JoinColumn(name="DC_COLLECTION_GROUPNAME", referencedColumnName="GROUP_NAME"),
                                                            @JoinColumn(name="DC_COLLECTION_GROUPDATE", referencedColumnName="GROUP_DATE")}
        )
        public Set<Collection> getCollectionSet() {
                return collectionSet;
        }
[/code]

The biggest thing was I declared each of the attributes separately that makes up the Collection_ID.

I am still not seeing any errors in the log file, nor am I seeing any insert statements into the database........

Suggestions and recommendations would be appreciated at this point.

Thanks for taking the time to read my post.......

Russ
[Message sent by forum member 'russ_ray' (russ_ray)]

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