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: "-Dframework=DerbyNetClient"? (Re: BulkInsert ? (Re: DERBY-167 has done but ...))
Date Thu, 12 May 2005 00:21:31 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Tomohito,<br>
<br>
How is the patch comming along? Were you able to apply both Dan's and
my comments? Glad you resolved the problem with derbyAll suite. Post
your patch when ready to be reviewed.<br>
<br>
I have created a sub-task (<a
 href="http://issues.apache.org/jira/browse/DERBY-275">Derby-275</a>)
to document new syntax once done. We don't have to worry about this for
now.<br>
<br>
Do attempt both soft-upgrade and full upgrades to see if the patch
works as expected.<br>
<br>
Satheesh<br>
<br>
TomohitoNakayama wrote:<br>
<blockquote cite="mid000c01c5562b$bd08cc20$2000a8c0@Arkat" type="cite">Hello.
  <br>
  <br>
In derbynetmats.properties,
  <br>
<a class="moz-txt-link-freetext" href="http://svn.apache.org/repos/asf/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.properties">http://svn.apache.org/repos/asf/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.properties</a>
  <br>
cofiguration was as next ...
  <br>
  <br>
framework=DerbyNet
  <br>
  <br>
I think this should be ,
  <br>
framework=DerbyNetClient.
  <br>
  <br>
This may be reason....
  <br>
  <br>
#And second reason is that I don't know much about common knoledge of
test suite ;P
  <br>
#I feel that derbyall test suite does not suit for my task....
  <br>
  <br>
Thanks.
  <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: "Myrna van Lunteren"
<a class="moz-txt-link-rfc2396E" href="mailto:m.v.lunteren@gmail.com">&lt;m.v.lunteren@gmail.com&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: Wednesday, May 11, 2005 2:04 AM
  <br>
Subject: Re: "-Dframework=DerbyNetClient"? (Re: BulkInsert ? (Re:
DERBY-167 has done but ...))
  <br>
  <br>
  <br>
Hi,
  <br>
  <br>
Well, derbyall runs derbynetmats &amp; derbynetclientmats. With
  <br>
derbynetmats, the intent of the suite is to test derbynet, i.e.
  <br>
networkserver via IBMs Universal JDBC driver ('db2jcc*.jar'). With
  <br>
derbynetclientmats, the intent of the suite is to test the (new)
  <br>
derbyclient - and thus, in that subsuite, -Dframework=DerbyNetClient.
  <br>
  <br>
So, it's not the default, the default framework is none - which means,
  <br>
using the embedded driver &amp; not networkserver at all. The property
  <br>
gets set by the harness because it's in the derbynetmats.properties
  <br>
file.
  <br>
  <br>
RunSuite derbyall should not be run with any framework properties
  <br>
passed in...the individual suites will add the framework properties as
  <br>
needed.
  <br>
  <br>
As to why you got a hang...??? If you have the db2jcc*.jar in your
  <br>
classpath, it should just run, if you don't it should just skip that
  <br>
test. I've not seen that test hang recently...You should check what
  <br>
the last thing is the test did - this you would see in the .tmp file.
  <br>
Also, do other derbynetmats tests pass? Also, the derbynet.out and
  <br>
derbynet.err (drill down into the derbynetmats dir untill you find
  <br>
them) will have more info.
  <br>
  <br>
Myrna
  <br>
  <br>
  <br>
On 5/10/05, TomohitoNakayama <a class="moz-txt-link-rfc2396E" href="mailto:tomonaka@basil.ocn.ne.jp">&lt;tomonaka@basil.ocn.ne.jp&gt;</a>
wrote:
  <br>
  <blockquote type="cite">Follows ....
    <br>
    <br>
&gt; Well .. I'm not sure default command option "-Dframework=DerbyNet"
    <br>
&gt; generated by RunSuite ....
    <br>
    <br>
This means that I wonder why default of the option is this value...
    <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 -----
    <br>
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: Tuesday, May 10, 2005 10:45 PM
    <br>
Subject: "-Dframework=DerbyNetClient"? (Re: BulkInsert ? (Re: DERBY-167
has
    <br>
done but ...))
    <br>
    <br>
&gt; Hello.
    <br>
&gt;
    <br>
&gt; I have tried alljava test suite , but failed in executing
    <br>
&gt; DerbyNetAutoStart.
    <br>
&gt; Many hours but the test does not finised.
    <br>
&gt;
    <br>
&gt; Executing command generated by RunSuite for that test was as next:
    <br>
&gt; Execute command:
    <br>
&gt; java -DjavaCmd=java -Dframework=DerbyNet -Dtimeout=60 -Djdk12te
    <br>
&gt; st=true
-Doutputdir=C:\ProgramDev\derbyUser\derbyall.20050510\derbyall\derbynetm
    <br>
&gt; ats\DerbyNet\derbynetmats
-Dtopsuitedir=C:\ProgramDev\derbyUser\derbyall.2005051
    <br>
&gt; 0\derbyall\derbynetmats\DerbyNet
-Dtopreportdir=C:\ProgramDev\derbyUser\derbyall
    <br>
&gt; .20050510\derbyall\derbynetmats
-Drundir=C:\ProgramDev\derbyUser\derbyall.200505
    <br>
&gt; 10
-DtestSpecialProps=derby.debug.true=enableBtreeConsistencyCheck^derby.stream.
    <br>
&gt;
error.logSeverityLevel=0^excludeJCC=at-or-after:3.0,when-at-or-before:jdk1.3.1^r
    <br>
&gt; unwithj9=false -Dsuitename=derbynetmats:derbynetmats
-Dtopsuitename=derbyall
    <br>
&gt; org
    <br>
&gt; .apache.derbyTesting.functionTests.harness.RunTest
    <br>
&gt; derbynet/DerbyNetAutoStart.ja
    <br>
&gt; va
    <br>
&gt;
    <br>
&gt; Seeing next url , I found option of "-Dframework=DerbyNetClient"
is &gt; needed
    <br>
&gt; for RunTest.
    <br>
&gt;
<a class="moz-txt-link-freetext" href="http://svn.apache.org/repos/asf/incubator/derby/code/trunk/java/testing/README.htm">http://svn.apache.org/repos/asf/incubator/derby/code/trunk/java/testing/README.htm</a>
    <br>
&gt;
    <br>
&gt; Adding above option to RunSuite also.
    <br>
&gt; After that test seems to be done.
    <br>
&gt;
    <br>
&gt; Well .. I'm not sure default command option "-Dframework=DerbyNet"
    <br>
&gt; generated by RunSuite ....
    <br>
&gt;
    <br>
&gt; Best regards.
    <br>
&gt;
    <br>
&gt; /*
    <br>
&gt;
    <br>
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Tomohito
Nakayama
    <br>
&gt;&nbsp;&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>
&gt;&nbsp;&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>
&gt;
    <br>
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Naka
    <br>
&gt;&nbsp;&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>
&gt;
    <br>
&gt; */
    <br>
&gt; ----- Original Message -----
    <br>
&gt; From: "TomohitoNakayama" <a class="moz-txt-link-rfc2396E" href="mailto:tomonaka@basil.ocn.ne.jp">&lt;tomonaka@basil.ocn.ne.jp&gt;</a>
    <br>
&gt; 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>
&gt; Sent: Tuesday, May 10, 2005 8:37 PM
    <br>
&gt; Subject: Re: BulkInsert ? (Re: DERBY-167 has done but ...)
    <br>
&gt;
    <br>
&gt;
    <br>
&gt;&gt; Hello.
    <br>
&gt;&gt;
    <br>
&gt;&gt; I see.
    <br>
&gt;&gt; I understood bulk insert.
    <br>
&gt;&gt; Thank you.
    <br>
&gt;&gt; Now, I have just tryed derbyall-test problem and there seems
to be
    <br>
&gt;&gt; trouble in derbynet/DerbyNetAutoStart..
    <br>
&gt;&gt;
    <br>
&gt;&gt; I will report it in detail later.
    <br>
&gt;&gt;
    <br>
&gt;&gt; Best regards.
    <br>
&gt;&gt; /*
    <br>
&gt;&gt;
    <br>
&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Tomohito Nakayama
    <br>
&gt;&gt;&nbsp;&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>
&gt;&gt;&nbsp;&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>
&gt;&gt;
    <br>
&gt;&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Naka
    <br>
&gt;&gt;&nbsp;&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>
&gt;&gt;
    <br>
&gt;&gt; */
    <br>
&gt;&gt; ----- Original Message -----
    <br>
&gt;&gt; From: "Kathey Marsden" <a class="moz-txt-link-rfc2396E" href="mailto:kmarsdenderby@sbcglobal.net">&lt;kmarsdenderby@sbcglobal.net&gt;</a>
    <br>
&gt;&gt; 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>
&gt;&gt; Sent: Tuesday, May 10, 2005 5:02 AM
    <br>
&gt;&gt; Subject: Re: BulkInsert ? (Re: DERBY-167 has done but ...)
    <br>
&gt;&gt;
    <br>
&gt;&gt;
    <br>
&gt;&gt;&gt; Satheesh Bandaram wrote:
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt;&gt; BulkInsert is an internal mechanism, that gets used
when you import
    <br>
&gt;&gt;&gt;&gt; data into a table, using Derby's import mechanism.
    <br>
&gt;&gt;&gt;&gt; (SYSCS_UTIL.SYSCS_IMPORT_TABLE
    <br>
&gt;&gt;&gt;&gt; <a class="moz-txt-link-rfc2396E" href="http://incubator.apache.org/derby/docs/ref/">&lt;http://incubator.apache.org/derby/docs/ref/&gt;</a>)
This is not directly
    <br>
&gt;&gt;&gt;&gt; exposed to applications using JDBC or SQL, so there is
no way to
    <br>
&gt;&gt;&gt;&gt; directly invoke it. If you write some test cases for
your feature
    <br>
&gt;&gt;&gt;&gt; using this procedure, you are testing bulkInsert code.
Are you
    <br>
&gt;&gt;&gt;&gt; familiar with importing/exporting tables? Looking at
Derby manuals &gt;&gt;&gt;&gt; for
    <br>
&gt;&gt;&gt;&gt; information would be very useful.
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt; I think you could add a test to tools/ieptests.sql
    <br>
&gt;&gt;&gt; which tests loading a table with an identity column.
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt; Kathey
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;&gt; --
    <br>
&gt;&gt;&gt; No virus found in this incoming message.
    <br>
&gt;&gt;&gt; Checked by AVG Anti-Virus.
    <br>
&gt;&gt;&gt; Version: 7.0.308 / Virus Database: 266.11.6 - Release
Date: 2005/05/06
    <br>
&gt;&gt;&gt;
    <br>
&gt;&gt;
    <br>
&gt;&gt;
    <br>
&gt;&gt; --
    <br>
&gt;&gt; No virus found in this outgoing message.
    <br>
&gt;&gt; Checked by AVG Anti-Virus.
    <br>
&gt;&gt; Version: 7.0.308 / Virus Database: 266.11.7 - Release Date:
2005/05/09
    <br>
&gt;&gt;
    <br>
&gt;&gt;
    <br>
&gt;&gt;
    <br>
&gt;&gt;
    <br>
&gt;&gt; --
    <br>
&gt;&gt; No virus found in this incoming message.
    <br>
&gt;&gt; Checked by AVG Anti-Virus.
    <br>
&gt;&gt; Version: 7.0.308 / Virus Database: 266.11.7 - Release Date:
2005/05/09
    <br>
&gt;&gt;
    <br>
&gt;&gt;
    <br>
&gt;
    <br>
&gt;
    <br>
&gt;
    <br>
&gt; --
    <br>
&gt; No virus found in this outgoing message.
    <br>
&gt; Checked by AVG Anti-Virus.
    <br>
&gt; Version: 7.0.308 / Virus Database: 266.11.7 - Release Date:
2005/05/09
    <br>
&gt;
    <br>
&gt;
    <br>
&gt;
    <br>
&gt;
    <br>
&gt; --
    <br>
&gt; No virus found in this incoming message.
    <br>
&gt; Checked by AVG Anti-Virus.
    <br>
&gt; Version: 7.0.308 / Virus Database: 266.11.7 - Release Date:
2005/05/09
    <br>
&gt;
    <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.7 - Release Date: 2005/05/09
    <br>
    <br>
    <br>
  </blockquote>
  <br>
  <br>
  <br>
</blockquote>
</body>
</html>


Mime
View raw message