...
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.
Changing the frevvo database naming and escaping conventions
In specific situations, your organization may require a certain naming convention for database objects (all uppercase, or at most 32 chars, or a specific name escaping convention) and the good news is that It is possible to change some of these parameters in by setting a couple of specific web context parameters.
| Note |
|---|
However, the bad news is that this is not completely supported by at this point. The main reason is that we cannot guarantee that all the existing functionality that we test before each release will work correctly for a given database when any of these settings is changed. |
Note also that the following settings affect the frevvoDS database schema and that any changes to these settings will force to create a schema that is not correct.
How can you make sure that all database object names are uppercase or lowercase? You can affect this by editing the frevvo/tomcat/conf/Catalina/localhost/frevvo.xml and adding the following parameter:
| Code Block |
|---|
<Parameter name="teneo.naming.strategy" value="uppercase" override="false" /> |
How can you make sure that all database object names have a max length (e.g. Oracle specifies a max of 32 chars)? You can affect this by editing the frevvo/tomcat/conf/Catalina/localhost/frevvo.xml and adding the following parameter:
| Code Block |
|---|
<Parameter name="teneo.naming.max_sql_name_length" value="30" override="false" /> |
How can you specify a custom name escape character? You can affect this by editing the frevvo/tomcat/conf/Catalina/localhost/frevvo.xml and adding the following parameter:
...