Change Connection Settings

 

The integrated assistants make it easy to change connection settings, local and remote passwords and JDBC driver settings.

 

Change JDBC Driver Settings

 

Preferences / Connections

The New Connection Assistant creates all necessary JDBC driver settings to connect to your database server. If you want to change the connection information afterwards you can use the Preferences dialog to do so. Open SQL4X Manager J -> Preferences to get a list of connections.

     
 

Edit JDBC Settings

Click "Edit JDBC Settings..." to view the current driver class and JDBC connect string for your selected connection. To modify the settings you can simply change the connect string and add/replace the options as described in your JDBC driver's manual.

After saving your changes to the JDBC settings the new settings will not automatically be active in open windows. If you have Database Navigator, SQL Viewer, SQL Console or any other window with a database connection on screen you have to press the Refresh icon (Database Navigator) or re-open it to reload the new connection information.

 

Don't quote field/table names

The current releases of all modern database servers support special characters (like spaces) within table and object names. To make sure the database server recognizes names with special characters correctly they have to be quoted. SQL4X Manager J automatically quotes all tabled and field names in generated commands.

Older releases of many database servers do not recognize the quote characters and produce an error message. In this case you should turn off quoting of field/table names.

 

Change Connection/Datebase Password I

 

Database Navigator/Connection

To change the password for your database connection open the Database Navigator, select your database connection and open the Connection list Corner Menu. From the Corner Menu select Change My Password...

As this option generates SQL commands to change the password with your database server, this option can only be used with supported servers. All major database servers are supported. If your sever is not supported send a request to our support team.

     
 

Change Password

Enter your new password and select one of the following options from the "Change On" selection:

Remote Database Server  

Changes your connection password on the database server only, but does not update your local password.

This selection generates the appropriate SQL Command to change the password with your database server. All future logins to your database server with your user account will require the new password. You need to change the local password too if you want to be able to connect to your database server again with SQL4X Manager J.

     
Local Connection  

Changes your local password for the selected connection. The local password is stored with the Mac OS X Keychain for security reasons, so no other user is able to access the password on your hard disk (Keychain encrypts passwords).

The password on your database server is not changed. This option is useful if you have changed your database password by any other means (like a SQL Script).

     
Both (Remote+Local)   Usually this is the prefered method to change your password. This option will send a SQL command to change your password on the database server and update your local password with Mac OS X Keychain.

 

 

Change Local Connection/Database Username and Password

 

Preferences / Connections

The New Connection Assistant creates all necessary JDBC driver settings to connect to your database server. If you want to change the connection information afterwards you can use the Preferences dialog to do so. Open SQL4X Manager J -> Preferences to get a list of connections.

     
 

Edit User/Password

Click "Edit User/Password..." to view the current user name and password for your selected connection. To modify the settings you can simply change the user name and/or password.

Click "Save new user settings" to store your changes to the user name and password to the Mac OS X Keychain. This will not update your password definition on your database server. See the previous section if you need to update the password on your database server too.

 

The new password will be available after refreshing your connections. This means all established connection with your database server will still work with the old password. All connections established after you updated the password will use the new password.