PowerBuilder

The JDBC database interface is removed from the Database painter

Description

    The PowerBuilder code rule "The JDBC database interface is removed from the Database painter" means that the JDBC database interface is no longer available in the Database painter. This means that the Database painter will no longer be able to connect to databases using the JDBC interface. Instead, users will need to use other database interfaces to connect to databases.

Key Benefits

  • Increased Performance: The JDBC database interface is removed from the Database painter, resulting in increased performance.
  • Reduced Complexity: The JDBC database interface is no longer required, reducing complexity and making the Database painter easier to use.
  • Improved Security: The removal of the JDBC database interface improves security by eliminating potential vulnerabilities.

 

Non-compliant Code Example

SQLCA.DBMS = "JDBC"       //Non compliant code
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='cdata.jdbc.sybase.SybaseDriver',URL='jdbc:sybase:User=myuser;Password=mypassword;Server=localhost;Database=mydatabase;Charset=iso_1;";        //Non compliant code
CONNECT USING SQLCA;
dw_master.SetTransObject(SQLCA);
dw_master.Retrieve();

Visual Expert 2024
 VEPBRULE92