Special Properties
DbVisualizer utilizes a few special properties that you can use to modify characteristics of the application. These properties are available in the DBVIS-HOME/resources/dbvis-custom.prefs file.
| Property | Description |
|---|---|
| dbvis.-AutoSaverRunInterval=30 | The number of seconds between auto-saving open SQL editors. |
| dbvis.disabledataedit=false | Specifies if table data editing should be completely disabled, i.e. the form and inline editors. Note: This has an effect only when used with a licensed edition. |
| dbvis.driver.ignore.dir=lib:resources:.install4j | Specify directories from DBVIS-HOME that should not be listed in the Driver Manager "System Classpath" list. Directories are separated with ":". Accepted values: one or several directory names starting from DBVIS-HOME. |
| dbvis.grid.encode=false | Specifies if encoding of data in result set grids will be performed or not. If set to true then make sure the dbvis.grid.fromEncode and/or dbvis.grid.toEncode are also set. |
| dbvis.grid.fromEncode=ISO8859_1 | Encoding used when translating text data that is fetched from the database |
| dbvis.grid.toEncode=GBK | Encoding used when translating data that will appear in the result set grid |
| dbvis.removepartialresultsets=false | Defines whether the result set(s) should be removed when interrupting an ongoing execution in the SQL Commander. |
| dbvis.savedatacolumns=false | Column layout changes such as reordering and/or visibility are saved for all grids in the Objects Views *except* for the "Data" grid. This property can be used to also include the layout in the "Data" grid. Note: This will result in DbVisualizer saving the layout for each table that is displayed in the Data grid = huge XML file... |
| dbvis.showactionresult=false | This defines whether the result for all actions should be displayed or only failures (default). |
| dbvis.sqlwarning.maxrows=5000 | Defines the number of SQL Warning rows that should be processed before truncating. |
| dbvis.usegetobject=false | Specifies if the generic ResultSet.getObject() method in JDBC will be used in favor of the data type specific get methods or not. Default is false. |
| dbvis.usestandardgridfit=false | Enable this property and DbVisualizer will use an accurate but slow method to automatically resize grid columns. "Accurate" since it does a real calculation of the columns width. If leaving this property disabled then column widths are determined much faster but depending on what grid font is used some columns may be truncated with "...". This property has an effect only if Tool Properties->Grid->Auto Resize Column Widths is enabled |
| dbvis.-ConnectionTestTimeout=20 | The timeout in seconds for the "Ping Server" feature. |
| dbvis.<database>.IgnoreMaxRowsForNonSELECT=true | Ignore the Max Rows setting for statements other than SELECT. MS SQL Server applies Max Rows also to DELETE, INSERT and UPDATE (upto and including SQL Server 2008). |
| dbvis.<database>.-RemoveNewLineChars=false | Backward compatibility setting used to specify that the SQL command will be trimmed of all whitespaces, tabs and newlines just before it is executed by the DB server. |
| locale=en,us | Use this to specify an alternate Locale |
| dbvis.-FileForceSync=true | By default, all XML settings files are synced with the underlying storage device at the time when these are saved. Use this property to disable the syncing and instead rely on OS syncs. Note: relying on OS syncs and performing an uncontrolled shutdown of Windows may corrupt files. |
| dbvis.-MasterPasswordRule=.{8,} | By default, a Master Password must be at least 8 characters. This is the definition of the default implementation. Please see the dbvis-custom.prefs file for some additional examples. |
| dbvis.-MasterPasswordRuleDescr=\ The new password must be at least 8 characters long | Use this to specify a description of the master password rule. |
You rarely need to modify these properties, as the default values are sufficient for most usage. Also note that these properties may change in future versions of DbVisualizer. Some are also experimental and may be removed or instead introduced in the DbVisualizer GUI.