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 for more information about specifying the user for database connections.
SQL console |
|
Database |
Select the database to use. |
View structure |
Click on |
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. |
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.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.