|
1. Choose type of Connection with the ComboBox [Connection].
2a. Fill in "username" and "password", click on [Open Connection] if it requires
this in formation. (which Connections you can choose from is stored in the
file "Connections.xml". This file contains from start some "default connections" which can be suitable as
starting points)
2b. If you want it to run against a Microsoft Access/Jet-database, you choose that alternative in
[Connection] and fills in the path to the mdb-file in the field "Database".
Instead of writing the path by hand, you can open it with a FileDialog [>>], and choose an
mdb-file that way.
3. Now the main Window will appear:
If all is well with the Connection, you'll see
 in one of the buttons in the toolbar. If something
went wrong when trying to establish the Connection, that button will instead show the icon
 .
4. To execute an SQL statement you write it in the TextArea below the tab [SQL
Statement] and click the button
 . The textare will give "syntax highlight" for reserved words in PL/SQL if you have checked
the checkbox.
Depending on the result of your SQL statement, the response will differ. If you have executed an
ordinary query, you're moved to the tab [Result], where your result will be shown in a table. (You can change the size of the window and width of columns just by "grabbing the
edges and drag"):
If something goes wrong, or if the SQL statement wasn't a query, you're moved to the tab
[Messages]:
Under the tab [Table Info] you find descriptions of the tables and view you have on your database.
Buttons in the Main Window:
|
|
Execute the SQL statement. |
 |
All your SQL statements during a session is saved in a "history list". With this button you can
"scroll backwards" among them... |
 |
...and with this you scroll forward. Note that the statements are not executed automatically, but
will just be put inot the field under the tab [SQL Statement] |
 |
If you had AutoCommit off, this button sends a "ROLLBACK" for all updates you've made since the
last "COMMIT". |
 |
If you had AutoCommit off, this button sends a "COMMIT" for all updates you've made. |
eller
|
This button shows if you have an open Connection or not. When you click this button, the login
dialog will appear, which will make it possible for you to change to another Connection, or reopen
the previous one it has failed. |
 |
A short description on what the buttons stand for (the same as what you've read here) |
Menues
[Actions]
[Auto Commit] |
Default is that your SQL statements not are autocommited. By this you can "redo" what you've done
with the "ROLLBACK" button. With this option you can set "Auto Commit On", which means that each
statement will be followed automatically by a "COMMIT".
NB! If you neither have "Auto Commit On" nor do a "manual" commit, you will lose all updates
you've made when you close the application!
|
[Actions]
[Syntax Highlight] |
This is the same "Checkbox" as under the tab "SQL Statement". |
[Actions]
[Configure Connection Properties...] |
See below on "DbPlus Configurator". |
[Help]
[Help...] |
The same as the "Help"-button in the toolbar... |
DbPlus Configurator
With "DbPlus Configurator" you can add, remove or change the properties for the "Connections" you can
choose from. This is also available via menu [Actions][Configure Connection Properties...]:
These properties can also be altered by "manuelly" edit the text file Connections.xml.
| Label |
This is shown in the Comboboxen at login. In this dialogue
you see the labels for all configurations to the left. |
| Driver |
The Java class for the JDBC driver. |
| Connection String |
The "url" for a JDBC connetion to a specific database. |
| Jar(s) |
Path to the jar-file(s) that contains the JDBC driver.
Relative paths are allowed, starting from the directory where SQLplus.jar
is. To remove a jar-file from the list; mark it and click on [Drop jar].
To add a jar-file to the list; click on [Add jar]. |
| |
|
| Save Property |
Saves the changes on the properties shown. NB! They will
not be permanently saved until you click on "Save to XML-file". |
| Delete Property |
Deletes shown property. NB! They will not be permanently
removed until you click on "Save to XML-file". |
| Save to XML-file |
Overwrites "Connections.xml" with the current information
on all "Connection Properties" (with all changes you've made). |
Bugs
"Syntax highlight" under the tab [SQL Statement] miss some
keyword and is sofar only extended to PL/SQL (Oracle's dialect,
which is a superset of SQL-92).
MS Access doesn't support all JDBC methods that's needed to
extract complete information under the tab [Table Info]
Specific command (e.g. Commit och Rollback) gives an "ugly"
printout in [Message], if no Connection is open...
NB! In the downloadable files, I've only included the drivers
for Oracle and
MySQL (Access is run through Suns ODBC-JDBC bridge).
|
