SQL Engine 

Use

This function enables you to choose an SQL type support, which defines the type of database connection you obtain.

Features

SQL Engine enables you to choose one of the following options:

·        Open SQL – the system returns a Database Interface (DBI) CommonConnection. By choosing this option, you choose to use all functions provided by SAP’s Open SQL for Java – that is, database vendor independence, SQL semantics, portability and syntax checks, SQL tracing mechanisms, statement caches, and table buffering.

If you want to use Open SQL, you need to initialize the tables in your database in the Java Dictionary.

·        Native SQL – the system returns a DBI DirectConnection. It provides only a part of the functions of Open SQL for Java – SQL tracing, and statement caching.

·        Vendor SQL – the system returns a standard JDBC connection without using DBI at all

To set the SQL type, you can use:

·        Runtime → Additional tab of JDBC Connector Service in Visual Administrator.

To view this tab, you have to select a DataSource entry from the Resources → DataSources → <applicationName>.

·        <sql-engine> tag from data-sources.dtd. If you do not use this tag, the system uses the Open SQL option as a default. For more information about the DTD, see data-sources.dtd.

See also:

Java Persistence