Eclipse Community Forums: EclipseLink » [ SOLVED ]JPA Question

Home » Eclipse Projects » EclipseLink » [ SOLVED ]JPA Question

[ SOLVED ]JPA Question [message #1221891]

Wed, 18 December 2013 11:21

Eclipse User

class ORDER {

@OneToMany
@JoinColumns({ @JoinColumn(name = "PARENT_ID", referencedColumnName = "ID"),
@JoinColumn(name = "TABLE_NAME", value="ORDER") })
private List<TableWithMultiKey> tableWithMultiKey;

}

I know that there is no "value" property...but something like this I need.

generated select should look like:

SELECT ID, FIELD1, FIELD2 FROM TableWithMultiKey WHERE PARENT_ID = 1 AND TABLE_NAME = 'ORDER';

...is it possible to implement a JoinColumn with a static value?

[Updated on: Thu, 02 January 2014 04:58] by Moderator

Re: JPA Question [message #1222017 is a reply to message #1221891]

Thu, 19 December 2013 06:58

Eclipse User

Is it possible to define a NamedQuery used by the @OneToMany call?

Re: JPA Question [message #1226649 is a reply to message #1222017]

Thu, 02 January 2014 04:59

Eclipse User

MySolution:

class ORDER {

@OneToMany
@JoinColumns({ @JoinColumn(name = "PARENT_ID", referencedColumnName = "ID"),
@JoinColumn(name = "'ORDER' as TABLE_NAME", referencedColumnName = "TABLE_NAME") })
private List<TableWithMultiKey> tableWithMultiKey;

}

... I simulate the SQL call and map to myself tablename. Rolling Eyes

Previous Topic:	Eclipselink Extensible Entity throw java.lang.NoSuchFieldException
Next Topic:	JPA reuse some "previous" JDBC login credentials

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 20:48:49 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter