[See all pages on this site.] [Find out more about Trifox Inc.] [Find out how to contact Trifox personnel.] [Complete product documentation, FAQs, online references.] [Pricing is simple.] [Download an evaluation copy of any Trifox product.] [Descriptions of all products, including VORTEX, DesignVision, and Genesis.]

[LOGO]
[Navigation Map]

 

[Search Site]

| 

VORTEXjava/VORTEXjdbc Extensions

   

[*] Frequently asked questions
[*] Glossary
[*] Documents for download
[*] White papers
[*] Online reference

VORTEXjava

VORTEXjava references the vortex.properties file located in the same directory as vortex.jar. If this properties file is found, then VORTEXjava looks for various logging and network connection properties. These are:
connect_timeout Number of seconds to wait for a connection.
environment_variables A comma separated list of environment name/value pairs to set on the server side of the connection
key_connect Integer key to use for uid/pwd obfuscation. It must match the -kn vtxnetd option value.
logfile The name of the logfile, e.g. /tmp/test. ".log" will be appended to the filename.
logopts A "+" separated list of logging options. The current supported options are:
FULLCreate a detailed logfile output. The default is much less verbose.
MULTIAppend a timestamp to the logfile name.
TIMEInsert timing data in the logfile output.
read_timeout Number of seconds to wait for a read response.

VORTEXjdbc

VORTEXjdbc references the vortex.properties file located in the same directory as vortex.jar. If this properties file is found, then VORTEXjdbc looks for SQL statements to send after the connection is made. These are named "jdbcsqln" where "n" is an integer beginning with zero and consecutive after that. For example,

jdbcsql0=set option tree on
jdbcsql1=set option plan on
jdbcsql3=set option expr on

The first two statements will be executed but not the third one.

Sample vortex.properties file

#
# VortexJava logging
# logfile is the name of the logfile, e.g. /tmp/test
# logopts is a + separated list of options (optional)
#
logfile=/tmp/test
logopts=FULL+MULTI+TIME

#
# VortexJdbc connection commands
# These are sent to target after the connection succeeds.
# A maximum of 20 statements are sent and they must be consecutively numbered
# without gaps
#
#jdbcsql0=set option logfile '/tmp/genesis.log'
#jdbcsql1=set option plan on

#
# Vortex network parameters
# connect_timeout - seconds to wait on a connect
# read_timeout - seconds to wait on a read response
# key_connect - integer key to use for uid/pwd obfuscation. Must match the
#               -kn vtxnetd option value.
connect_timeout=15
read_timeout=1440
#key_connect=1999
#environment_variables=VORTEX_HOST_LOGFILE=/tmp/vtest,VORTEX_HOST_LOGOPTS=FULL

Back To Top


© 1985-2013 Updated 9 May 2016.