Horrible Servoy problem...

I have a solution which uses Sybase for an internal stock and contact managment system. There is a relationship to some Mysql tables on the same server to run a website. The server is a G5 iMac running 10.4.3, servoy is 2.2.3 and the latest Java 1.5.

I use my powerbook to develop this solution and periodically export to file and import a solution on the server. Has been working fine.

Recently, tried to open the solution on my machine to do some work on it. Servoy crashed when I loaded the form which has the related Mysql table data on it (it just hung and had to be force quit) Every subsequent try to get servoy to run resulted in a crash when that form was loaded (I eventually unplugged the network cable which errored about relationships and still allowed it to work but only for a short while).

As I was on site at the time and this was wasting time, I made the changes that I needed to the solution using Servoy Developer ON the server - this worked fine. I then exported the solution from the servoy server and copied it to my Powerbook with a view to deleting and reimporting it on my machine to get the latest developed version. I think though that this is going to cause a branching problem and am unsure if it is the right way to go about this. If I reimport the solution onto my laptop, will I then be able to continue to develop it on the powerbook and export later versions back to the Servoy server? If not, how do I get around this problem? copy the .db files from the server to my machine? (my own machine has many solutions on it so I can’t copy the repository to me). Will it cause a branching problem if I import back to me and then later export from my powerbook and import back to the server??

Any ideas would be helpful

Thanks

Bevil

Questions:
-did you wait for a long time to see if it returned with an error? (wait like 10 minutes)
-are you using transaction in the database? (transaction can stall other clients/developer)
-are you sure the database it tries to use on the form is running? (can you access it via other tools?)

Hi Jan

I have not waited 10 minutes or more to see if there is some error, I am trying it as I write this :)

No transactions in the database.

The database is running and I am able to access the database (and data) with the same username / password in CocoaMySQL with no trouble. In fact Servoy its-self does not complain if I put the correct ip, username / password into preferences for the MySQL server, it is only when I access a form (in designer or browse mode) that it hangs. And it hangs properly..

If I am able to solve the MySQL access problem from my machine, that is great. More worrying though is that I made changes in Servoy developer ON the server. am I going to be able to avoid branching problems with reimporting to my powerbook, making changes there and then exporting back to the server??

Thanks for any help

Bevil

Ps, I’ll report back on the waiting 10 minutes thing, it has been about 8 or 9 minutes now and it is still properly hung…

Hi Jan

I have now waited over 40 minutes and still nothing… It has properly crashed. No menu or button or keyboard command will work in Servoy in this state. It also doesn’t seem to be logging anything whilst like this.

Could you send us the .log.txt when it hangs?