![]() Property: workbench.db. (will overwrite the DBMS independent configuration) JDBC 4.0 defines the following constants: Workbench.db.some_dbid.typemap=3:DOUBLE 2:NUMBER($size,$digits) -1:VARCHAR($size) Maps the JDBC value -1 (LONGVARCHAR) to the DBMS type VARCHAR The NUMBER datatypes needs uses two parameter placeholders The following entry maps the JDBC datatype with the value 3 (DECIMAL) to the targetĭatatype double and the value 2 (BIGINT) to the target The numeric JDBC datatype valueĪnd the DBMS specific datatype name are separated with a colon. To a real data type name for the target DBMS. The entry is a list of mappings that map the numeric value With this setting you can define your own type mappingįor a specific dbms. WbCopy, the type mapping from the JDBC driver might When using the -createTarget parameter for WbSetConfig workbench.db.ddlneedscommit=true Īlternatively the command WbSetDbConfig can be used, which only requires to specify the If the current connection is against a PostgreSQL database: The followingĬommand changes the property named workbench.db.postgresql.ddlneedscommit Inside the property name and it will get replaced with the current DBID automatically. When using WbSetConfig you can use the value If the DBID is part of a property key this will be referred to as in this chapter. If the description for a property in this chapter refers to the "DBID", then this value has to be used. This DBID is displayed in the connection info dialog that is displayed, when you right click on the connection URL in the main window,Īdditionally, the DBID is also reported in the log file: You can also change the values for these properties while the application is running by using theĭBMS specific settings are controlled through properties that contain a DBMS specific value, called the The position where you add this entry does not matter. Simply create a new line with the property name and the value as described here. ![]() Listed properties will be present in ttings. Which is located in the configuration directory. The name of the setting refers to the entry in the file ttings ![]() This section describes the additional options for SQL Workbench/J whichĪre not (yet) available in the options dialog. ![]() Settings related to SQL statement generation 37.17. Default settings for Export/Import 37.12. Configuring the check for the update table 37.9. Controlling code generation for code snippets 37.5. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |