Question : I have a DB2 database with a table for daily transactions, which is cleared to a history table […]
Tag: jdbc
Oracle 11g delete by unique key slow
Question : We have been plagued by a deadlock issue for quite some time that relates to deletes and inserts […]
LoadBalancing JDBC DataSource Connect without URL
Question : When using JDBC I like the new DataSource-way to establish the connection. Further I like the isolated set-Methods […]
jdbc+mysql: “Deadlock found when trying to get lock; try restarting transaction”
Question : After recovering from a disk-full problem, I started getting these errors in my logs: java.sql.BatchUpdateException: Deadlock found when […]
Replacing a large object in PostgreSQL
Question : What should one do when one wishes to replace a large object with a new large object. An […]
Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?
Question : I’ve and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA […]
java.sql.SQLException: Login failed for user ‘sa’
Question : I am having trouble connecting to my Microsoft SQL Server database through a jTDS connection: Connection conn = […]
Does Postgresql support different transaction isolation per connection?
Question : I just discovered that H2 doesn’t support concurrent connections using different transaction isolation levels. Meaning, changing the transaction […]
jdbc+mysql: “Deadlock found when trying to get lock; try restarting transaction”
Question : After recovering from a disk-full problem, I started getting these errors in my logs: java.sql.BatchUpdateException: Deadlock found when […]
how to solve Invalid usage of the option NEXT in the FETCH statement [duplicate]
Question : This question already has answers here: SQL Server Error, “Invalid usage of the option FIRST in the FETCH […]