C:\jee-2020-092\eclipse>eclipse -clearPersistedState
'분류 전체보기'에 해당되는 글 691건
- 2021.05.25 eclipse 실행 안될 때
- 2021.05.21 JPA, A different object with the same identifier value was already associated with the session
- 2021.05.21 JPA crud
- 2021.05.20 JPA, org.hibernate.PropertyAccessException: Null value
- 2021.05.12 liunx, . meaning
- 2021.05.07 MySQL, case insensitive (default)
- 2021.04.30 linux, date
- 2021.04.29 vi, 빈 줄 지우기
- 2021.04.20 mysql, FIND_IN_SET
- 2021.04.20 mysql, comma string to multi rows
JPA, A different object with the same identifier value was already associated with the session
카테고리 없음 2021. 5. 21. 13:21Entity 쪽 컬럼에 값이 유일해질 수 있도록 컬럼에 @Id 추가
The JPA Id does not always have to match the database table primary key constraint, nor is a primary key or a unique constraint required.
https://en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing#No_Primary_Key
long -> Integer
int -> Integer
liunx, . meaning
2021. 5. 12. 18:40보호되어 있는 글입니다. 내용을 보시려면 비밀번호를 입력하세요.
SELECT 'a' = 'A'; -- 1
SELECT BINARY 'a' = 'A'; -- 0
(dev.mysql.com/doc/refman/5.7/en/cast-functions.html#operator_binary)
SELECT * FROM BATCH_INFO20 WHERE FIND_IN_SET(DATE_FORMAT(NOW(), '%H'), EXEC_HOURS);
(stackoverflow.com/questions/18710921/mysql-find-in-set-with-array-string)
with recursive T as ( select 'a,b,c,d,e,f' as items), N as ( select 1 as n union select n + 1 from N, T where n <= length(items) - length(replace(items, ',', ''))) select distinct substring_index(substring_index(items, ',', n), ',', -1) group_name from N, T
(stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows)
