...
- Create a database for TermWeb to store data in (e.g.
termweb
).- Open pgAdmin and right click on Databases and select New Database
Encoding: UTF8
Template: template0
Collation: C
Character Type: C
- Open pgAdmin and right click on Databases and select New Database
- Create a database login role (user) which TermWeb will connect as (e.g.
termwebuser
), with permissions for the database.- Create a new login role (right click on Login Roles and select New Login Role) and name it termwebuser. Select password: termwebuser.
- Set login role as database owner and set permissions (right click on
termweb
database and select Properties). Select termwebuser as owner.
- Execute the
termweb_postgresql.sql
file from the installation package to create the database tables.- Select
termweb
database and click on SQL icon to open an SQL execution window. - Copy paste termweb_postgresql.sql content and execute query.
- Select
2. Copy the SQL Server JDBC Driver to Tomcat
...