Page Comparison

...

A database on one of the following database servers

• Oracle 9i, 10g, 11, 12
• Microsoft SQL Server
2018 (R2)/2012 (R2
• 2012 or later
  
  
• (Oracle 12c)

Application server

• Apache Tomcat 7 or 8

...

• Oracle Java JDK at least 1.8
• JDBC driver for one of the following databases:MySQL 5.x (http:
  //www.mysql.com/products/connector/j)
  • Oracle 9i, 10g, 11 (http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/)
  • Microsoft SQL Server 2008(R2) (http://msdn.microsoft.com/data/jdbc)

...

1. Unpack the delivery and extract the file "JAAS.config" in the folder "WEB_INF\classes\" and copy it into the installation directory of Tomcat (C:\serverServer\tomcat).
2. After installation , execute the application "→ start menu → tomcat → "configure tomcat".
3. Perform the following steps:

                Tab "General": Set the start starting-option of the service to automatic

...

                "-Djava.security.auth.login.config=<path and filename of JAAS.config>" (which you copied under in Step 1.)

                Insert the lines in the same window:

...

1. The steps for setting up the database are kept general at this point in order to do justice to satisfy the different configurations of the database systems.
2. Create a new database/database scheme on the database server.
3. Create a database user with permission to "INSERT", "UPDATE", "DELETE", "ALTER" on this database.
4. Make sure that the database can be accessed from the application server with this user. If you use the SQL Server with windows authentication, the Tomcat service must execute under a domain account and this domain account must be configured as a user in the database.
   Download the sqljdbc_auth.dll of the Microsoft JDBC driver sqljdbc_6.2 from the internet and copy it to the bin directory of Tomcat.
5. Execute the scripts included in your shipment to create the database on it.
6. Make sure that the user who imports the DB scripts has all rights on the GlobalTaxCenter database.

...

          here <dbms> stands for the database system selected under 1above. In this file you adjust the IP/ host name of the database server, the database name and the user/ password according to the parameters selected under "Database"

...