[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[List Home]
|
[eclipselink-users] SQL server with (nolock)
|
- From: Leen Toelen <toelen@xxxxxxxxx>
- Date: Tue, 27 Oct 2009 09:36:04 +0100
- Delivered-to: eclipselink-users@eclipse.org
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=6mOGWpH9OhyRSDmwsiQ5l1mLCrHh/NpdJolZ2GdWQss=; b=moCIa3hqwbxv8IZ1/rTauaI2MShgzgz2hnn8rHndlUXhYhcSGiKvD/8lEQ9v/ni7et aNy5cz6p9ZIh6Er4b4EB1Qa6j1YqbjNh18vSnbPipmhCxPMi9XMd+BuNCzxhhJDKtrki wcbSxLYXNHp547umwYU2phtwKVQoJBSKMtKkw=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=L/n/IaH9Vin8tzvrlHTq19FEz+OhrV5a1Ea4ZbVgkVtH17F+qrI+AMqKf2wMVT8+ho AbadmuEe/ldHD37txpsskO0vcCIO1NelAlOl3smgP8ycaDV9H0TYgFSH5XJOpt+2U4yK Nt/zcjcc2C9EUdjsMWK6I5e1OitWC6hksz5Z4=
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