In the Database Connections panel, you can view information from the database(s) being used by XperienCentral. You can view the database's metadata as well as a list of all the tables in the database(s). By selecting a table from the list, you can see the fields it contains and the format of those fields. You can also query the database in order to retrieve the current value of a specific field or fields as well as to alter the structure of the database.
In This Topic
Database Metadata
Select a database from the drop-down list to view its properties:
In the example above the XperienCentral database is selected. In the "Database Connection Metadata" section, the following information is shown:
| Metadata | Description |
|---|---|
| Name | The name of the database. |
| JNDI Resource | The name of the JNDI resource used by the database. |
| Product name | The manufacturer of the database (Oracle, MySQL, etc.). |
| Product version | The major.minor version number of the database. |
| Driver name | The name of the database driver. |
| Driver version | The major.minor version of the database driver. |
For example:
Database Tables
In the "Tables" section, a selectable list of all the tables in a database is available. To see a summary of the fields in a database table, click it. The information that is shown for the fields in a table vary by database. The following is an example of the fields belonging to a table in a MySQL database:
The fields of the table are shown along with the following information:
| Field | Description |
|---|---|
| Name | The name of the database field. |
| Data type | The type of data stored in the field (INT, VARCHAR, and so forth) |
| Length | The length of the field in bytes. |
Table Queries
You can enter Structured Query Language (SQL) statements in order to manage a database and retrieve the values of fields in a database's tables on the "Query" tab.
Use extreme caution when using SQL statements such as DELETE, JOIN, and others that can affect the structure of the database and/or tables and fields because doing so could have an adverse affect on your website(s).
To perform a query, follow these steps:
- Select the database to query from the "Database" drop-down list.
- To limit the results to a specific amount, enter a value in the "Maximum number of records to be returned" field.
- In the "Query" field, enter a Structured Query Language (SQL) statement and then click [Execute query]. The result is displayed in the "Query Results" section. For example:
If the query does not retrieve values (by an UPDATE, for example), the result(s) of the query on the database will be shown. For example: