db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: BulkInsert ? (Re: DERBY-167 has done but ...)
Date Mon, 09 May 2005 18:44:55 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-2022-JP"
 http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
BulkInsert is an internal mechanism, that gets used when you import
data into a table, using Derby's import mechanism. (<a
 href="http://incubator.apache.org/derby/docs/ref/">SYSCS_UTIL.SYSCS_IMPORT_TABLE</a>)
This is not directly exposed to applications using JDBC or SQL, so
there is no way to directly invoke it. If you write some test cases for
your feature using this procedure, you are testing bulkInsert code. Are
you familiar with importing/exporting tables? Looking at Derby manuals
for information would be very useful.<br>
<br>
For next steps for your proposed patch, I would recommend applying
Dan's and my suggestions to our changes. Post any questions you may
have. I also think another review after applying the changes would be
useful.<br>
<br>
Satheesh<br>
<br>
TomohitoNakayama wrote:<br>
<blockquote cite="mid000c01c5548e$2fa726e0$2000a8c0@Arkat" type="cite">Hello.
  <br>
  <br>
Satheesh Bandaram wrote:
  <br>
  <blockquote type="cite">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
    <br>
  </blockquote>
  <br>
Can I execute bulkInsert using next method ?
  <br>
<a class="moz-txt-link-freetext" href="http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#executeBatch(">http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#executeBatch(</a>)
  <br>
  <br>
Best regards.
  <br>
  <br>
/*
  <br>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tomohito Nakayama
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-abbreviated"
href="mailto:tomonaka@basil.ocn.ne.jp">tomonaka@basil.ocn.ne.jp</a>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-abbreviated"
href="mailto:tomohito@rose.zero.ad.jp">tomohito@rose.zero.ad.jp</a>
  <br>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Naka
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-freetext"
href="http://www5.ocn.ne.jp/~tomohito/TopPage.html">http://www5.ocn.ne.jp/~tomohito/TopPage.html</a>
  <br>
  <br>
*/
  <br>
----- Original Message ----- From: "TomohitoNakayama"
<a class="moz-txt-link-rfc2396E" href="mailto:tomonaka@basil.ocn.ne.jp">&lt;tomonaka@basil.ocn.ne.jp&gt;</a>
  <br>
To: "Derby Development" <a class="moz-txt-link-rfc2396E" href="mailto:derby-dev@db.apache.org">&lt;derby-dev@db.apache.org&gt;</a>
  <br>
Sent: Saturday, May 07, 2005 1:44 AM
  <br>
Subject: Re: DERBY-167 has done but ...
  <br>
  <br>
  <br>
  <blockquote type="cite">Hello.
    <br>
    <br>
    <blockquote type="cite">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
      <br>
&gt;needed, on these tests. Before commiting the patch, it would be
good to
      <br>
add more tests in general.
      <br>
    </blockquote>
    <br>
I don't know much about bulkInsert option.
    <br>
Can you tell me entry point for the information about that ?
    <br>
    <br>
Best regards.
    <br>
    <br>
    <br>
/*
    <br>
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tomohito Nakayama
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-abbreviated"
href="mailto:tomonaka@basil.ocn.ne.jp">tomonaka@basil.ocn.ne.jp</a>
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-abbreviated"
href="mailto:tomohito@rose.zero.ad.jp">tomohito@rose.zero.ad.jp</a>
    <br>
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Naka
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-freetext"
href="http://www5.ocn.ne.jp/~tomohito/TopPage.html">http://www5.ocn.ne.jp/~tomohito/TopPage.html</a>
    <br>
    <br>
*/
    <br>
----- Original Message ----- From: Satheesh Bandaram
    <br>
To: Derby Development
    <br>
Sent: Friday, May 06, 2005 2:04 AM
    <br>
Subject: Re: DERBY-167 has done but ...
    <br>
    <br>
    <br>
Great job getting this done. This is indeed a very useful Enhancement
to Derby.
    <br>
    <br>
Looking briefly at the attached patch, some comments:
    <br>
    <br>
I think syntax for GENERATED BY DEFAULT needs to include the BY,
according to SQL standard.
    <br>
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.
    <br>
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.
    <br>
    <br>
Again, great to see the patch.
    <br>
    <br>
Satheesh
    <br>
    <br>
TomohitoNakayama wrote:
    <br>
Hello.
    <br>
    <br>
I think coding for solution-1 of DERBY-167 has done.
    <br>
I attach patch file to this mail for others to confirm it.
    <br>
    <br>
Relating test , autoincrement and columnDefaults , was passed.
    <br>
    <br>
    <br>
However, In derbyall test , I found many errors which seems not caused
by my modification.
    <br>
Errors seems to be devided three kind ...
    <br>
1:Error of parameterMapping. I don't know what is parameter Mapping
mean,
    <br>
but file names told so.
    <br>
2:Error of i18n. It seems that English message was generated though
test assume Spanish.
    <br>
3:Error of derbynetclientmats.
    <br>
    <br>
I uploaded $TEST_DIR/derbyall_fail.txt and $TEST_DIR/derbyall_diff.txt
to my web directory,
    <br>
because size was too large.
    <br>
<a class="moz-txt-link-freetext" href="http://www5.ocn.ne.jp/~tomohito/20050505/derbyall_fail.txt">http://www5.ocn.ne.jp/~tomohito/20050505/derbyall_fail.txt</a>
    <br>
<a class="moz-txt-link-freetext" href="http://www5.ocn.ne.jp/~tomohito/20050505/derbyall_diff.txt">http://www5.ocn.ne.jp/~tomohito/20050505/derbyall_diff.txt</a>
    <br>
    <br>
Something is going on ...?
    <br>
    <br>
    <br>
Best regards.
    <br>
    <br>
    <br>
/*
    <br>
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tomohito Nakayama
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-abbreviated"
href="mailto:tomonaka@basil.ocn.ne.jp">tomonaka@basil.ocn.ne.jp</a>
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-abbreviated"
href="mailto:tomohito@rose.zero.ad.jp">tomohito@rose.zero.ad.jp</a>
    <br>
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Naka
    <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a class="moz-txt-link-freetext"
href="http://www5.ocn.ne.jp/~tomohito/TopPage.html">http://www5.ocn.ne.jp/~tomohito/TopPage.html</a>
    <br>
    <br>
*/
    <br>
    <br>
No virus found in this outgoing message.
    <br>
Checked by AVG Anti-Virus.
    <br>
Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
    <br>
    <br>
    <br>
    <br>
    <br>
No virus found in this incoming message.
    <br>
Checked by AVG Anti-Virus.
    <br>
Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
    <br>
    <br>
    <br>
--&nbsp;<br>
No virus found in this outgoing message.
    <br>
Checked by AVG Anti-Virus.
    <br>
Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
    <br>
    <br>
    <br>
    <br>
    <br>
--&nbsp;<br>
No virus found in this incoming message.
    <br>
Checked by AVG Anti-Virus.
    <br>
Version: 7.0.308 / Virus Database: 266.11.5 - Release Date: 2005/05/04
    <br>
    <br>
  </blockquote>
  <br>
  <br>
  <br>
</blockquote>
</body>
</html>


Mime
View raw message