Versions Compared

Old Version 46

changes.mady.by.user Former user

Saved on

compared with

New Version 47

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleClick to see standalone bundle content details

Excerpt

The database.zip file has the following structure:

Note the files in the database-connector-2.5.x directory that are used to manage the Database Connector as services on *nix and Windows operating systems: These files should be run as an administrator.

  • Install-Service.bat - installs the Database Connector on a Windows system as a service named frevvo Database Connector.

  • Uninstall-service.bat - uninstalls the frevvo Database Connector on a Windows operating system

  • Start-DB Connector-Service.bat - starts the frevvo Database Connector on a Windows operating system

  • Start-DBConnector.sh - starts the frevvo Database Connector as a *nix console instance.

  • Restart-DBConnector-Service.bat - restarts the frevvo Database Connector on a Windows operating system

  • Restart-DBConnector.sh - restarts the frevvo Database Connector as a *nix console instance.

  • Stop-DBConnector-Service.bat - stops the frevvo Database Connector on a Windows operating system.

  • Stop-DbConnector.sh - stops the frevvo Database Connector *nix console instance.


There is another option for Linux systems. The Database Connector can also run as a service using systemd

Systemd is used by many Linux distributions.It is possible to manage the Database Connector using systemd ‘service’ scripts.

  • Copy the sample service file located in /bin/dbconnector.service to /etc/systemd/system
  • Review it's contents and
  • Make sure it is executable.

You can now use systemd to manage the dbconnector service:

  • systemctl start dbconnector.service

  • systemctl stop dbconnector.service

  • systemctl restart dbconnector.service

  • systemctl status dbconnector.service

To flag the service to start automatically on system boot use the following command:

Code Block
systemctl enable dbconnector.service

Consult the service unit configuration man page for more details.

Install a JDBC

...

Driver

The connector relies on the JDBC API. You can use any relational database as long as you have a JDBC driver for that database.

...

The preinstalled drivers are listed below.

  • MS SQL driver - The MS SQL driver This is embedded in the database.war in the Database Connector Standalone bundle. It file with standalone bundle, however it is not embedded in the frevvo-tomcat bundle.

  • DERBY driver

If you don't find what you need your database driver is not pre-installed, you will need have to locate a driver compatible to your database. Usually you can download your driver from the internet. Try one of these locations.

Once you have the driver you need, copy it to:Copy your driver to

  • <frevvo-home>/tomcat/lib in the frevvo-tomcat bundle
  • <db-home>\database-connector-2.5.x\lib in the Database Connector Standalone bundle

Info
  • You MUST copy the MS SQL (sqljdbc.jar) to the <frevvo-home>/tomcat/lib directory if you are deploying the connector in the tomcat bundle and using MS SQL as your external database
  • Refer  If you are using the jTDS driver, refer to the special considerations when defining datasources if you are using the jTDS driver.
  • It is also appropriate to copy the driver into any location that is in the CLASSPATH of your servlet container. In a tomcat installation another location would be <CATALINA_HOME>/lib.

...