Scriptella drivers matrix

Built-in and community drivers for databases, files, directories, scripting languages, and application frameworks. See also the driver package Javadoc.

JDBC bridge drivers

Scriptella provides built-in adapters for popular databases. See the JDBC bridge Javadoc for common properties and behaviour.

Current JDBC guidance covers PostgreSQL, MariaDB, MySQL, Oracle, and SQL Server. PostgreSQL and MariaDB have full release validation; MySQL has targeted validation. Oracle Free and SQL Server have focused public real-database compatibility tests through the Scriptella Testcontainers suite, but this is not a broad compatibility or certification matrix. See the core database compatibility matrix for details, driver links, and classpath examples.

Adapter Driver name Native driver Notes
IBM AS/400 Database scriptella.driver.as400.Driver com.ibm.as400.access.AS400JDBCDriver
CUBRID Database scriptella.driver.cubrid.Driver cubrid.jdbc.driver.CUBRIDDriver
DB2 Database scriptella.driver.db2.Driver com.ibm.db2.jcc.DB2Driver
Derby Database scriptella.driver.derby.Driver org.apache.derby.jdbc.ClientDriver; org.apache.derby.jdbc.EmbeddedDriver
H2 Database scriptella.driver.h2.Driver org.h2.Driver The primary bundled database for Scriptella's unit tests and examples.
JNDI scriptella.driver.jndi.Driver Any JDBC driver Works with JNDI-bound data source connections, useful in Java EE environments.
MariaDB Database scriptella.driver.mariadb.Driver org.mariadb.jdbc.Driver First-class adapter for jdbc:mariadb: URLs; candidate matrix tested with MariaDB Connector/J 3.5.7 and MariaDB 11.8.8.
Microsoft SQL Server Database scriptella.driver.mssql.Driver com.microsoft.sqlserver.jdbc.SQLServerDriver Preferred class for jdbc:sqlserver: URLs; focused public Linux Testcontainers coverage, not a broad release matrix.
MySQL Database scriptella.driver.mysql.Driver com.mysql.cj.jdbc.Driver Targeted lane for jdbc:mysql: URLs, tested with Connector/J 26.7.0 and MySQL Server 8.4.11; not a broad compatibility matrix.
Oracle Database scriptella.driver.oracle.Driver oracle.jdbc.OracleDriver Preferred class for jdbc:oracle: URLs, including simplified handling of PL/SQL blocks; focused public Oracle Free Testcontainers coverage, not a broad release matrix.
PostgreSQL Database scriptella.driver.postgresql.Driver org.postgresql.Driver First-class adapter for jdbc:postgresql: URLs; candidate matrix tested with pgJDBC 42.7.13 and PostgreSQL 17.11.
Spring Framework scriptella.driver.spring.Driver Any JDBC driver Works with Spring-managed data source connections. Requires scriptella.driver.spring.EtlExecutorBean in the Spring configuration.
Sybase Database scriptella.driver.sybase.Driver com.sybase.jdbc3.jdbc.SybDriver
JDBC Driver for Excel Spreadsheets scriptella.driver.xls.Driver net.pcal.sqlsheet.XlsDriver Interact with Microsoft Excel spreadsheets using SQL statements.

Non-JDBC drivers

Adapter Driver name Notes
Autodiscovery scriptella.driver.auto.Driver Automatically discovers a suitable driver based on the specified URL.
CSV scriptella.driver.csv.Driver Write and query CSV files.
Janino scriptella.driver.janino.Driver Embed Java code in <query> and <script> elements.
JEXL scriptella.driver.jexl.Driver Use JEXL scripts in <query> and <script> elements.
LDAP scriptella.driver.ldap.Driver Execute LDIF scripts and search-filter queries.
MongoDB org.scriptella.mongodb.Driver Integrates MongoDB with Scriptella.
Mail scriptella.driver.mail.Driver Send email via SMTP.
javax.script bridge scriptella.driver.script.Driver Optional JSR 223 bridge for scripting languages such as JavaScript, JRuby, and Groovy. Not required for ordinary ETL work. If you use JavaScript, add a JSR-223 engine to the application classpath; the binary distribution includes official Rhino 1.9.1 under lib/ for that case. Maven and embedded consumers add org.mozilla:rhino-engine:1.9.1 themselves.
Scriptella driver scriptella.driver.scriptella.Driver Run nested Scriptella ETL files. Similar to Ant's <ant> task, useful for splitting large ETL files into sub-projects.
Shell scriptella.driver.shell.Driver Execute operating-system shell commands as scripts or queries. Queries export each output line as a row. Runs with the permissions of the Scriptella process.
Text scriptella.driver.text.Driver Work with text data. Supports regular expressions for querying and Ant-style property expansion in output files.
Velocity scriptella.driver.velocity.Driver Integrate Velocity templates into script files.
vtd-xml scriptella.driver.vtdxml.Driver Community vtd-xml XPath driver for Scriptella.
XPath scriptella.driver.xpath.Driver Query XML files with XPath expressions.