Page 1 of 1

Database connections PER workspace

PostPosted: Fri Mar 05, 2010 11:11 pm
by ROCLASI
It would be very welcome if we could have specific database connections enabled PER workspace. Or even better having a servoy.properties file PER workspace, at least for the connections part.

The benefits are obvious. One can have multiple workspaces with modules that connect to the same connection name but to different databases. Or when working at a client in-house you use different connections then at your own office. Etc.

I filed case #278466 .

Re: Database connections PER workspace

PostPosted: Fri Mar 05, 2010 11:24 pm
by jcompagner
for now just use multiply properties files and a servoy shortcut per client that uses a system property to define the property file.

Re: Database connections PER workspace

PostPosted: Fri Mar 05, 2010 11:37 pm
by ROCLASI
jcompagner wrote:for now just use multiply properties files and a servoy shortcut per client that uses a system property to define the property file.

How did that work again ? I can't find it on the forum but I know it was mentioned somewhere.

Re: Database connections PER workspace

PostPosted: Fri Mar 05, 2010 11:49 pm
by Karel Broer
ROCLASI wrote:It would be very welcome if we could have specific database connections enabled PER workspace. Or even better having a servoy.properties file PER workspace, at least for the connections part.

My vote for this too! It would be great just to switch workspace and having all db connections properly set.
Especially for us ISV's, having lot's of different customers with their own databases and specific app settings, this would be something very usefull! :idea:

Re: Database connections PER workspace

PostPosted: Sat Mar 06, 2010 1:13 am
by Harjo
yeah, with servoy 3.5 you could do that by using the property option IN the batfile
Don't know how this can be done in eclipse....

Johan? can you tell us?

Re: Database connections PER workspace

PostPosted: Sat Mar 06, 2010 1:15 am
by JuanMartin
I also I agree with the proposal. It would be interesting

Re: Database connections PER workspace

PostPosted: Sat Mar 06, 2010 1:21 am
by Roberto Blasco
So do I.

:P

I'ts a great proposal. Many times I'ven talking about this "will" with other spanish Servoy programmers.

Best regards. Roberto.

Re: Database connections PER workspace

PostPosted: Sat Mar 06, 2010 10:08 pm
by mboegem
jcompagner wrote:for now just use multiply properties files and a servoy shortcut per client that uses a system property to define the property file.


This is what Johan ment:
a shortcut to servoy.exe, then alter the execution path to this:
"<SERVOY INSTALL>\developer\servoy.exe" -data <PATH TO WORKSPACE> -vmargs -Xms40m -Xmx256m -XX:MaxPermSize=256M -Dproperty-file=<NAME OF PROPERTY FILE>

Re: Database connections PER workspace

PostPosted: Sat Mar 06, 2010 10:42 pm
by Harjo
oke, so everything in the servoy.ini file is skipped?
we have lot of stuff extra there, like proxy server settings. browser-suite stuff?

Is there a possibility to which servoy.ini file to use?

Re: Database connections PER workspace

PostPosted: Mon Mar 08, 2010 11:37 am
by pbakker
the .ini file is still used as well

Paul

Re: Database connections PER workspace

PostPosted: Mon Mar 08, 2010 12:36 pm
by Harjo
oke, so my next question is than, can we use this shortcut to set the ini file?
than we have everything is one place...

Re: Database connections PER workspace

PostPosted: Mon Mar 08, 2010 2:21 pm
by jcompagner
yes you should be able to set this in the ini file.
Only 1 problem there can be only 1 ini file.
So then it doesnt make much sense.

Creating more then 1 shortcut to the same servoy.exe and then adjusting those for the different property files.

Re: Database connections PER workspace

PostPosted: Mon Jun 06, 2011 10:48 pm
by jgarfield
+1 It would be fantastic to be able to do this