Hope this helps Hibernate creates a link table named tbl_project_tbl_media for your one-to-many relationship. I think you just want a column in your Media table referring to the project, thus avoiding the use of a link table. The @JoinColumn annotation does just that. I can't compile and run it myself to test right now, so not going to post any code, but basically you can create a Project field in your Media class, and then use @JoinColumn("yourColumnName") right before or after @OneToMany.
this one helps. I forget to set capture_big_lobs in trigger table. Changing value to 1 solved problem. However if the column is NULL, then SymmetricDS will throw Null Pointer Exception. I am using 3.5.10, so maybe it's solved in newer versions.
CoreData error by saving new item to filtered fetch request with inheritance
should help you out I confirm it's a bug in Hibernate Search. Here is the JIRA I just created: https://hibernate.atlassian.net/browse/HSEARCH-2301 . I already wrote a fix but I have to go and doesn't have the time to clean it up; I'll post a PR later today.