...
- Locate the frevvoDS data source url parameter and decide on a name for the frevvo database. For SQL Server it would look like this: "url="jdbc:sqlserver://localhost:1433;databaseName=frevvo". You can change the name "frevvo" to whatever you wish, "" for example. But it must match the database name you create in your SQL server. See configure the connection Url below.
- Create a UTF-8 encoded database "frevvo" (assuming you left the url parameter database name as the default) in your SQL server
- Set the frevvoDS data source url parameter to your database server. See configure the connection Url below.
- Set the frevvoDS data source parameters username and password password parameters to a user that has read and write permissions to the frevvo database.
- The frevvo database setup is now complete. will create all the necessary tables upon startup.
...
For your selected database type in frevvo.xml:
1) Verify that the "url" parameter is pointing to the correct Set the frevvoDS data source url parameter to your database server. If and the database server are collocated "localhost" may be fine. The Url url parameters depend on the database type and installation choices made when your DBA installed your database software. Consult your DBA for the correct connection values. For example, SQL server installed on a non-default port and running on a machine named e00sca will require that you add a port number and host name to the Url. For example:
...