Page History
...
See “About the Adapter Settings portlet” on page 26.
See “About the Retrieve from Database portlet” on page 31. See “Common JDBC drivers” on page 28.
Common JDBC drivers
JDBC drivers allow you to connect to databases that support Structured Query Language (SQL).
JDBC technology drivers are available from a number of vendors. The following lists provide information on what values must be entered in the DBAdapter portlet settings for popular databases.
The JDBC drivers need to be saved in:<precise
<precise_root>root>\products\gui\website\webapps\DBAdapter\WEB-INF\lib\
The following table shows the information you must enter in the DBAdapter portlet settings to connect to a Microsoft
SQL Server (2005) database.
Table 3-3 Microsoft 3 Microsoft SQL Server JDBC driver
| JDBC |
|---|
...
| driver | Value |
|---|---|
| Driver |
...
| name | com.microsoft.sqlserver.jdbc.SQLServerDriver |
| Connection |
...
| strong format | jdbc:sqlserver://<host>:<port1433>;DatabaseName=<database> |
The following table shows the information you must enter in the DBAdapter portlet settings to connect to a MySQL
database.
Table 3-4 MySQL 4 MySQL JDBC driver
| JDBC |
|---|
...
| driver | Value |
|---|---|
| Driver |
...
| name | com.mysql.jdbc.Driver |
| Connection |
...
| string format | jdbc:mysql://<host>:<port>/<databaseName> |
The following table shows the information you must enter in the DBAdapter portlet settings to connect to a Sybase database.
Table 3-5 Sybase 5 Sybase JDBC driver
| JDBC |
|---|
...
| driver | Value |
|---|---|
| Driver |
...
| name | com.sybase.jdbc2.jdbc.SybDriver |
| Connection |
...
| string format | jdbc:sybase:Tds:<host>:<port>/<databaseName> |
The following table shows the information you must enter in the DBAdapter portlet settings to connect to a Oracle database.
Table 3-6 Oracle 6 Oracle JDBC driver
| JDBC |
|---|
...
| driver | Value |
|---|---|
| Driver |
...
| name | oracle.jdbc.driver.OracleDriver |
| Connection |
...
| string format | jdbc:oracle:thin: |
...
@<host>:<port>:<sid> |
About the Portlet Upgrader portlet
This portlet is located in the portlets tree under admin.
The portlet gives you the functionality to upgrade all portlets that are using the same Precise installation (source) to another Precise installation (destination).
The portlet upgrader in the Precise Custom Portal v9.6 supports the portlet upgrade from Precise v8.0 to v8.5, v8.5/v8.7 to v9.0,and v9.0 to v9.6 adapter type data sources. The upgrade process will convert the portlet’s request and parameters to match the new data source.
If the conversion logic fails for a portlet, it will be aborted, logged, and the process will continue with the next portlet. The logging output for the portlet upgrade process can be found in the
<precise_root>\products\gui\website\logs\upgrade.log and upgrade-report.log files.
The following table describes the fields that are available in the portlet:
Table 3-7 Portlet 7 Portlet Upgrader portletFields Description
| Fields | Description |
|---|---|
| Source |
...
| adapter | List of defined |
...
| adapters |
| Source data |
...
| source | List of defined data sources for the selected |
...
| source adapter |
| Destination |
...
| adapter | List of defined |
...
| adapters |
| Destination data |
...
| source | List of defined data sources for the selected |
...
| destination adapter |
About the Refresh Rate Settings portlet
The administrator can configure how often the information displayed in the dashboard is refreshed in the Refresh Rate
Settings portlet. These settings apply to all pages on the dashboard.
To configure the refresh rate settings1 On
- On the Refresh Rate Settings portlet toolbar, click the Edit Preferences icon.
...
- In the Page refresh rate (minutes) field, type how often you want the information displayed on the page to be refreshed.
...
- Click Ok.
| Anchor | ||||
|---|---|---|---|---|
|
...