powered by simpleCommunicator - 2.0.30     © 2024 Programmizd 02
Map
Форумы / Java [игнор отключен] [закрыт для гостей] / Почему не работает SequenceGenerator в Spring Boot?
25 сообщений из 60, страница 1 из 3
Почему не работает SequenceGenerator в Spring Boot?
    #40051638
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Я веду блог на Spring Boot + Spring Date. Есть сообщение, пользователь, комментарий и сущности, которые содержат ссылки между ними. Для каждой из этих 6 сущностей я добавил аннотацию
Код: java
1.
@SequenceGenerator (name = "...", sequenceName = "...", allocationSize = 1)



Также создается в Базе данных дополнительно hibernate_sequencе

Однако возникают следующие проблемы.

Когда я добавляю сообщение (с id = 1) и удаляю его, а затем создаю новое сообщение, оно уже с идентификатором 2, а не с идентификатором 1
Когда я пытаюсь добавить к нему комментарий, выдает ошибку, которая обычно возникает, если нет SequenceGenerator. ОШИБКА: INSERT или UPDATE в таблице "posts_comments" нарушает ограничение внешнего ключа "posts_comments_post_id_fkey"
Подробности: Ключ (post_id)=(3) отсутствует в таблице "posts".

add comment in CommentService

Код: java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
public void create(Comments new_comment,Long  parent_id, String login, int post_id)
        {
            Users user=userService.findByLogin(login);
            Posts post=postsRepository.findById((long) post_id).get();
    
            if((parent_id!=null)&&(commentsRepository.existsById(parent_id)))
            {
                Comments parentComment=commentsRepository.findById(parent_id).get();
                parentComment.getChildComment().add(new_comment);
                commentsRepository.save(parentComment);
            }
            new_comment.setOwnerpost(post);
            new_comment.setOwner(user);
            commentsRepository.save(new_comment);
        }



Comment

Код: java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
@Entity
    @Table(name = "comments")
    @Setter
    @Getter
    @NoArgsConstructor
    @AllArgsConstructor
    public class Comments implements Serializable {
        private static final long serialVersionUID = 1L;
        @Id
        @SequenceGenerator(name = "clientsIdSeq1", sequenceName = "comments_id_seq", allocationSize = 1)
        @GeneratedValue(strategy = GenerationType.SEQUENCE,generator="comments_id_seq")
        private Long id;
    
        @Column(name = "title")
        private String title;
    
        @Column(name = "content")
        private String content;
    
        @Column(name = "date_create")
        private LocalDate dateCreate;
    
        @Column(name = "count_like")
        private Long countLike;
    
        @Column(name = "count_dislike")
        private Long counterDislike;
    
        @OneToMany(fetch= FetchType.EAGER,cascade=CascadeType.ALL ,orphanRemoval=true )
        @JoinTable(name = "parentchild_comment",
                joinColumns = @JoinColumn(name= "parent_id"),
                inverseJoinColumns =  @JoinColumn(name= "child_id"))
        @Fetch(value = FetchMode.SUBSELECT)
        private List<Comments> childComment;
        @ManyToOne(fetch= FetchType.EAGER,cascade=CascadeType.ALL )
        @JoinTable(name = "users_comments",
                joinColumns = @JoinColumn(name= "comment_id"),
                inverseJoinColumns =  @JoinColumn(name= "user_id"))
        @JsonIgnoreProperties({"listPost", "listComment"})
        private Users owner;
    
        @ManyToOne(fetch= FetchType.EAGER,cascade = {CascadeType.REFRESH })
        @JoinTable(name = "posts_comments",
                joinColumns = @JoinColumn(name= "post_id"),
                inverseJoinColumns =  @JoinColumn(name= "comment_id"))
        @JsonIgnoreProperties({"listComments"})
        private Posts ownerpost;
    }



Post


Код: java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
@Entity
    @Table(name = "posts")
    @Setter
    @Getter
    @NoArgsConstructor
    @AllArgsConstructor
    public class Posts implements Serializable {
        @Id
        @Column(name = "id")
        @SequenceGenerator(name = "clientsIdSeq4", sequenceName = "posts_id_seq", allocationSize = 1)
        @GeneratedValue(strategy = GenerationType.SEQUENCE,generator ="posts_id_seq" )
        private Long id ;
        @Column(name = "title")
        private String title;
    
        @Column(name = "content")
        private String content;
    
        @Column(name = "date_create")
        private LocalDate dateCreate;
    
        @Column(name = "count_like")
        private Long countLike;
    
        @Column(name = "count_dislike")
        private Long counterDislike;
    
        @OneToMany(mappedBy = "ownerpost",fetch= FetchType.EAGER,cascade=CascadeType.ALL,orphanRemoval=true )
        @Fetch(value = FetchMode.SUBSELECT)
        @JsonIgnoreProperties("childComment")
        private List<Comments> listComments;
    
        @ManyToOne(fetch= FetchType.EAGER,cascade=CascadeType.REFRESH)
        @JoinTable(name = "users_posts",
                joinColumns = @JoinColumn(name= "post_id"),
                inverseJoinColumns =  @JoinColumn(name= "user_id"))
        @JsonIgnoreProperties({"listPost", "listComment"})
        private Users owner;
    }



User


Код: java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
@Entity
    @Table(name = "users")
    @Setter
    @Getter
    @NoArgsConstructor
    @AllArgsConstructor
    public class Users implements Serializable {
    
        private static final long serialVersionUID = 1L;
    
        @Id
        @SequenceGenerator(name = "clientsIdSeq5", sequenceName = "users_id_seq", allocationSize = 1)
        @GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "users_id_seq")
    
        private Long id;
    
        @Column(name = "login")
        private String login;
    
        @Column(name = "password")
        private String password;
    
        @ManyToOne(optional = false, cascade = CascadeType.REFRESH)
        @JoinColumn(name = "position_id")
        private Position position;
    
        @OneToMany(mappedBy = "owner",fetch= FetchType.EAGER,cascade=CascadeType.ALL,orphanRemoval=true )
        @JsonIgnoreProperties("listComments")
        @Fetch(value = FetchMode.SUBSELECT)
        private List<Posts> listPost;
    
        @OneToMany(mappedBy = "owner",fetch= FetchType.EAGER,cascade=CascadeType.ALL,orphanRemoval=true )
        @JsonIgnoreProperties("childComment")
        @Fetch(value = FetchMode.SUBSELECT)
        private List<Comments> listComment;
    
        @Override
        public boolean equals(Object o) {
            if (this == o) return true;
            if (!(o instanceof Users)) return false;
    
            Users users = (Users) o;
    
            if (!Objects.equals(id, users.id)) return false;
            if (!Objects.equals(login, users.login)) return false;
            if (!Objects.equals(password, users.password)) return false;
            if (!Objects.equals(position, users.position)) return false;
            if (!Objects.equals(listPost, users.listPost)) return false;
            return Objects.equals(listComment, users.listComment);
        }
    
        @Override
        public int hashCode() {
            int result = id != null ? id.hashCode() : 0;
            result = 31 * result + (login != null ? login.hashCode() : 0);
            result = 31 * result + (password != null ? password.hashCode() : 0);
            result = 31 * result + (position != null ? position.hashCode() : 0);
            result = 31 * result + (listPost != null ? listPost.hashCode() : 0);
            result = 31 * result + (listComment != null ? listComment.hashCode() : 0);
            return result;
        }
    }
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051653
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,
Удали лишний код. Сделай 3 таблы с одним полем каждая.
Потом ошибку сюда. И запросы которые к бд тоже
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051673
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp,Я не знаю какой код нужен и привожу его как можно больше.

Ошибку я тоже привел,а запросы составляет hibrenate
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051677
Фотография asv79
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,зачем ты создаешь свои секвенсы если не шаришь
используй такое

Код: java
1.
2.
3.
 @Id
  @GeneratedValue(strategy = GenerationType.IDENTITY)
  private Long id;



далее= если ты удалил запиись с id =1 ,то ты просто удалил эту запись - секвенсы живут отдельно и им по барабану что ты удалил запись с id=1,если хочешь заново получиь id=1 нужно дропнуть секвенс
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051679
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
asv79,

потому что с GenerationType.IDENTITY как раз и возникала та самая ошибка и я нашел совет использовать sequence.

Так а как правильно удалять и добавлять сущности с sequence?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051704
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
asv79,я еще раз сделал именно так.Ошибка осталась
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051707
Lelouch
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
asv79,я еще раз сделал именно так.Ошибка осталась

Попробуйте в GeneratedValue#generator указать не название sequence, а значение, которое указали в SequenceGenerator#name

Как то так:
Код: java
1.
2.
@SequenceGenerator(name = "clientsIdSeq5", sequenceName = "users_id_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "clientsIdSeq5")
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051708
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
PetroNotC Sharp,Я не знаю какой код нужен и привожу его как можно больше.

Ошибку я тоже привел,а запросы составляет hibrenate

Повторить?
Лишний код убрать. Тебе бесплатно за это помогают.
Запросы хибера в студию.
DDL таблиц сюда.
Ты написал что удалил сообщение, но кода удаления нет.
В общем случае, надо после удаления все сбросить в бд и опять его найти.
Удалить лишние каскады.
Удалить аннотации json не имеющие отношения к вопросу.
Не ленись. Работай. Ленивые не становятся профи.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051709
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
asv79,

потому что с GenerationType.IDENTITY как раз и возникала та самая ошибка и я нашел совет использовать sequence.

Так а как правильно удалять и добавлять сущности с sequence?
по взрослому, добавить триггер на 3 таблицы.
Тогда ничего в java писать не надо с именами сиквенсов.
Ну или вообще без них тип поля счётчик появился вроде
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051710
Lelouch
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Lelouch
stavatar
asv79,я еще раз сделал именно так.Ошибка осталась

Попробуйте в GeneratedValue#generator указать не название sequence, а значение, которое указали в SequenceGenerator#name

Как то так:
Код: java
1.
2.
@SequenceGenerator(name = "clientsIdSeq5", sequenceName = "users_id_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "clientsIdSeq5")



AFAIK: И ещё имейте в виду, что не важно на каком уровне вы объявили SequenceGenerator - они создаются глобально в рамках Persistent unit и необходимо следить за уникальностью имён
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051714
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Lelouch
Lelouch
пропущено...

Попробуйте в GeneratedValue#generator указать не название sequence, а значение, которое указали в SequenceGenerator#name

Как то так:
Код: java
1.
2.
@SequenceGenerator(name = "clientsIdSeq5", sequenceName = "users_id_seq", allocationSize = 1)
@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "clientsIdSeq5")



AFAIK: И ещё имейте в виду, что не важно на каком уровне вы объявили SequenceGenerator - они создаются глобально в рамках Persistent unit и необходимо следить за уникальностью имён


Я и так тоже делал.Ошибка остается
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051715
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar
asv79,

потому что с GenerationType.IDENTITY как раз и возникала та самая ошибка и я нашел совет использовать sequence.

Так а как правильно удалять и добавлять сущности с sequence?
по взрослому, добавить триггер на 3 таблицы.
Тогда ничего в java писать не надо с именами сиквенсов.
Ну или вообще без них тип поля счётчик появился вроде


Что должно быть в этих триггерах?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051717
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar
PetroNotC Sharp,Я не знаю какой код нужен и привожу его как можно больше.

Ошибку я тоже привел,а запросы составляет hibrenate

Повторить?
Лишний код убрать. Тебе бесплатно за это помогают.
Запросы хибера в студию.
DDL таблиц сюда.
Ты написал что удалил сообщение, но кода удаления нет.
В общем случае, надо после удаления все сбросить в бд и опять его найти.
Удалить лишние каскады.
Удалить аннотации json не имеющие отношения к вопросу.
Не ленись. Работай. Ленивые не становятся профи.


Думаю,мне проще дать ссылку на архив с кодом.Ибо я не знаю что может понадобится в коде.
https://dropmefiles.com/pdv48

DDL

Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
CREATE TABLE public.comments
(
    id integer NOT NULL DEFAULT nextval('comments_id_seq'::regclass),
    title text COLLATE pg_catalog."default",
    content text COLLATE pg_catalog."default",
    date_create date,
    count_like integer,
    count_dislike integer,
    CONSTRAINT comments_pkey PRIMARY KEY (id)
)



Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
CREATE TABLE public.posts
(
    id integer NOT NULL DEFAULT nextval('posts_id_seq'::regclass),
    title text COLLATE pg_catalog."default",
    content text COLLATE pg_catalog."default",
    date_create date,
    count_like integer,
    count_dislike integer,
    CONSTRAINT posts_pkey PRIMARY KEY (id)
)



Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
CREATE TABLE public.posts_comments
(
    id integer NOT NULL DEFAULT nextval('posts_comments_id_seq'::regclass),
    post_id integer,
    comment_id integer,
    CONSTRAINT posts_comments_pkey PRIMARY KEY (id),
    CONSTRAINT posts_comments_comment_id_fkey FOREIGN KEY (comment_id)
        REFERENCES public.comments (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT posts_comments_post_id_fkey FOREIGN KEY (post_id)
        REFERENCES public.posts (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)



Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
CREATE TABLE public.users
(
    id integer NOT NULL DEFAULT nextval('users_id_seq'::regclass),
    login text COLLATE pg_catalog."default",
    password text COLLATE pg_catalog."default",
    position_id integer,
    CONSTRAINT users_pkey PRIMARY KEY (id),
    CONSTRAINT users_position_id_fkey FOREIGN KEY (position_id)
        REFERENCES public."position" (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)



Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
CREATE TABLE public.users_comments
(
    id integer NOT NULL DEFAULT nextval('users_comments_id_seq'::regclass),
    user_id integer,
    comment_id integer,
    CONSTRAINT users_comments_pkey PRIMARY KEY (id),
    CONSTRAINT users_comments_comment_id_fkey FOREIGN KEY (comment_id)
        REFERENCES public.comments (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT users_comments_user_id_fkey FOREIGN KEY (user_id)
        REFERENCES public.users (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)



Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
CREATE TABLE public.users_posts
(
    id integer NOT NULL DEFAULT nextval('users_posts_id_seq'::regclass),
    post_id integer,
    user_id integer,
    CONSTRAINT users_posts_pkey PRIMARY KEY (id),
    CONSTRAINT users_posts_post_id_fkey FOREIGN KEY (post_id)
        REFERENCES public.posts (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT users_posts_user_id_fkey FOREIGN KEY (user_id)
        REFERENCES public.users (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051731
Фотография crutchmaster
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
PetroNotC Sharp
по взрослому, добавить триггер на 3 таблицы.

Ид хибернейт должен расставлять, зачем триггер?
PetroNotC Sharp
Тогда ничего в java писать не надо с именами сиквенсов.

Откуда тогда жабка узнает, какой там новый ид, еще *до* вставки? Как бы вся пляска с sequence делается, чтобы не вставлять каждый раз, когда создаёшь объект и не бегать лишний раз в бд (для чего allocationSize делают сильно больше единицы). С другой стороны, если приложение с базой работает одно, зачем вообще нужен sequence из бд.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051737
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
crutchmaster,
Выше GenerationType.IDENTITY все делает.
Я тебя умоляю, не надо беспокоится о скорости в бд если у вас спринг бут с длинными транзакциями)
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051739
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
PetroNotC Sharp
пропущено...
по взрослому, добавить триггер на 3 таблицы.
Тогда ничего в java писать не надо с именами сиквенсов.
Ну или вообще без них тип поля счётчик появился вроде


Что должно быть в этих триггерах?

Вот чел ищет, спрашивает, чтобы писать современно и меньше кода
https://stackoverflow.com/questions/40497768/jpa-and-postgresql-with-generationtype-identity/40499193
Если не работает, спрашивай.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051740
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,
Дак у тебя УЖЕ код в бд не для маппинг что ты написал..
id integer NOT NULL DEFAULT nextval('comments_id_seq'::regclass),
?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051741
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,

Таблиц должно быть всего 3 а не 6.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051742
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
crutchmaster,
Итого, возвращаемся к началу - убрать все поля и оставить только ID, name, FK в демке вопросе на форум.
Трассировку SQL не знаем как включить?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051744
mad_nazgul
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar

Однако возникают следующие проблемы.

Когда я добавляю сообщение (с id = 1) и удаляю его, а затем создаю новое сообщение, оно уже с идентификатором 2, а не с идентификатором 1

Когда я пытаюсь добавить к нему комментарий, выдает ошибку, которая обычно возникает, если нет SequenceGenerator. ОШИБКА: INSERT или UPDATE в таблице "posts_comments" нарушает ограничение внешнего ключа "posts_comments_post_id_fkey"
Подробности: Ключ (post_id)=(3) отсутствует в таблице "posts".



1. Какая БД? Т.к. в разных БД есть особенности работы с Sequence
2. Поведение при добавлении/удалении правильное. Так и должно быть.
3. Поведение странное. Возможно нужно добавить "@Transactional"?!
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051755
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar,
Дак у тебя УЖЕ код в бд не для маппинг что ты написал..
id integer NOT NULL DEFAULT nextval('comments_id_seq'::regclass),
?


Это уже скопированное из БД.

Изначально я писал " id serial PRIMARY KEY"

А как должно быть,что бы со спрингом работало?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051756
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
mad_nazgul
stavatar

Однако возникают следующие проблемы.

Когда я добавляю сообщение (с id = 1) и удаляю его, а затем создаю новое сообщение, оно уже с идентификатором 2, а не с идентификатором 1

Когда я пытаюсь добавить к нему комментарий, выдает ошибку, которая обычно возникает, если нет SequenceGenerator. ОШИБКА: INSERT или UPDATE в таблице "posts_comments" нарушает ограничение внешнего ключа "posts_comments_post_id_fkey"
Подробности: Ключ (post_id)=(3) отсутствует в таблице "posts".



1. Какая БД? Т.к. в разных БД есть особенности работы с Sequence
2. Поведение при добавлении/удалении правильное. Так и должно быть.
3. Поведение странное. Возможно нужно добавить "@Transactional"?!



1)Postgres
2)Я об этой аннотации мало знаю,куда ее нужно вставить?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051766
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
crutchmaster,
Итого, возвращаемся к началу - убрать все поля и оставить только ID, name, FK в демке вопросе на форум.
Трассировку SQL не знаем как включить?
/

Ну хорошо....Щас пришлю
Это если добавить первый пост
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:18:19.500 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:18:19.501 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:18:19.502 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:18:19.503 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:18:19.504 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.507 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
2021-03-09 09:18:19.507 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.514  INFO 16704 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter               : do filter...
2021-03-09 09:18:19.514  INFO 16704 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter               : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 09:18:19.518  INFO 16704 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter               : !!test
2021-03-09 09:18:19.519 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:18:19.520 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:18:19.521 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:18:19.522 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:18:19.523 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:18:19.524 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.526 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
2021-03-09 09:18:19.527 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.562 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:18:19.563 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:18:19.566 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:18:19.566 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:18:19.568 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:18:19.568 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.571 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
2021-03-09 09:18:19.572 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:18:19.606 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        nextval ('posts_id_seq')
Hibernate: 
    select
        nextval ('posts_id_seq')
2021-03-09 09:18:19.643 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    insert 
    into
        posts
        (content, count_like, count_dislike, date_create, title, id) 
    values
        (?, ?, ?, ?, ?, ?)
Hibernate: 
    insert 
    into
        posts
        (content, count_like, count_dislike, date_create, title, id) 
    values
        (?, ?, ?, ?, ?, ?)
2021-03-09 09:18:19.644 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [TEST1]
2021-03-09 09:18:19.644 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [0]
2021-03-09 09:18:19.644 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [3] as [BIGINT] - [0]
2021-03-09 09:18:19.645 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [4] as [DATE] - [null]
2021-03-09 09:18:19.648 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [5] as [VARCHAR] - [TITLEE1]
2021-03-09 09:18:19.649 TRACE 16704 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [6] as [BIGINT] - [2]
2021-03-09 09:18:19.688 DEBUG 16704 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    insert 
    into
        users_posts
        (user_id, post_id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        users_posts
        (user_id, post_id) 
    values
        (?, ?)





Это если добавить затем второй пост

Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:21:10.933 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:21:10.934 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:21:10.935 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.936 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:21:10.937 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:21:10.943 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        listcommen0_.comment_id as comment_2_4_0_,
        listcommen0_.post_id as post_id3_4_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        users2_.id as id1_5_2_,
        users2_.login as login2_5_2_,
        users2_.password as password3_5_2_,
        users2_.position_id as position4_5_2_,
        position3_.id as id1_2_3_,
        position3_.description as descript2_2_3_,
        position3_.name as name3_2_3_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        users users2_ 
            on comments1_2_.user_id=users2_.id 
    left outer join
        position position3_ 
            on users2_.position_id=position3_.id 
    where
        listcommen0_.comment_id=?
Hibernate: 
    select
        listcommen0_.comment_id as comment_2_4_0_,
        listcommen0_.post_id as post_id3_4_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        users2_.id as id1_5_2_,
        users2_.login as login2_5_2_,
        users2_.password as password3_5_2_,
        users2_.position_id as position4_5_2_,
        position3_.id as id1_2_3_,
        position3_.description as descript2_2_3_,
        position3_.name as name3_2_3_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        users users2_ 
            on comments1_2_.user_id=users2_.id 
    left outer join
        position position3_ 
            on users2_.position_id=position3_.id 
    where
        listcommen0_.comment_id=?
2021-03-09 09:21:10.944 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.948 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
2021-03-09 09:21:10.948 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:21:10.952  INFO 16704 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter               : do filter...
2021-03-09 09:21:10.952  INFO 16704 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter               : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 09:21:10.955  INFO 16704 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter               : !!test
2021-03-09 09:21:10.958 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:21:10.959 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:21:10.960 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:21:10.961 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.963 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:21:10.963 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:21:10.966 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        listcommen0_.comment_id as comment_2_4_0_,
        listcommen0_.post_id as post_id3_4_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        users2_.id as id1_5_2_,
        users2_.login as login2_5_2_,
        users2_.password as password3_5_2_,
        users2_.position_id as position4_5_2_,
        position3_.id as id1_2_3_,
        position3_.description as descript2_2_3_,
        position3_.name as name3_2_3_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        users users2_ 
            on comments1_2_.user_id=users2_.id 
    left outer join
        position position3_ 
            on users2_.position_id=position3_.id 
    where
        listcommen0_.comment_id=?
Hibernate: 
    select
        listcommen0_.comment_id as comment_2_4_0_,
        listcommen0_.post_id as post_id3_4_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        users2_.id as id1_5_2_,
        users2_.login as login2_5_2_,
        users2_.password as password3_5_2_,
        users2_.position_id as position4_5_2_,
        position3_.id as id1_2_3_,
        position3_.description as descript2_2_3_,
        position3_.name as name3_2_3_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        users users2_ 
            on comments1_2_.user_id=users2_.id 
    left outer join
        position position3_ 
            on users2_.position_id=position3_.id 
    where
        listcommen0_.comment_id=?
2021-03-09 09:21:10.967 TRACE 16704 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:21:10.971 DEBUG 16704 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 





А теперь когда добавляешь комментарий ко второму добавленному посту,после которого возникает ошибка

Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.
694.
695.
696.
697.
698.
699.
700.
701.
702.
703.
704.
705.
706.
707.
708.
709.
710.
711.
712.
713.
714.
715.
716.
717.
718.
719.
720.
721.
722.
723.
724.
725.
726.
727.
728.
729.
730.
731.
732.
733.
734.
735.
736.
737.
738.
739.
740.
741.
742.
743.
744.
745.
746.
747.
748.
749.
750.
751.
752.
753.
754.
755.
756.
757.
758.
759.
760.
761.
762.
763.
764.
765.
766.
767.
768.
769.
770.
771.
772.
773.
774.
775.
776.
777.
778.
779.
780.
781.
782.
783.
784.
785.
786.
787.
788.
789.
790.
791.
792.
793.
794.
795.
796.
797.
798.
799.
800.
801.
802.
803.
804.
805.
806.
807.
808.
809.
810.
811.
812.
813.
814.
815.
816.
817.
818.
819.
820.
821.
822.
823.
824.
825.
826.
827.
828.
829.
830.
831.
832.
833.
834.
835.
836.
837.
838.
839.
840.
841.
842.
843.
844.
845.
846.
847.
848.
849.
850.
851.
852.
853.
854.
855.
856.
857.
858.
859.
860.
861.
862.
863.
864.
865.
866.
867.
868.
869.
870.
871.
872.
873.
874.
875.
876.
877.
878.
879.
880.
881.
882.
883.
884.
885.
886.
887.
888.
889.
890.
891.
892.
893.
894.
895.
896.
897.
898.
899.
900.
901.
902.
903.
904.
905.
906.
907.
908.
909.
910.
911.
912.
913.
914.
915.
916.
917.
918.
919.
920.
921.
922.
923.
924.
925.
926.
927.
928.
929.
930.
931.
932.
933.
934.
935.
936.
937.
938.
939.
940.
941.
942.
943.
944.
945.
946.
947.
948.
949.
950.
951.
952.
953.
954.
955.
956.
957.
958.
959.
960.
961.
962.
963.
964.
965.
966.
967.
968.
969.
970.
971.
972.
973.
974.
975.
976.
977.
978.
979.
980.
981.
982.
983.
984.
985.
986.
987.
988.
989.
990.
991.
992.
993.
994.
995.
996.
997.
998.
999.
1000.
1001.
1002.
1003.
1004.
1005.
1006.
1007.
1008.
1009.
1010.
1011.
1012.
1013.
1014.
1015.
1016.
1017.
1018.
1019.
1020.
1021.
1022.
1023.
1024.
1025.
1026.
1027.
1028.
1029.
1030.
1031.
1032.
1033.
1034.
1035.
1036.
1037.
2021-03-09 09:31:34.741 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:31:34.743 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:31:34.746 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:31:34.746 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:31:34.748 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:31:34.748 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.765 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listcommen0_.comment_id as comment_2_4_5_,
        listcommen0_.post_id as post_id3_4_5_,
        comments1_.id as id1_0_0_,
        comments1_.content as content2_0_0_,
        comments1_.count_like as count_li3_0_0_,
        comments1_.count_dislike as count_di4_0_0_,
        comments1_.date_create as date_cre5_0_0_,
        comments1_.title as title6_0_0_,
        comments1_1_.comment_id as comment_2_4_0_,
        comments1_2_.user_id as user_id2_6_0_,
        posts2_.id as id1_3_1_,
        posts2_.content as content2_3_1_,
        posts2_.count_like as count_li3_3_1_,
        posts2_.count_dislike as count_di4_3_1_,
        posts2_.date_create as date_cre5_3_1_,
        posts2_.title as title6_3_1_,
        posts2_1_.user_id as user_id2_7_1_,
        users3_.id as id1_5_2_,
        users3_.login as login2_5_2_,
        users3_.password as password3_5_2_,
        users3_.position_id as position4_5_2_,
        position4_.id as id1_2_3_,
        position4_.description as descript2_2_3_,
        position4_.name as name3_2_3_,
        users5_.id as id1_5_4_,
        users5_.login as login2_5_4_,
        users5_.password as password3_5_4_,
        users5_.position_id as position4_5_4_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    left outer join
        users users5_ 
            on comments1_2_.user_id=users5_.id 
    where
        listcommen0_.comment_id in (
            select
                posts1_.id 
            from
                users_posts listpost0_ 
            inner join
                posts posts1_ 
                    on listpost0_.post_id=posts1_.id 
            left outer join
                users_posts posts1_1_ 
                    on posts1_.id=posts1_1_.post_id 
            where
                listpost0_.user_id=?
        )
Hibernate: 
    select
        listcommen0_.comment_id as comment_2_4_5_,
        listcommen0_.post_id as post_id3_4_5_,
        comments1_.id as id1_0_0_,
        comments1_.content as content2_0_0_,
        comments1_.count_like as count_li3_0_0_,
        comments1_.count_dislike as count_di4_0_0_,
        comments1_.date_create as date_cre5_0_0_,
        comments1_.title as title6_0_0_,
        comments1_1_.comment_id as comment_2_4_0_,
        comments1_2_.user_id as user_id2_6_0_,
        posts2_.id as id1_3_1_,
        posts2_.content as content2_3_1_,
        posts2_.count_like as count_li3_3_1_,
        posts2_.count_dislike as count_di4_3_1_,
        posts2_.date_create as date_cre5_3_1_,
        posts2_.title as title6_3_1_,
        posts2_1_.user_id as user_id2_7_1_,
        users3_.id as id1_5_2_,
        users3_.login as login2_5_2_,
        users3_.password as password3_5_2_,
        users3_.position_id as position4_5_2_,
        position4_.id as id1_2_3_,
        position4_.description as descript2_2_3_,
        position4_.name as name3_2_3_,
        users5_.id as id1_5_4_,
        users5_.login as login2_5_4_,
        users5_.password as password3_5_4_,
        users5_.position_id as position4_5_4_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    left outer join
        users users5_ 
            on comments1_2_.user_id=users5_.id 
    where
        listcommen0_.comment_id in (
            select
                posts1_.id 
            from
                users_posts listpost0_ 
            inner join
                posts posts1_ 
                    on listpost0_.post_id=posts1_.id 
            left outer join
                users_posts posts1_1_ 
                    on posts1_.id=posts1_1_.post_id 
            where
                listpost0_.user_id=?
        )
2021-03-09 09:31:34.767 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.772 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
2021-03-09 09:31:34.773 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.777  INFO 5392 --- [nio-8087-exec-5] c.e.L.config.jwt.JwtFilter               : do filter...
2021-03-09 09:31:34.778  INFO 5392 --- [nio-8087-exec-5] c.e.L.config.jwt.JwtFilter               : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 09:31:34.780  INFO 5392 --- [nio-8087-exec-5] c.e.L.config.jwt.JwtFilter               : !!test
2021-03-09 09:31:34.781 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:31:34.782 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:31:34.783 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:31:34.784 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:31:34.785 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:31:34.786 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.789 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listcommen0_.comment_id as comment_2_4_5_,
        listcommen0_.post_id as post_id3_4_5_,
        comments1_.id as id1_0_0_,
        comments1_.content as content2_0_0_,
        comments1_.count_like as count_li3_0_0_,
        comments1_.count_dislike as count_di4_0_0_,
        comments1_.date_create as date_cre5_0_0_,
        comments1_.title as title6_0_0_,
        comments1_1_.comment_id as comment_2_4_0_,
        comments1_2_.user_id as user_id2_6_0_,
        posts2_.id as id1_3_1_,
        posts2_.content as content2_3_1_,
        posts2_.count_like as count_li3_3_1_,
        posts2_.count_dislike as count_di4_3_1_,
        posts2_.date_create as date_cre5_3_1_,
        posts2_.title as title6_3_1_,
        posts2_1_.user_id as user_id2_7_1_,
        users3_.id as id1_5_2_,
        users3_.login as login2_5_2_,
        users3_.password as password3_5_2_,
        users3_.position_id as position4_5_2_,
        position4_.id as id1_2_3_,
        position4_.description as descript2_2_3_,
        position4_.name as name3_2_3_,
        users5_.id as id1_5_4_,
        users5_.login as login2_5_4_,
        users5_.password as password3_5_4_,
        users5_.position_id as position4_5_4_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    left outer join
        users users5_ 
            on comments1_2_.user_id=users5_.id 
    where
        listcommen0_.comment_id in (
            select
                posts1_.id 
            from
                users_posts listpost0_ 
            inner join
                posts posts1_ 
                    on listpost0_.post_id=posts1_.id 
            left outer join
                users_posts posts1_1_ 
                    on posts1_.id=posts1_1_.post_id 
            where
                listpost0_.user_id=?
        )
Hibernate: 
    select
        listcommen0_.comment_id as comment_2_4_5_,
        listcommen0_.post_id as post_id3_4_5_,
        comments1_.id as id1_0_0_,
        comments1_.content as content2_0_0_,
        comments1_.count_like as count_li3_0_0_,
        comments1_.count_dislike as count_di4_0_0_,
        comments1_.date_create as date_cre5_0_0_,
        comments1_.title as title6_0_0_,
        comments1_1_.comment_id as comment_2_4_0_,
        comments1_2_.user_id as user_id2_6_0_,
        posts2_.id as id1_3_1_,
        posts2_.content as content2_3_1_,
        posts2_.count_like as count_li3_3_1_,
        posts2_.count_dislike as count_di4_3_1_,
        posts2_.date_create as date_cre5_3_1_,
        posts2_.title as title6_3_1_,
        posts2_1_.user_id as user_id2_7_1_,
        users3_.id as id1_5_2_,
        users3_.login as login2_5_2_,
        users3_.password as password3_5_2_,
        users3_.position_id as position4_5_2_,
        position4_.id as id1_2_3_,
        position4_.description as descript2_2_3_,
        position4_.name as name3_2_3_,
        users5_.id as id1_5_4_,
        users5_.login as login2_5_4_,
        users5_.password as password3_5_4_,
        users5_.position_id as position4_5_4_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    left outer join
        users users5_ 
            on comments1_2_.user_id=users5_.id 
    where
        listcommen0_.comment_id in (
            select
                posts1_.id 
            from
                users_posts listpost0_ 
            inner join
                posts posts1_ 
                    on listpost0_.post_id=posts1_.id 
            left outer join
                users_posts posts1_1_ 
                    on posts1_.id=posts1_1_.post_id 
            where
                listpost0_.user_id=?
        )
2021-03-09 09:31:34.790 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.798 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
2021-03-09 09:31:34.799 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.816 ERROR 5392 --- [nio-8087-exec-5] c.e.L.controller.CommentsController      : Optional.empty
2021-03-09 09:31:34.817 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
Hibernate: 
    select
        users0_.id as id1_5_,
        users0_.login as login2_5_,
        users0_.password as password3_5_,
        users0_.position_id as position4_5_ 
    from
        users users0_ 
    where
        users0_.login=?
2021-03-09 09:31:34.817 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 09:31:34.819 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
Hibernate: 
    select
        position0_.id as id1_2_0_,
        position0_.description as descript2_2_0_,
        position0_.name as name3_2_0_ 
    from
        position position0_ 
    where
        position0_.id=?
2021-03-09 09:31:34.819 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 09:31:34.822 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
Hibernate: 
    select
        listpost0_.user_id as user_id2_7_0_,
        listpost0_.post_id as post_id3_7_0_,
        posts1_.id as id1_3_1_,
        posts1_.content as content2_3_1_,
        posts1_.count_like as count_li3_3_1_,
        posts1_.count_dislike as count_di4_3_1_,
        posts1_.date_create as date_cre5_3_1_,
        posts1_.title as title6_3_1_,
        posts1_1_.user_id as user_id2_7_1_ 
    from
        users_posts listpost0_ 
    inner join
        posts posts1_ 
            on listpost0_.post_id=posts1_.id 
    left outer join
        users_posts posts1_1_ 
            on posts1_.id=posts1_1_.post_id 
    where
        listpost0_.user_id=?
2021-03-09 09:31:34.822 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.828 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listcommen0_.comment_id as comment_2_4_5_,
        listcommen0_.post_id as post_id3_4_5_,
        comments1_.id as id1_0_0_,
        comments1_.content as content2_0_0_,
        comments1_.count_like as count_li3_0_0_,
        comments1_.count_dislike as count_di4_0_0_,
        comments1_.date_create as date_cre5_0_0_,
        comments1_.title as title6_0_0_,
        comments1_1_.comment_id as comment_2_4_0_,
        comments1_2_.user_id as user_id2_6_0_,
        posts2_.id as id1_3_1_,
        posts2_.content as content2_3_1_,
        posts2_.count_like as count_li3_3_1_,
        posts2_.count_dislike as count_di4_3_1_,
        posts2_.date_create as date_cre5_3_1_,
        posts2_.title as title6_3_1_,
        posts2_1_.user_id as user_id2_7_1_,
        users3_.id as id1_5_2_,
        users3_.login as login2_5_2_,
        users3_.password as password3_5_2_,
        users3_.position_id as position4_5_2_,
        position4_.id as id1_2_3_,
        position4_.description as descript2_2_3_,
        position4_.name as name3_2_3_,
        users5_.id as id1_5_4_,
        users5_.login as login2_5_4_,
        users5_.password as password3_5_4_,
        users5_.position_id as position4_5_4_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    left outer join
        users users5_ 
            on comments1_2_.user_id=users5_.id 
    where
        listcommen0_.comment_id in (
            select
                posts1_.id 
            from
                users_posts listpost0_ 
            inner join
                posts posts1_ 
                    on listpost0_.post_id=posts1_.id 
            left outer join
                users_posts posts1_1_ 
                    on posts1_.id=posts1_1_.post_id 
            where
                listpost0_.user_id=?
        )
Hibernate: 
    select
        listcommen0_.comment_id as comment_2_4_5_,
        listcommen0_.post_id as post_id3_4_5_,
        comments1_.id as id1_0_0_,
        comments1_.content as content2_0_0_,
        comments1_.count_like as count_li3_0_0_,
        comments1_.count_dislike as count_di4_0_0_,
        comments1_.date_create as date_cre5_0_0_,
        comments1_.title as title6_0_0_,
        comments1_1_.comment_id as comment_2_4_0_,
        comments1_2_.user_id as user_id2_6_0_,
        posts2_.id as id1_3_1_,
        posts2_.content as content2_3_1_,
        posts2_.count_like as count_li3_3_1_,
        posts2_.count_dislike as count_di4_3_1_,
        posts2_.date_create as date_cre5_3_1_,
        posts2_.title as title6_3_1_,
        posts2_1_.user_id as user_id2_7_1_,
        users3_.id as id1_5_2_,
        users3_.login as login2_5_2_,
        users3_.password as password3_5_2_,
        users3_.position_id as position4_5_2_,
        position4_.id as id1_2_3_,
        position4_.description as descript2_2_3_,
        position4_.name as name3_2_3_,
        users5_.id as id1_5_4_,
        users5_.login as login2_5_4_,
        users5_.password as password3_5_4_,
        users5_.position_id as position4_5_4_ 
    from
        posts_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.post_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    left outer join
        users users5_ 
            on comments1_2_.user_id=users5_.id 
    where
        listcommen0_.comment_id in (
            select
                posts1_.id 
            from
                users_posts listpost0_ 
            inner join
                posts posts1_ 
                    on listpost0_.post_id=posts1_.id 
            left outer join
                users_posts posts1_1_ 
                    on posts1_.id=posts1_1_.post_id 
            where
                listpost0_.user_id=?
        )
2021-03-09 09:31:34.829 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.837 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
Hibernate: 
    select
        listcommen0_.user_id as user_id2_6_0_,
        listcommen0_.comment_id as comment_3_6_0_,
        comments1_.id as id1_0_1_,
        comments1_.content as content2_0_1_,
        comments1_.count_like as count_li3_0_1_,
        comments1_.count_dislike as count_di4_0_1_,
        comments1_.date_create as date_cre5_0_1_,
        comments1_.title as title6_0_1_,
        comments1_1_.comment_id as comment_2_4_1_,
        comments1_2_.user_id as user_id2_6_1_,
        posts2_.id as id1_3_2_,
        posts2_.content as content2_3_2_,
        posts2_.count_like as count_li3_3_2_,
        posts2_.count_dislike as count_di4_3_2_,
        posts2_.date_create as date_cre5_3_2_,
        posts2_.title as title6_3_2_,
        posts2_1_.user_id as user_id2_7_2_,
        users3_.id as id1_5_3_,
        users3_.login as login2_5_3_,
        users3_.password as password3_5_3_,
        users3_.position_id as position4_5_3_,
        position4_.id as id1_2_4_,
        position4_.description as descript2_2_4_,
        position4_.name as name3_2_4_ 
    from
        users_comments listcommen0_ 
    inner join
        comments comments1_ 
            on listcommen0_.comment_id=comments1_.id 
    left outer join
        posts_comments comments1_1_ 
            on comments1_.id=comments1_1_.post_id 
    left outer join
        users_comments comments1_2_ 
            on comments1_.id=comments1_2_.comment_id 
    left outer join
        posts posts2_ 
            on comments1_1_.comment_id=posts2_.id 
    left outer join
        users_posts posts2_1_ 
            on posts2_.id=posts2_1_.post_id 
    left outer join
        users users3_ 
            on posts2_1_.user_id=users3_.id 
    left outer join
        position position4_ 
            on users3_.position_id=position4_.id 
    where
        listcommen0_.user_id=?
2021-03-09 09:31:34.837 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 09:31:34.856 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    select
        nextval ('comments_id_seq')
Hibernate: 
    select
        nextval ('comments_id_seq')
2021-03-09 09:31:34.859 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    insert 
    into
        comments
        (content, count_like, count_dislike, date_create, title, id) 
    values
        (?, ?, ?, ?, ?, ?)
Hibernate: 
    insert 
    into
        comments
        (content, count_like, count_dislike, date_create, title, id) 
    values
        (?, ?, ?, ?, ?, ?)
2021-03-09 09:31:34.859 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [Ut quaerat est. Consequatur aut aliquid in a eos aspernatur at omnis. Expedita architecto error nesciunt. Molestiae cum consequuntur in quisquam quia a minima.]
2021-03-09 09:31:34.860 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [0]
2021-03-09 09:31:34.860 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [3] as [BIGINT] - [0]
2021-03-09 09:31:34.861 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [4] as [DATE] - [2021-03-09]
2021-03-09 09:31:34.862 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [5] as [VARCHAR] - [totam!!!!!!!!]
2021-03-09 09:31:34.862 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [6] as [BIGINT] - [2]
2021-03-09 09:31:34.864 DEBUG 5392 --- [nio-8087-exec-5] org.hibernate.SQL                        : 
    insert 
    into
        posts_comments
        (comment_id, post_id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        posts_comments
        (comment_id, post_id) 
    values
        (?, ?)
2021-03-09 09:31:34.864 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [3]
2021-03-09 09:31:34.864 TRACE 5392 --- [nio-8087-exec-5] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [2]
2021-03-09 09:31:34.889  WARN 5392 --- [nio-8087-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2021-03-09 09:31:34.889 ERROR 5392 --- [nio-8087-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : ОШИБКА: INSERT или UPDATE в таблице "posts_comments" нарушает ограничение внешнего ключа "posts_comments_comment_id_fkey"
  Подробности: Ключ (comment_id)=(3) отсутствует в таблице "comments".
2021-03-09 09:31:34.940 ERROR 5392 --- [nio-8087-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement] with root cause
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051769
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,

Теперь спрячьте свою портянку под спойлер и ответьте на остальные вопросы.
Почему 6 таблиц?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051771
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Четвёртый раз говорю. Всё поля лишние убрать
Например
posts2_.date_create as date_cre5_3_2_
...
Рейтинг: 0 / 0
25 сообщений из 60, страница 1 из 3
Форумы / Java [игнор отключен] [закрыт для гостей] / Почему не работает SequenceGenerator в Spring Boot?
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]