1

We're using testcontainers in integration test with DB. To setup initial state of DB we use container method withInitScript(*pathToScript*). Under the hood it uses org.postgresql.jdbc.PgStatement class to execute query. But an executing fails if sqlQuery contains function/procedure with $$ delimiter. The solution is to replace $$ with ', but it takes long time to control sql sqript and keep in mind necessity of replacing delimiter.

There is related question, but no solution: Exception in JPA when using seed file for PostgreSQL

Is it possible to point a type of delimiter or something like that?

Improve this question
1
Related questions
7
Put $$ in dollar-quoted string in PostgreSQL
7
Postgresql escape dollar sign
6
Unterminated dollar-quoted string at or near "$$
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.