Sqlways.ini File - Section [JAVA]

This article describes sqlways.ini file [JAVA] section and options it contains.

Option name	Description
CONNECTION	This option controls generation of connections in java code. If this option is empty or DEFAULT is specified SQLWays will generate connections in all classes with Embedded SQL. If this option is set to MAP SQLWays will generate connection mapping code and instance method, no matter whether the DML statements are used or not. If SINGLE is specified, SQLWays will generate connection code in separate class if DML statements are used.
PASSWORD	This option sets assigned value into String password parameter of DriverManager method getConnection. When the option is empty or isn't specified then by default SQLWays assigns empty value into String password parameter of DriverManager method getConnection.
USERNAME	This option sets assigned value into String user parameter of DriverManager method getConnection. When the option is empty or isn't specified then by default SQLWays assigns empty value into String user parameter of DriverManager method getConnection.
CONNECTIONURL	This option sets assigned value into String url parameter of DriverManager method getConnection. When the option is empty or isn't specified then by default SQLWays assigns “jdbc:default:connection” value into String url parameter of DriverManager method getConnection.
CONVERT_SQL_IN_CONST_STRING	This option controls how the query inside constant string will be treated. When the whole SQL query is built in one constant string need to set this option to “Yes” and SQLWays will try to convert it. Possible values “Yes”, “No” or empty. Default value - “No” or empty
OVERALL_TRY_CATCH	This option whether the generated Java code will be placed inside the TRY CATCH block. If this options is set to “Yes”, TRY CATCH block will be generated. If option is set to “No”, will be used default conversion. Possible values “Yes”, “No” or empty. Default value - “Yes”.
UI_TYPE	This option defines User Interface type for Java as a target direction, for example “SPRINGBOOT”, “JSF”, “JSFSimple”, “SWING”. For the whole list of supported values for this option, please contact our support team.
ENABLE_CAMEL_CASE	If this option is set to “Yes”, camel case will to used for all identifiers in generated Java code. Possible values “Yes”, “No” or empty. Default value - “Yes”.
STATIC_OBJ	This option controls generation of static modifier. If this option is empty or “Yes” then the class fields and methods will be generated with Static modifier. Static methods will be invoked with the class name. If this option is set to “No”, then class fields and methods will be generated without static modifier. In this case, reference to java methods will be implemented with an object reference. Possible values - “No”, “Yes” or Empty. Default value - “Yes” or Empty.
USE_DOUBLE	This options controls the conversion of NUMBER data type, when migrating from Oracle to Java. For cases when NUMBER data type used without precision and scale, when NUMBER(n,0) and n >= 19, and when NUMBER(n,m) with m !=0, such cases will be converted to BigDecimal by default. But if this option is set to “Yes”, such cases will be converted to Double data type. Possible values “Yes”, “No” or empty. Default value - “No” or Empty.
SOURCE_APP_TYPE	This option defines the source application type when migrating to Java code, like “ORACLE FORMS”. For the whole list of supported source application please contact our support team: support@ispirer.com

Example:

[JAVA]
CONNECTION=single
CONNECTIONURL=jdbc:oracle:thin:@localhost:1521:xe
USERNAME=oracle
PASSWORD=oracle

[JAVA]
CONNECTION=SINGLE
CONNECTIONURL=jdbc:informix-sqli://192.168.2.94:1526/test:INFORMIXSERVER=ol_vmdbsrv007 
USERNAME=informix 
PASSWORD=Ifmx_9.4

Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays