PSQLException relation does not exist. Active Objects

[Mathieu Yargeau]

I am trying to save a relation between two objects. AT is an object that will have a Many to Many relationship with CT (which is an interface really, AT will actually have a relationship with with entities inheriting from CT, IT for example).

public interface AtToCt extends Entity {
    public AT getAT();
    public void setAT(AT at);
    public CT getCT();
    public void setCT(CT ct);
}

@Polymorphic
public interface CT extends Template {
    @ManyToMany(value = AtToCt.class)
    public AT[] getATs();
}

public interface AT extends Template {
    @ManyToMany(value = AtToCt.class)
    public CT[] getCTs();
}

public interface IT extends CT { }

@Polymorphic
public interface Template extends Entity { }

Here is the code saving the relation

final AtToCt atToct = ao.create(AtToCt.class);
atToct.setAT(at);
atToct.setCT(ct);
atToct.save();

The first line gives me an exception. The `ct` variable is an instance of `IT`. Both `at` and `ct` are valid entities taken from the database. `ao` is the ActiveObjects component from JIRA.

There was a SQL exception thrown by the Active Objects library:
Database:
- name:PostgreSQL
- version:9.4.11
- minor version:4
- major version:9
Driver:
- name:PostgreSQL Native Driver
- version:PostgreSQL 9.4.1212

org.postgresql.util.PSQLException: ERROR: relation "public.AO_C3F116_AT_TO_CT_ID_seq" does not exist
Position: 16

[Ana Retamal Ortiz]

Hi Mathieu! For this kind of question, it would be better to submit it to our Developer Community. You can find them at community.developer.atlassian.com.

Hope this helps :)

Ana