Snipplr

(HTML) Print request details in JSP - ejboy

Fri, 08 Apr 2011 00:39:56 UTC

(XML) Load CSV data into a database - ejboy

Fri, 23 Feb 2007 13:51:21 UTC

This example demonstrates usage of Scriptella ETL Tool to load CSV data into a database table.

(XML) Copy table from one database to another - ejboy

Fri, 23 Feb 2007 13:49:49 UTC

This Scriptella ETL script copies all rows from Src_Table to Dest_Table. Src_Table contains the following columns: id, first_name, last_name Dest_Table contains the following columns: id, name The name column of the Dest_Table is produced by a concatenation of first_name and last_name from the Src_Table This example demonstrates HSQLDB-To-Oracle copy procedure, although it works between virtually any databases.

(XML) ETL Script to Insert BLOB from File into a Database - ejboy

Fri, 23 Feb 2007 13:46:53 UTC

Scriptella ETL allows inserting files into a database. This is achieved by a simple bind variables extension syntax ?{file ...}. The following sample initializes table of music tracks. Each track has a DATA field containing a file loaded from an external location. File song1.mp3 is stored in the same directory as etl.xml and song2.mp3 is loaded from the web: