Servoy Forum

Using SQL Anywhere database, I need to source the sa_config.sh file to use the native driver (not jconn3.jar or jconn4.jar) as a database server connection within Servoy Developer.

To achieve this, I inserted the following source command on the last line of the Servoy Developer init file, which is in my environment at /Applications/Servoy8.1/servoy.app/Contents/eclipse/servoy.ini:

source /Applications/SQLAnywhere17/System/bin64/sa_config.sh

But it does not seem to get executed, i. e. the database server connection is not recognised. Is the servoy.in the correct place to insert such a command for the Developer or is there any other file to use?

By the way, the sa_config.sh file is set to be executable.
I am on Servoy Developer 8.1.4, Java 1.8.0_151, and macOS 10.13

Regards,

Robert,

servoy.ini is a configuration file, not a bash script, it won't run things.

You could create a script with 2 lines, 1 to source the settings file and 1 to start Servoy

Code: Select all

source /Applications/SQLAnywhere17/System/bin64/sa_config.sh
open -a /Applications/Servoy8.1/servoy

(second line is a guess, I do not have access to a mac)

Rob

Rob,

Your suggestion works, and the second line only misses .app at the end.

For a more elegant startup, I now only have to find a place within Servoy (Eclipse) where I can embed the source /Applications/SQLAnywhere17/System/bin64/sa_config.sh command.

Thanks, Robert

rgansevles wrote:Robert,

servoy.ini is a configuration file, not a bash script, it won't run things.

You could create a script with 2 lines, 1 to source the settings file and 1 to start Servoy

Code: Select all

source /Applications/SQLAnywhere17/System/bin64/sa_config.sh
open -a /Applications/Servoy8.1/servoy

(second line is a guess, I do not have access to a mac)

Rob

Rob

For a production environment, any hint where I could put the shell script command below to get it run at Tomcat startup?

Code: Select all

source /Applications/SQLAnywhere17/System/bin64/sa_config.sh

Regards