You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Bryan Pendleton <bp...@amberpoint.com> on 2005/11/01 18:04:24 UTC
Need some help with setting up my Derby development testing environment
Hi all,
I'm still struggling, trying to get a configuration of
my system such that I can run 'derbyall' successfully.
Three questions:
1) java/testing/README.htm does not say anything about
creating a database; it just says to "cd into a directory
that does not have any colons or spaces in it." Do I
need to create a database for the tests to use? Or do they
all create their own databases? If I need to create a
database first, does it need to have any particular
configuration?
2) I'm seeing a bunch of diffs/failures that say "No
Suitable Driver". I'm wondering whether this means that
I don't have my db2jcc driver set up correctly. All I
did was to download the two jar files and put them in
my CLASSPATH before starting derbyall. Should that have
been sufficient? How can I confirm that I've got the
db2jcc driver configured correctly? What else might cause
me to get "No Suitable Driver"?
3) Running 'derbyall', then waiting 6 hours, then staring
at a giant pile of diffs is not really helping me very
much; is there a smaller simple test that I can run to
confirm my environment is set up correcly?
Thanks,
bryan
Re: Need some help with setting up my Derby development testing
environment
Posted by Rick Hillegas <Ri...@Sun.COM>.
Hi Bryan,
(1) The tests will create their own databases. That one you don't have
to worry about.
(2) I'm guessing your problem is that you don't have a properly
configured classpath.
(3) I'm enclosing the scripts which I use to run tests. You should
probably do a test run with just a single test to make sure that
everything's ok. Here's what my various scripts do:
setupClasspath - this script wires together the Derby class tree and the
jar files in trunk/tools/java
setupTests - this script deletes the old test run and invokes the
previous script
runtestsuite - this script invokes the previous script and then runs a
single test suite
runtests - this script invokes the previous script to run the full
derbyall master suite
runonetest - this script invokes setupTests, then runs a single test
If you put these scripts in some directory in your $PATH, you can do the
following:
# this runs derbyall
runtests
# run the bit.sql test from the lang suite
runonetest lang/bit.sql
Hope this helps,
-Rick
Bryan Pendleton wrote:
> Hi all,
>
> I'm still struggling, trying to get a configuration of
> my system such that I can run 'derbyall' successfully.
>
> Three questions:
>
> 1) java/testing/README.htm does not say anything about
> creating a database; it just says to "cd into a directory
> that does not have any colons or spaces in it." Do I
> need to create a database for the tests to use? Or do they
> all create their own databases? If I need to create a
> database first, does it need to have any particular
> configuration?
>
> 2) I'm seeing a bunch of diffs/failures that say "No
> Suitable Driver". I'm wondering whether this means that
> I don't have my db2jcc driver set up correctly. All I
> did was to download the two jar files and put them in
> my CLASSPATH before starting derbyall. Should that have
> been sufficient? How can I confirm that I've got the
> db2jcc driver configured correctly? What else might cause
> me to get "No Suitable Driver"?
>
> 3) Running 'derbyall', then waiting 6 hours, then staring
> at a giant pile of diffs is not really helping me very
> much; is there a smaller simple test that I can run to
> confirm my environment is set up correcly?
>
> Thanks,
>
> bryan
>
Re: Need some help with setting up my Derby development testing
environment
Posted by Rick Hillegas <Ri...@Sun.COM>.
Hi Bryan,
I took a quick look at the first diff file. It was trying to run under
the DerbyNet configuration, which I believe uses the DB2 driver. The
error message says to me that the test can't find the DB2 driver on your
classpath.
Regards,
-Rick
Re: POLL: Remove need for DB2 JDBC driver from Derby build and test
Posted by "David W. Van Couvering" <Da...@Sun.COM>.
I'd be happy to fix this, I just thought I'd follow the process, and I
also thought *perhaps* you might want to own this. I do hope you review
what I write and make sure I'm not misstating anything (no that I ever
do *that* :) ).
Cheers,
David
Myrna van Lunteren wrote:
> I'd rather not spend time - making a patch and all that...- on it right
> now. Maybe you can fix it and commit it too?
> (That is, you *are* a committer? Didn't see your name on:
> http://db.apache.org/whoweare.html)
>
> :-)
>
> Myrna
>
> On 11/1/05, *David W. Van Couvering* <David.Vancouvering@sun.com
> <ma...@sun.com>> wrote:
>
> OK, that's good to know. It looks like I and others have been misled
> that we had to pull these jars down to run tests. Note Bryan's recent
> efforts to get these jars -- I think he was just following the
> instructions in BUILDING.txt.
>
> I can log a JIRA to fix the wording in testing/README.htm to make it
> clear that the DB2 driver is optional (and thus the derbynet tests are
> optional).
>
> David
>
> Daniel John Debrunner wrote:
> > David W. Van Couvering wrote:
> >
> >
> >>I hope I'm not stepping on a landmine here, but does anyone else who
> >>thinks it would be a good thing to remove the need for the DB2 JDBC
> >>driver for our builds and tests? It's fine if it's an optional part,
> >>like support for JDK 1.6, but it doesn't seem right that it's
> required
> >>now that we have our own JDBC driver...
> >
> >
> > Dumb question, in what way is it required?
> >
> > I thought it was alredy optional.
> >
> > As far as I know it is not needed for building.
> >
> > As far as I know the derbynet tests will be skipped if it is not
> in the
> > class path.
> >
> > I thought that this had been the case since Derby was open sourced.
> >
> > Dan.
> >
>
>
>
Re: POLL: Remove need for DB2 JDBC driver from Derby build and test
Posted by Myrna van Lunteren <m....@gmail.com>.
I'd rather not spend time - making a patch and all that...- on it right now.
Maybe you can fix it and commit it too?
(That is, you *are* a committer? Didn't see your name on:
http://db.apache.org/whoweare.html)
:-)
Myrna
On 11/1/05, David W. Van Couvering <Da...@sun.com> wrote:
>
> OK, that's good to know. It looks like I and others have been misled
> that we had to pull these jars down to run tests. Note Bryan's recent
> efforts to get these jars -- I think he was just following the
> instructions in BUILDING.txt.
>
> I can log a JIRA to fix the wording in testing/README.htm to make it
> clear that the DB2 driver is optional (and thus the derbynet tests are
> optional).
>
> David
>
> Daniel John Debrunner wrote:
> > David W. Van Couvering wrote:
> >
> >
> >>I hope I'm not stepping on a landmine here, but does anyone else who
> >>thinks it would be a good thing to remove the need for the DB2 JDBC
> >>driver for our builds and tests? It's fine if it's an optional part,
> >>like support for JDK 1.6, but it doesn't seem right that it's required
> >>now that we have our own JDBC driver...
> >
> >
> > Dumb question, in what way is it required?
> >
> > I thought it was alredy optional.
> >
> > As far as I know it is not needed for building.
> >
> > As far as I know the derbynet tests will be skipped if it is not in the
> > class path.
> >
> > I thought that this had been the case since Derby was open sourced.
> >
> > Dan.
> >
>
>
>
Re: POLL: Remove need for DB2 JDBC driver from Derby build and test
Posted by "David W. Van Couvering" <Da...@Sun.COM>.
OK, that's good to know. It looks like I and others have been misled
that we had to pull these jars down to run tests. Note Bryan's recent
efforts to get these jars -- I think he was just following the
instructions in BUILDING.txt.
I can log a JIRA to fix the wording in testing/README.htm to make it
clear that the DB2 driver is optional (and thus the derbynet tests are
optional).
David
Daniel John Debrunner wrote:
> David W. Van Couvering wrote:
>
>
>>I hope I'm not stepping on a landmine here, but does anyone else who
>>thinks it would be a good thing to remove the need for the DB2 JDBC
>>driver for our builds and tests? It's fine if it's an optional part,
>>like support for JDK 1.6, but it doesn't seem right that it's required
>>now that we have our own JDBC driver...
>
>
> Dumb question, in what way is it required?
>
> I thought it was alredy optional.
>
> As far as I know it is not needed for building.
>
> As far as I know the derbynet tests will be skipped if it is not in the
> class path.
>
> I thought that this had been the case since Derby was open sourced.
>
> Dan.
>
Re: POLL: Remove need for DB2 JDBC driver from Derby build and test
Posted by Francois Orsini <fr...@gmail.com>.
I agree - it is easy to get confused between DerbyNet and DerbyNetClient -
maybe DerbyNet should be renamed ;)
On 11/1/05, Myrna van Lunteren <m....@gmail.com> wrote:
>
> On 11/1/05, Daniel John Debrunner <dj...@debrunners.com> wrote:
> >
> > David W. Van Couvering wrote:
> >
> > > I hope I'm not stepping on a landmine here, but does anyone else who
> > > thinks it would be a good thing to remove the need for the DB2 JDBC
> > > driver for our builds and tests? It's fine if it's an optional part,
> > > like support for JDK 1.6, but it doesn't seem right that it's required
> >
> > > now that we have our own JDBC driver...
> >
> > Dumb question, in what way is it required?
> >
> > I thought it was alredy optional.
> >
> > As far as I know it is not needed for building.
> >
> > As far as I know the derbynet tests will be skipped if it is not in the
> > class path.
> >
> > I thought that this had been the case since Derby was open sourced.
> >
> > Dan.
> >
> >
> Yes. However, it's not explicit in the testing/README.htm, and the section
> on setting up the CLASSPATH includes db2jcc.jar. An oversight. We should
> add a ('optional') behind those jars.
> Myrna
>
Re: POLL: Remove need for DB2 JDBC driver from Derby build and test
Posted by Myrna van Lunteren <m....@gmail.com>.
On 11/1/05, Daniel John Debrunner <dj...@debrunners.com> wrote:
>
> David W. Van Couvering wrote:
>
> > I hope I'm not stepping on a landmine here, but does anyone else who
> > thinks it would be a good thing to remove the need for the DB2 JDBC
> > driver for our builds and tests? It's fine if it's an optional part,
> > like support for JDK 1.6, but it doesn't seem right that it's required
> > now that we have our own JDBC driver...
>
> Dumb question, in what way is it required?
>
> I thought it was alredy optional.
>
> As far as I know it is not needed for building.
>
> As far as I know the derbynet tests will be skipped if it is not in the
> class path.
>
> I thought that this had been the case since Derby was open sourced.
>
> Dan.
>
>
Yes. However, it's not explicit in the testing/README.htm, and the section
on setting up the CLASSPATH includes db2jcc.jar. An oversight. We should add
a ('optional') behind those jars.
Myrna
Re: POLL: Remove need for DB2 JDBC driver from Derby build and test
Posted by Daniel John Debrunner <dj...@debrunners.com>.
David W. Van Couvering wrote:
> I hope I'm not stepping on a landmine here, but does anyone else who
> thinks it would be a good thing to remove the need for the DB2 JDBC
> driver for our builds and tests? It's fine if it's an optional part,
> like support for JDK 1.6, but it doesn't seem right that it's required
> now that we have our own JDBC driver...
Dumb question, in what way is it required?
I thought it was alredy optional.
As far as I know it is not needed for building.
As far as I know the derbynet tests will be skipped if it is not in the
class path.
I thought that this had been the case since Derby was open sourced.
Dan.
POLL: Remove need for DB2 JDBC driver from Derby build and test
Posted by "David W. Van Couvering" <Da...@Sun.COM>.
I hope I'm not stepping on a landmine here, but does anyone else who
thinks it would be a good thing to remove the need for the DB2 JDBC
driver for our builds and tests? It's fine if it's an optional part,
like support for JDK 1.6, but it doesn't seem right that it's required
now that we have our own JDBC driver...
David
Bryan Pendleton wrote:
> Myrna van Lunteren wrote:
>
>> I think your problem is indeed with db2jcc. Your sysinfo reports it's
>> version 1.0:
>> "[/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 -
>> (581)"
>> I think we only support 2.4 and up with derby 10 and up. Try to
>> download a later version if you need jcc.
>
>
> Ah, good.
>
> I was rather confused by this download step in my setup. The link
> in java/testing/README.htm points to:
>
> http://www-128.ibm.com/developerworks/db2/downloads/jcc/
>
> The link on this page asked me to register myself with IBM, which
> I did, and then took me to
>
>
> http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=cloudscape
>
> There are 9 downloads listed on that page, so I went down the list and
> found the thing that looked most likely to me:
>
> 8. Released product: IBM Cloudscape (IBM DB2 JDBC
> Universal Driver, for Cloudscape/Derby)
> IBM Cloudscape V10.1 is a pure, open source-based Java relational
> database management system that can be embedded in Java programs and
> used for online transaction processing (OLTP)
> Operating system: Java, Java2 | Version: 2.4.17 | Size:
> 1.03MB |
> Release date: 04 Oct 2004
>
> This certainly looks like it should be version 2.4.17.
>
> When I clicked on that item, I get a file called db2jcc_for_derby.zip,
> with a readme dated Sep 29, 2004, and jar files dated Aug 24, 2004:
>
> -bash-2.05b$ ls -l /home/bpendleton/downloads/derby/db2jcc/lib
> total 1064
> -r--r--r-- 1 bpendleton users 1077696 Aug 24 2004 db2jcc.jar
> -r--r--r-- 1 bpendleton users 673 Aug 24 2004
> db2jcc_license_c.jar
> -bash-2.05b$
>
> But, as you point out, the Derby Information section in supersimple.diff
> clearly states that I'm running version 1.0 of the driver:
>
> --------- Derby Information --------
> JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derby.jar]
> 10.2.0.0 alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbytools.jar]
> 10.2.0.0 alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbynet.jar]
> 10.2.0.0 alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyclient.jar]
> 10.2.0.0 alpha - (315052M)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc_license_c.jar] 1.0 -
> (581)
>
>
> So, I guess I'm confused: where did I go wrong, and what do I need
> to do differently?
>
> thanks,
>
> bryan
>
>
Re: Need some help with setting up my Derby development testing environment
Posted by Bryan Pendleton <bp...@amberpoint.com>.
> Well, I'm confused too - it's too weird.
OMG! I am very embarrassed.
It turns out that one of the other tools I have on my
machine had copied an old version of db2jcc.jar into
my $JAVA_HOME/jre/lib/ext.
Removing that file solved the problem.
My apologies, and thanks to Myrna for double-checking
my work, and giving me the confidence to look elsewhere
for the problem.
bryan
Re: Need some help with setting up my Derby development testing environment
Posted by Myrna van Lunteren <m....@gmail.com>.
On 11/1/05, Bryan Pendleton <bp...@amberpoint.com> wrote:
>
> Myrna van Lunteren wrote:
> > I think your problem is indeed with db2jcc. Your sysinfo reports it's
> > version 1.0:
> > "[/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)"
> > I think we only support 2.4 and up with derby 10 and up. Try to download
> > a later version if you need jcc.
>
> Ah, good.
>
> I was rather confused by this download step in my setup. The link
> in java/testing/README.htm points to:
>
> http://www-128.ibm.com/developerworks/db2/downloads/jcc/
>
> The link on this page asked me to register myself with IBM, which
> I did, and then took me to
>
>
> http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=cloudscape
>
> There are 9 downloads listed on that page, so I went down the list and
> found the thing that looked most likely to me:
>
> 8. Released product: IBM Cloudscape (IBM DB2 JDBC
> Universal Driver, for Cloudscape/Derby)
> IBM Cloudscape V10.1 is a pure, open source-based Java relational
> database management system that can be embedded in Java programs and
> used for online transaction processing (OLTP)
> Operating system: Java, Java2 | Version: 2.4.17 | Size: 1.03MB |
> Release date: 04 Oct 2004
>
> This certainly looks like it should be version 2.4.17.
>
> When I clicked on that item, I get a file called db2jcc_for_derby.zip,
> with a readme dated Sep 29, 2004, and jar files dated Aug 24, 2004:
>
> -bash-2.05b$ ls -l /home/bpendleton/downloads/derby/db2jcc/lib
> total 1064
> -r--r--r-- 1 bpendleton users 1077696 Aug 24 2004 db2jcc.jar
> -r--r--r-- 1 bpendleton users 673 Aug 24 2004 db2jcc_license_c.jar
> -bash-2.05b$
>
> But, as you point out, the Derby Information section in supersimple.diff
> clearly states that I'm running version 1.0 of the driver:
>
> --------- Derby Information --------
> JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derby.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbytools.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbynet.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyclient.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc_license_c.jar] 1.0 -
> (581)
>
>
> So, I guess I'm confused: where did I go wrong, and what do I need
> to do differently?
>
> thanks,
>
> bryan
>
>
>
Well, I'm confused too - it's too weird. I did the same thing you did but
those same files on my windowze box show it's 2.4 (17). I plopped the zip
file to a linux box & it works there too. file size & dates match to what
you have...
Maybe sysinfo is misbehaving...or maybe the testharness?
I have very few suggestions to figure this out...none very good, I'm afraid.
1. do you get the same result when instead of running a test you do:
java org.apache.derby.tools.sysinfo
(it should get the same result, but...)
2. run the test not with the jars you just built, but use ant all and the
resulting full directory in your classpath (but we did agree that we should
all test with built jars before sub/committing).
3. ..sync up again, ant clobber and rebuild (software madness principles -
do it again, and expect different behavior).
4. still working on further ideas... :-)
In the meantime, why don't you consider yourself mostly up and running. It
is not required to use db2jcc to be a derby developer, although I'd hate to
see the effort you put in already go to waste.
If you don't put db2jcc*.jar in the classpath, you can continue working...
Anyone else have any other suggestions?
Myrna
Re: Need some help with setting up my Derby development testing environment
Posted by Bryan Pendleton <bp...@amberpoint.com>.
Myrna van Lunteren wrote:
> I think your problem is indeed with db2jcc. Your sysinfo reports it's
> version 1.0:
> "[/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)"
> I think we only support 2.4 and up with derby 10 and up. Try to download
> a later version if you need jcc.
Ah, good.
I was rather confused by this download step in my setup. The link
in java/testing/README.htm points to:
http://www-128.ibm.com/developerworks/db2/downloads/jcc/
The link on this page asked me to register myself with IBM, which
I did, and then took me to
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=cloudscape
There are 9 downloads listed on that page, so I went down the list and
found the thing that looked most likely to me:
8. Released product: IBM Cloudscape (IBM DB2 JDBC
Universal Driver, for Cloudscape/Derby)
IBM Cloudscape V10.1 is a pure, open source-based Java relational
database management system that can be embedded in Java programs and
used for online transaction processing (OLTP)
Operating system: Java, Java2 | Version: 2.4.17 | Size: 1.03MB |
Release date: 04 Oct 2004
This certainly looks like it should be version 2.4.17.
When I clicked on that item, I get a file called db2jcc_for_derby.zip,
with a readme dated Sep 29, 2004, and jar files dated Aug 24, 2004:
-bash-2.05b$ ls -l /home/bpendleton/downloads/derby/db2jcc/lib
total 1064
-r--r--r-- 1 bpendleton users 1077696 Aug 24 2004 db2jcc.jar
-r--r--r-- 1 bpendleton users 673 Aug 24 2004 db2jcc_license_c.jar
-bash-2.05b$
But, as you point out, the Derby Information section in supersimple.diff
clearly states that I'm running version 1.0 of the driver:
--------- Derby Information --------
JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
[/home/bpendleton/src/derby-subversion/trunk/jars/insane/derby.jar] 10.2.0.0 alpha - (315052M)
[/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbytools.jar] 10.2.0.0 alpha - (315052M)
[/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbynet.jar] 10.2.0.0 alpha - (315052M)
[/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyclient.jar] 10.2.0.0 alpha - (315052M)
[/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)
[/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc_license_c.jar] 1.0 - (581)
So, I guess I'm confused: where did I go wrong, and what do I need
to do differently?
thanks,
bryan
Re: Need some help with setting up my Derby development testing environment
Posted by Myrna van Lunteren <m....@gmail.com>.
I think your problem is indeed with db2jcc. Your sysinfo reports it's
version 1.0:
"[/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)"
I think we only support 2.4 and up with derby 10 and up. Try to download a
later version if you need jcc.
(Unless of course sysinfo doesn't report it correctly...)
Myrna
On 11/1/05, Bryan Pendleton <bp...@amberpoint.com> wrote:
>
> Thanks for the quick help, everybody!
>
> I am working with trunk as of a few weeks ago. I am building
> all the code from scratch, including building derbyTesting.jar.
> The builds were completely uneventful. I am running with the
> insane jars built by "ant buildjars".
>
> Running store/access.sql was fine.
> Running lang/supersimple.sql was fine.
> Running -Dframework=DerbyNetClient lang/supersimple.sql was fine.
>
> Running -Dframework=DerbyNet lang/supersimple.sql blew up badly.
>
> Attached are a few of the files in the resulting "DerbyNet" subdirectory.
> (I would have sent the whole thing, but this list doesn't accept
> zips :) ).
>
> Do you see the problem from any of the files here?
>
> thanks,
>
> bryan
>
>
> ------------------ Java Information ------------------
> Java Version: 1.4.2_06
> Java Vendor: Sun Microsystems Inc.
> Java home: /usr/local/lib/j2sdk1.4.2_06/jre
> Java classpath:
> /home/bpendleton/src/derby-subversion/trunk/tools/java/jakarta-
> oro-2.0.8.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyTesting.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derby.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbytools.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbynet.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyclient.jar:/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar:/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc_license_c.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_de_DE.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_es.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_fr.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_it.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_ja_JP.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_ko_KR.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_pt_BR.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_zh_CN.jar:/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyLocale_zh_TW.jar
> OS name: Linux
> OS architecture: i386
> OS version: 2.4.21-27.0.2.ELsmp
> Java user name: bpendleton
> Java user home: /home/bpendleton
> Java user dir: /home/bpendleton/src/derby-subversion/tests2
> java.specification.name <http://java.specification.name>: Java Platform
> API Specification
> java.specification.version: 1.4
> --------- Derby Information --------
> JRE - JDBC: J2SE 1.4.2 - JDBC 3.0
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derby.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbytools.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbynet.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/src/derby-subversion/trunk/jars/insane/derbyclient.jar]
> 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc.jar] 1.0 - (581)
> [/home/bpendleton/downloads/derby/db2jcc/lib/db2jcc_license_c.jar] 1.0 -
> (581)
> ------------------------------------------------------
> ----------------- Locale Information -----------------
> Current Locale : [English/United States [en_US]]
> Found support for locale: [de_DE]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [es]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [fr]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [it]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [ja_JP]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [ko_KR]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [pt_BR]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [zh_CN]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> Found support for locale: [zh_TW]
> version: 10.2.0.0 <http://10.2.0.0> alpha - (315052M)
> ------------------------------------------------------
> Framework: DerbyNet
> *** Start: supersimple jdk1.4.2_06 DerbyNet 2005-11-01 10:17:02 ***
> 0a1
> > ERROR 08001: No suitable driver
> 2a4
> > IJ ERROR: Unable to establish connection
> 4 del
> < 0 rows inserted/updated/deleted
> 4a6
> > IJ ERROR: Unable to establish connection
> 6 del
> < 1 row inserted/updated/deleted
> 6a8
> > IJ ERROR: Unable to establish connection
> 8 del
> < A
> 9 del
> < -----
> 10 del
> < 1
> 10a10
> > IJ ERROR: Unable to establish connection
> 12 del
> < 0 rows inserted/updated/deleted
> 12a12
> > IJ ERROR: Unable to establish connection
> 14 del
> < 0 rows inserted/updated/deleted
> 14a14
> > IJ ERROR: Unable to establish connection
> 16 del
> < 1 row inserted/updated/deleted
> 16a16
> > IJ ERROR: Unable to establish connection
> 18 del
> < 1 row inserted/updated/deleted
> 18a18
> > IJ ERROR: Unable to establish connection
> 20 del
> < 1 row inserted/updated/deleted
> 20a20
> > IJ ERROR: Unable to establish connection
> 22 del
> < 1 row inserted/updated/deleted
> 22a22
> > IJ ERROR: Unable to establish connection
> 24 del
> < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> 25 del
> < -----
> 26 del
> < 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> 27 del
> < -----32768 |-2147483648 |-9223372036854775808 |1.2E-37 |2.225E-307
> |2.225E-307 |-56.12 |-123456.123 |one |one |one |01abcd |one
> 28 del
> < NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
> |NULL
> 29 del
> < 32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38
> |999.99 |9999999.999 |one |one |one |01abcd |one
> 29a24
> > IJ ERROR: Unable to establish connection
> 31 del
> < 0 rows inserted/updated/deleted
> 31a26
> > IJ ERROR: Unable to establish connection
> 33 del
> < 0 rows inserted/updated/deleted
> 33a28
> > IJ ERROR: Unable to establish connection
> 35 del
> < 1 row inserted/updated/deleted
> 35a30
> > IJ ERROR: Unable to establish connection
> 37 del
> < 1 row inserted/updated/deleted
> 37a32
> > IJ ERROR: Unable to establish connection
> 39 del
> < SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
> 40 del
> < -----
> 41 del
> < 2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
> 42 del
> < -----32768 |-2147483648 |-9223372036854775808 |1.2E-37 |2.225E-307
> |2.225E-307 |-56.12 |-123456.123 |one |one |one |01abcd |one
> 42a34
> > IJ ERROR: Unable to establish connection
> 44 del
> < 1
> 45 del
> < -----
> 46 del
> < 10
> 46a36
> > IJ ERROR: Unable to establish connection
> 48 del
> < 1
> 49 del
> < -----
> 50 del
> < hello
> 50a38
> > IJ ERROR: Unable to establish connection
> 52 del
> < 1
> 53 del
> < -----
> 54 del
> < 1.2
> 54a40
> > IJ ERROR: Unable to establish connection
> 56 del
> < 0 rows inserted/updated/deleted
> 56a42
> > IJ ERROR: Unable to establish connection
> 59 del
> < ALIASINFO
> 60 del
> < -----
> 60a45
> > IJ ERROR: Unable to establish connection
> 62a48
> > IJ ERROR: Unable to establish connection
> 64 del
> < 0 rows inserted/updated/deleted
> 64a50
> > IJ ERROR: Unable to establish connection
> 66 del
> < 1 row inserted/updated/deleted
> 66a52
> > IJ ERROR: Unable to establish connection
> 68 del
> < A
> 69 del
> < -----
> 70 del
> < 1
> 70a54
> > IJ ERROR: Unable to establish connection
> 71a56
> > IJ ERROR: Unable to establish connection
> 73 del
> < 0 rows inserted/updated/deleted
> 73a58
> > IJ ERROR: Unable to establish connection
> 74a60
> > IJ ERROR: Unable to establish connection
> 76 del
> < A
> 77 del
> < -----
> 78 del
> < 1
> 78a62
> > IJ ERROR: Unable to establish connection
> 80 del
> < 0 rows inserted/updated/deleted
> 80a64
> > IJ ERROR: Unable to establish connection
> 81a66
> > IJ ERROR: Unable to establish connection
> 82a68
> > IJ ERROR: Unable to establish connection
> 94 del
> < 1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20
> |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39
> |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58
> |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77
> |78 |79 |80 |81 |82 |83 |84
> 95 del
> < -----
> 96 del
> < 1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20
> |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39
> |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58
> |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77
> |78 |79 |80 |81 |82 |83 |84
> 96a80
> > IJ ERROR: Unable to establish connection
> 107 del
> < 1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20
> |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39
> |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58
> |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77
> |78 |79 |80 |81 |82 |83 |84 |85 |86
> 108 del
> < -----
> 109 del
> < 1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20
> |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39
> |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58
> |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77
> |78 |79 |80 |81 |82 |83 |84 |85 |86 |87 |88 |89 |90 |91 |92 |93 |94 |95 |96
> |97 |98 |99 |100
> 109a91
> > IJ ERROR: Unable to establish connection
> 113 del
> < 0 rows inserted/updated/deleted
> 113a95
> > IJ ERROR: Unable to establish connection
> 115 del
> < ERROR 22003: The resulting value is outside the range for the data type
> INTEGER.
> 115a97
> > IJ ERROR: Unable to establish connection
> 117 del
> < 1 row inserted/updated/deleted
> 117a99
> > IJ ERROR: Unable to establish connection
> 119 del
> < A
> 120 del
> < -----
> 121 del
> < 1
> 121a101
> > IJ ERROR: Unable to establish connection
> 123 del
> < 0 rows inserted/updated/deleted
> 123a103
> > IJ ERROR: Unable to establish connection
> 126a107
> > IJ ERROR: Unable to establish connection
> 128 del
> < 0 rows inserted/updated/deleted
> 128a109
> > IJ ERROR: Unable to establish connection
> 130a112
> > IJ ERROR: Unable to establish connection
> 132 del
> < 0 rows inserted/updated/deleted
> 132a114
> > IJ ERROR: Unable to establish connection
> 134 del
> < 1 row inserted/updated/deleted
> 134a116
> > IJ ERROR: Unable to establish connection
> 135a118
> > IJ ERROR: Unable to establish connection
> 137 del
> < 1 row inserted/updated/deleted
> 137a120
> > IJ ERROR: Unable to establish connection
> 139 del
> < ij(CONNECTION1)> -- by default, holdability of ResultSet objects created
> using this Connection object is true. Following will set it to false for
> this connection.
> 139a122,123
> > ERROR 08001: No suitable driver
> > ij> -- by default, holdability of ResultSet objects created using this
> Connection object is true. Following will set it to false for this
> connection.
> 141 del
> < ij(CONNECTION1)> prepare s1 as 'select * from t';
> 142 del
> < ij(CONNECTION1)> execute s1;
> 143 del
> < I
> 144 del
> < -----
> 145 del
> < ERROR 40XL1: A lock could not be obtained within the time requested
> 146 del
> < ij(CONNECTION1)> execute s1;
> 147 del
> < I
> 148 del
> < -----
> 149 del
> < ERROR 40XL1: A lock could not be obtained within the time requested
> 150 del
> < ij(CONNECTION1)> -- Bug 5967 - Selecting from 2 lob columns w/ the first
> one having data of length 0
> 150a125,132
> > IJ ERROR: Unable to establish connection
> > ij> prepare s1 as 'select * from t';
> > IJ ERROR: Unable to establish connection
> > ij> execute s1;
> > IJ ERROR: Unable to establish connection
> > ij> execute s1;
> > IJ ERROR: Unable to establish connection
> > ij> -- Bug 5967 - Selecting from 2 lob columns w/ the first one having
> data of length 0
> 152 del
> < 0 rows inserted/updated/deleted
> 153 del
> < ij(CONNECTION1)> insert into t1 values ('', 'some clob');
> 154 del
> < 1 row inserted/updated/deleted
> 155 del
> < ij(CONNECTION1)> select * from t1;
> 156 del
> < C1 |C2
> 157 del
> < -----
> 158 del
> < |some clob
> 159 del
> < ij(CONNECTION1)> select c2 from t1;
> 160 del
> < C2
> 161 del
> < -----
> 162 del
> < some clob
> 163 del
> < ij(CONNECTION1)> insert into t1 values ('', '');
> 164 del
> < 1 row inserted/updated/deleted
> 165 del
> < ij(CONNECTION1)> insert into t1 values ('some clob', '');
> 166 del
> < 1 row inserted/updated/deleted
> 167 del
> < ij(CONNECTION1)> select * from t1;
> 168 del
> < C1 |C2
> 169 del
> < -----
> 170 del
> < |some clob
> 171 del
> < |
> 172 del
> < some clob |
> 173 del
> < ij(CONNECTION1)> select c2 from t1;
> 174 del
> < C2
> 175 del
> < -----
> 176 del
> < some clob
> 177 del
> < ij(CONNECTION1)> drop table t1;
> 178 del
> < 0 rows inserted/updated/deleted
> 179 del
> < ij(CONNECTION1)>
> 179 add
> > IJ ERROR: Unable to establish connection
> > ij> insert into t1 values ('', 'some clob');
> > IJ ERROR: Unable to establish connection
> > ij> select * from t1;
> > IJ ERROR: Unable to establish connection
> > ij> select c2 from t1;
> > IJ ERROR: Unable to establish connection
> > ij> insert into t1 values ('', '');
> > IJ ERROR: Unable to establish connection
> > ij> insert into t1 values ('some clob', '');
> > IJ ERROR: Unable to establish connection
> > ij> select * from t1;
> > IJ ERROR: Unable to establish connection
> > ij> select c2 from t1;
> > IJ ERROR: Unable to establish connection
> > ij> drop table t1;
> > IJ ERROR: Unable to establish connection
> > ij>
> Test Failed.
> *** End: supersimple jdk1.4.2_06 DerbyNet 2005-11-01 10:17:05 ***
>
>
> ERROR 08001: No suitable driver
> ij> -- by default, holdability of ResultSet objects created using this
> Connection object is true. Following will set it to false for this
> connection.
> NoHoldForConnection;
> IJ ERROR: Unable to establish connection
> ij> create table a (a int);
> IJ ERROR: Unable to establish connection
> ij> insert into a values (1);
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> create table b (si smallint,i int, bi bigint, r real, f float, d
> double precision, n5_2 numeric(5,2), dec10_3 decimal(10,3), ch20 char(20),vc
> varchar(20), lvc long varchar, blobCol blob(1000), clobCol clob(1000));
> IJ ERROR: Unable to establish connection
> ij> insert into b values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
> 'one','one','one',cast(X'01ABCD' as blob(1000)),'one');
> IJ ERROR: Unable to establish connection
> ij> insert into b values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
> 2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
> cast(X'01ABCD' as blob(1000)),'one');
> IJ ERROR: Unable to establish connection
> ij> insert into b
> values(null,null,null,null,null,null,null,null,null,null,null,null,null);
> IJ ERROR: Unable to establish connection
> ij> insert into b values(32767,2147483647, 9223372036854775807 ,1.4 ,
> 3.4028235E38 ,3.4028235E38 ,999.99, 9999999.999,'one','one','one',cast(X'01ABCD'
> as blob(1000)), 'one');
> IJ ERROR: Unable to establish connection
> ij> select * from b;
> IJ ERROR: Unable to establish connection
> ij> drop table b;
> IJ ERROR: Unable to establish connection
> ij> create table c (si smallint not null,i int not null , bi bigint not
> null, r real not null, f float not null, d double precision not null, n5_2
> numeric(5,2) not null , dec10_3 decimal(10,3) not null, ch20 char(20) not
> null ,vc varchar(20) not null, lvc long varchar not null, blobCol blob(1000)
> not null, clobCol clob(1000) not null);
> IJ ERROR: Unable to establish connection
> ij> insert into c values(2,3,4,5.3,5.3,5.3,31.13,123456.123,
> 'one','one','one', cast(X'01ABCD' as blob(1000)), 'one');
> IJ ERROR: Unable to establish connection
> ij> insert into c values(-32768,-2147483648, -9223372036854775808 ,1.2E-37,
> 2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one',
> cast(X'01ABCD' as blob(1000)),'one');
> IJ ERROR: Unable to establish connection
> ij> select * from c;
> IJ ERROR: Unable to establish connection
> ij> values(10);
> IJ ERROR: Unable to establish connection
> ij> values('hello');
> IJ ERROR: Unable to establish connection
> ij> values(1.2);
> IJ ERROR: Unable to establish connection
> ij> drop table c;
> IJ ERROR: Unable to establish connection
> ij> -- bug 4430 aliasinfo nullability problem
> select aliasinfo from sys.sysaliases where aliasinfo is null;
> IJ ERROR: Unable to establish connection
> ij> -- test commit and rollback
> autocommit off;
> IJ ERROR: Unable to establish connection
> ij> create table a(a int);
> IJ ERROR: Unable to establish connection
> ij> insert into a values (1);
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> commit;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> rollback;
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> commit;
> IJ ERROR: Unable to establish connection
> ij> autocommit on;
> IJ ERROR: Unable to establish connection
> ij> maximumdisplaywidth 5000;
> ij> --test 84 columns
> values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
> 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
> 21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
> 31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
> 41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
> 51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
> 61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
> 71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
> 81, 82, 83, 84);
> IJ ERROR: Unable to establish connection
> ij> values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
> 11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
> 21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
> 31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
> 41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
> 51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
> 61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
> 71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
> 81, 82, 83, 84, 85, 86, 87, 88, 89, 90,
> 91, 92, 93, 94, 95, 96, 97, 98, 99, 100);
> IJ ERROR: Unable to establish connection
> ij> -- test SQL Error with non-string arguments
> ----- Make sure connection still ok (Bug 4657)
> create table a (a int);
> IJ ERROR: Unable to establish connection
> ij> insert into a values(2342323423) ;
> IJ ERROR: Unable to establish connection
> ij> insert into a values(1);
> IJ ERROR: Unable to establish connection
> ij> select * from a;
> IJ ERROR: Unable to establish connection
> ij> drop table a;
> IJ ERROR: Unable to establish connection
> ij> -- Bug 4694 Test automatic rollback with close of connection
> ----- in ij
> autocommit off;
> IJ ERROR: Unable to establish connection
> ij> create table a (a int);
> IJ ERROR: Unable to establish connection
> ij> -- Bug 4758 - Store error does not return properly to client
> autocommit off;
> IJ ERROR: Unable to establish connection
> ij> create table t (i int);
> IJ ERROR: Unable to establish connection
> ij> insert into t values(1);
> IJ ERROR: Unable to establish connection
> ij> commit;
> IJ ERROR: Unable to establish connection
> ij> insert into t values(2);
> IJ ERROR: Unable to establish connection
> ij> connect 'wombat';
> ERROR 08001: No suitable driver
> ij> -- by default, holdability of ResultSet objects created using this
> Connection object is true. Following will set it to false for this
> connection.
> NoHoldForConnection;
> IJ ERROR: Unable to establish connection
> ij> prepare s1 as 'select * from t';
> IJ ERROR: Unable to establish connection
> ij> execute s1;
> IJ ERROR: Unable to establish connection
> ij> execute s1;
> IJ ERROR: Unable to establish connection
> ij> -- Bug 5967 - Selecting from 2 lob columns w/ the first one having
> data of length 0
> create table t1 (c1 clob(10), c2 clob(10));
> IJ ERROR: Unable to establish connection
> ij> insert into t1 values ('', 'some clob');
> IJ ERROR: Unable to establish connection
> ij> select * from t1;
> IJ ERROR: Unable to establish connection
> ij> select c2 from t1;
> IJ ERROR: Unable to establish connection
> ij> insert into t1 values ('', '');
> IJ ERROR: Unable to establish connection
> ij> insert into t1 values ('some clob', '');
> IJ ERROR: Unable to establish connection
> ij> select * from t1;
> IJ ERROR: Unable to establish connection
> ij> select c2 from t1;
> IJ ERROR: Unable to establish connection
> ij> drop table t1;
> IJ ERROR: Unable to establish connection
> ij>
>
>
> #Derby Properties
> #Tue Nov 01 10:17:00 PST 2005
> derby.locks.deadlockTimeout=3
> derby.locks.waitTimeout=3
>
>
> #Test Properties
> #Tue Nov 01 10:17:00 PST 2005
> ij.showNoConnectionsAtStart=true
> ij.dataSource.createDatabase=create
>
> ij.defaultResourcePackage=/org/apache/derbyTesting/functionTests/tests/lang/
> ij.driver=com.ibm.db2.jcc.DB2Driver
> usedefaults=true
> runwithfoundation=false
> ij.user=APP
> ij.showNoCountForSelect=true
> ij.dataSource.databaseName=wombat
> ij.password=APP
> ij.database=jdbc\:derby\:net\://localhost\:1527/wombat;create\=true
> ij.retrieveMessagesFromServerOnGetMessage=true
> ij.protocol=jdbc\:derby\:net\://localhost\:1527/
>
>
> Server is ready to accept connections on port 1527.
> Shutdown successful.
>
>
>
Re: Need some help with setting up my Derby development testing environment
Posted by Bryan Pendleton <bp...@amberpoint.com>.
Thanks for the quick help, everybody!
I am working with trunk as of a few weeks ago. I am building
all the code from scratch, including building derbyTesting.jar.
The builds were completely uneventful. I am running with the
insane jars built by "ant buildjars".
Running store/access.sql was fine.
Running lang/supersimple.sql was fine.
Running -Dframework=DerbyNetClient lang/supersimple.sql was fine.
Running -Dframework=DerbyNet lang/supersimple.sql blew up badly.
Attached are a few of the files in the resulting "DerbyNet" subdirectory.
(I would have sent the whole thing, but this list doesn't accept
zips :) ).
Do you see the problem from any of the files here?
thanks,
bryan
Re: Need some help with setting up my Derby development testing environment
Posted by Myrna van Lunteren <m....@gmail.com>.
Hi Bryan...
On 11/1/05, Bryan Pendleton <bp...@amberpoint.com> wrote:
>
> Hi all,
>
> I'm still struggling, trying to get a configuration of
> my system such that I can run 'derbyall' successfully.
>
> Three questions:
>
> 1) java/testing/README.htm does not say anything about
> creating a database; it just says to "cd into a directory
> that does not have any colons or spaces in it." Do I
> need to create a database for the tests to use? Or do they
> all create their own databases? If I need to create a
> database first, does it need to have any particular
> configuration?
The tests will create their own databases.
2) I'm seeing a bunch of diffs/failures that say "No
> Suitable Driver". I'm wondering whether this means that
> I don't have my db2jcc driver set up correctly. All I
> did was to download the two jar files and put them in
> my CLASSPATH before starting derbyall. Should that have
> been sufficient? How can I confirm that I've got the
> db2jcc driver configured correctly? What else might cause
> me to get "No Suitable Driver"?
If you do *not* have the db2jcc.jar or db2jcc_license_c.jar in your
classpath, then the tests in the suite 'derbynetmats' should skip. I'm
curious which tests you're seeing the failures.
3) Running 'derbyall', then waiting 6 hours, then staring
> at a giant pile of diffs is not really helping me very
> much; is there a smaller simple test that I can run to
> confirm my environment is set up correcly?
You can run this:
java org.apache.derbyTesting.functionTests.harness.RunTestlang/supersimple.sql
If you're trying for network server with jcc it's like this:
java -Dframework=DerbyNet
org.apache.derbyTesting.functionTests.harness.RunTest lang/supersimple.sql
Network server with derby client goes like this:
java -Dframework=DerbyNetClient
org.apache.derbyTesting.functionTests.harness.RunTest lang/supersimple.sql
If that proves uneventfull, the next step - depending on what you're after,
might be to run derbylang suite instead of derbyall. We'd normally depend on
the nightly results to show us common failures and run derbyall when ready
to create (or commit) a patch.
I'm wondering though how you're running, did you download derbyTesting.jar,
or did you get the trunk, do ant all, and then run with the resulting
classes dir in your classpath?
Myrna
Thanks,
>
> bryan
>
>
Re: Need some help with setting up my Derby development testing environment
Posted by Mike Matrigali <mi...@sbcglobal.net>.
Bryan Pendleton wrote:
> Hi all,
>
> I'm still struggling, trying to get a configuration of
> my system such that I can run 'derbyall' successfully.
>
> Three questions:
>
> 1) java/testing/README.htm does not say anything about
> creating a database; it just says to "cd into a directory
> that does not have any colons or spaces in it." Do I
> need to create a database for the tests to use? Or do they
> all create their own databases? If I need to create a
> database first, does it need to have any particular
> configuration?
All the tests create their own database, in fact most tests
create database, run tests, and get rid of the database.
A few tests are configured to run multiple tests in a single
db. By tests I mean a single .java or .sql file.
>
> 2) I'm seeing a bunch of diffs/failures that say "No
> Suitable Driver". I'm wondering whether this means that
> I don't have my db2jcc driver set up correctly. All I
> did was to download the two jar files and put them in
> my CLASSPATH before starting derbyall. Should that have
> been sufficient? How can I confirm that I've got the
> db2jcc driver configured correctly? What else might cause
> me to get "No Suitable Driver"?
does sound like a jar/classpath issue. See if embedded tests
work to narrow down to see if it is a network server problem.
>
> 3) Running 'derbyall', then waiting 6 hours, then staring
> at a giant pile of diffs is not really helping me very
> much; is there a smaller simple test that I can run to
> confirm my environment is set up correcly?
To test embedded environment try running one test:
java -Doutputdir=/tmp
org/apache/derbyTesting/functionTests/harness/RunTest store/access.sql
>
> Thanks,
>
> bryan
>
>