BulkInsert ? (Re: DERBY-167 has done but ...)

[TomohitoNakayama]

Hello.

Satheesh Bandaram wrote:
>Import code actually uses bulkInsert option, so it would be good to test 
>this code path too. I can help, if needed, on these tests. Before commiting 
>the patch, it would be good to add more tests

Can I execute bulkInsert using next method ?
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#executeBatch()

Best regards.

/*

         Tomohito Nakayama
         [EMAIL PROTECTED]
         [EMAIL PROTECTED]

         Naka
         http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/
----- Original Message ----- 
From: "TomohitoNakayama" <[EMAIL PROTECTED]>
To: "Derby Development" <derby-dev@db.apache.org>
Sent: Saturday, May 07, 2005 1:44 AM
Subject: Re: DERBY-167 has done but ...


> Hello.
>
>>created with the new identity option. Import code actually uses bulkInsert 
>>option, so it would be good to test this code path too. I can help, if
>> >needed, on these tests. Before commiting the patch, it would be good to
>>add more tests in general.
>
> I don't know much about bulkInsert option.
> Can you tell me entry point for the information about that ?
>
> Best regards.
>
>
> /*
>
>         Tomohito Nakayama
>         [EMAIL PROTECTED]
>         [EMAIL PROTECTED]
>
>         Naka
>         http://www5.ocn.ne.jp/~tomohito/TopPage.html
>
> */
> ----- Original Message ----- 
> From: Satheesh Bandaram
> To: Derby Development
> Sent: Friday, May 06, 2005 2:04 AM
> Subject: Re: DERBY-167 has done but ...
>
>
> Great job getting this done. This is indeed a very useful Enhancement to 
> Derby.
>
> Looking briefly at the attached patch, some comments:
>
> I think syntax for GENERATED BY DEFAULT needs to include the BY, according 
> to SQL standard.
> One of the main uses of this new clause is for importing data into 
> IDENTITY columns. I would like to see some tests that import data into 
> tables created with the new identity option. Import code actually uses 
> bulkInsert option, so it would be good to test this code path too. I can 
> help, if needed, on these tests. Before commiting the patch, it would be 
> good to add more tests in general.
> I couldn't fully apply the patch. Had issues with two files, 
> ResultColumnList and ColumnDescriptor. I think these files might have been 
> updated since you started working on the patch. It would be good if you 
> can merge up to the latest version.
>
> Again, great to see the patch.
>
> Satheesh
>
> TomohitoNakayama wrote:
> Hello.
>
> I think coding for solution-1 of DERBY-167 has done.
> I attach patch file to this mail for others to confirm it.
>
> Relating test , autoincrement and columnDefaults , was passed.
>
>
> However, In derbyall test , I found many errors which seems not caused by 
> my modification.
> Errors seems to be devided three kind ...
> 1:Error of parameterMapping. I don't know what is parameter Mapping mean,
> but file names told so.
> 2:Error of i18n. It seems that English message was generated though test 
> assume Spanish.
> 3:Error of derbynetclientmats.
>
> I uploaded $TEST_DIR/derbyall_fail.txt and $TEST_DIR/derbyall_diff.txt to 
> my web directory,
> because size was too large.
> http://www5.ocn.ne.jp/~tomohito/20050505/derbyall_fail.txt
> http://www5.ocn.ne.jp/~tomohito/20050505/derbyall_diff.txt
>
> Something is going on ...?
>
>
> Best regards.
>
>
> /*
>
>        Tomohito Nakayama
>        [EMAIL PROTECTED]
>        [EMAIL PROTECTED]
>
>        Naka
>        http://www5.ocn.ne.jp/~tomohito/TopPage.html
>
> */
>
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
>
>
>
>
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
>
>
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
>
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
> 



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 2005/05/06