scriptella.jdbc

As specified in Service Provider API all JDBC drivers are registered via this bridge. This procedure is transparent to end user, he only have to specify jdbc driver class name or an alias.

General information

JDBC Bridge Properties

JDBC bridge makes the following configuration properties available in configuration element:

Properties Substitution

Example:

var=_name
id=11
--------------------------------------
select * FROM table${var} where id=?id
-- is transformed to a JDBC prepared statement---
select * FROM table_name where id=?
-- where parameter id=11

Notes:

• $ prefixed expressions are substituted in all parts except comments.
• ? prefixed expressions are not substituted inside quotes and comments.

Example:

--only ${prop} and ?surname are handled
     SELECT * FROM "Table" WHERE NAME="?John${prop}" and SURNAME=?surname;
    

Examples

    <connection id="in" driver="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:file:tmp" user="sa" classpath="hsqldb.jar">
        #Disable cache - just for example
        statement.cache=0
        #Set SQL statements separator
        statement.separator=;
    </connection>

    <connection id="out" driver="h2" url="jdbc:h2:file:out" user="sa"/>
    <query connection-id="in">
        SELECT * from Bug
        <script connection-id="out">
            INSERT INTO Bug VALUES (?ID, ?priority, ?summary, ?status);
        </script>
    </query>

This class defines a strategy for handling specific parameters like URL and by default provides a generic behaviour for any objects.

Configuration by exception is the general philosophy of this class, i.e. most of the conversions must be performed by a provided resultset/preparedstatement and custom conversions are applied only in rare cases.