New answers tagged java
0
Parameter placeholders in JDBC are defined using ? not $1 - but you don't need any parameter placeholders for the UPDATE part to begin with, because you can reference the values using the excluded keyword.
String query=
"INSERT INTO " + this.table+ " VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) "
+ "ON CONFLICT (uid) DO UPDATE SET "
+ "(id, rt, rid, ls, chn, ...
-1
I have working code with
Statement stmt = conn.createStatement();
stmt.execute("set search_path to '" + schema + "'");
1
"openJDK" is not listed within the Supported Configuration documents.
https://www.oracle.com/middleware/technologies/fusion-certification.html
Use Oracle JDK.
-1
It looks like your lock function or key needs to take into account who set and who can release the lock (i.e. an owner). Perhaps by using a randomly generated ID. With a specific lock owner each thread has to verify that they are the owner when they set a lock and when they release a lock.
Top 50 recent answers are included
