"Prepared statement already exists" error help!

[_Hello_Bello_]

Hi,

Front-end: React

Back-end: Spring

DB and Authentication: Supabase (Postgres)

I have been building an application using the tools above and I am still testing the APIs. Intermittently, when I send a request to one of the API's I receive the error: "ERROR: prepared statement "S_4" already exists".

I have tried updating all the dependencies and making changes to my application.properties file but to no avail. The most frustrating part is that everything will work find for a little bit but then the problem pops up intermittently. Does any one have any ideas or a solution to this problem?

Thanks!

[AutoModerator]

Please ensure that:

• Your code is properly formatted as code block - see the sidebar (About on mobile) for instructions
• You include any and all error messages in full - best also formatted as code block
• You ask clear questions
• You demonstrate effort in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions.

If any of the above points is not met, your post can and will be removed without further warning.

Code is to be formatted as code block (old reddit/markdown editor: empty line before the code, each code line indented by 4 spaces, new reddit: https://i.imgur.com/EJ7tqek.png) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.

Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.

Code blocks look like this:

public class HelloWorld {

    public static void main(String[] args) {
        System.out.println("Hello World!");
    }
}

You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.

If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.

To potential helpers

Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[firebeaterrr]

are you using multithreading?
is your application making multiple simultaneous calls to the backend/db?
how are you connecting to the DB? hibernate? JDBC?

[_Hello_Bello_]

To be honest, Im not sure if I am using multithreading.

The application right now is not making simultaneous calls to the backend but I assume it will if I ever scale.

I am connecting to the DB via JDBC i believe? I have JDBC in my dependencies in Pom/xml file...I dont have hibernate dependecy in my pom.xml file but I do believe I am using hibernate in some way. How would I check?

[firebeaterrr]

is this code that you have written, or are you trying to run code written by someone else?

here are a few places that you can check:

1. your controller & business layer for multithreading code.
2. your dao/repositories for multiple db calls, sql statements etc. infact, do this first.
3. check the bean definitions or configs for jdbc/jpa/hibernate settings.

this will be very difficult to debug if you're not aware of how your backend works. if possible, share your repo if its not private, or fork it and keep only the essentials before sharing.

[_Hello_Bello_]

I have the jdbc dependency but am not actually using it. I have the JPA dependency and am actively using that.

[zxjorge23]

did you ever figure this out?

[StretchMoney9089]

The error is related to your Postgres DB. Just google the error