Question for testing upgrade db

2005-05-05 Thread TomohitoNakayama
Hello. (B (BI have implemented patch for DERBY-167 and try to test upgrade db. (B (BConnecting previous database , next error occured. (B (Bij version 10.1 (Bij> connect 'jdbc:derby:testdb'; (BERROR XJ040: Failed to start database 'testdb', see the next exception for (Bdetails. (BERROR X

Re: Question for testing upgrade db

2005-05-05 Thread Daniel John Debrunner
TomohitoNakayama wrote: > Hello. > > I have implemented patch for DERBY-167 and try to test upgrade db. > > Connecting previous database , next error occured. > > ij version 10.1 > ij> connect 'jdbc:derby:testdb'; > ERROR XJ040: Failed to start database 'testdb', see the next exception > for de

Re: Multiple systems in same VM -- does this really work?

2005-05-05 Thread Daniel John Debrunner
Jeremy Boynes wrote: > We have the same issue embedding Derby in Geronimo. The use of global > system properties is a real problem for us, not only because it > precludes multiple instances in the same JVM but also because it makes > the interface to JMX harder. > > Several people have asked for

Re: Question for testing upgrade db

2005-05-05 Thread TomohitoNakayama
Thank you ! I could run program. Best regards. /* Tomohito Nakayama [EMAIL PROTECTED] [EMAIL PROTECTED] Naka http://www5.ocn.ne.jp/~tomohito/TopPage.html */ - Original Message - From: "Daniel John Debrunner" <[EMAIL PROTECTED]> To: "Derby Development

[jira] Commented: (DERBY-259) [doc] submission formats listing

2005-05-05 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-259?page=comments#action_64538 ] Jean T. Anderson commented on DERBY-259: Regarding Scott's note: > Also, noted that Forrest and OpenOffice License types might not mesh > with Apache.org. This was

Does anyone know about Derby-179?

2005-05-05 Thread Satheesh Bandaram
I was briefly looking at Derby-179. The bug started describing a problem that is actually unsupported syntax on Derby. Then there were couple of notes indicating current problem with Hibernate and Derby integration is Derby-127. Jack seems to be working on Derby-127, so I was wondering if Derby

Re: [patch] [doc] updatable ResultSets [having trouble applying patch]

2005-05-05 Thread Jean T. Anderson
I'm having trouble applying this patch, but perhaps I'm not getting the patch syntax correct. I've succeeded previously applying Jeff's patches that modified just one file, and this is the first time I have tried to apply a patch that modifies more than one file. So, it modifies three files rel

[STATUS] (Derby) Wed May 4 23:45:27 2005

2005-05-05 Thread Rodent of Unusual Size
APACHE DERBY STATUS: Last modified at [$Date: 2005-02-10 15:37:41 -0500 (Thu, 10 Feb 2005) $] by $Author: fuzzylogic $. Web site: http://incubator.apache.org/derby/ Incubator Status Description "Derby" is a snapshot of the IBM's Cloudscape Java relational database. IBM is opening the cod

Re: [PATCH]Derby-229

2005-05-05 Thread Shreyas Kaushik
What would be a good name, rsgetXXXcolumnNames be a good one ? ~ Shreyas Daniel John Debrunner wrote: Shreyas Kaushik wrote: Attached is the new patch taking care of your comments. See inline for answers. ~ Shreyas One of my comments is that the test could be expanded in the future to perfo

Re: Derby-12 and Derby-13 ...

2005-05-05 Thread Shreyas Kaushik
I worked with Dan and submitted the patch for these. I will close these. ~ Shreyas Satheesh Bandaram wrote: Shreyas, since you worked on both these bugs, can close them after confirming they are indeed fixed and we have a test case for both in our testsuites? Since you can close bugs, it is best if

[jira] Resolved: (DERBY-234) Documentation of DateTime types is incomplete

2005-05-05 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-234?page=all ] Jean T. Anderson resolved DERBY-234: Resolution: Fixed Patch applied and committed revision 168252. > Documentation of DateTime types is incomplete > --

Re: [patch] [doc] updatable ResultSets [having trouble applying patch]

2005-05-05 Thread Jean T. Anderson
Jean T. Anderson wrote: By the way, I tried to apply this with the DITA source at revision 168249. Jeff, what was the revision of your local copy when you produced the patch? --There is a backlog of patches to apply in Jira (and which I'll try to catch up on). I'm wondering if it's possible this

Re: [patch] [doc] updatable ResultSets [having trouble applying patch]

2005-05-05 Thread Jeff Levitt
I just created a new patch, and it seems that the "src/" was left off the file names in the first patch. Maybe that has something to do with it? I created the attached diff from the trunk. Its also a more current revision number. Does it work? --- "Jean T. Anderson" <[EMAIL PROTECTED]> wrote:

Re: [patch] [doc] updatable ResultSets [having trouble applying patch]

2005-05-05 Thread scott hutinger
I always use (in linux/unix) patch -p0 < patchfile.diff The -p0 means use the current path. For example, if the diff was created in trunk, then if you are trying to patch in trunk, then I always use -p0. If, for some reason, I was down one level in src, and the diff was from the trunk, then I

Re: [patch] [doc] updatable ResultSets [having trouble applying patch]

2005-05-05 Thread Jeff Levitt
--- scott hutinger <[EMAIL PROTECTED]> wrote: > I always use (in linux/unix) > > patch -p0 < patchfile.diff > > The -p0 means use the current path. For example, if > the diff was > created in trunk, then if you are trying to patch in > trunk, then I > always use -p0. If, for some reason, I w

DERBY-167 has done but ...

2005-05-05 Thread TomohitoNakayama
(BI uploaded $TEST_DIR/derbyall_fail.txt and $TEST_DIR/derbyall_diff.txt to my (Bweb directory, (Bbecause size was too large. (Bhttp://www5.ocn.ne.jp/~tomohito/20050505/derbyall_fail.txt (Bhttp://www5.ocn.ne.jp/~tomohito/20050505/derbyall_diff.txt (B (BSomething is going on ...? (B (B (

Re: DERBY-167 has done but ...

2005-05-05 Thread Kathey Marsden
TomohitoNakayama wrote: (B (B> (B> However, In derbyall test , I found many errors which seems not caused (B> by my modification. (B (B> Errors seems to be devided three kind ... (B> 1:Error of parameterMapping. I don't know what is parameter Mapping mean, (B> but file names told so. (B> 2

Re: [STATUS] (Derby) Wed May 4 23:45:27 2005

2005-05-05 Thread Kathey Marsden
Rodent of Unusual Size wrote: >APACHE DERBY STATUS: >Last modified at [$Date: 2005-02-10 15:37:41 -0500 (Thu, 10 Feb 2005) $] by >$Author: fuzzylogic $. > > > [snip lots of out of date stuff...] I am always a little confused by this email and the STATUS file itself. How often is the STATUS

Re: DERBY-167 has done but ...

2005-05-05 Thread TomohitoNakayama
Hello. (B (BI have execused svn updated , (Bbut code for derbynetclientmats seems not updated. (B (BI will check building. (BThere may be mistake especially where around "sane" option... (B (BBest regards. (B (B (B (B/* (B (B Tomohito Nakayama (B [EMAIL PROTECTED] (B

Re: DERBY-167 has done but ...

2005-05-05 Thread Myrna van Lunteren
Not knowing your classpath, for the i18n failure you describe, I'm guessing that you generated, then ran with jars but you don't have all the locale jars - in particular the spanish one (derbyLocale_es.jar) - in your classpath. re parameterMapping - haven't seent hat fail recently... Myrna On 5/

Re: DERBY-167 has done but ...

2005-05-05 Thread Sunitha Kambhampati
[Kathey Marsden wrote.. ] >> >> For derbynetclientmats You are getting class not found on the new >> ClientDriver which was checked in last week. I am not sure why you are >> not picking it up. I suggest you svn update, ant clobber and rebuild. >> Hopefully that will fix it. >> >> The client drive

Re: DERBY-167 has done but ...

2005-05-05 Thread TomohitoNakayama
Hello. I had made CLASSPATH resemble to that of derby/trunk/frameworks/embedded/bin/setEmbeddedCP.bat. Seeing those, I couldn't find configuration for derbyLocale_es.jar... Hmm... I will try it. Thank you ! Best regards. /* Tomohito Nakayama [EMAIL PROTECTED] [EMAIL PROTEC

Re: DERBY-167 has done but ...

2005-05-05 Thread Jeremy Boynes
TomohitoNakayama wrote: Hello. I have execused svn updated , but code for derbynetclientmats seems not updated. I will check building. There may be mistake especially where around "sane" option... derbynetclientmats was passing for me last night. Did you remember to add the new derbyclient.jar to

Re: [jira] Commented: (DERBY-230) "Schema already exists" when creating a table

2005-05-05 Thread Øystein Grøvlen
I was thinking I should add a test for this bug fix. Since a multithreaded program is needed, I was trying to use the MultiTest framework, but despite trying several approaches I have not been able to reproduce it that way. Note that I in 20 minutes was able to write the Java program that is att

patch review request for Derby-248

2005-05-05 Thread Lance Andersen
Attached are the changes for Derby-248. I validated that ij, dblook and the NetworkServer start happily and i could create a database and dump its contents. -- Lance Andersen email: [EMAIL PROTECTED] Sun Microsystems Inc.phone: (781) 442-2037 1 Network Drive,

Re: [patch] [doc] updatable ResultSets [having trouble applying patch]

2005-05-05 Thread Jean T. Anderson
I used this command last night to commit the patch for DERBY-234 and had no problems: patch -p0 -i derby234.diff I'll try Jeff's new patch. thanks, -jean Jeff Levitt wrote: --- scott hutinger <[EMAIL PROTECTED]> wrote: I always use (in linux/unix) patch -p0 < patchfile.diff The -p0 means use

Re: DataSource class hierarchy in client

2005-05-05 Thread Jeremy Boynes
Satheesh Bandaram wrote: I suspect the class hierarchy has been made this way partly to match Embedded driver. I am still thinking why the Embedded driver does this.. I don't know if it is relevant but most of the implementation in the client code uses ClientDataSource instances rather than the ba

Re: [patch] [doc] updatable ResultSets [having trouble applying patch]

2005-05-05 Thread Jean T. Anderson
Jeff Levitt wrote: I just created a new patch, and it seems that the "src/" was left off the file names in the first patch. Maybe that has something to do with it? I created the attached diff from the trunk. Its also a more current revision number. Does it work? The patch applied without any err

[PATCH] Derby-127

2005-05-05 Thread Jack Klebanoff
I have attached a patch that fixes Jira bug Derby-127 (http://issues.apache.org/jira/browse/DERBY-127). The problem is with select statements that use a correlation name in the select list, a group by clause, and an order by clause that refers to a column by its database name instead of its cor

Re: [jira] Commented: (DERBY-230) "Schema already exists" when creating a table

2005-05-05 Thread David Van Couvering
I'm stil learning this harness, but I am pretty sure you can run any program with a main() that you want from within the test harness, just by adding the .java file to functionTests/tests. I don't think the harness has any restrctions on this main() program being multi-threaded or single-threa

Issue running derbynetclientmats

2005-05-05 Thread Jeremy Boynes
Last couple of times I have run this suite I am getting reports like the one attached that show no tests passed and no tests failed. If I look at the individual tests they all passed. Any ideas? -- Jeremy Generating report for RunSuite derbynetclientmats null null DerbyNetClient true

Re: DERBY-167 has done but ...

2005-05-05 Thread Satheesh Bandaram
ctory, (B (Bbecause size was too large. (B (Bhttp://www5.ocn.ne.jp/~tomohito/20050505/derbyall_fail.txt (B (Bhttp://www5.ocn.ne.jp/~tomohito/20050505/derbyall_diff.txt (B (B (BSomething is going on ...? (B (B (B (BBest regards. (B (B (B (B/* (B (B (B    Tomohit

Re: DERBY-167 has done but ...

2005-05-05 Thread Myrna van Lunteren
Actually, using the settings from the set*.* scripts are *not* sufficient for the testing. The testing is functional testing & for instance assumes you'd run both embedded and networkserver tests and various locales with the same setup, which would be highly unusual for any other situation. If you

Re: DERBY-167 has done but ...

2005-05-05 Thread David Van Couvering
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, >>

Re: DataSource class hierarchy in client

2005-05-05 Thread Satheesh Bandaram
I think the ClientBaseDataSource was not meant to be a public class. We tried to localize all public classes into the 'jdbc' package and use only the jdbc package to generate public javadoc. That is one of the reasons for putting all public tracing support in ClientDataSource. I would also like to

Re: DERBY-167 has done but ...

2005-05-05 Thread Daniel John Debrunner
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. There seems to be a lot of code re-formatting in this patch. This makes it much harder for the reviewers to see the actual changes. For example a

Re: DataSource class hierarchy in client

2005-05-05 Thread Kathey Marsden
Jeremy Boynes wrote: > > I am going to go through the client code and switch the usages to the > base class (which declares the methods being used) and then change the > hierarchy here as proposed. Hi Jeremy, I would vote -1 on the restructuring on the basis that I think that we should slow down

[jira] Commented: (DERBY-232) Open Invitation to add a Question and Answer to Derby FAQs

2005-05-05 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-232?page=comments#action_64575 ] Jean T. Anderson commented on DERBY-232: Here's a question for the "Using Derby" section: When will Derby have its own client JDBC driver? Answer: A Derby client dr

Re: DataSource class hierarchy in client

2005-05-05 Thread Jeremy Boynes
Satheesh Bandaram wrote: I think the ClientBaseDataSource was not meant to be a public class. We tried to localize all public classes into the 'jdbc' package and use only the jdbc package to generate public javadoc. That is one of the reasons for putting all public tracing support in ClientDataSour

Re: DataSource class hierarchy in client

2005-05-05 Thread Jeremy Boynes
Kathey Marsden wrote: Jeremy Boynes wrote: I am going to go through the client code and switch the usages to the base class (which declares the methods being used) and then change the hierarchy here as proposed. Hi Jeremy, I would vote -1 on the restructuring on the basis that I think that we sho

running tests with j9?

2005-05-05 Thread Daniel John Debrunner
The README file for the testing implies that the tests should run with IBM's wsdd5.6 (aka j9). Are there any examples on how to do this? I tried this, with my classpath just set to include the Derby stuff, but I get a java.lang.Object not found. c:/wsdd5.6/ive/bin/j9 -jcl:Max org.apache.derbyTes

Re: DataSource class hierarchy in client

2005-05-05 Thread Kathey Marsden
Jeremy Boynes wrote: > > The changes here are incremental and can be rolled back at any time. > >> I want to establish that the goals ... >> are to make it more compatible with the embedded driver. I think that >> is very important. >> > > As I commented to Satheesh, I agree. There are differenc

Re: DERBY-167 has done but ...

2005-05-05 Thread Mamta Satoor
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:E

Re: DataSource class hierarchy in client

2005-05-05 Thread Jeff Levitt
Will this affect the docs? I have been making progress on updating the docs for the Network Client, (and I should have a proposed patch soon) but I have been using the functional spec. Does the functional spec need to be updated? --- Kathey Marsden <[EMAIL PROTECTED]> wrote: > Jeremy Boynes wro

Re: [jira] Created: (DERBY-251) DISTINCT query is returning duplicate rows

2005-05-05 Thread Mamta Satoor
Hi, I have a patch for this optimizer bug. Basically, the issue turned out to be the logic for DISTINCT elimination. During the optimization phase, if a query has DISTINCT clause, then impl.sql.compile.FromList class's returnsAtMostSingleRow() method gets called. This method returns true if the me

Pooled connections are closed?

2005-05-05 Thread David Van Couvering
Hi, all. I'm working on testing the toString() fix for Connections. I'm trying to cover all the bases in terms of our various data sources. In my tests I create a new instance of EmbeddedXADataSource and ConnectionPoolDataSource, and then get an XAConnection and a PooledConnection. From each

[jira] Created: (DERBY-261) Document Network Client in Derby docs

2005-05-05 Thread Jeff Levitt (JIRA)
Document Network Client in Derby docs - Key: DERBY-261 URL: http://issues.apache.org/jira/browse/DERBY-261 Project: Derby Type: Task Components: Documentation Environment: All Reporter: Jeff Levitt Priority: Minor Tr

Remaining issue outlined in Derby 261

2005-05-05 Thread Jeff Levitt
I just opened a new Jira issue for documenting the Derby Network Client: http://issues.apache.org/jira/browse/DERBY-261 I am in the process of implementing the goals outlined in that issue. However, as I mentioned in the entry, we don't have resolution on whether to completely remove information

Re: Pooled connections are closed?

2005-05-05 Thread Dibyendu Majumdar
Hi, I have created an issue for this (DERBY-246). Basically, the XA implementation seems broken, and behaviour is the same as that of DB2 type-4 driver against a DB2 database. Regards - Original Message - From: "David Van Couvering" <[EMAIL PROTECTED]> To: Sent: Thursday, May 05, 2005 1

Re: running tests with j9?

2005-05-05 Thread Myrna van Lunteren
Is it possible JAVA_HOME is pointing to another jvm? It would be one situation where you'd get the error you mention. And then it is required to add the bootclasspath to the location of the java.sql classes (e.g. database_enabler.jar), which is an additional package, or you'll get java.sql.SQLExce

Re: [PATCH] Derby 218 - Add relaxed durability option

2005-05-05 Thread Sunitha Kambhampati
Thanks Suresh for your comments. I have attached a new patch that takes care of them and as well as the property name change as discussed on the list. So now, 1)To enable this no syncs mode, the property setting is derby.system.durability=test If it is set to any other value other than test

Re: Issue running derbynetclientmats

2005-05-05 Thread Sunitha Kambhampati
Jeremy Boynes wrote: Last couple of times I have run this suite I am getting reports like the one attached that show no tests passed and no tests failed. If I look at the individual tests they all passed. Generating report for RunSuite derbynetclientmats null null DerbyNetClient true

[PATCH] (DERBY-251) DISTINCT query is returning duplicate rows

2005-05-05 Thread Mamta Satoor
Hi, I have a patch for this optimizer bug. Basically, the issue turned out to be the logic for DISTINCT elimination. During the optimization phase, if a query has DISTINCT clause, then impl.sql.compile.FromList class's returnsAtMostSingleRow() method gets called. This method returns true if the me

Re: Pooled connections are closed?

2005-05-05 Thread Dibyendu Majumdar
Oops - sorry - different problem. - Original Message - From: "Dibyendu Majumdar" <[EMAIL PROTECTED]> To: "Derby Development" Sent: Friday, May 06, 2005 12:13 AM Subject: Re: Pooled connections are closed? > Hi, > > I have created an issue for this (DERBY-246). > Basically, the XA implem