java - Hibernate Composite Key Join -


i'm trying use spring data perform joined queries 1 of tables has composite key , i'm not sure how map entities.

here analogy of data model:

table: device pk=model_id pk=serial_id ...  table: device_settings pk=device_settings_id fk=model_id fk=serial_id ...

here analogy of code, doesn't compile due "mappedby" attribute isn't present.

@entity @table(name = "device_settings") public class devicesettings {      @id     @generatedvalue(strategy = generationtype.auto)     @column(name = "device_settings_id")     private long id;      // pretty sure problem     @onetomany(targetentity = device.class, mappedby = "devicekey", cascade = {cascadetype.merge}, fetch = fetchtype.eager)     @joincolumns({         @joincolumn(name = "model_id", referencedcolumnname = "model_id"),         @joincolumn(name = "serial_id", referencedcolumnname = "serial_id")})     private list<device> devices; }  @entity @table(name = "device") public class device {     @id         private devicekey devicekey;     }     ... }   @embeddable public class devicekey implements serializable {     private static final long serialversionuid = -1943684511893963184l;      @column(name = "model_id")     private long modelid;      @column(name = "serial_id")     private short serialid; }

associations marked mappedby must not define database mappings @jointable or @joincolumn

to achieve scenario have define @manytoone: 

@manytoone(cascade = {cascadetype.merge}, fetch = fetchtype.eager)     @joincolumns({         @joincolumn(name = "model_id", referencedcolumnname = "model_id"),         @joincolumn(name = "serial_id", referencedcolumnname = "serial_id")})      private device device;

this end model_id, serial_id, device_settings_id

or

define @joincolumn in device entity entities:

devicesettings : 

    @entity     @table(name = "device_settings")     public class devicesettings {          @id         @generatedvalue(strategy = generationtype.auto)         @column(name = "device_settings_id")         private long id;           @onetomany( mappedby = "devicesettings", cascade = {cascadetype.merge}, fetch = fetchtype.eager)          private list<device> devices; }

device entity : 

@entity @table(name = "device") public class device {          @embeddedid         private devicekey devicekey;          @manytoone         @joincolumn(name="device_settings_id")         private devicesettings devicesettings;        //getters , setters }

note : can decide owner of relationship , put mappings accorindly either 1 device has many device settings or other way around.


Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

nginx - phpPgAdmin - log in works but I have to login again after clicking on any links -

i have setup postgres 9.6 , phppgadmin on centos 7 server nginx, i can log in phppgadmin, postgresql server on right of page remains crossed out , link try browse (databases, roles etc) requires log in again. i'm thinking seems sessions problem, unsure how resolve it. any pointers on how fix or should looking @ in order track down problem? solved. turns out owner of /var/lib/php/session apache - needed nginx. sorted changing ownership nginx below: chown -r nginx:nginx /var/lib/php/session/
Read more