Does automatic data update work with batch changes?

Questions, answers, tips and ideas on Servoy Client

Re: Does automatic data update work with batch changes?

Postby martinh » Mon Jul 13, 2009 6:30 pm

It looks like you are right Adrian.

I checked my situation and I also see INSERTS but not the UPDATES
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: Does automatic data update work with batch changes?

Postby ROCLASI » Tue Jul 14, 2009 12:30 pm

Hi martin,

Sorry for the late reply.
martinh wrote:
ROCLASI wrote:Robert,

Do you mean with that?

Databaseservername A connects to jdbc:jtds:sqlserver://SERVOY/example_data
Databaseservername B connects also to jdbc:jtds:sqlserver://SERVOY/example_data

In that case, this is not the case, because Servoy doesn't allow me (never had)

That's what I meant yes. This was still allowed in pre 3.5 versions (or was it pre 3.1).

martinh wrote:It looks like you are right Adrian.

I checked my situation and I also see INSERTS but not the UPDATES


Martin/Adrian,
Do you see the same issue between rich clients and web clients as well?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Does automatic data update work with batch changes?

Postby martinh » Thu Jul 16, 2009 7:46 pm

ROCLASI wrote:
Martin/Adrian,
Do you see the same issue between rich clients and web clients as well?


Hi Robert,

The same issue between web and smart clients. I made a test.

Changing an existing record and adding a new record in smart client
I see the new record in webclient, but not changes of the existing one.

When I restart the webclient, I see the changed value too.
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: Does automatic data update work with batch changes?

Postby ROCLASI » Thu Jul 16, 2009 8:55 pm

Hi Martin,

Since you made a test can you also test between rich-client/rich-client and web-client/web-client?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Does automatic data update work with batch changes?

Postby martinh » Fri Jul 17, 2009 9:58 am

Hi Robert,

Rich/Rich client same issue!

I started smart client on 2 different computers

I changed some description and I added a related record

When reselect the changed record, I don't see the change I made in description, but I do see the added record
Also when I delete a child record and I reselect the parent, the child record is not shown anymore

I made also test to delete the parent record

When the parent is delete on computer A I can still walk through the foundset on computer B and I see a record that has already been deleted
I can even still change that record!

On computer B I have 7 records and on computer A I still have 8 records

I can even add a new child record on the deleted record on computer A without errors :?:
And in my database I still see 7 parent records.


BUT .... :!: :!: :!:

I see in my database that a child record was added.
So now I have a child record without a parent in my database

So this looks to be a very serious problem!
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: Does automatic data update work with batch changes?

Postby pbakker » Fri Jul 17, 2009 10:49 am

Please file a case in our support system with a sample solution in which this can be reproduced + description how to reproduce it.

Paul
pbakker
 
Posts: 2822
Joined: Wed Oct 01, 2003 8:12 pm
Location: Amsterdam, the Netherlands

Re: Does automatic data update work with batch changes?

Postby ROCLASI » Fri Jul 17, 2009 2:57 pm

martinh wrote:Rich/Rich client same issue!

[snip]

So this looks to be a very serious problem!


That really sounds like one :| .

martinh wrote:I see in my database that a child record was added.
So now I have a child record without a parent in my database


That would have never happened when you would have put the referential integrity checks (foreign key constraints) not (only) in the application layer but in the database layer where it belongs. But that is another discussion altogether.


But please do what Paul is asking and file this test in the support system.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Does automatic data update work with batch changes?

Postby kazar » Sat Jul 18, 2009 7:23 pm

and please do post more info as you uncover it here, this is an important thread some of us are following, thanks!!

kazar
User avatar
kazar
 
Posts: 367
Joined: Sat Sep 13, 2003 9:59 pm
Location: New York City

Re: Does automatic data update work with batch changes?

Postby amcgilly » Sat Jul 18, 2009 11:17 pm

I submitted a case 223009 with a sample solution reproducing aspects of this problem on 6/30. The sample solution showed a foundset based on global relation failing to be updated correctly when a record was modified. This was all local in the same SC/WC, no batch process involved. The status of the case is still 'new' so I don't think it's been looked at yet. I've emailed Jan Blok and Paul Bakker asking that it be looked at soon. Thanks.
Adrian McGilly
Servoy Developer

Image
amcgilly
 
Posts: 375
Joined: Fri Dec 09, 2005 12:03 am
Location: San Francisco, CA

Re: Does automatic data update work with batch changes?

Postby amcgilly » Thu Jul 30, 2009 2:14 am

Update - I have just uploaded to case 22452 a sample solution which reproduces the problem exactly. It shows the server failing to broadcast updates a client-based foundset that is based on a global relation as records are modified by a batch process. Hopefully this will help Servoy resolve the problem.
Adrian McGilly
Servoy Developer

Image
amcgilly
 
Posts: 375
Joined: Fri Dec 09, 2005 12:03 am
Location: San Francisco, CA

Re: Does automatic data update work with batch changes?

Postby amcgilly » Tue Aug 18, 2009 4:21 pm

Just received word from Servoy Support that this issue is fixed in release 5, beta 2. Here is an excerpt from the bug resolution report:

We have added support now for related foundsets to update when records are updated by another client.
This was working already, but only in the case that the client had loaded the record, since the new version it also works if the client has not loaded the record.


I'm not sure I'll have a chance to test this fix in the beta release anytime soon but perhaps someone else following this thread can test it and let us know their results.

Thank you Servoy Support for addressing this problem.
Adrian McGilly
Servoy Developer

Image
amcgilly
 
Posts: 375
Joined: Fri Dec 09, 2005 12:03 am
Location: San Francisco, CA

Previous

Return to Servoy Client

Who is online

Users browsing this forum: No registered users and 8 guests