skip to main content
Using the Driver : Using the SQL Engine Server : Configuring the SQL Engine Server on UNIX/Linux : Configuring and Starting the SQL Engine Server on UNIX/Linux
  

Try DataDirect Drivers Now
Configuring and Starting the SQL Engine Server on UNIX/Linux
In server mode, you must start the SQL engine server before using the driver. Be aware that you must have permissions to write to the directory specified by the SchemaMap option to start the SQL engine server.
To configure the SQL engine server, specify values for the Java options in the following JVM argument:
java -Xmx<heap_size>m -cp "<jvm_classpath>" com.ddtek.cassandracloud.sql.Server
-port <port_number> -Dhttp.proxyHost=<proxy_host> -Dhttp.proxPort=<proxy_port>
-Dhttp.proxyUser=<proxy_user> -Dhttp.proxyPassword=<proxy_password>
See the "SQL Engine Server Java Options" table for a description of these options.
For example:
java -Xmx1024m -cp "/opt/Progress/DataDirect/ODBC_80_64bit/java/lib/cassandra.jar"
com.ddtek.cassandracloud.sql.Server -port 19933 -Dhttp.proxyHost=myhost@mydomain.com
-Dhttp.proxPort=12345 -Dhttp.proxyUser=JohnQPublic -Dhttp.proxyPassword=secret
To start the SQL engine service, execute the JVM Argument after configuring the Java options. A confirmation message is returned once the server is online.
Table 14. SQL Engine Server Java Options
Java Option
Description
Required Java Options
-cp
Specifies the CLASSPATH for the Java Virtual Machine (JVM) used by the driver. The CLASSPATH is the search string the JVM uses to locate the Java jar files the driver needs. The Cassandra driver's JVM is located on the following path:
install_dir/java/lib/cassandra.jar
-port
Specifies a valid port on which the SQL engine listens for requests from the driver. We recommend specifying one of the following values:
*19934 (32-bit drivers)
*19933 (64-bit drivers)
Optional Java Options
-Xmx
Specifies the maximum memory heap size, in megabytes, for the JVM. The default size is determined by your JVM. We recommend specifying a size no smaller than 1024.
Note: Although this option is not required to start the SQL engine server, we highly recommend specifying a value.
-Dhttp.proxyHost
Specifies the Hostname of the Proxy Server. The value specified can be a host name, a fully qualified domain name, or an IPv4 or IPv6 address.
-Dhttp.proxyPort
Specifies the port number where the Proxy Server is listening for HTTP and/or HTTPS requests.
-Dhttp.proxyUser
Specifies the user name needed to connect to the Proxy Server.
-Dhttp.proxyPassword
Specifies the password needed to connect to the Proxy Server.