Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: AW: [eclipselink-users] @ElementCollection with @Embeddables 
Hi Rafal,

  You may have to add a type to the JoinColumn, but aside from that, looks good.
You should be able to build the bug using mostly cut and paste from this discussion. I suggest simply cutting and pasting the following:
The definition of the collection mapping and the definition of the Embeddable + the generated DDL Code.
If you have a recreation, that is always nice. (I think you sent a project earlier) 

-Tom

Swierzynski, Rafal wrote:

Hi Tom,

Thanks for looking into this.
Do you mean:
@CollectionTable(name = "SomeMap", joinColumns = JoinColumn(columnDefinition = "my DDL"))
?

As for the bug, is it ok to just link to this discussion after a brief description, or do you prefer that I repeat the whole problem in the bug body verbatim? What about the attachment?

Regards,
Rafał

-----Original Message-----
From: eclipselink-users-bounces@xxxxxxxxxxx [mailto:eclipselink-users-bounces@xxxxxxxxxxx] On Behalf Of Tom Ware
Sent: Monday, March 15, 2010 2:38 PM
Cc: EclipseLink User Discussions
Subject: Re: AW: [eclipselink-users] @ElementCollection with @Embeddables

Another workaround:
Explicitly add the joinColumn with the correct type to the annotation for the collecttion. 

Tom Ware wrote:

Hi Rafal,
Please enter a bug. The issue is with our DDL generation. The "SomeMap" table does not have the correct type for SomeENtity_ID.
The workaround is to use our option of generating the DDL as a sql-script, then to edit the sql-script and run it against the DB. 

-Tom

Swierzynski, Rafal wrote:

Hi Tom,
yes, I am using the auto generated DDL. The statements are (I omit drops and the sequence table): 
CREATE TABLE SOMEENTITY (ID BIGINT NOT NULL, PRIMARY KEY (ID))
CREATE TABLE SomeMap (VALUE VARCHAR(255), KEY VARCHAR(255), SomeEntity_ID VARCHAR(255))
The insert statements are (after // is what gets bound to the parameters): 
INSERT INTO SOMEENTITY (ID) VALUES (?) // bind => [1]
INSERT INTO SomeMap (SomeEntity_ID, VALUE, KEY) VALUES (?, ?, ?) // bind => [1, stół, pl] INSERT INTO SomeMap (SomeEntity_ID, VALUE, KEY) VALUES (?, ?, ?) // bind => [1, table, en] INSERT INTO SomeMap (SomeEntity_ID, VALUE, KEY) VALUES (?, ?, ?) // bind => [1, Tish, de] 

And eventually, the selects:
SELECT ID FROM SOMEENTITY WHERE (ID = ?) // bind => [1]
SELECT VALUE, KEY FROM SomeMap WHERE (SomeEntity_ID = ?) // bind => [1]

And the last one results in this:
ERROR: operator does not exist: character varying = bigint
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. 'character varying' is the data type of the SomeMap.PERSON_ID column as reported by PGadmin, so it means it is the PostgreSQL name for VARCHAR.
In the DDL the SomeMap.SomeEntity_ID foreign key is of type VARCHAR whereas SomeEntity.id is BIGINT. I didn't think of looking in this direction, I thought my mapping was wrong, but I couldn't figure out what is wrong. We don't have such an issue as we don't use EL DDL in production. 
I had a similar issue with Map collection.
Does this mean it is a EclipseLink DDL generation issue? If not, what else do I need to do to make this work? 

Regards,
Rafał

________________________________________
Von: eclipselink-users-bounces@xxxxxxxxxxx [eclipselink-users-bounces@xxxxxxxxxxx] im Auftrag von Tom Ware [tom.ware@xxxxxxxxxx] 
Gesendet: Freitag, 12. März 2010 16:39
An: EclipseLink User Discussions
Betreff: Re: [eclipselink-users] @ElementCollection with @Embeddables

Hi Rafal,

   What do the insert statements look like when the objects are inserted.
(persistence unit property eclipselink.logging.level=FINEST)?

   Are you using EclipseLink to gennerate DDL? What do the table creation
statements look like?

-Tom

Swierzynski, Rafal wrote:

Hi,

I have such collection mapping:

@ElementCollection(fetch = FetchType.EAGER)
@CollectionTable(name = "SomeMap")
private Set<Pair> someSet = new HashSet<Pair>();

with Pair being defined as:

@Embeddable
public class Pair {

    private String key;

    private String value;

    public Pair(String key, String value) {
        this.key = key;
        this.value = value;
    }

    protected Pair() {
    }

    public String getKey() {
        return key;
    }

    public String getValue() {
        return value;
    }
}

The code to persist is as follows:
EntityManagerFactory emf = Persistence.createEntityManagerFactory("TestJPA"); 
EntityManager em = emf.createEntityManager();
EntityTransaction tx = em.getTransaction();
tx.begin();
SomeEntity s = new SomeEntity();
s.put("en", "table");
s.put("de", "Tish");
s.put("pl", "stół");
em.persist(s);
tx.commit();

em.clear();

s = em.find(SomeEntity.class, s.getId());
The entity is persisted in the database in the first transaction. However, when the entity is read again, I get: 

Exception in thread "main" Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.v20091127-r5931): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = bigint Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. 
  Position: 53
Error Code: 0
Call: SELECT VALUE, KEY FROM SomeMap WHERE (SomeEntity_ID = ?)
      bind => [1]
Query: ReadAllQuery(name="someSet" referenceClass=Pair sql="SELECT VALUE, KEY FROM SomeMap WHERE (SomeEntity_ID = ?)")
When I looked into the generated table for the collection, I noticed that SomeEntity_ID is of type "character varying". 

What am I doing wrong here?
A project is attached to this email with the whole source code.

Regards,
Rafał


------------------------------------------------------------------------

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users


_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users


_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

Back to the top