Show Table of Contents
8. Managing Databases Associated with JBoss ON
There are several basic tasks that can be done to manage the Oracle or PostgreSQL databases that are used by the JBoss ON server.
8.1. Running SQL Commands from JBoss ON
SQL commands can be run through the JBoss ON web UI on any database that the JBoss ON server is using for its data.
Note
The database management page is not accessible through the normal JBoss ON GUI. Administrators must manually navigate to the admin area of the JBoss ON UI.
Note
Whatever JBoss ON user you are logged in as must have adequate user rights on the database to execute the SQL commands.
- Open the administrative page, with the location
coregui/#Test/ServerAccess/SQL. For example:http://server.example.com:7080/coregui/#Test/ServerAccess/SQL
- Enter the SQL commands, as appropriate for the JBoss ON Oracle or PostgreSQL database instance. If there are multiple commands, make sure the Continue if statements fail? checkbox is selected. That way, even if one command fails, the other commands will be submitted. Otherwise, the series will be terminated at the first failure.
- Click the button.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.