Database connections PER workspace

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Database connections PER workspace

Postby ROCLASI » Fri Mar 05, 2010 11:11 pm

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 .
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

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

Re: Database connections PER workspace

Postby jcompagner » Fri Mar 05, 2010 11:24 pm

for now just use multiply properties files and a servoy shortcut per client that uses a system property to define the property file.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8214
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Database connections PER workspace

Postby ROCLASI » Fri Mar 05, 2010 11:37 pm

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.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

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

Re: Database connections PER workspace

Postby Karel Broer » Fri Mar 05, 2010 11:49 pm

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:
Karel Broer
ServoyCamp - http://www.servoycamp.com
User avatar
Karel Broer
 
Posts: 779
Joined: Mon May 03, 2004 12:49 am
Location: Doetinchem

Re: Database connections PER workspace

Postby Harjo » Sat Mar 06, 2010 1:13 am

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?
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4296
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Database connections PER workspace

Postby JuanMartin » Sat Mar 06, 2010 1:15 am

I also I agree with the proposal. It would be interesting
Juan Antonio Martín Pinilla
Servoy 2019.6.0.3502 - PostgreSql 9.4
software@critenerife.com
User avatar
JuanMartin
 
Posts: 126
Joined: Tue Nov 25, 2008 9:20 pm
Location: Tenerife - Spain

Re: Database connections PER workspace

Postby Roberto Blasco » Sat Mar 06, 2010 1:21 am

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.
Un saludo. Roberto.

Madrid - Spain
Tfno: (+34) 625653066
E-mail: roberto.blasco.serrano@gmail.com
User avatar
Roberto Blasco
007
 
Posts: 348
Joined: Tue Apr 08, 2008 7:18 pm
Location: Madrid / Spain

Re: Database connections PER workspace

Postby mboegem » Sat Mar 06, 2010 10:08 pm

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>
_____________________
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance SAN Developer

Image
User avatar
mboegem
 
Posts: 1526
Joined: Sun Oct 14, 2007 1:34 pm
Location: Hoofddorp, The Netherlands

Re: Database connections PER workspace

Postby Harjo » Sat Mar 06, 2010 10:42 pm

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?
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4296
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Database connections PER workspace

Postby pbakker » Mon Mar 08, 2010 11:37 am

the .ini file is still used as well

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

Re: Database connections PER workspace

Postby Harjo » Mon Mar 08, 2010 12:36 pm

oke, so my next question is than, can we use this shortcut to set the ini file?
than we have everything is one place...
Harjo Kompagnie
Direct ICT / Servoy Hosting / ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
User avatar
Harjo
 
Posts: 4296
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Database connections PER workspace

Postby jcompagner » Mon Mar 08, 2010 2:21 pm

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.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8214
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: Database connections PER workspace

Postby jgarfield » Mon Jun 06, 2011 10:48 pm

+1 It would be fantastic to be able to do this
Programmer.
adBlocks
http://www.adblocks.com
jgarfield
 
Posts: 223
Joined: Wed Sep 28, 2005 9:02 pm
Location: Boston, US


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 1 guest

cron