...
- Locate the frevvoDS data source url parameter. 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 verify 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 parameters username and password to a user that has write permissions to the frevvo database.
- The frevvo database setup is now complete. will create all the necessary tables upon startup.
...
Configure the Connection Url
Configuration of the connection Url is key to successfully connect the server to your database. Consult your DBA to assist with connection issues.
...
The 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:
| Code Block |
|---|
<url>jdbc:jtds:url="jdbc:sqlserver://e00sca:59377/frevvo</url>;databaseName=frevvo;" |
As of SQL 2000, Microsoft SQL allows installation of multiple SQL named instances. If your SQL server was installed this way you must use the instance parameter. For example if you database instance was named xyzzy:
| Code Block |
|---|
<url>jdbc:jtds:url="jdbc:sqlserver://e00sca:59377/;databaseName=frevvo;instance=xyzzy</url>xyzzy" |
2) Verify that the user and password required to connect to the frevvo database are correct.
3) Make sure that the user configured in the data sources has permissions to read and write to the frevvo database.
...