Postgres for production, H2 to test, rand() function. | Java Community | Help. Code. Learn. | Page 1

buoyant sequoia Jun 8, 2023, 2:17 PM

#

I was using h2 for the whole application, but now I want to change the production to postgress. However some of my queries have the rand() function. How can I change it to work in both, pg and h2?

surreal karmaBOT Jun 8, 2023, 2:17 PM

#

⌛ This post has been reserved for your question.

Hey @buoyant sequoia! Please use /close or the Close Post button above when you're finished. 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.

violet swift Jun 8, 2023, 2:37 PM

#

I think you need to use random() in postgres

buoyant sequoia Jun 8, 2023, 2:38 PM

#

yeah, but then i'll get an error in the h2 tests

violet swift Jun 8, 2023, 2:38 PM

#

use random() if you are in prod and rand() if you are in tests?

buoyant sequoia Jun 8, 2023, 2:38 PM

#

Can I do that?

violet swift Jun 8, 2023, 2:38 PM

#

or maybe there's a compatibility mode with H2

#

use an if statement

#

chexk if you are in tests?

buoyant sequoia Jun 8, 2023, 2:40 PM

#

I couldn't do that, because the query is an annotation:

@Query("SELECT um FROM User u " +
            "JOIN u.favoriteMovies um " + 
               "WHERE u.id = :userId AND um.id NOT IN :movieIds " +          "ORDER BY RAND() LIMIT 1")
    Optional<Movie> findRandomMovieByUserIdAndNotInMovieIds(@Param("userId") Long userId,
            @Param("movieIds") List<Long> movieId);

violet swift Jun 8, 2023, 2:43 PM

#

or maybe add ;MODE=PostgreSQL to the H2 JDBC URL

#

Are you using JPA?

buoyant sequoia Jun 8, 2023, 2:44 PM

#

Yes

#

Hm, I didn't know this option

#

Ok, how exactly can I use that?
spring.datasource.url=jdbc:h2:mem:testdb;MODE=PostgreSQL
This way?

violet swift Jun 8, 2023, 2:46 PM

#

Do you have a different hibernate diakect configured in test and production?

buoyant sequoia Jun 8, 2023, 2:47 PM

#

Yes, but I can change if it is necessary

surreal karmaBOT Jun 8, 2023, 2:49 PM

#

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

buoyant sequoia Jun 8, 2023, 2:52 PM

#

Ok, I think it worked, let me do some more tests

#Postgres for production, H2 to test, rand() function.