Setting Additional Database Connection Properties # JDBC Connection parameters can be added to configure different aspects of the connection to the database. Configuration properties are platform specific and not common across DB platforms. For some DB platforms, JDBC connection properties can be provided as part of the connection URL (configured with the <dataSource> tag in sics-database-sources.xml).
It is also possible - for all DB platforms - to configure JDBC connection properties on the command line and/or with the <additionalJdbcConnectionProperties> tag in sics-database-sources.
...
When an unexpected error occurs in SICS a so-called walkback is written. This file is important for DXC when troubleshooting errors.
The walkback is a zip file containing various information about the SICS installation and the error.
The SICS installation includes a walkback viewer which can be used to easily view the content of the walkback.
The default folder for walkback files is:
<java working directory>/walkback
The folder can be changed by:
...
SICS Batch Server is a memory intensive application and the standard Java VM settings are not sufficient. To avoid out of memory error messages like: java.lang.OutOfMemoryError.
Do the following:
Ensure Tomcat is not running Start (double-click) the %CATALINA_HOME%\bin\tomcat10w.exe program You will then see a window like this: Go to the “Java” tab and at the bottom at the “Java Options” field and add the following parameters:
Set the Initial memory pool 512 MB and Maximum memory pool 1024 MB.
...
Deployment on Apache Tomcat 10.x # The way to deploy war files differ from the various Java Servlet Containers. The following describe how to do it on Apache Tomcat 10.1.40.
Ensure Tomcat is running. Open the Tomcat Web Application Manager in a browser.
If you have installed it locally on port 8080 the address is http://localhost:8080/manager/html (or click on the link Tomcat Manager in the Tomcat start page (http://localhost:8080)
...
Required knowledge # Most SICS Batch Server configuration is specified using XML files. You should be familiar with syntax rules for well formed XML, and be able to comment and uncomment XML fragments.
Suggested configuration order # Step Description 1 Configure logging 2 Configure security 3 Configure schedulers 4 Configure user authorization interface Configure logging # Configure Log file Destination # Logging in SICS is done using the Apache Log4j 2 library and is configured using a file called log4j2.
...
Two-level login is supported when using “application managed” database connection. This is how it works:
The user name and password for the first-level ’technical user’ is provided in a configuration text file which is read by SICS. SICS will connect to the database using the technical user name and password. SICS reads the corresponding SICS User Object from the CNU_USER table. SICS detects that the SICS User Object contains a second-level name and password.
...
SE-6148 # The SQL Server jTDS JDBC Driver has been replaced by Microsoft JDBC Driver.
Please read the instructions in /conf/sics-database-sources.xml.
Driver class name has changed # SQL Server database <source> definitions need to change the driver class name in the <driver> element to com.microsoft.sqlserver.jdbc.SQLServerDriver.
Example:
<source name="SQLServer"> <driver>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver> <accessor>com.csc.troll.accessor.JDBCDatabaseAccessor</accessor> <interface>com.csc.troll.accessor.SQLServer2000Interface</interface> <dataSource>jdbc:sqlserver://hostname;sendStringParametersAsUnicode=false;selectMethod=cursor</dataSource> <useParameterizedSql>true</useParameterizedSql> <statementCacheSize>100</statementCacheSize> </source> SQL Server Windows Authentication (aka ‘Database remote OS authentication’ in SICS) with Microsoft JDBC Driver # In order to use SQL Server Windows Authentication, the integratedSecurity property (URL parameter) must be set to true (;integratedSecurity=true) on the <datasource> URL.
...