Miscellaneous

SICS Database Maintenance Launcher

Technical Doc, Miscellaneous
v21.2

Introduction # SICS SysAdmin Utility is shipped with a command-line utility for maintenance work on SICS databases. Being a command-line utility means it is a headless application, well suited for automation. The command-line utility is implemented as a Java program which is launched from a class named com.csc.sics.launcher.DatabaseMaintenanceLauncherMain. The SICS Database Maintenance Launcher has the following capabilites: Create a new SICS database Update an existing SICS database to a higher version Create SICS reporting tables and views Create SICS reporting stored procedures and functions Usage # Bootstrapping # In order to execute the SICS Database Maintenance Launcher, a few JAR’s from the lib folder of the SICS SysAdmin Utility must be added to the Java class-path. ...

Third Party Notice

Technical Doc, Miscellaneous
v25.3

Third Party Software Notices And Information # The Product is delivered with Open Source Software (OSS) components potentially developed or owned by third parties. OSS components may be used according to the terms and conditions of the specific licence under which the relevant OSS components are distributed, but are provided "AS IS" by such third parties and DXC. Artifact Version Homepage Licenses angus-activation 2.0.2 https://projects.eclipse.org/projects/angus EDL 1.0 angus-mail 2.0.3 http://projects. ...

SICS 4.7.2

Technical Doc, Miscellaneous
v4.7.2

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. ...