O7 and GO-Global
Jim Creak
jim at jacsoft.co.nz
Tue Jun 23 00:54:28 EDT 2015
The places it hangs seems to be more when we are opening a window, I'm not sure if there are any edits/inserts happening at the time, but I can check, I do mix up some SQL UPDATES with DML edits, the DML edits either do a wait for semaphores or they don't wait for semaphores, but check and don't enter edit mode unless the request to edit the data returns true.
I'll do some tracing to see if there are any missed edits, they should all be going through the same routine that works with semaphores.
Thanks
Jim
JACSoft Programming Ltd.
On 23/06/2015, at 9:16 AM, Mike Matthews wrote:
> I think the ODB doesn't mind multiple IP addresses connecting, I suspect it uses a socket per connection. So why the padlock?
>
> Is at a point of about to use the Prepare to Insert/Edit command possibly? I thought that was the only time a padlock came up.
>
> Do you check for Semaphore Lock prior to any Prepare to Insert/Edit command?
>
> Mike
>
>
> Mike Matthews,
> Managing Director, SQLWorks Software Ltd
>
> On 22 Jun 2015, at 21:42, Jim Creak <jim at jacsoft.co.nz> wrote:
>
>> It all seems to be sitting on the same box, it's a DML datafile using ODB to link to it.
>>
>> Thanks
>> Jim
>>
>> JACSoft Programming Ltd.
>>
>> On 22/06/2015, at 7:21 PM, Mike Matthews wrote:
>>
>>> Hello Jim,
>>>
>>> Where is the datafile, the same server?
>>> Are you using ODB for the connection to the datafile?
>>>
>>> Mike
>>>
>>>
>>> Mike Matthews,
>>> Managing Director, SQLWorks Software Ltd
>>>
>>> On 22 Jun 2015, at 02:53, Jim Creak <jim at jacsoft.co.nz> wrote:
>>>
>>>> Hi,
>>>>
>>>> One of our sites are having issues with our program padlocking while running, and when we put the trace on it, it no longer padlocks, so we are not able to pinpoint where the padlock is happening, but on unique thing about this site is that is has been set up on terminal server called GO-Global, each client has their own Library and Omnis and everything seems to work as it should other then the padlock coming up through the day.
>>>>
>>>> I'm just wondering if anyone else has experienced Go-Global with Omnis classic and found any gotcha's that I should check out.
>>>>
>>>> Thanks
>>>> Jim
>>>>
>>>> JACSoft Programming Ltd.
>>>>
More information about the omnisdev-en
mailing list