isolation-level
Database JDBC using multicore vs isolation level overhead
Hallo, I want to get data into a database on a multicore system with ative WAL using JDBC. I was thinking about spawning multiple threads in my application to insert data parallely.[详细]
2023-03-13 07:58 分类:问答set isolation level for postgresql stored procedures
Hopefully a simple question, but one for which I haven\'t readily found a decent answer. I\'m reliably informed that stored procedures (user-defined DB functions) in PostgreSQL (specifically, version[详细]
2023-03-11 08:49 分类:问答ERROR: duplicate key value violates unique constraint "xak1fact_dim_relationship"
I am getting the below error while deleting some rows and updating the table based on a condition from java. My database is PostgreSQL 8.4. Below is the error:[详细]
2023-03-09 02:33 分类:问答Isolation level not working in vb.net connecting to a SQL 2008 DB
I have a VB.net CF app connecting to a SQL 2008 server. I\'m trying to implement transactions but when i break my code at the start of a transaction certain read queries cannot be done on the table.[详细]
2023-03-02 05:09 分类:问答Practical uses of Seralization Isolation level?
Under what scenarios we use SERIALIZABLE Isolation level? I have seen some answers on website that says, when you want transaction to be completely isolated, we usually go for this.[详细]
2023-02-27 15:17 分类:问答How do you change the SQL isolation level from Python using MySQLdb?
The documentation I\'ve run across researching this indic开发者_开发问答ates that the way to do it for other databases is to use multiple statements in your query, a la:[详细]
2023-02-25 06:48 分类:问答How to produce "phantom read" in REPEATABLE READ? (MySQL)
Using "repeatable read", it should be possible to produce a 开发者_StackOverflowphantom read, but how? I need it for an example teaching CS-students.[详细]
2023-02-20 04:29 分类:问答View isolation level for a query in mysql
How do I determine the isolation level in use for a given query? After a query is executed (by a 3rd party application) I\'d like to know which isolation level was used (e.g., read uncommitted).[详细]
2023-02-17 18:58 分类:问答setting isolation level in spring annotation-based transactions
I use in my project annotation-based transaction management (I annotate some methods with @Transactional). I would like t开发者_运维问答o set the isolation level globally (not by putting it as an argu[详细]
2023-02-15 02:18 分类:问答Concurrency strategy configuration for JBoss TreeCache as 2nd level Hibernate cache
I am using JBoss EAP 4.3. I\'m currently looking into the different options for concurrency strategy when using the built-in JBoss TreeCache as a second level cache for Hibernate. I have set it up a[详细]
2023-02-10 05:49 分类:问答