项目作者: try0

项目描述 :
JPA Criteria API examples
高级语言: Java
项目地址: git://github.com/try0/jpa-criteria-examples.git
创建时间: 2019-02-03T03:37:29Z
项目社区:https://github.com/try0/jpa-criteria-examples

开源协议:

下载


jpa-criteria-examples

JPA Criteria API examples

EclipseLink, H2DB

examples

When the tests are run, the table is created in the in-memory h2db and the executed sql is output to the log.

  1. 情報: start initialize [日 8 07 08:59:19 JST 2022]
  2. [EL Info]: 2022-08-07 08:59:20.138--ServerSession(2144644334)--EclipseLink, version: Eclipse Persistence Services - 2.7.10.v20211216-fe64cd39c3
  3. [EL Fine]: sql: 2022-08-07 08:59:20.774--ServerSession(2144644334)--Connection(1402333753)--CREATE TABLE m_group (group_id VARCHAR NOT NULL, NAME VARCHAR, PRIMARY KEY (group_id))
  4. [EL Fine]: sql: 2022-08-07 08:59:20.787--ServerSession(2144644334)--Connection(1402333753)--CREATE TABLE m_user (user_id VARCHAR NOT NULL, age INTEGER, NAME VARCHAR, PASSWORD VARCHAR, user_number INTEGER, PRIMARY KEY (user_id))
  5. [EL Fine]: sql: 2022-08-07 08:59:20.79--ServerSession(2144644334)--Connection(1402333753)--CREATE TABLE user_group (group_id VARCHAR NOT NULL, user_id VARCHAR NOT NULL, PRIMARY KEY (group_id, user_id))
  6. [EL Fine]: sql: 2022-08-07 08:59:20.792--ServerSession(2144644334)--Connection(1402333753)--CREATE TABLE email_address (user_id VARCHAR NOT NULL, email_address VARCHAR, PRIMARY KEY (user_id))
  7. [EL Fine]: sql: 2022-08-07 08:59:20.794--ServerSession(2144644334)--Connection(1402333753)--ALTER TABLE email_address ADD CONSTRAINT FK_email_address_user_id FOREIGN KEY (user_id) REFERENCES m_user (user_id)
  8. [EL Fine]: sql: 2022-08-07 08:59:21.043--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_user (user_id, age, NAME, PASSWORD, user_number) VALUES (?, ?, ?, ?, ?)
  9. bind => [uid1, 43, UserName1, 93439e71, 1]
  10. [EL Fine]: sql: 2022-08-07 08:59:21.046--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_user (user_id, age, NAME, PASSWORD, user_number) VALUES (?, ?, ?, ?, ?)
  11. bind => [uid3, 47, UserName3, 1f1693e1, 3]
  12. [EL Fine]: sql: 2022-08-07 08:59:21.046--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_user (user_id, age, NAME, PASSWORD, user_number) VALUES (?, ?, ?, ?, ?)
  13. bind => [uid4, 86, UserName4, 63843736, 4]
  14. [EL Fine]: sql: 2022-08-07 08:59:21.047--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_user (user_id, age, NAME, PASSWORD, user_number) VALUES (?, ?, ?, ?, ?)
  15. bind => [uid0, 18, UserName0, 4bf5deee, 0]
  16. [EL Fine]: sql: 2022-08-07 08:59:21.047--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_user (user_id, age, NAME, PASSWORD, user_number) VALUES (?, ?, ?, ?, ?)
  17. bind => [uid2, 37, UserName2, 74f0d62c, 2]
  18. [EL Fine]: sql: 2022-08-07 08:59:21.047--ClientSession(219812012)--Connection(1402333753)--INSERT INTO email_address (user_id, email_address) VALUES (?, ?)
  19. bind => [uid2, EmailAddress2@example.com]
  20. [EL Fine]: sql: 2022-08-07 08:59:21.049--ClientSession(219812012)--Connection(1402333753)--INSERT INTO email_address (user_id, email_address) VALUES (?, ?)
  21. bind => [uid0, EmailAddress0@example.com]
  22. [EL Fine]: sql: 2022-08-07 08:59:21.05--ClientSession(219812012)--Connection(1402333753)--INSERT INTO email_address (user_id, email_address) VALUES (?, ?)
  23. bind => [uid1, EmailAddress1@example.com]
  24. [EL Fine]: sql: 2022-08-07 08:59:21.05--ClientSession(219812012)--Connection(1402333753)--INSERT INTO email_address (user_id, email_address) VALUES (?, ?)
  25. bind => [uid4, EmailAddress4@example.com]
  26. [EL Fine]: sql: 2022-08-07 08:59:21.051--ClientSession(219812012)--Connection(1402333753)--INSERT INTO email_address (user_id, email_address) VALUES (?, ?)
  27. bind => [uid3, EmailAddress3@example.com]
  28. [EL Fine]: sql: 2022-08-07 08:59:21.051--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_group (group_id, NAME) VALUES (?, ?)
  29. bind => [gid4, GroupName4]
  30. [EL Fine]: sql: 2022-08-07 08:59:21.051--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_group (group_id, NAME) VALUES (?, ?)
  31. bind => [gid0, GroupName0]
  32. [EL Fine]: sql: 2022-08-07 08:59:21.052--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_group (group_id, NAME) VALUES (?, ?)
  33. bind => [gid2, GroupName2]
  34. [EL Fine]: sql: 2022-08-07 08:59:21.052--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_group (group_id, NAME) VALUES (?, ?)
  35. bind => [gid1, GroupName1]
  36. [EL Fine]: sql: 2022-08-07 08:59:21.052--ClientSession(219812012)--Connection(1402333753)--INSERT INTO m_group (group_id, NAME) VALUES (?, ?)
  37. bind => [gid3, GroupName3]
  38. [EL Fine]: sql: 2022-08-07 08:59:21.054--ClientSession(219812012)--Connection(1402333753)--INSERT INTO user_group (group_id, user_id) VALUES (?, ?)
  39. bind => [gid4, uid4]
  40. [EL Fine]: sql: 2022-08-07 08:59:21.054--ClientSession(219812012)--Connection(1402333753)--INSERT INTO user_group (group_id, user_id) VALUES (?, ?)
  41. bind => [gid0, uid0]
  42. [EL Fine]: sql: 2022-08-07 08:59:21.054--ClientSession(219812012)--Connection(1402333753)--INSERT INTO user_group (group_id, user_id) VALUES (?, ?)
  43. bind => [gid1, uid1]
  44. [EL Fine]: sql: 2022-08-07 08:59:21.055--ClientSession(219812012)--Connection(1402333753)--INSERT INTO user_group (group_id, user_id) VALUES (?, ?)
  45. bind => [gid3, uid3]
  46. [EL Fine]: sql: 2022-08-07 08:59:21.055--ClientSession(219812012)--Connection(1402333753)--INSERT INTO user_group (group_id, user_id) VALUES (?, ?)
  47. bind => [gid2, uid2]
  48. 情報: end initialize [日 8 07 08:59:21 JST 2022]
  49. 情報: ========= Sub Query ========= [日 8 07 08:59:21 JST 2022]
  50. [EL Fine]: sql: 2022-08-07 08:59:21.133--ServerSession(2144644334)--Connection(1402333753)--SELECT t0.user_id, t0.age, t0.NAME, t0.PASSWORD, t0.user_number FROM m_user t0 WHERE t0.user_id IN (SELECT t1.user_id FROM email_address t1 WHERE t1.email_address LIKE ?)
  51. bind => [%@gmail.com]
  52. 情報: ========= Select All ========= [日 8 07 08:59:21 JST 2022]
  53. [EL Fine]: sql: 2022-08-07 08:59:21.163--ServerSession(2144644334)--Connection(1402333753)--SELECT user_id, age, NAME, PASSWORD, user_number FROM m_user
  54. 情報: ========= Fetch Left Join ========= [日 8 07 08:59:21 JST 2022]
  55. [EL Fine]: sql: 2022-08-07 08:59:21.192--ServerSession(2144644334)--Connection(1402333753)--SELECT t1.user_id, t1.age, t1.NAME, t1.PASSWORD, t1.user_number, t0.user_id, t0.email_address FROM {oj m_user t1 LEFT OUTER JOIN email_address t0 ON (t0.user_id = t1.user_id)}
  56. 情報: ========= Delete ========= [日 8 07 08:59:21 JST 2022]
  57. [EL Fine]: sql: 2022-08-07 08:59:21.206--ClientSession(1232703108)--Connection(1402333753)--DELETE FROM m_user WHERE (user_id = ?)
  58. bind => [0000]
  59. 情報: ========= Select Using Function ========= [日 8 07 08:59:21 JST 2022]
  60. [EL Fine]: sql: 2022-08-07 08:59:21.214--ServerSession(2144644334)--Connection(1402333753)--SELECT user_id, UUID() FROM m_user
  61. 情報: ========= Fetch Inner Join ========= [日 8 07 08:59:21 JST 2022]
  62. [EL Fine]: sql: 2022-08-07 08:59:21.236--ServerSession(2144644334)--Connection(1402333753)--SELECT t1.user_id, t1.age, t1.NAME, t1.PASSWORD, t1.user_number, t0.user_id, t0.email_address FROM email_address t0, m_user t1 WHERE (t0.user_id = t1.user_id)
  63. 情報: ========= Group By & Having ========= [日 8 07 08:59:21 JST 2022]
  64. [EL Fine]: sql: 2022-08-07 08:59:21.244--ServerSession(2144644334)--Connection(1402333753)--SELECT NAME, SUM(user_number) FROM m_user GROUP BY NAME HAVING (SUM(user_number) > ?)
  65. bind => [100]
  66. 情報: ========= Update ========= [日 8 07 08:59:21 JST 2022]
  67. [EL Fine]: sql: 2022-08-07 08:59:21.257--ClientSession(382252989)--Connection(1402333753)--UPDATE m_user SET NAME = ? WHERE (user_id = ?)
  68. bind => [new-name, 0000]
  69. 情報: ========= Inner Join ========= [日 8 07 08:59:21 JST 2022]
  70. [EL Fine]: sql: 2022-08-07 08:59:21.266--ServerSession(2144644334)--Connection(1402333753)--SELECT t1.user_id, t1.age, t1.NAME, t1.PASSWORD, t1.user_number FROM email_address t0, m_user t1 WHERE (t0.email_address LIKE ? AND (t0.user_id = t1.user_id))
  71. bind => [a%]
  72. 情報: ========= Multi Select ========= [日 8 07 08:59:21 JST 2022]
  73. [EL Fine]: sql: 2022-08-07 08:59:21.279--ServerSession(2144644334)--Connection(1402333753)--SELECT user_id, NAME FROM m_user
  74. 情報: ========= Avg ========= [日 8 07 08:59:21 JST 2022]
  75. [EL Fine]: sql: 2022-08-07 08:59:21.283--ServerSession(2144644334)--Connection(1402333753)--SELECT AVG(age) FROM m_user
  76. 情報: ========= Max ========= [日 8 07 08:59:21 JST 2022]
  77. [EL Fine]: sql: 2022-08-07 08:59:21.29--ServerSession(2144644334)--Connection(1402333753)--SELECT MAX(age) FROM m_user
  78. 情報: ========= Min ========= [日 8 07 08:59:21 JST 2022]
  79. [EL Fine]: sql: 2022-08-07 08:59:21.294--ServerSession(2144644334)--Connection(1402333753)--SELECT MIN(age) FROM m_user
  80. 情報: ========= Count ========= [日 8 07 08:59:21 JST 2022]
  81. [EL Fine]: sql: 2022-08-07 08:59:21.299--ServerSession(2144644334)--Connection(1402333753)--SELECT COUNT(user_id) FROM m_user
  82. 情報: ========= Group By ========= [日 8 07 08:59:21 JST 2022]
  83. [EL Fine]: sql: 2022-08-07 08:59:21.304--ServerSession(2144644334)--Connection(1402333753)--SELECT NAME, SUM(user_number) FROM m_user GROUP BY NAME
  84. 情報: ========= Select With Condition ========= [日 8 07 08:59:21 JST 2022]
  85. [EL Fine]: sql: 2022-08-07 08:59:21.309--ServerSession(2144644334)--Connection(1402333753)--SELECT user_id, age, NAME, PASSWORD, user_number FROM m_user WHERE (user_id = ?)
  86. bind => [0000]
  87. 情報: ========= Left Join ========= [日 8 07 08:59:21 JST 2022]
  88. [EL Fine]: sql: 2022-08-07 08:59:21.314--ServerSession(2144644334)--Connection(1402333753)--SELECT t1.user_id, t1.age, t1.NAME, t1.PASSWORD, t1.user_number FROM {oj m_user t1 LEFT OUTER JOIN email_address t0 ON (t0.user_id = t1.user_id)} WHERE t0.email_address LIKE ?
  89. bind => [a%]
  90. 情報: ========= Cross Join (No relations) ========= [日 8 07 08:59:21 JST 2022]
  91. [EL Fine]: sql: 2022-08-07 08:59:21.322--ServerSession(2144644334)--Connection(1402333753)--SELECT t0.user_id, t0.age, t0.NAME, t0.PASSWORD, t0.user_number FROM m_user t0, user_group t1 WHERE ((t0.user_id = t1.user_id) AND (t1.group_id IN (?, ?)))
  92. bind => [gid1, gid2]