Here's my console test app.
I commented out every line that uses Message class because Player class already throws exception, but Message class will be usefull after Player class will work.
import java.io.Serializable;
import java.util.*;
import javax.persistence.*;
@Entity
class Player implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue
private Long id;
private String playerName;
@ManyToMany
private List<Player> friendWishList = new ArrayList<Player>();
@ManyToMany(mappedBy = "friendWishList")
private List<Player> possibleFriends;
// @ManyToOne
// private List<Message> postedMessages = new ArrayList<Message>();
//
// @OneToMany(mappedBy = "address")
// private List<Message> receivedMessages;
protected Player() {
}
public Player(String playerName) {
this.playerName = playerName;
}
public Long getId() {
return id;
}
public String getPlayerName() {
return playerName;
}
// public List<Message> getReceivedMessages() {
// return receivedMessages;
// }
//
// public List<Message> getPostedMessages() {
// return postedMessages;
// }
public List<Player> getFriendWishList() {
return friendWishList;
}
public List<Player> getPossibleFriends() {
return possibleFriends;
}
@Override
public String toString() {
return playerName + '#' + getId();
}
}
//@Entity
//class Message implements Serializable {
//
// private static final long serialVersionUID = 1L;
//
// @Id
// @GeneratedValue
// private Long id;
//
// @Temporal(TemporalType.TIMESTAMP)
// private Date sendDate = new Date();
//
// private String text;
//
// @OneToMany(mappedBy="postedMessages")
// private Player sender;
//
// @ManyToOne
// private Player address;
//
// protected Message() {
// }
//
// public Message(Player address, String text) {
// this.address = address;
// this.text = text;
// }
//
// public Long getId() {
// return id;
// }
//
// public String getText() {
// return text;
// }
//
// public Date getSendDate() {
// return sendDate;
// }
//
// public Player getSender() {
// return sender;
// }
//
// public Player getAddress() {
// return address;
// }
//
// public void setText(String text) {
// this.text = text;
// }
//
// @Override
// public String toString() {
// return "Message#" + getId();
// }
//
//}
public class Main {
private static final String PLAYER1 = "player1", PLAYER2 = "player2";
private static EntityManager db;
private static EntityManager createEntityManager() {
Map<String, String> properties = new HashMap<String, String>();
properties.put("javax.persistence.jdbc.user", "admin");
properties.put("javax.persistence.jdbc.password", "admin");
EntityManagerFactory emf = Persistence.createEntityManagerFactory("objectdb://localhost:6136/fzoli_bugreport.odb", properties);
return emf.createEntityManager();
}
private static boolean isDatabaseEmpty() {
try {
return db.createQuery("SELECT count(p) = 0 FROM Player p", Boolean.class).getSingleResult();
}
catch (PersistenceException ex) {
ex.printStackTrace();
return false;
}
}
private static Player getPlayer(String name) {
if (name == null) return null;
try {
TypedQuery<Player> query = db.createQuery("SELECT p FROM Player p WHERE upper(p.playerName) = upper(:name)", Player.class);
return query.setParameter("name", name).getSingleResult();
}
catch (PersistenceException ex) {
ex.printStackTrace();
return null;
}
}
// private static List<Message> getMessages(String playerName) {
// if (playerName == null) return null;
// try {
// TypedQuery<Message> query = db.createQuery("SELECT m FROM Message m WHERE m.sender.playerName = :name", Message.class);
// return query.setParameter("name", playerName).getResultList();
// }
// catch (PersistenceException ex) {
// ex.printStackTrace();
// return null;
// }
// }
private static boolean save(Object obj) {
EntityTransaction tr = db.getTransaction();
try {
tr.begin();
db.persist(obj);
tr.commit();
} catch (Exception ex) {
ex.printStackTrace();
return false;
}
return true;
}
public static void main(String[] args) {
db = createEntityManager(); // create database connection
if (isDatabaseEmpty()) { // database is empty, create entity classes
System.out.println("Initialize test database.");
// create two player
Player p1 = new Player(PLAYER1);
save(p1);
Player p2 = new Player(PLAYER2);
save(p2);
// add player2 to player1's friend wish list
p1.getFriendWishList().add(p2);
save(p1);
// add player1 to player2's friend wish list
// IF YOU DON'T ADD, NO EXCEPTION SHOULD BE THROWN
p2.getFriendWishList().add(p1);
save(p2);
// /* create new message to player1 from player2 */
// Message m = new Message(p1, "test message");
// p2.getPostedMessages().add(m);
// save(m);
// save(p2);
//
// /* create new message to player2 from player1 */
// m = new Message(p2, "test message 2");
// p1.getPostedMessages().add(m);
// save(m);
// save(p1);
// create new database connection in order to cause exception
db.close();
db = createEntityManager();
}
else {
System.out.println("Database already initialized.");
}
System.out.println("Get " + PLAYER1 + " from database.");
System.out.println(getPlayer(PLAYER1)); // getPlayer() should cause exception
// System.out.println("Get " + PLAYER1 + "'s messages.");
// System.out.println(getMessages(PLAYER1)); // getMessages() should cause exception too
db.close();
}
} And the result:
Database already initialized.
Get player1 from database.
[ObjectDB 2.4.1_07] javax.persistence.PersistenceException
Failed to write the value of field field testcase.Player.possibleFriends using reflection (error 363)
at com.objectdb.jpa.JpaQuery.getSingleResult(JpaQuery.java:723)
at testcase.Main.getPlayer(Main.java:155)
at testcase.Main.main(Main.java:230)
Caused by: com.objectdb.o.UserException: Failed to write the value of field field testcase.Player.possibleFriends using reflection
at com.objectdb.o.MSG.d(MSG.java:74)
at com.objectdb.o.UMR.M(UMR.java:907)
at com.objectdb.o.UMR.x(UMR.java:567)
at com.objectdb.o.UML.u(UML.java:536)
at com.objectdb.o.ENH.d(ENH.java:234)
at com.objectdb.o.ENT.T(ENT.java:851)
at com.objectdb.o.LDR.y(LDR.java:484)
at com.objectdb.o.LDR.x(LDR.java:448)
at com.objectdb.o.LDR.s(LDR.java:161)
at com.objectdb.o.OBC.aN(OBC.java:1076)
at com.objectdb.o.OBC.aL(OBC.java:976)
at com.objectdb.o.OBC.UG(OBC.java:815)
at com.objectdb.o.SRB.l(SRB.java:149)
at com.objectdb.o.QRR.b(QRR.java:187)
at com.objectdb.jpa.JpaQuery.getSingleResult(JpaQuery.java:716)
... 2 more
Caused by: com.objectdb.o._PersistenceException: Failed to write the value of field field testcase.Player.possibleFriends using reflection
at com.objectdb.o._PersistenceException.b(_PersistenceException.java:45)
at com.objectdb.o.JPE.g(JPE.java:142)
at com.objectdb.o.ERR.f(ERR.java:60)
at com.objectdb.o.IVP.h(IVP.java:107)
at com.objectdb.o.IVP.g(IVP.java:87)
at com.objectdb.o.ILP.isEmpty(ILP.java:136)
at com.objectdb.o.TYW.av(TYW.java:477)
at com.objectdb.o.TYW.writeElement(TYW.java:305)
at com.objectdb.o.UMR$P.y(UMR.java:975)
at com.objectdb.o.UMR.x(UMR.java:564)
... 14 more
Caused by: com.objectdb.o.UserException: Failed to write the value of field field testcase.Player.possibleFriends using reflection
at com.objectdb.o.MSG.d(MSG.java:74)
at com.objectdb.o.UMR.M(UMR.java:907)
at com.objectdb.o.UMR.x(UMR.java:567)
at com.objectdb.o.UML.u(UML.java:536)
at com.objectdb.o.ENH.d(ENH.java:234)
at com.objectdb.o.ENT.T(ENT.java:851)
at com.objectdb.o.LDR.y(LDR.java:484)
at com.objectdb.o.LDR.x(LDR.java:448)
at com.objectdb.o.LDR.s(LDR.java:161)
at com.objectdb.o.OBC.aN(OBC.java:1076)
at com.objectdb.o.OBC.aL(OBC.java:976)
at com.objectdb.o.OBC.UG(OBC.java:815)
at com.objectdb.o.SRB.l(SRB.java:149)
at com.objectdb.o.QRR.m(QRR.java:544)
at com.objectdb.o.QRR.b(QRR.java:206)
at com.objectdb.o.QRR.b(QRR.java:651)
at com.objectdb.o.UMR.u(UMR.java:516)
at com.objectdb.o.ENT.loadInverse(ENT.java:1394)
at com.objectdb.o.IVP.h(IVP.java:100)
... 20 more
Caused by: com.objectdb.o._PersistenceException: Failed to write the value of field field testcase.Player.possibleFriends using reflection
at com.objectdb.o._PersistenceException.b(_PersistenceException.java:45)
at com.objectdb.o.JPE.g(JPE.java:142)
at com.objectdb.o.ERR.f(ERR.java:60)
at com.objectdb.o.IVP.h(IVP.java:107)
at com.objectdb.o.IVP.g(IVP.java:87)
at com.objectdb.o.ILP.isEmpty(ILP.java:136)
at com.objectdb.o.TYW.av(TYW.java:477)
at com.objectdb.o.TYW.writeElement(TYW.java:305)
at com.objectdb.o.UMR$P.y(UMR.java:975)
at com.objectdb.o.UMR.x(UMR.java:564)
... 36 more
Caused by: com.objectdb.o.UserException: Failed to write the value of field field testcase.Player.possibleFriends using reflection
at com.objectdb.o.MSG.d(MSG.java:74)
at com.objectdb.o.UMR.M(UMR.java:907)
at com.objectdb.o.UMR.x(UMR.java:567)
at com.objectdb.o.UML.u(UML.java:536)
at com.objectdb.o.ENH.d(ENH.java:234)
at com.objectdb.o.ENT.T(ENT.java:851)
at com.objectdb.o.LDR.y(LDR.java:484)
at com.objectdb.o.LDR.x(LDR.java:448)
at com.objectdb.o.LDR.s(LDR.java:161)
at com.objectdb.o.OBC.aN(OBC.java:1076)
at com.objectdb.o.OBC.aM(OBC.java:1019)
at com.objectdb.o.OBC.aL(OBC.java:924)
at com.objectdb.o.OBC.UG(OBC.java:815)
at com.objectdb.o.SRB.l(SRB.java:149)
at com.objectdb.o.QRR.m(QRR.java:544)
at com.objectdb.o.QRR.b(QRR.java:206)
at com.objectdb.o.QRR.b(QRR.java:651)
at com.objectdb.o.UMR.u(UMR.java:516)
at com.objectdb.o.ENT.loadInverse(ENT.java:1394)
at com.objectdb.o.IVP.h(IVP.java:100)
... 42 more
Caused by: com.objectdb.o._PersistenceException: Failed to write the value of field field testcase.Player.possibleFriends using reflection
[...]
'/%3E %3ClinearGradient y1='5.353' x2='0' y2='42.619' id='9' xlink:href='%236' gradientUnits='userSpaceOnUse'/%3E %3ClinearGradient x1='-3.655' y1='-42.14' x2='23.875' y2='28.921' id='A' xlink:href='%235' gradientUnits='userSpaceOnUse'/%3E %3C/defs%3E %3Cpath d='m 73.831503,56.540211 a 27.457239,3.7650394 0 1 1 -54.914478,0 27.457239,3.7650394 0 1 1 54.914478,0 z' transform='matrix(0.8607554,0,0,0.837344,-15.916898,-4.1187776)' id='1' opacity='0.8' fill='url(%238)'/%3E %3Cpath d='m 23.745885,4.8366182 c -8.802495,0.2375247 -10.458576,6.7343608 -9.9886,11.6217548 0.07298,0.759003 0.419647,1.45117 0.969359,2.065153 0.05164,-0.481788 0.12211,-0.955708 0.221266,-1.422426 -0.03689,0.4142 -0.05268,0.838085 -0.05268,1.264379 0,3.935025 1.61426,7.411391 4.067087,9.461775 -0.163396,0.961944 -0.531105,1.783069 -1.074723,2.781635 L 8.6997677,32.579213 C 4.2458962,33.609558 3.9089135,39.951429 4.2112201,43.168393 43.88856,43.055802 4.1345553,43.234679 43.870593,43.0841 43.734607,39.567206 43.237712,33.315864 38.70771,32.347411 L 30.004563,30.69318 c -6.6e-4,-0.0281 0.002,-0.05618 0,-0.08429 l -0.537361,-2.960756 c 2.339084,-2.069434 3.866895,-5.456647 3.866894,-9.282654 0,-0.03864 3.11e-4,-0.07736 0,-0.115901 0.03777,0.192801 0.07538,0.383427 0.105366,0.547897 0.498845,-0.67264 0.381843,-1.824112 0.516288,-2.728952 0.699546,-4.708055 -1.951521,-11.0931996 -9.3248,-11.2319048 -0.298997,-0.00562 -0.601105,-0.00766 -0.885065,0 z' id='2' fill='%23555753' fill-rule='evenodd' stroke='%23323232' stroke-width='1.042'/%3E %3Cpath d='m 23.78125,5.875 c -4.145538,0.1118622 -6.347373,1.6089948 -7.625,3.59375 -1.22166,1.897812 -1.540263,4.384838 -1.375,6.59375 0.315181,-0.04369 0.633133,0.05826 0.864128,0.277101 0.230994,0.218837 0.349978,0.530818 0.323372,0.847899 -0.03023,0.339413 0,0.751967 0,1.1875 0,3.649433 1.474225,6.800987 3.65625,8.625 0.29833,0.239773 0.44211,0.623187 0.375,1 -0.192613,1.133951 -0.659641,2.066728 -1.21875,3.09375 -0.141443,0.268269 -0.392227,0.462056 -0.6875,0.53125 l -9.1875,2 c -1.7745211,0.410513 -2.6766636,1.807072 -3.21875,3.71875 -0.4455205,1.571137 -0.4984358,3.30909 -0.4375,4.75 12.500668,0.01464 24.999191,-0.01402 37.5,-0.0625 -0.09526,-1.572458 -0.287738,-3.356234 -0.8125,-4.9375 C 41.292687,35.150733 40.321102,33.764327 38.5,33.375 l -8.6875,-1.65625 c -0.458981,-0.08914 -0.803287,-0.471698 -0.84375,-0.9375 -0.01111,-0.02048 -0.02153,-0.04133 -0.03125,-0.0625 -0.0011,-0.04656 3.67e-4,-0.01517 0,-0.03125 l -0.5,-2.84375 c -0.06266,-0.360806 0.06768,-0.728136 0.34375,-0.96875 2.084914,-1.844563 3.500001,-4.954264 3.5,-8.5 10e-7,-0.04422 2.09e-4,-0.09906 0,-0.125 0.0018,-0.375471 0.204523,-0.721233 0.53125,-0.90625 0.04124,-0.412683 0.04587,-0.904925 0.125,-1.4375 0.311211,-2.0945 -0.137889,-4.613833 -1.46875,-6.5625 C 30.137889,7.3950828 27.981251,5.9699752 24.59375,5.90625 24.302819,5.90078 24.040853,5.867995 23.78125,5.875 z' id='3' opacity='0.8' fill='none' stroke='url(%239)' stroke-width='1.042'/%3E %3Cpath d='m 23.75,5.34375 c -4.279827,0.1154859 -6.68992,1.7114873 -8.0625,3.84375 -1.37258,2.132263 -1.665114,4.851739 -1.4375,7.21875 0.02159,0.224531 0.110797,0.443755 0.1875,0.65625 0.0042,-0.02047 -0.0043,-0.04208 0,-0.0625 0.03452,-0.276142 0.286358,-0.472018 0.5625,-0.4375 0.276142,0.03452 0.472018,0.286358 0.4375,0.5625 -0.03373,0.378688 -0.03125,0.819319 -0.03125,1.25 0,2.849561 0.86456,5.44344 2.28125,7.375 4.794221,-2.62034 9.862678,-5.232077 15.15625,-7.28125 2.17e-4,-0.03134 0,-0.06234 0,-0.09375 10e-7,-0.04128 2.63e-4,-0.09244 0,-0.125 -0.0054,-0.243706 0.166594,-0.455421 0.40625,-0.5 0.02067,-0.109172 0.08035,-0.15874 0.09375,-0.28125 0.05011,-0.457953 0.0505,-0.967353 0.125,-1.46875 0.331462,-2.230794 -0.14191,-4.8887 -1.5625,-6.96875 C 30.48566,6.9512002 28.169597,5.4104305 24.625,5.34375 24.329833,5.3382 24.022394,5.3364 23.75,5.34375 z' id='4' fill='url(%23A)' fill-rule='evenodd'/%3E%3C/svg%3E "jch's picture")
