DBEntrance Chart Service
This chart service is brought to you by DBEntrance.
Script Browsing
The EntranceServet can serve the script files under the script directory in a simple way. Just point your browser to
src under the mapping URI of the servlet.
For the out of box setting, it is chart/src.
Direct Drawing
When URL used for scripting is having the request parameter of draw (e.g. http://example.com/dbentrance/chart/src/bar/bar.sql?draw),
the EntranceServlet serves images instead
based on the request parameters. In this way, web applications written in any language would be able to integrate with chart server through
HTTP connections. The following parameters are supported:
| Name | Required? | Description |
|---|
| format | No |
The format of the image (e.g. 'png', 'jpg'), default to png. The supported type are based on the Java Image support. |
| width | No |
The width of the image, defaults 800 |
| height | No |
The height of the image, defaults to 600 |
If any of the required parameters for the configuration or request is missing, this page will be dispalyed.
Limitations
- No support for other way of configuration JDBC connection like JNDI from the container or through IoC.
- The database connections are opened and closed upon each request rather than through connection pooling.
Configuration
DBEntrance charting servlet can be configured by adding it to web.xml file of your web application, with the following parameters:
| Name | Required? | Description |
|---|
| jdbc-url | Yes |
The JDBC URL used to connect to the database |
| username | No |
The username used to connect to the database, defaults to 'root' |
| password | No |
The Password used to connect to the database, defaults to '' (empty string) |
| script-root | Yes |
The root to the script directory, which can be a zip file. All the script look-ups are done from here. |