What is 'Native SQL' in SAP BC-JAS - Java Application Server?

Native SQL - Overview

• Component: BC-JAS

• Component Name: Java Application Server

• Description: A support layer within the Open SQL for Java framework. Native SQL enables the use of specific database features. This layer does not guarantee full database portability, but still it provides some of the enhancements available within the Open SQL for Java framework - namely, statement pooling and SQL Trace.

Native SQL - Details

• 
  Key Concepts: 
  Native SQL is a feature of the BC-JAS Java Application Server that allows developers to write SQL statements directly in the Java code. This allows developers to access and manipulate data stored in a database without having to use a separate SQL query language. Native SQL is an efficient way to access and manipulate data stored in a database, as it eliminates the need for multiple layers of abstraction. 
  
  How to use it: 
  To use Native SQL, developers must first create a connection to the database. This can be done using the Java Database Connectivity (JDBC) API. Once the connection is established, developers can write SQL statements directly in the Java code. The SQL statements can then be executed against the database, allowing developers to access and manipulate data stored in the database. 
  
  Tips & Tricks: 
  When using Native SQL, it is important to ensure that all SQL statements are properly formatted and that all parameters are correctly specified. Additionally, it is important to ensure that all SQL statements are properly tested before being executed against the database. This will help ensure that any errors or unexpected results are caught before they cause any issues with the application. 
  
  Related Information: 
  For more information on Native SQL and how to use it with the BC-JAS Java Application Server, please refer to the official SAP