Why decrease the wait_timeout configuration parameter in MySQL?
Question I’m working on an application that uses a connection pool in Apache Tomcat to communicate with MySQL. I was wondering why would … Read more
jdbc
Proxy authentication for PostgeSQL
The following seems likely to be a fairly common situation, but I haven’t seen any solutions. I have a PostgreSQL database containing views … Read more
Replacing a large object in PostgreSQL
What should one do when one wishes to replace a large object with a new large object. An example would be to update … Read more
Retrieving data from inner join using LIMIT and OFFSET
These are my two tables: table1 qid[PK] |gid[PK] |abcd | xyz | date —————+———+———+——+———— 00001 | qwe | 54 | a | 1994-11-29 … Read more
Oracle 11g delete by unique key slow
We have been plagued by a deadlock issue for quite some time that relates to deletes and inserts on the same table. It … Read more
SET ROLE via parameterized query
In the very helpful response I received to a previous question, I am trying to write some JDBC code that first sets the … Read more
Access operator added by extension inside a schema
I am writing an application that uses postgres. Each microservice uses its own schema inside the database. So connect to the database schema … Read more
Keep H2 in-memory database between connections
I create and use a H2 database in-memory (no writing to storage) for demos and quick tests using this code in Java: Connection … Read more
Configuring sqlnet.ora and tnsnames.ora on the client side
I have an application server talking to an Oracle database, using the Oracle instant client. We are troubleshooting a specific bug, and it … Read more
Measure Performance for INSERT, UPDATE and DELETE commands on DB2
I have a DB2 database with a table for daily transactions, which is cleared to a history table at the end of the … Read more
