powered by simpleCommunicator - 2.0.30     © 2024 Programmizd 02
Map
Форумы / Java [игнор отключен] [закрыт для гостей] / Почему не работает SequenceGenerator в Spring Boot?
60 сообщений из 60, показаны все 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
Почему не работает SequenceGenerator в Spring Boot?
    #40051775
Фотография crutchmaster
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
PetroNotC Sharp
Теперь спрячьте свою портянку под спойлер

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

Теперь спрячьте свою портянку под спойлер и ответьте на остальные вопросы.
Почему 6 таблиц?


У меня уже нет кнопки отредактировать пост.

Ну,6 сущностей,потому что 3 из них сущности-связи.Где есть сопостовление индексов двух других сущностей.ВРоде так правильно проектировать архитектуру бд
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051785
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
PetroNotC Sharp
stavatar,

Теперь спрячьте свою портянку под спойлер и ответьте на остальные вопросы.
Почему 6 таблиц?


У меня уже нет кнопки отредактировать пост.

Ну,6 сущностей,потому что 3 из них сущности-связи.Где есть сопостовление индексов двух других сущностей.ВРоде так правильно проектировать архитектуру бд

1. Просим модератора.
2.
Значит не верные связи. Поэтому ошибка.
Доказывайте. Или рисунок сущностей сюда.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051787
Фотография asv79
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Код: java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
    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);
        }



у тебя в первой части кода каскадом записывается в бд new_comment

а во второй части ты этот же комент еще раз хочешь записать в таблицу .
когда ты добавляешь в коллекцию какой то элемент - при этом у тебя прописано cascasde=all ты уже записал по факту этот элемент
Код: java
1.
2.
3.
4.
5.
Comments parentComment=commentsRepository.findById(parent_id).get();
 new_comment.setOwnerpost(post);
            new_comment.setOwner(user);
parentComment.getChildComment().add(new_comment);
commentsRepository.save(parentComment);


вот так должно быть - попробуй
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051790
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
asv79,
У него в коде одно. В ТЗ словами другое, в модели 6 таблиц третье.
Частями не лечится.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051792
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
asv79,
То что имя сиквенс прописано в java коде а по факту это в DDL не удивило?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051793
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
asv79,
У него в коде одно. В ТЗ словами другое, в модели 6 таблиц третье.
Частями не лечится.


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


И об этом поподробнее.

Я делал и с sequence и c identity.Везде одна ошибка
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051795
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
asv79
Код: java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
    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);
        }



у тебя в первой части кода каскадом записывается в бд new_comment

а во второй части ты этот же комент еще раз хочешь записать в таблицу .
когда ты добавляешь в коллекцию какой то элемент - при этом у тебя прописано cascasde=all ты уже записал по факту этот элемент
Код: java
1.
2.
3.
4.
5.
Comments parentComment=commentsRepository.findById(parent_id).get();
 new_comment.setOwnerpost(post);
            new_comment.setOwner(user);
parentComment.getChildComment().add(new_comment);
commentsRepository.save(parentComment);


вот так должно быть - попробуй


Попробую
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051796
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
PetroNotC Sharp
asv79,
То что имя сиквенс прописано в java коде а по факту это в DDL не удивило?


И об этом поподробнее.

Я делал и с sequence и c identity.Везде одна ошибка

Дайте ссыль на пример с которого делали.
Или пруф.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051797
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
asv79
Код: java
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
    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);
        }



у тебя в первой части кода каскадом записывается в бд new_comment

а во второй части ты этот же комент еще раз хочешь записать в таблицу .
когда ты добавляешь в коллекцию какой то элемент - при этом у тебя прописано cascasde=all ты уже записал по факту этот элемент
Код: java
1.
2.
3.
4.
5.
Comments parentComment=commentsRepository.findById(parent_id).get();
 new_comment.setOwnerpost(post);
            new_comment.setOwner(user);
parentComment.getChildComment().add(new_comment);
commentsRepository.save(parentComment);


вот так должно быть - попробуй


так...Но суть в том,что ошибка появляется даже если нету parentComment,он не всегда существует.

То есть часто вот этот if не выполняется
Код: plsql
1.
2.
3.
4.
5.
6.
  if((parent_id!=null)&&(commentsRepository.existsById(parent_id)))
            {
                Comments parentComment=commentsRepository.findById(parent_id).get();
                parentComment.getChildComment().add(new_comment);
                commentsRepository.save(parentComment);
            }
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051798
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,
Делать демку 30 минут, а вы много говорите. Вторую страницу.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051807
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar,
Делать демку 30 минут, а вы много говорите. Вторую страницу.
/
Уже второй раз пытаюсь прислать .

Я убрал почти все лишние поля

Вот если добавить пост

select
Код: 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.
        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 10:31:28.556 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:31:28.557 DEBUG 16192 --- [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 10:31:28.558 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:31:28.560 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:31:28.561 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.563 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:31:28.563 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.567  INFO 16192 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter               : do filter...
2021-03-09 10:31:28.568  INFO 16192 --- [nio-8087-exec-2] c.e.L.config.jwt.JwtFilter               : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 10:31:28.571 DEBUG 16192 --- [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 10:31:28.571 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:31:28.572 DEBUG 16192 --- [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 10:31:28.573 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:31:28.574 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:31:28.574 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.577 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:31:28.577 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.603 DEBUG 16192 --- [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 10:31:28.604 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:31:28.606 DEBUG 16192 --- [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 10:31:28.606 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:31:28.608 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:31:28.608 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.611 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:31:28.612 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.638 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    select
        nextval ('posts_id_seq')
Hibernate: 
    select
        nextval ('posts_id_seq')
2021-03-09 10:31:28.666 DEBUG 16192 --- [nio-8087-exec-2] org.hibernate.SQL                        : 
    insert 
    into
        posts
        (title, id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        posts
        (title, id) 
    values
        (?, ?)
2021-03-09 10:31:28.667 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [TITLEE1]
2021-03-09 10:31:28.667 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [2]
2021-03-09 10:31:28.668 DEBUG 16192 --- [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
        (?, ?)
2021-03-09 10:31:28.668 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:31:28.668 TRACE 16192 --- [nio-8087-exec-2] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [2]




Если добавить Второй Пост

Код: 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.
2021-03-09 10:33:12.209 DEBUG 16192 --- [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 10:33:12.210 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:33:12.211 DEBUG 16192 --- [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 10:33:12.212 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.213 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:33:12.214 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.216 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:33:12.216 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.219 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:33:12.220 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.224  INFO 16192 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter               : do filter...
2021-03-09 10:33:12.225  INFO 16192 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter               : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 10:33:12.227  INFO 16192 --- [nio-8087-exec-4] c.e.L.config.jwt.JwtFilter               : !!test
2021-03-09 10:33:12.228 DEBUG 16192 --- [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 10:33:12.229 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:33:12.230 DEBUG 16192 --- [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 10:33:12.230 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.231 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:33:12.231 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.233 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:33:12.234 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.237 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:33:12.238 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.243 DEBUG 16192 --- [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 10:33:12.243 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:33:12.244 DEBUG 16192 --- [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 10:33:12.244 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.246 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:33:12.246 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.248 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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 10:33:12.248 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:33:12.250 DEBUG 16192 --- [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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:33:12.251 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.254 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    select
        nextval ('posts_id_seq')
Hibernate: 
    select
        nextval ('posts_id_seq')
2021-03-09 10:33:12.257 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    insert 
    into
        posts
        (title, id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        posts
        (title, id) 
    values
        (?, ?)
2021-03-09 10:33:12.258 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [TITLEE1]
2021-03-09 10:33:12.258 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [3]
2021-03-09 10:33:12.258 DEBUG 16192 --- [nio-8087-exec-4] org.hibernate.SQL                        : 
    insert 
    into
        users_posts
        (user_id, post_id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        users_posts
        (user_id, post_id) 
    values
        (?, ?)
2021-03-09 10:33:12.259 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:33:12.259 TRACE 16192 --- [nio-8087-exec-4] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [3]




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


Код: 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.
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 10:35:57.375 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:35:57.376 DEBUG 16192 --- [nio-8087-exec-7] 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 10:35:57.376 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:35:57.378 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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 10:35:57.378 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.383 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:35:57.383 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.390 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:35:57.390 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.391  INFO 16192 --- [nio-8087-exec-7] c.e.L.config.jwt.JwtFilter               : do filter...
2021-03-09 10:35:57.391  INFO 16192 --- [nio-8087-exec-7] c.e.L.config.jwt.JwtFilter               : eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJ0ZXN0In0.ldBwpa4O1pPhGiJQVCGSCrrFWcLaCr5mpn_-xTqEygjOrGldkecwOiAmoTG_2o9co82tPAlGsoUT8-A4Em_2dQ
2021-03-09 10:35:57.394  INFO 16192 --- [nio-8087-exec-7] c.e.L.config.jwt.JwtFilter               : !!test
2021-03-09 10:35:57.394 DEBUG 16192 --- [nio-8087-exec-7] 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 10:35:57.395 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:35:57.396 DEBUG 16192 --- [nio-8087-exec-7] 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 10:35:57.397 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:35:57.399 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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 10:35:57.399 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.403 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:35:57.404 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.410 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:35:57.410 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.422 ERROR 16192 --- [nio-8087-exec-7] c.e.L.controller.CommentsController      : Optional.empty
2021-03-09 10:35:57.423 DEBUG 16192 --- [nio-8087-exec-7] 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 10:35:57.423 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [test]
2021-03-09 10:35:57.425 DEBUG 16192 --- [nio-8087-exec-7] 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 10:35:57.425 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [2]
2021-03-09 10:35:57.426 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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 10:35:57.427 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.431 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:35:57.432 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.439 DEBUG 16192 --- [nio-8087-exec-7] 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_.title as title2_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_.title as title2_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_.title as title2_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_.title as title2_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 10:35:57.440 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [4]
2021-03-09 10:35:57.453 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL                        : 
    select
        nextval ('comments_id_seq')
Hibernate: 
    select
        nextval ('comments_id_seq')
2021-03-09 10:35:57.456 DEBUG 16192 --- [nio-8087-exec-7] org.hibernate.SQL                        : 
    insert 
    into
        comments
        (title, id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        comments
        (title, id) 
    values
        (?, ?)
2021-03-09 10:35:57.457 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [labore!!!!!!!!]
2021-03-09 10:35:57.457 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [2]
2021-03-09 10:35:57.458 DEBUG 16192 --- [nio-8087-exec-7] 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 10:35:57.459 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [3]
2021-03-09 10:35:57.459 TRACE 16192 --- [nio-8087-exec-7] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [BIGINT] - [2]
2021-03-09 10:35:57.484  WARN 16192 --- [nio-8087-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 23503
2021-03-09 10:35:57.484 ERROR 16192 --- [nio-8087-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper   : ОШИБКА: INSERT или UPDATE в таблице "posts_comments" нарушает ограничение внешнего ключа "posts_comments_comment_id_fkey"
  Подробности: Ключ (comment_id)=(3) отсутствует в таблице "comments".

...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051808
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,
Я не могу смотреть пока не пойму почему 6 таблиц. А ты мне шлёшь и шлёшь уже работу на 6ти таблицах.
Дошло?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051810
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar,
Я не могу смотреть пока не пойму почему 6 таблиц. А ты мне шлёшь и шлёшь уже работу на 6ти таблицах.
Дошло?


Ну,есть пользователи и есть посты.
Как мне иначе организовать кто каким постом владеет?Вот я и создаю отдельную таблицу связей ,где сопостоявлю пользователя с постами,которыми он владеет.то же самое с постом и комментарием и комментарием и пользователем
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051811
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
PetroNotC Sharp
stavatar,
Я не могу смотреть пока не пойму почему 6 таблиц. А ты мне шлёшь и шлёшь уже работу на 6ти таблицах.
Дошло?


Ну,есть пользователи и есть посты.
Как мне иначе организовать кто каким постом владеет?Вот я и создаю отдельную таблицу связей ,где сопостоявлю пользователя с постами,которыми он владеет.то же самое с постом и комментарием и комментарием и пользователем

Рисунок где?
Доп таблица ТОЛЬКО ПРИ связях много ко много.
Жду рисунок.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051815
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar
пропущено...


Ну,есть пользователи и есть посты.
Как мне иначе организовать кто каким постом владеет?Вот я и создаю отдельную таблицу связей ,где сопостоявлю пользователя с постами,которыми он владеет.то же самое с постом и комментарием и комментарием и пользователем

Рисунок где?
Доп таблица ТОЛЬКО ПРИ связях много ко много.
Жду рисунок.


Вот
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051819
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,
Теперь оставь три и соедини. Пробуй
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051836
Фотография crutchmaster
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,

Схема - избыточная хрень, отсюда все проблемы. Нужны только юзеры и посты. Пост может быть заглавным. В противном случае - это коммент, который привязан к заглавному. Еще поста есть юзер, title и всё остальное. Тут всё хорошо, пока у тебя нет дерева. Впрочем в твоей схеме с деревом тоже всё плохо.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051838
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
crutchmaster,
Я тоже все думал, что такое сущность Коммент))))
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051916
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
crutchmaster
stavatar,

Схема - избыточная хрень, отсюда все проблемы. Нужны только юзеры и посты. Пост может быть заглавным. В противном случае - это коммент, который привязан к заглавному. Еще поста есть юзер, title и всё остальное. Тут всё хорошо, пока у тебя нет дерева. Впрочем в твоей схеме с деревом тоже всё плохо.


Заглавный комментарий тоже существует.И я решил разделить похожие сущности Поста и комментария для расширяемости.Мало ли как необходимо будет в дальнейшем расширять функционал поста и комментария.Может у поста еще будут теги или еще что то уникальное,а у комментариев нет.

И да,проблема решилась и там проблема просто в том ,что я в этом месте неправильно сделал

Код: java
1.
2.
oinColumns = @JoinColumn(name= "post_id"),
            inverseJoinColumns =  @JoinColumn(name= "comment_id"))



Должно было быть
Код: java
1.
2.
3.
 @JoinTable(name = "posts_comments",
            joinColumns = @JoinColumn(name="comment_id"),
            inverseJoinColumns =  @JoinColumn(name= "post_id"))
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051921
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,
Что значит проблема решилась?
- в сети полно примеров на трех таблицах а не на 6ти
- тип колонки постгри делают serial без сиквенсов
- JPA аннотация другая
-....
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051946
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar,
Что значит проблема решилась?
- в сети полно примеров на трех таблицах а не на 6ти
- тип колонки постгри делают serial без сиквенсов
- JPA аннотация другая
-....


Я про изначальную проблему,с которой я пришел на форум.

1)Примеров то полно,но вопрос как верно.Есть нормальная форма в БД.И ,Если я не ошибаюсь,то по 2ой или 3ей форме нужно делать доп таблицы.

2)Он у меня и serial.Просто serial,если смотреть по документации,превращается именно в эту конструкцию

3)Про какую аннотацию вы говорите?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051961
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar,
Как можно решить как верно если ты не привёл НИ ОДНОГО ВАРИАНТА для обсуждения?
Это верно внизу?
https://miro.medium.com/max/1320/1*fcJgAoUrQdh_pf2p2zlpzQ.png
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051967
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051972
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
PetroNotC Sharp
stavatar,
Как можно решить как верно если ты не привёл НИ ОДНОГО ВАРИАНТА для обсуждения?
Это верно внизу?
https://miro.medium.com/max/1320/1*fcJgAoUrQdh_pf2p2zlpzQ.png


Ну ,так решить можно.
Но что насчет нормальных форм?
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40051976
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
PetroNotC Sharp
stavatar,
Как можно решить как верно если ты не привёл НИ ОДНОГО ВАРИАНТА для обсуждения?
Это верно внизу?
https://miro.medium.com/max/1320/1*fcJgAoUrQdh_pf2p2zlpzQ.png


Ну ,так решить можно.
Но что насчет нормальных форм?
удовлетворяет. Подробнее в ветку Проектирование субд
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40052057
Фотография mayton
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Реляционные БД плохо подходят для форумов и блогов. Как-бы мы сильно не оптимизировали такую БД - впоследствии
оптимизация сводится к полной (почти) денормализации страниц. Пост + приаттаченные каменты заменяются на 1
документ наподобие текстового файла с разметкой и этот документ и будет использоваться в механике response.

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

Ты пытаешься натянуть оопоту из орм на рбд. Не надо так делать. Не знаю, кто тебе такого насоветовал, но он насоветовал херни.
stavatar
И я решил разделить похожие сущности Поста и комментария для расширяемости.

Это в оопэ расширяемость. В контексте рбд это - избыточность. Теги делаются тупо отдельной таблицей с id поста (какого надо), id тега. И там уже не важно, заглавный коммент или нет. Не нужны теги к комментам, не выбирай и не пиши их туда.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40052135
Фотография crutchmaster
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
И да,проблема решилась

Нельзя покласть на нормализацию и не поиметь в итоге проблем на ровном месте. БД так не работают
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40052136
Фотография crutchmaster
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
mayton
Реляционные БД плохо подходят для форумов и блогов.

И да и нет. Поиск - это всё равно какой-нибудь elastic, который не рбд. Выбирать по 10, 20, 50 постов с оффсетом - это специфичное садомазо для рбд. Комментарии в виде дерева - вообще отдельный изврат, особенно, когда захочешь это дерево тащить частями. С другой стороны, легко делается трекер с последними сообщениями, ищутся комментарии и треды пользователя, уведомления, подписки. Можно, конечно, и без рбд, но всё равно, какой-то индекс надо сбоку иметь.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40052197
Фотография mayton
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
crutchmaster
mayton
Реляционные БД плохо подходят для форумов и блогов.

И да и нет. Поиск - это всё равно какой-нибудь elastic, который не рбд. Выбирать по 10, 20, 50 постов с оффсетом - это специфичное садомазо для рбд. Комментарии в виде дерева - вообще отдельный изврат, особенно, когда захочешь это дерево тащить частями. С другой стороны, легко делается трекер с последними сообщениями, ищутся комментарии и треды пользователя, уведомления, подписки. Можно, конечно, и без рбд, но всё равно, какой-то индекс надо сбоку иметь.

Да. Совершенно верно. И если пойди по бизнес-кейсам. Или по вариантам использования блога или форума - то
реляционных операций там на самом деле мало. Больше таких как : создать пост. Добавить камент. Найти текст
в блоге. И удалить или отмодерировать посты. Само по себе удаление производится редко. Вангую что 99.9% операций
это - чтение и извлечение контента всей страницы с постами. Вот на нее и надо ориентировать движок.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40052443
stavatar
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
crutchmaster,я убрал все доп таблицы.

Но проблема никак не была связан с этим
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40052459
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
stavatar
crutchmaster,я убрал все доп таблицы.

Но проблема никак не была связан с этим
а кто сказал что проблема у тебя одна и только в этом?
Ты не поверил, пошел к соседям. Там тебе мозги в правили чтобы слушал старших.
Ты потерял 4 дня.
Теперь опять сюда DDL.
Мы так и не знаем какую модель данных обсуждаем.
...
Рейтинг: 0 / 0
Почему не работает SequenceGenerator в Spring Boot?
    #40052461
PetroNotC Sharp
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
...
Рейтинг: 0 / 0
60 сообщений из 60, показаны все 3 страниц
Форумы / Java [игнор отключен] [закрыт для гостей] / Почему не работает SequenceGenerator в Spring Boot?
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


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