3

I have a java thread that does the update of few tables in a transaction and there is another thread that reads the tables with read only transaction . The thread that reads the tables is waiting and not retuning the result and returns only after the other thread had done the update .

The case is different if DB is mysql where the update and query does happen parallel and no waiting . Am I missing something on MS SQL side . What needs to be done to make it parallel . Is this happening because of table locks in MS Sql Server .

The MS Sql server hibernate setting :

db.driverClassName = com.microsoft.sqlserver.jdbc.SQLServerDataSource

db.dialect = org.hibernate.dialect.SQLServer2008Dialect

Hibernate version : v4.3.6.Final

Connection pool : HikariCP-java6 - v2.2.5

tanmally
  • 996
  • 1
  • 9
  • 13

1 Answers1

1

in T-SQL you can use UNLOCK command, in this link you can see a full description of it. also you can use WITH (NOLOCK) while selecting from table like:

SELECT *
FROM sample_table WITH (NOLOCK)
WHERE --conditions

But in Hibernate with MS SQL Server I really don't know how to implement NOLOCK if you find a solution for it tell us I'll follow this question.

void
  • 7,760
  • 3
  • 25
  • 43
  • Thanks for the reply . I still haven't figured out the solution . I probably will use your solution by knocking of hibernate and using jdbc templates to do the update – tanmally Feb 09 '15 at 16:24
  • you are welcome, I hope you'll fix the issue soon. good luck. – void Feb 09 '15 at 18:57