Help get this topic noticed by sharing it on Twitter, Facebook, or email.

sf_refresh locks table when called from JDBC

I am having a problem where sf_refresh locks my account table. i am using jdts + jdbc to make the call followed by a bunch of reads. it seems the whole table is locked until a rather large operation is complete. is there some way to ensure that the sf_refresh does not lock the table ? the DB has simple recovery model - and I have tried using an isolated jdbc connection to no avail. Please help.
1 person has
this problem
+1
Reply