Notes about Environment (Linux)
Folders
Given below is a list of important folders in your StyleVision Server setup.
/opt/Altova/StyleVisionServer2023/
|
/var/opt/Altova/StyleVisionServer
|
/etc/profile.d/jdbc.sh The environment settings file (typically named jdbc.sh) is executed at system start. The definitions in it must be specific to your particular environment. The example path above serves only as a general guide.
|
Database connections
On Linux, the following database connections are supported:
•JDBC — You can use JDBC for all supported databases except Microsoft Access
•Native connections — Currently available for SQLite and PostgreSQL databases
If you are using JDBC, note the following points:
•The Java Runtime Environment or SDK must be installed.
•The JDBC drivers for the target database must be installed.
•The following environment variables must be set correctly for your environment:
οCLASSPATH: to find the jar-files that connect to the JDBC database; the jar-files can be entered either in (i) an executable script (like jdbc.sh) that is executed on system start or (ii) a unit file that is executed when StyleVision Server is started as a service. Using a unit file to specify the jar-files has the advantage that the files required for StyleVision Server's JDBC connections will be located without you having to modify the existing system configuration. A unit file is listed below.
οPATH: to find the JRE, but might not be necessary depending on the installation
οJAVA_HOME: if necessary, depending on the installation.
Listing of important files
The following shell script (or unit file) is copied to the folder /opt/Altova/StyleVisionServer/etc so as not to overwrite already existing configuration files. Make the necessary changes as required. Also see the section JDBC Connections above. The parts highlighted in blue are environment-specific and need to be adjusted to match your environment:
#- jdbc - environment - export PATH=/usr/local/jdk1.7.0_17/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/qa/bin export JAVA_HOME=/usr/local/jdk1.7.0_17 export CLASSPATH=/usr/local/jdbc/oracle/ojdbc6.jar:/usr/local/jdbc/oracle/xdb.jar:/usr/local/jdbc/oracle/xmlparserv2.jar:/usr/local/jdbc/postgre/postgresql-9.0-801.jdbc4.jar:/usr/local/jdbc/mssql/sqljdbc4.jar:/usr/local/jdbc/iseries/lib/jt400.jar:/usr/local/jdbc/mysql/mysql-connector-java-5.1.16-bin.jar:/usr/local/jdbc/sqlite/sqlitejdbc-v056.jar:/usr/local/jdbc/Informix_JDBC_Driver/lib/ifxjdbc.jar:/usr/local/jdbc/sybase/jconn7/jconn4.jar:/usr/local/jdbc/db2/db2jcc.jar:/usr/local/jdbc/db2/db2jcc_license_cu.jar:./:
|