Re: [jira] Updated: (DERBY-239) Need a online backup feature that does not block update operations when online backup is in progress.

2005-11-17 Thread Suresh Thalamati
Mike Matrigali wrote: I have tested this patch and reviewed the changes and have commited it as svn 345355. I have the following suggestions from review, and will look at any subsequent changes in these areas that Suresh would like to submit: o RawStore.java!canStartOnlineBackup() has a todo it

Re: Dan could you take a look at this lock manager change? Re: [jira] Updated: (DERBY-715) lock deadlocks sometimes reported as lock timeouts

2005-11-17 Thread Daniel John Debrunner
Mike Matrigali wrote: > While looking at Bryan's issues with DERBY-666 I think I found the > problem that I have reported in DERBY-715. It looks like > deadlockWait is being used to indicate a deadlock was encountered, > but in some cases it is false even if a deadlock was encountered. > > A que

Re: [jira] Commented: (DERBY-587) Providing JDBC 4.0 support for derby

2005-11-17 Thread V Narayanan
Hi, Thanx for the help with the icla Jean. Thank you Satheesh and Rick for guiding me through the various details of the patch. Thanx to everyone for the reviews and the comments. Narayanan Satheesh Bandaram (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/DERBY-587?page=comments#ac

Re: Re-enabling VTIs

2005-11-17 Thread Daniel John Debrunner
Rick Hillegas wrote: > I have logged enhancement request 716 to track the re-enabling of > customer-defined Virtual Table Interfaces (VTIs). A little history follows: > I can imagine that the non-standard nature of VTI declaration was an > issue. Are there other issues? Has anyone given some thoug

[jira] Commented: (DERBY-587) Providing JDBC 4.0 support for derby

2005-11-17 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-587?page=comments#action_12357950 ] Satheesh Bandaram commented on DERBY-587: - I have submitted this patch. Thanks everyone! > Providing JDBC 4.0 support for derby > >

RE: Re-enabling VTIs

2005-11-17 Thread Westerfeld, Kurt
I for one, see the power of this feature and welcome it back in the fold. We are moving in a direction that would either 1) place our own VTIs under the diag namespace (ugly) or 2) shipping a slightly modified form (ugly) or 3) petitioning to get this added back in. The VTI API should have the

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread Francois Orsini
I think having 2 embedded Derby or 2 client derby apps at different version levels in the same JVM is wrong. It is technically feasible but is it rational? Separate classloaders should be used if one intends to run 2 different versions of embedded derby in the same JVM. Actually, of one of the embe

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread Rick Hillegas
Hi Kathey, Some comments follow. Cheers-Rick Kathey Marsden wrote: ... You can't have two client apps at different version levels in the same classloader. The one loaded first will win. I'm not so sure this is true. If classes are added/deleted to/from the public API, then it may be

Re: [jira] Commented: (DERBY-587) Providing JDBC 4.0 support for derby

2005-11-17 Thread Bryan Pendleton
Narayanan's icla now shows up as being recorded Yay! So does mine! http://people.apache.org/~jim/committers.html#unlistedclas bryan

Re: Derby Driver

2005-11-17 Thread Stanley Bradbury
Sean McCully wrote: Apologies should I continue the discussion here or move it? Yes when I execute the derby jar it works, and actually I was able to get the driver to load by merely replacing the String name with a String constant but on subsequents loads it failed. Also this may be due to

[jira] Commented: (DERBY-587) Providing JDBC 4.0 support for derby

2005-11-17 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-587?page=comments#action_12357948 ] Jean T. Anderson commented on DERBY-587: Narayanan's icla now shows up as being recorded -- so go ahead and commit, Satheesh. > Providing JDBC 4.0 support for derby >

Dan could you take a look at this lock manager change? Re: [jira] Updated: (DERBY-715) lock deadlocks sometimes reported as lock timeouts

2005-11-17 Thread Mike Matrigali
While looking at Bryan's issues with DERBY-666 I think I found the problem that I have reported in DERBY-715. It looks like deadlockWait is being used to indicate a deadlock was encountered, but in some cases it is false even if a deadlock was encountered. A question I have is if this was just

[jira] Updated: (DERBY-715) lock deadlocks sometimes reported as lock timeouts

2005-11-17 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-715?page=all ] Mike Matrigali updated DERBY-715: - Attachment: derby715.diff I have not run tests on this diff yet, just posting to get some input on whether I am on the right track or not. Do not commit thi

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread David W. Van Couvering
By the way, this solves the message versioning problem, but doesn't solve the overall forward/backward compatibility issue and the code cruft that it will engender. In reading Kathey's email, I also seem to understand that there are issues beyond code compatibility. In particular, we seem to

[jira] Updated: (DERBY-715) lock deadlocks sometimes reported as lock timeouts

2005-11-17 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-715?page=all ] Mike Matrigali updated DERBY-715: - Attachment: repro.java slightly altered repro from the one bryan posted to DERBY-666, mostly just some extra prints. On my ~2 ghz single processor laptop, ru

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread David W. Van Couvering
I don't understand what you mean by "distinguish client from server messages." Client messages would be in client-messages.properties, server messages are in m_*.properties. When the engine asks for a message, it specifies the appropriate m_*.properties file based on message id. When the cli

Re-enabling VTIs

2005-11-17 Thread Rick Hillegas
I have logged enhancement request 716 to track the re-enabling of customer-defined Virtual Table Interfaces (VTIs). A little history follows: Cloudscape used to let users include arbitrary customer written ResultSets in the FROM lists of queries. This provided a very powerful ability to impose

[jira] Created: (DERBY-716) Re-enable VTIs

2005-11-17 Thread Rick Hillegas (JIRA)
Re-enable VTIs -- Key: DERBY-716 URL: http://issues.apache.org/jira/browse/DERBY-716 Project: Derby Type: New Feature Reporter: Rick Hillegas Cloudscape used to expose Virtual Table Interfaces, by which any class which implemented ResultSet could b

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread Kathey Marsden
Rick Hillegas wrote: > Hi Kathey, > > What you say is true if the classpath contains an embedded Derby app > and a client app. But I don't think it works if the classpath contains > two embedded Derby apps or two client apps (at different version > levels). I think that encoding a version number m

[jira] Created: (DERBY-715) lock deadlocks sometimes reported as lock timeouts

2005-11-17 Thread Mike Matrigali (JIRA)
lock deadlocks sometimes reported as lock timeouts -- Key: DERBY-715 URL: http://issues.apache.org/jira/browse/DERBY-715 Project: Derby Type: Bug Components: Services Versions: 10.0.2.0 Reporter: Mike Ma

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread Rick Hillegas
Hi Kathey, What you say is true if the classpath contains an embedded Derby app and a client app. But I don't think it works if the classpath contains two embedded Derby apps or two client apps (at different version levels). I think that encoding a version number makes all cases work. If for

Re: Test Harness useprocess=false question

2005-11-17 Thread Myrna van Lunteren
On 11/17/05, Daniel John Debrunner <[EMAIL PROTECTED] > wrote: The test harness can run tests within the same jvm if useprocess=false.This is set for the nist suite, so that all the sub-scripts are run in a single JVM, mainly for performance reasons.I'm looking at the code in RunTest.java so I ca

Re: [jira] Updated: (DERBY-239) Need a online backup feature that does not block update operations when online backup is in progress.

2005-11-17 Thread Mike Matrigali
I have tested this patch and reviewed the changes and have commited it as svn 345355. I have the following suggestions from review, and will look at any subsequent changes in these areas that Suresh would like to submit: o RawStore.java!canStartOnlineBackup() has a todo item - needs an exceptio

Re: Derby Driver

2005-11-17 Thread Sean McCully
Apologies should I continue the discussion here or move it?   Yes when I execute the derby jar it works, and actually I was able to get the driver to load by merely replacing the String name with a String constant but on subsequents loads it failed. Also this may be due to the computer I was usin

Re: Derby Driver

2005-11-17 Thread Francois Orsini
Btw, this kind of question should be posted to derby-user mailing list preferrably...On 11/17/05, Francois Orsini < [EMAIL PROTECTED]> wrote:Seems like a classpath issue...is your application using the default JVM classloader On the command-line,  can you run: (you need to have derby.jar or derby

Re: Derby Driver

2005-11-17 Thread Francois Orsini
Seems like a classpath issue...is your application using the default JVM classloader On the command-line,  can you run: (you need to have derby.jar or derbytools.jar in the classpath) java org.apache.derby.tools.sysinfo Do you get the same ClassNotFound exception?On 11/17/05, Sean McCully <[EMAI

Test Harness useprocess=false question

2005-11-17 Thread Daniel John Debrunner
The test harness can run tests within the same jvm if useprocess=false. This is set for the nist suite, so that all the sub-scripts are run in a single JVM, mainly for performance reasons. I'm looking at the code in RunTest.java so I can add security manager to this in-process mode. The buildTest

Re: Cannot make web site changes visible: svn: Can't open file '.svn/lock': Permission denied

2005-11-17 Thread Jean T. Anderson
[EMAIL PROTECTED] wrote: Jean T. Anderson wrote: What groups are you in, Oyvind? You need to be in 'db' -- are you? I thought it might be a group thing. -bash-2.05b$ groups bakksjo apcvs incubator Exactly. Oyvind, you should be in the 'db' group now. -jean

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread Kathey Marsden
Rick Hillegas wrote: > Here is a possible solution to the versioned message id problem: > > [snip details ...] > o The Derby build can create message files whose names contain the > current value of DERBY_VERSION. > [snip more details]... If the derby build is going to create extra message files,

Re: UpdateNode/DeleteNode and SYNONYM

2005-11-17 Thread Satheesh Bandaram
It may be possible to differ this synonym resolution to verifyTargetTable(), but this is currently called after some cursor bind checking that expects correct target table name. If verifyTargetTable() can be performed before this cursor checking, which resolves synonyms correctly, the following cod

[jira] Created: (DERBY-714) NullPointerException or ClassCastException if UPDATE or DELETE is performed on a diagnostic VTI

2005-11-17 Thread Daniel John Debrunner (JIRA)
NullPointerException or ClassCastException if UPDATE or DELETE is performed on a diagnostic VTI --- Key: DERBY-714 URL: http://issues.apache.org/jira/browse/DERBY-714 Project: Derby

Re: [jira] Updated: (DERBY-289) Enable code sharing between Derby client and engine

2005-11-17 Thread Rick Hillegas
Here is a possible solution to the versioned message id problem: o The message resolver needs two pieces of information from its callers: 1) the actual message ID, 2) the derby version that its caller was compiled at. o The names of built message files need to encode the derby version number.

Derby Driver

2005-11-17 Thread Sean McCully
Hello I probably have a rather simple question, when I execute the following line   Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();   it throws the following exception   java.lang.ClassNotFoundException: org.apache.derby.jdbc.EmbeddedDriver   derby.jar is included in

Re: [Derby-573]Upgrade code and metadata.properties

2005-11-17 Thread Daniel John Debrunner
Mamta Satoor wrote: > Hi, > > I am working on writing the upgrade code for metadata.properties changes > because of optimizer overrides syntax change. Also, I am trying to see > if I can use org.apache.derbyTesting.upgradeTests.phaseTester (checked > in by Dan couple months back) to test this pa

UpdateNode/DeleteNode and SYNONYM

2005-11-17 Thread Daniel John Debrunner
I was fixing some code in the bind() for UpdateNode and DeleteNode for DERBY-571 and noticed that the methods are very similar and possibly could be combined. One thing that stood out is that UpdateNode has this code at the beginning of bind() related to SYNONYMs // check if targe

[jira] Commented: (DERBY-713) CLONE - Query optimizer should not make poor choices when optimizing IN and WHERE clauses

2005-11-17 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-713?page=comments#action_12357922 ] Satheesh Bandaram commented on DERBY-713: - If possible, rewriting the query select * from tbl where i1 in (-1,10) to select * from tbl where i1= -1 UNION

Re: [jira] Commented: (DERBY-280) Wrong result from select when aliasing to same name as used in group by

2005-11-17 Thread Rick Hillegas
Thanks, Satheesh! Satheesh Bandaram (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-280?page=comments#action_12357918 ] Satheesh Bandaram commented on DERBY-280: - I have submitted this fix to trunk. Please Resolve and Close the bug after

Re: [jira] Commented: (DERBY-666) Enhance derby.locks.deadlockTrace to print stack traces for all threads involved in a deadlock

2005-11-17 Thread Mike Matrigali
I tried your repro on a build from the trunk and got a deadlock message from the embedded case, when I ran it on a clean database. I reran after that and inconsistently got sometimes deadlock and sometimes timeout - note each run will add another uncommitted row to each of the tables in the db a

Re: [jira] Commented: (DERBY-280) Wrong result from select when aliasing to same name as used in group by

2005-11-17 Thread Satheesh Bandaram
Hi Rick, This is committed now. Thanks for addressing all issues. Satheesh Rick Hillegas wrote: > Hi Satheesh, > > I fixed the npe you spotted and attached the updated patch to the JIRA > issue. This is ready for you to commit when you have a moment. > > Thanks, > -Rick > > >

[jira] Commented: (DERBY-280) Wrong result from select when aliasing to same name as used in group by

2005-11-17 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-280?page=comments#action_12357918 ] Satheesh Bandaram commented on DERBY-280: - I have submitted this fix to trunk. Please Resolve and Close the bug after confirming the fix. I have added a comment to ind

Re: [jira] Updated: (DERBY-239) Need a online backup feature that does not block update operations when online backup is in progress.

2005-11-17 Thread Mike Matrigali
I am looking at reviewing/committing this patch. Suresh Thalamati (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-239?page=all ] Suresh Thalamati updated DERBY-239: --- Attachment: onlinebackup_3.diff This patch adds code to support real-tim

[jira] Updated: (DERBY-556) NetworkServer does not set thread context classloader

2005-11-17 Thread Jeremy Boynes (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-556?page=all ] Jeremy Boynes updated DERBY-556: Attachment: Derby556.java Java program to illustrate the problem. > NetworkServer does not set thread context classloader >

Re: Use of Apache feather in logo

2005-11-17 Thread David W. Van Couvering
I'll raise it with legal-discuss. Thanks, Jean. David Jean T. Anderson wrote: David Van Couvering wrote: Does anyone know if there is a reason we can't directly use the Apache feather in our logo? When Derby was under incubation my understanding was we could use the Apache logo, but it m

Re: Cannot make web site changes visible: svn: Can't open file '.svn/lock': Permission denied

2005-11-17 Thread Jean T. Anderson
[EMAIL PROTECTED] wrote: Jean T. Anderson wrote: What groups are you in, Oyvind? You need to be in 'db' -- are you? I thought it might be a group thing. -bash-2.05b$ groups bakksjo apcvs incubator Exactly. OK, Oyvind, I'll ask the DB PMC to add you to the 'db' group. In the meantime, I

Re: Cannot make web site changes visible: svn: Can't open file '.svn/lock': Permission denied

2005-11-17 Thread Oyvind . Bakksjo
Jean T. Anderson wrote: What groups are you in, Oyvind? You need to be in 'db' -- are you? I thought it might be a group thing. -bash-2.05b$ groups bakksjo apcvs incubator Exactly. -- Oyvind Bakksjo Sun Microsystems, Database Technology Group Trondheim, Norway http://weblogs.java.net/blog/ba

Re: New Enhancement Request

2005-11-17 Thread Daniel John Debrunner
Vishwani Sodhi wrote: > > Hi, > > My name is Vishwani Sodhi, I work for Software Development/Tools > Department in Lenovo. > > I have the following request for a feature to be added in Cloudscape: > > * I would like to be able to specify an alternate default port > number for the cl

Re: RowLocation lifetime

2005-11-17 Thread Mike Matrigali
Øystein Grøvlen wrote: "MM" == Mike Matrigali <[EMAIL PROTECTED]> writes: MM> Øystein Grøvlen wrote: >>> "MM" == Mike Matrigali <[EMAIL PROTECTED]> writes: >> >> MM> It is only stable while some sort of stable table intent lock is held. MM> Rows can move durin

Re: Cannot make web site changes visible: svn: Can't open file '.svn/lock': Permission denied

2005-11-17 Thread Jean T. Anderson
[EMAIL PROTECTED] wrote: The web page at http://db.apache.org/derby/papers/derby_web.html#7.+Make+web+site+changes+visible says the following: -- A Derby committer can make web site changes visible as follows: ssh -l your_apache_login people.apache.org cd /www/db.apache.org/derby s

Cannot make web site changes visible: svn: Can't open file '.svn/lock': Permission denied

2005-11-17 Thread Oyvind . Bakksjo
The web page at http://db.apache.org/derby/papers/derby_web.html#7.+Make+web+site+changes+visible says the following: -- A Derby committer can make web site changes visible as follows: ssh -l your_apache_login people.apache.org cd /www/db.apache.org/derby svn update -- I tried

Re: Use of Apache feather in logo

2005-11-17 Thread Jean T. Anderson
David Van Couvering wrote: Does anyone know if there is a reason we can't directly use the Apache feather in our logo? When Derby was under incubation my understanding was we could use the Apache logo, but it might be wise to ask legal-discuss. --I haven't seen this topic raised visibly. Si

[jira] Updated: (DERBY-297) Submit an entry for the Derby logo contest by uploading it to this issue

2005-11-17 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-297?page=all ] David Van Couvering updated DERBY-297: -- Attachment: (was: derby hat.jpeg) > Submit an entry for the Derby logo contest by uploading it to this issue > --

Re: [jira] Commented: (DERBY-280) Wrong result from select when aliasing to same name as used in group by

2005-11-17 Thread Rick Hillegas
Hi Satheesh, I fixed the npe you spotted and attached the updated patch to the JIRA issue. This is ready for you to commit when you have a moment. Thanks, -Rick

Use of Apache feather in logo

2005-11-17 Thread David Van Couvering
Does anyone know if there is a reason we can't directly use the Apache feather in our logo? Thanks, David

Re: RowLocation lifetime

2005-11-17 Thread Øystein Grøvlen
> "MM" == Mike Matrigali <[EMAIL PROTECTED]> writes: MM> Øystein Grøvlen wrote: >>> "MM" == Mike Matrigali <[EMAIL PROTECTED]> writes: >> >> MM> It is only stable while some sort of stable table intent lock is held. MM> Rows can move during a compress table opera

[jira] Closed: (DERBY-707) providing RowLocation for deleted+purged row to GenericConglomerateController causes nullpointerexception

2005-11-17 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-707?page=all ] Andreas Korneliussen closed DERBY-707: -- Fix has been committed. > providing RowLocation for deleted+purged row to GenericConglomerateController > causes nullpointerexception > --

[jira] Resolved: (DERBY-707) providing RowLocation for deleted+purged row to GenericConglomerateController causes nullpointerexception

2005-11-17 Thread Bernt M. Johnsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-707?page=all ] Bernt M. Johnsen resolved DERBY-707: Fix Version: 10.2.0.0 Resolution: Fixed > providing RowLocation for deleted+purged row to GenericConglomerateController > causes nullpointerex

[jira] Commented: (DERBY-713) CLONE - Query optimizer should not make poor choices when optimizing IN and WHERE clauses

2005-11-17 Thread Daniel James Neades (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-713?page=comments#action_12357867 ] Daniel James Neades commented on DERBY-713: --- Creating a clone probably wasn't the right thing to do, but given the extra information now added to DERBY-47, it should

[jira] Created: (DERBY-713) CLONE - Query optimizer should not make poor choices when optimizing IN and WHERE clauses

2005-11-17 Thread Daniel James Neades (JIRA)
CLONE - Query optimizer should not make poor choices when optimizing IN and WHERE clauses - Key: DERBY-713 URL: http://issues.apache.org/jira/browse/DERBY-713 Project: Derby Type

[jira] Closed: (DERBY-704) Large page cache kills initial performance

2005-11-17 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-704?page=all ] Knut Anders Hatlen closed DERBY-704: Fixed in revision 344270. Extra comments put into the code in revision 345215. > Large page cache kills initial performance > -

[jira] Resolved: (DERBY-704) Large page cache kills initial performance

2005-11-17 Thread Bernt M. Johnsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-704?page=all ] Bernt M. Johnsen resolved DERBY-704: Resolution: Fixed > Large page cache kills initial performance > -- > > Key: DERBY-704 > U

[jira] Updated: (DERBY-297) Submit an entry for the Derby logo contest by uploading it to this issue

2005-11-17 Thread Oyvind Bakksjo (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-297?page=all ] Oyvind Bakksjo updated DERBY-297: - Attachment: derbyhatlogo-lettersaligned.png Maybe someone who's more skilled with graphics than I am can take the hat idea, place all the characters on the sa