Hello,
My current application is working fine when I use MySql. When I switch
database to Sql Anywhere (Sybase), I see the following behaviour.
1)Within my transaction, I have an INSERT INTO TABLE A, followed by
SELECT COUNT(*) FROM Table A.
When I run this thru Castor the SELECT COUNT(*) HANGS Blocking on the
INSERT query. Initially I was surprised why this happened in the same
transaction. I would have expected 2 transactions to conflict but not 2
queries within same transaction..
Anyways I found that for SELECT COUNT(*) Castor opens a NEW DATABASE
connection and this gets into a conflict with the INSERT operation on
first connection..INSERT holds exclusive lock and select count(*) wants
to put shared lock (in ISOLATION LEVEL 1, which I think is reasonable)
WHY DOES CASTOR NEED A NEW CONNECTION? Any solutions, please?
2) Castor converted DbLocked Queries into SELECT...FOR UPDATE but SQL
Anywhere ignores SELECT..FOR UPDATE. Is support for SELECT..FOR UPDATE
essential for DbLocked mode to work?
3) Actually If I use REPEATABLE_READ Isolation mode, SQL Anywhere locks
the rows with Shared Lock when I do a select. So that might help, I will
let you know. In the meanwhile is to possible to set ISOLATION LEVEL in
CASTOR or will it pick up the default database setting..Somehow I tried
setting default in DB but Castor was not picking it up?
According to the Castor Web Site, Ianywhere is supported. Is that just
for Enterprise version or is SQL Anywhere also supported?
I will address rest of my qyestions in next mail.
Thanks for Any information,
Sandy.
**************************Disclaimer************************************
Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.
***************************************************************************
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
