JBStrap Native Sql

JPA DAO API enables you to execute native SQL statements and also to start a database connection which may be used as JDBC. You can also query a sequence from the database if you use a database that supports sequences. All this means that the API is perfectly capable of servicing any type of request.

When using native SQL statements, the API supports queries ( select ) and modification requests. Upon executing the statements, the results will be returned in a list of data records, thereby ensuring compatibility with the framework. Also, you can send DDL statements to the database, as this is how you can modify a data structure in run-time.

Getting a standard JDBC connection using the JPA DAO API:

Executing a native SQL query without parameters:

         List<DataRecord> result = JpaDaoAPI.runNativeSelect("select * from table_name");
        

Executing a native SQL query and parameter binding:

         List<DataRecord> result = JpaDaoAPI.runNativeSelect("select * from table_name where column1 = ? and column2 < ?", 100, 50);
        

Executing native DML statements without parameters:

         JpaDaoAPI.runNativeStatement("update table_name set column1 = ’value’ where id = 25");
        

Executing a native DML statement and parameter binding:

         JpaDaoAPI.runNativeStatement("update table_name, set column1 = ? where id = ?", "value", 25);
        

Executing a native DDL statement:

         JpaDaoAPI.runNativeStatement("create table table_name (id number not null, column1 varchar2(255))");
        