Servoy 5.2.3

Servoy announcements

Re: Servoy 5.2.3

Postby jbader » Mon Nov 29, 2010 4:56 pm

Hi Johan,

The problem is that I don't really have time to create a sample solution. I can create a case if you like, but quite simply, security.login no longer directs to a solution's first form. Whatever code was changed form 5.2.2 to 5.2.3 in regards to security.login for solutions using a custom login form w/o enhanced security has broken first-form loading.

What is troublesome to me with this particular problem is that my solutions all implement the same generic login code, and different solutions need to redirect to different forms after login, but I do not believe there is an accessor for getting a solutions first form is there? So how do I redirect appropriately now? A big if-else chain checking the solution name?
jbader
 
Posts: 520
Joined: Sun Sep 18, 2005 4:24 am
Location: Miami, FL

Re: Servoy 5.2.3

Postby jbader » Mon Nov 29, 2010 5:01 pm

Rob,

You tried this with enhanced security disabled, using a custom login form? And it worked for you?

I have changed absolutely nothing in my code from 5.2.2 to 5.2.3 and security.login does not forward to first form any longer. Something definitely changed in the implementation.
jbader
 
Posts: 520
Joined: Sun Sep 18, 2005 4:24 am
Location: Miami, FL

Re: Servoy 5.2.3

Postby jbader » Mon Nov 29, 2010 6:45 pm

I can no longer commit any transactions in 5.2.3! I get the following exception:

Caused by: com.servoy.j2db.persistence.RepositoryException: dbName: Thread tried to acquire lock which it already owned, transaction id=7, thread=http-8080-5 ...

I see in the new 5.2.3 post:

[fix] 326332 servoy.record.lock.lockInDB = true does not work on sybase
[fix] 324734 CommitTransaction issue


Neither case is public (or if it is I can't access it by filtering the list).

We use MySQL 5.
jbader
 
Posts: 520
Joined: Sun Sep 18, 2005 4:24 am
Location: Miami, FL

Re: Servoy 5.2.3

Postby ROCLASI » Tue Nov 30, 2010 11:08 am

jbader wrote:I can no longer commit any transactions in 5.2.3! I get the following exception:

Caused by: com.servoy.j2db.persistence.RepositoryException: dbName: Thread tried to acquire lock which it already owned, transaction id=7, thread=http-8080-5

I see the same thing. Using an in-memory transaction (autosave==off). I use PostgreSQL 9.0.1 and Developer, so no other users involved.
It doesn't always happen. I will investigate a little further...
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: Servoy 5.2.3

Postby Hans Nieuwenhuis » Tue Nov 30, 2010 11:33 am

I did a few tests with Oracle 10gr2 and I do not see this issue.

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Servoy 5.2.3

Postby irennie » Tue Nov 30, 2010 11:41 am

I am getting the thread issue with transactions also. I am using SQL Server 2008 Express. No changes to code but just upgraded to Servoy 5.2.3 and started getting the issue.
On further investigation I have found that for me it happens when I start a transaction and then create a new record, then try to save the record. If I start a transaction and edit an existing record I don't get the error.
Also, it only happens on some tables in my solution. It seems to be tables that were added when my solution was using Servoy 4 have the problem. As my solution has been upgraded through Servoy versions to 5 and new tables added, these new tables work OK.
I exported my solution with data, created a blank database, re-pointed my db server to this blank db, imported my solution creating all the tables and data, and now it all works OK and I don't get the error.
For us though this is not a fix, as we have many customers who need to be upgraded without recreating their whole database.
Iain Rennie
Asset Guardian Solutions Limited
http://www.assetguardian.com
User avatar
irennie
 
Posts: 27
Joined: Fri Jun 11, 2010 3:24 pm
Location: Livingston, UK

Re: Servoy 5.2.3

Postby rossent » Tue Nov 30, 2010 11:48 am

Regarding the transaction commit issue: we are using SQL Server 2008 and PostgreSQL and so far have not experienced this issue. However, in our case the database schema is created and maintained outside of Servoy.
Rossen Totev
Argos Software
rossent
 
Posts: 288
Joined: Wed Dec 31, 2008 2:03 pm

Re: Servoy 5.2.3

Postby Hans Nieuwenhuis » Tue Nov 30, 2010 11:54 am

Same with us :

the database schema is created and maintained outside of Servoy.
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Servoy 5.2.3

Postby ROCLASI » Tue Nov 30, 2010 12:13 pm

I have here 3 tracelogs of 3 different tables I use an in-memory transaction on. The code to save the transactions is the same method.
2 of the logs show the error, 1 however does work.
Also my schema is created and maintained outside of Servoy (not that I think this should matter) and I use dbidenties, not servoy sequences.
You do not have the required permissions to view the files attached to this post.
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: Servoy 5.2.3

Postby rgansevles » Tue Nov 30, 2010 12:30 pm

Robert, Jeff,

This issue occurs when you insert a new record of a table that has db-managed or db-default columns.
And only when you save the new record(s) from within a transaction.

We are working on fixing this now.

Thanks,

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Servoy 5.2.3

Postby Hans Nieuwenhuis » Tue Nov 30, 2010 12:34 pm

will there be an intermediate release for this ??

I hope so, because we need the other fixes in 5.2.3 urgently !

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Servoy 5.2.3

Postby ROCLASI » Tue Nov 30, 2010 1:32 pm

rgansevles wrote:This issue occurs when you insert a new record of a table that has db-managed or db-default columns.
And only when you save the new record(s) from within a transaction.

My save-record code does indeed use a db transaction. (see http://www.servoycamp.com/topics/tutori ... tions.html)
Or are you talking about in-memory transactions ?
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: Servoy 5.2.3

Postby rgansevles » Tue Nov 30, 2010 2:09 pm

Robert,

It happens with transactions started with databaseManager.startTransaction() and only wit inserts for tables with columns that are db-managed or have db-default values.

Rob
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Servoy 5.2.3

Postby Hans Nieuwenhuis » Tue Nov 30, 2010 4:18 pm

Rob,

What do you mean by db-managed ?

Regards,
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Servoy 5.2.3

Postby ROCLASI » Tue Nov 30, 2010 4:21 pm

I assume it means database sequences via default value functions (like with PostgreSQL) or via triggers (like with Oracle).
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

PreviousNext

Return to Announcements

Who is online

Users browsing this forum: No registered users and 16 guests