sql - PersistenceException: ERROR executing DML bindLog when Updating an Object -

-

good day! have 2 objects: tag , relatedtag. tag can have many relatedtags (which tag). saving tag related tags works fine. when update tag, has error saying

[persistenceexception: error executing dml bindlog[] error[unique index or primary key violation: "primary key on public.related_tag(id)"; sql statement:\n insert related_tag (id, tag_id, relationship, related_notes) values (?,?,?,?) [23505-172]]]

here tag model:

package models;  import java.util.*;  import javax.persistence.*; import javax.validation.*;  import play.data.form; import play.data.validation.constraints.*; import play.db.ebean.*; import play.db.ebean.model.finder; import scala.int;  @entity public class tag extends model{      @id     private int id;      @required     @maxlength(value=100)     private string name;      @maxlength(value=200)     private string notes;      @onetomany(cascade=cascadetype.all)     public list<relatedtag> relatedtags = new arraylist<relatedtag>();      public static finder<integer, tag> find = new finder(int.class, tag.class);      public tag() {      }      public tag(string name, string notes){         this.name = name;         this.notes = notes;     }      public tag(int id, string name, string notes, list<relatedtag> relatedtags) {         this.id = id;         this.name = name;         this.notes = notes;         this.relatedtags = relatedtags;     }      public int getid() {         return id;     }      public void setid(int id) {         this.id = id;     }      public string getname() {         return name;     }      public void setname(string name) {         this.name = name;     }      public string getnotes() {         return notes;     }      public void setnotes(string notes) {         this.notes = notes;     }      public list<relatedtag> getrelatedtags() {         return relatedtags;     }      public void setrelatedtags(list<relatedtag> relatedtags) {         this.relatedtags = relatedtags;     }      public static list<tag> all() {         return find.all();     }      public static void create(tag tag){         tag.save();     }      public static void delete(int id){         find.ref(id).delete();     }      public static void update(int id, tag tag) {         tag.update(id); // updates entity, specifying entity id     }      public static boolean exists(tag newtag) {         for(tag alltags : tag.find.all()) {             if(alltags.getname().equals(newtag.getname()))                 return true;         }          return false;     }         }

and here relatedtag model:

package models;  import java.util.*;  import javax.persistence.*; import javax.validation.*;  import play.data.form; import play.data.validation.constraints.*; import play.db.ebean.*; import play.db.ebean.model.finder; import scala.int;  @entity public class relatedtag extends model {      @id     private int id;      private string relationship;      private string relatednotes;      public relatedtag() {}      public relatedtag(int id, string relationship, string relatednotes) {         this.id = id;         this.relationship = relationship;         this.relatednotes = relatednotes;     }      public void setid(int id){         this.id = id;     }      public void setrelationship(string relationship){         this.relationship = relationship;     }      public void setrelatednotes(string relatednotes) {         this.relatednotes = relatednotes;     }      public int getid(){         return id;     }       public string getrelationship(){         return relationship;     }      public string getrelatednotes() {         return relatednotes;     }      public static boolean exists(string tagrelated) {         for(tag tag : tag.find.all()) {             if(tagrelated.equals(tag.getname()))                 return true;         }         return false;     }      public static relatedtag findbylabel(string tagrelated, string relation, string relatednotes) {         relatedtag relatedtag = null;         for(tag tag : tag.find.all()) {             if(tagrelated.equals(tag.getname())) {                 relatedtag = new relatedtag(tag.getid(), relation, relatednotes);             }         }         return relatedtag;     }      public static tag findtag(int id) {         for(tag tag : tag.find.all()) {             if(id == tag.getid())                  return tag;         }         return null;     }  }

when run (in update tag), error happens. 

private static void reciprocate(tag tag) {             list<tag> peers = new arraylist<tag>();              (relatedtag rt : tag.getrelatedtags()) {                 if(rt.getrelationship().equals("peer"))                     peers.add(relatedtag.findtag(rt.getid()));             }          for(relatedtag rt : tag.getrelatedtags()) {             int reltemp = 0;             string relation = new string();             if (rt.getrelationship().equals("parent"))                 reltemp = 1;              if (rt.getrelationship().equals("child"))                 reltemp = 2;              if (rt.getrelationship().equals("peer"))                 reltemp = 3;              switch(reltemp) {                 case 1: relation = "child"; break;                 case 2: relation = "parent"; break;                 case 3: relation = "peer"; break;             }              tag related = new tag();             related = tag.find.byid(relatedtag.findtag(rt.getid()).getid());             list<relatedtag> available = new arraylist<relatedtag>();             list<string> availablename = new arraylist<string>();             (relatedtag rt2 : related.getrelatedtags()) {                 availablename.add(relatedtag.findtag(rt2.getid()).getname());             }             if(availablename.contains(tag.getname())) {                 for(relatedtag rt2 : related.getrelatedtags()) {                     if(!relatedtag.findtag(rt2.getid()).getname().equals(tag.getname())) {                         available.add(rt2);                     }                 }             }             available.add(relatedtag.findbylabel(                     tag.getname(), relation,                     rt.getrelatednotes()));             related.setrelatedtags(available);             related.update(related.getid());    //here                   } }

please me figure out. after first rt has been iterated, there goes error saves related tag. thank much.

your method relatedtag#findbylabel creates new relatedtags ids of tag class; if have 2 related tags same tag, produce 2 related tags same id.

look @generatedvalue , entitymanager#createquery.


Comments

Post a Comment

Popular posts from this blog

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more