Error JDBC Connection

[proven island]

⌛ This post has been reserved for your question.

Hey @grizzled spoke! Please use /close or the Close Post button above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

[somber violet]

How are you configuring/setting up the DB?

[grizzled spoke]

the ressources folder is in the test folder

[somber violet]

Is that the IP of another device in your network?

[grizzled spoke]

Yes i'm using external server for databse

[somber violet]

Which resources folder?

[somber violet]

And this is a test database?

[grizzled spoke]

yes

[somber violet]

What's the exact error?

[grizzled spoke]

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection

[somber violet]

Can you show the complete stack trace?

[grizzled spoke]

this ?

[somber violet]

yes

[grizzled spoke]

I retried again, with and without ```@DirtiesContext(classMode = DirtiesContext.ClassMode.BEFORE_EACH_TEST_METHOD)

With  : ❌ 
Without : ![check](https://cdn.discordapp.com/emojis/759740404941455440.webp?size=128 "check")

[somber violet]

Can you try AFTER_EACH_TEST_METHOD?

maybe it's related to https://commerce-engineer.rakuten.careers/entry/en/tech/0054

[grizzled spoke]

New error about duplicate key

Probably because the "clean" is not working

[somber violet]

Can you maybe create a minimal reproducer for your original issue?

[grizzled spoke]

what do you mean ?

I can make a git repo for you, also the werid thing it that I followed a tutorial and in the video, no such problem

2:41:55 when he writes this

[somber violet]

essentially the smallest possible project so you still get the issue

i.e. you create a copy of the project and you remove stuff from that copy as long as you can reproduce the issue

[grizzled spoke]

ok want me to put it on github ?

[somber violet]

When you have a minimal reproducer, sure

and with minimal, I really mean minimal

[grizzled spoke]

It's realy minimal

[somber violet]

then yeah I might be able to try and reproduce it

[grizzled spoke]

change the username and password in ressources folders

do you want the SQL ?

[somber violet]

The DB password isn't important, right?

[grizzled spoke]

no no

[somber violet]

because you included it :)

[grizzled spoke]

Yeah no problem

Oh to run all test I write in the terminal: mvn clean verify

[somber violet]

It's not that simple but yeah

Can you try updating Spring Boot from 3.2.4 to 3.2.5 in the meantime?

[grizzled spoke]

Ok, I just change in the pom xml the version ?

[somber violet]

Why do you have H2 in your dependencies?

[somber violet]

yes

[grizzled spoke]

Well, I dont realy know, I followed the tuto but He used postgresql and I work with mysql so I just followed what he did but it's probable not necessary

[somber violet]

I mean, try removing it

[grizzled spoke]

ok I retry, thanks you btw for the time spending, rly kind 🙂

so I have the dupplicate key error again

[grizzled spoke]

It's looks like the AFTER doesn't works well

in my case

[somber violet]

oh I meant with your original thing

[grizzled spoke]

the first test pass but the second doesn't

[grizzled spoke]

Same thing

Thx for your time, it's okay I'll follow the turorial

[somber violet]

If you use AFTER_EACH_TEST_METHOD, you get an exception for duplicate keys, right?

I was able to reproduce your issue with fewer code

using the AFTER thing seems to work

and the duplicate key thing seems to be an issue with your code I think

actually let me check that

ok so I can explain the issue you got with the duplicate key

you are using an actual database

so everything you insert into the DB will actually be inserted

oh nvm they left