[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] SQL server with (nolock)
|
A native SQL query would be you best solution.
If you set the pessimistic lock query hint, EclipseLink will use "WITH
(UPDLOCK)", if that is sufficient.
Leen Toelen wrote:
>
> Hi,
>
> I am performing a query on a large table (80GB), which is occasionaly
> terminated by the server with a query timeout. The errot is always caused
> by
> another query running at the same time. The solution is to use 'with
> (nolock)' in the query, since I don't need locking in this situation. I
> tried to enable this using eclipselink using query hints, but never saw
> the
> 'with (nolock)' appear in the queries. Does anybody know how to use 'with
> (nolock)' in SQL server (using jTDS) and eclipselink.
>
> Regards,
> Leen
>
-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
http://www.eclipse.org/eclipselink/
EclipseLink , http://www.oracle.com/technology/products/ias/toplink/
TopLink
Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink ,
http://wiki.oracle.com/page/TopLink TopLink
Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
http://www.nabble.com/EclipseLink-f26430.html EclipseLink
Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
--
View this message in context: http://www.nabble.com/SQL-server-with-%28nolock%29-tp26073950p26077982.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.