JMap Admin provides a generic SQL console that can be used to view database structures, execute SQL queries, inspect the content of tables, test for query execution speed, etc.
All configured databases are accessible through this console.
When performing an SQL query, the query execution is subject to security permissions granted to the user connected to the database. See Creating Databases section for more information about specifying the user for database connections.
Query results are displayed in a new window. The results of the INSERT, UPDATE, and DELETE requests are grouped in the same tab. The results of SELECT type queries appear in separate tabs.
SQL console
Database
Select the database to use.
View structure
Click on to open a window that allows you to navigate in the structure of the database. You can see the schemas, the tables and views, and information about each field of a table or view.
Max. rows
When executing a SELECT SQL query, you can enter a value to limit the number of returned rows.
Auto commit
If performing SQL transactions (e.g. INSERT, UPDATE), select this option to validate the transactions automatically (SQL COMMIT command). Otherwise, you will need to perform the validations manually.
Test for speed only
When executing an SQL query, select this option to repeat the query a certain number of times and display the execution times.
SQL Query
Enter the SQL query to execute. The result will be displayed in a table.