Ispirer Website Ispirer Capabilities - Java Conversion Free Trial

Sqlways.ini File - Section [JAVA]

This article describes sqlways.ini file's [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, by default SQLWays will assign 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, by default SQLWays will assign 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, by default SQLWays will assign “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, you 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 specifies 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”, default conversion will be used. 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 be 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 set to “Yes”, 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”, 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. The cases when NUMBER data type is used without precision and scale, when NUMBER(n,0) and n >= 19, and when NUMBER(n,m) with m !=0, 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, for example “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