...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Section | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
If you prefer to define your datasources on the container level, the recommended approach is to define the datasource in the container and then use a resource-ref in the Database Connector properties file to reference it.
frevvo only supports/certifies the Database Connector running in the Apache Tomcat container. Refer to our Supported Platforms for the list of Application Servers and databases supported/certified by frevvo.
...
Add the enabled= attribute with a value of false to the <querySet/> or individual <query> elements in the configuration.xml file to completely disable it.
Code Block <dbconnector> <querySet name="BIRT" enabled="false" ...>
The same can be done by adding the enabled property with a value of false as shown below to the dbconnector.properties(standalone bundle) or dbconnector.properties (tomcat bundle).
Code Block dbconnector.querySet@<queryset name>.enabled=false
This property disables all querysets. Add it to the dbconnector.properties(standalone bundle) or dbconnector.properties (tomcat bundle).
Code Block dbconnector.querySet.enabled=false
You will see the disabled status when you browse the status URL for the Database connector - http://<server:host>/database/status. Browsing a disabled query displays the message shown below:
Can the Database Connector Serve CSV Files?
Yes. One option is to use the CsvJDBC driver. A limitation of this approach is that it only supports SELECTs.
1. Download the JDBC driver from here.
2. Place the driver in the frevvo/tomcat/lib folder.
3. Add the following to your configuration.xml. (See this section for details.) Replace the queryset name and query name with your csv name.
| Code Block |
|---|
<dbconnector>
<queryset name="bikes">
<resource-def>
<url>jdbc:relique:csv:${catalina.base}/db?suppressHeaders=true</url>
<driver>org.relique.jdbc.csv.CsvDriver</driver>
</resource-def>
<query name="selectBikes">
<retrieve>
<statement>
SELECT * FROM bikes
</statement>
</retrieve>
</query>
</queryset>
</dbconnector>
|
4. Add the csv to frevvo/tomcat/db/. Here is an example (bikes.csv) that you can download and test with above configuration.