The name and password of the database user are used by the item. SQLDRIVERCONNECT=jdbc:sqlserver://dbsrv01 databaseName=AEV10 With this option, a separate database connection string for the JWP is defined in the section. The entry should be on one line (no break).Ģ) Separate connection string for the JWP SQLDRIVERCONNECT=ODBCVAR=SNNNNNRN,Driver= Server=tcp:dbsrv01,1433 Database=AEV10 Uid=user Pwd=password The server and database name must be specified directly in this case. When installing a JWP for an existing system, all WPs must be subsequently restarted.Ī connection string is required in the section of the configuration file, the syntax of which does not require DSN. Please note that with this option, the same database connection string that is also used by all the other WPs in the Automation Engine system must be changed in the configuration file. The database connection must be modified in the configuration file for the JWP. The JWP uses the same configuration file (ucsrv.ini) as the other work processes of the Automation Engine system. Modify the Automation Engine configuration file The message "Server is listening on " should be found in the current log file, which contains the port. If you are not sure of the port of your MS SQL server instance, you can find this out from its log file. The default port of the MS SQL server port is 1433. The item "TCP/IP" must be set to "Enabled" in the right-hand section. Open the SQL Server Configuration Manager and select Protocols for MSSQLSERVER under SQL Server Network Configuration. Now check whether the MS SQL server instance used allows access via TCP/IP. MS SQL Serverĭownload Microsoft JDBC Driver 4.0 for SQL servers.Īfter downloading, copy the file "sqljdbc4.jar" into the lib directory of the Automation Engine. The subsequent installation steps depend on the database type used. In UNIX, the files are located in the respective TAR archive.Ĭopy the provided "plugin" and "lib" directories into the BIN directory of the Automation Engine. In Windows, the JWP files are automatically copied from the SETUP.EXE program to the BIN directory. This includes information on how the components are connected including the settings applied./ is created automatically when the JWP is first started and contains the OSGI bundle's cache. The directory / configuration A set of constituent components that make up a system. database A database is an organized collection of data including relevant data structures.jarĪdditional OSGI bundles for console and services. File / Directoryĭirectory with OSGI implementation and JDBC driver. The JWP is provided in the same directory as all the other Automation Engine files. Application Release Automation Integration.The JWP is a component of the Automation Engine which is required for the following functions:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |