cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Evgeny Ryabitskiy <>
Subject Re: [jira] Closed: (CAY-304) SQLTemplates and Batches Support
Date Wed, 13 Jan 2010 15:17:33 GMT
Actually I am really missing for nice Batch support when I have to do
mass insert in some table.
There was some issue to move data between databases (from MS SQL to Oracle).

Chain is slow when you are moving huge tables.

For now I am using InsertBatchQuery but is little bit painful :(
InsertBatchQuery  oriented for internal use and requires DbEntity to
be instantiated. So I am loading DB meta data to form DbEntity  (like
our reverse engineering is working) .

maybe we could do such embedded feature? Make InsertBatchQuery  as API
(external) add there DbEntity  reverse loading (and DbEntity caching).
it should be very useful!


2010/1/13 Andrus Adamchik (JIRA) <>:
>     [
> Andrus Adamchik closed CAY-304.
> -------------------------------
>    Resolution: Won't Fix
> the closest analog is querychain, although it uses separate preparedstatements
>> SQLTemplates and Batches Support
>> --------------------------------
>>                 Key: CAY-304
>>                 URL:
>>             Project: Cayenne
>>          Issue Type: Improvement
>>          Components: Core Library
>>    Affects Versions: 1.2 branch
>>            Reporter: Andrus Adamchik
>>            Assignee: Andrus Adamchik
>>            Priority: Minor
>>             Fix For: Undefined future
>> 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.
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.

View raw message