I’m trying to figure out if there is a way to configure Spring datasource using a single string that contains all credentials: By far I see that spring.datasource always requires username and password properties to be defined separately and url property to start with jdbc:. Is there some other way to co…
Tag: postgresql
org.jooq.exception.DataAccessException: unsupported Unicode escape sequence u0000
I’m trying to insert a serialized JSON into a Postgres JSONB column using jOOQ, but it’s failing because the serialized JSON has a \0 inside of it. Is there a way jOOQ will escape this automatically for us? This is the exception I’m getting: Answer Given the details provided in your bug repo…
Is there a way to prevent Postgres triggers from triggering before Java/EclipseLink transaction commits
I have a Java application that connects to a Postgres DB using EclipseLink. My problem is that database triggers are triggered before the Java/EclipseLink transaction is completed causing the data to be incorrect. Example: There is a trigger to update a order_logs table every time there is an insert or update…
Spring boot – org.postgresql.util.PSQLException: FATAL: password authentication failed for user “postgres” [closed]
Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed 8 m…
How to generate .dot file using Schemacrawler
Using schemcrawler I’ve generated html file But I want to have an output in .dot file that contains diagram, node, graph, edge etc.. So how can I do it using my code or maybe some another way to do it with Java? Answer Simply change the output format from TextOutputFormat.html to DiagramOutputFormat.scd…
Parametrized query request postgresql
I want to get data from my DB where is LocalDateTime equals to LocalDateTime in get request. Timeslot table code: Controller code: But when I did this request result in console is: org.postgresql.util.PSQLException: ERROR: syntax error at end of input. How do i change sql request code to fix this error? Shoul…
Can’t automatically obtain ID for a record in database
My entity is: Method to write a record to the database. I just want to send it to the database and automatically obtain an ID for every record in this table, but every time when I do this – “status”: 500, “error”: “Internal Server Error”. And nothing changing in table…
ValidationFailedException after Liquibase update to 4.9.1
We were using older Liquibase that we now wanted to update to 4.9.1 due to vulnerabilities in older versions. However, now at least one of our old migrations fails with ValidationFailedException: The constraintName is missing from <addPrimaryKey>. However, it worked just fine with the older versions. Ho…
Result set is empty but query works in Postgres
I’m trying to get some results from Postgres into my Java application. As of now, I always used PreparedStatements with ResultSets to get data from my database in memory. But today my code refuses to work, although I use the same code as usual. Here is my piece of code: Here is the log: The ArrayList ex…
Why in Postgres, with an empty table, if I use BEFORE INSERT, the :NEW: variable is NULL?
I’m developing a Cinema Database in PostgreSQL. I have a Trigger which, before I insert a new show, checks if the date of the show is prior the movie’s release date (for example, adding today a show of Avatar 2). Here’s the code: Thing is, if the SHOWS table is empty, var1 is NULL. Already c…