[CAY-304] SQLTemplates and Batches Support

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 1.2 branch
• Fix Version/s: Undefined future
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 11/Apr/05 02:02
• Updated: 13/Jan/10 14:10
• Resolved: 13/Jan/10 14:10

Description

I was just doing some testing with OpenBase and one annoying thing was the lack of batch support in SQLTemplate. Each SQLTemplate corresponds to a single JDBC statement, and those expect just one command...

I suggest having another Velocity directive (say "#go") that will separate individual statements in the template. This way we can build (sort of) db-independent batches. Scheduling this for 1.2

Also this feature should make preparation of DB for unit testing MUCH simpler.