new jar file name

2006-03-01 Thread Andrew McIntyre
I thought of another possible candidate for the new jar file to execute the tools and network server as part of DERBY-1063: derbyrun.jar, which also works as runderby.jar So far these are the proposed names: derbycmd.jar derbyctl.jar derbygo.jar derbyrun.jar goderby.jar runderby.jar Does anyone

Re: [jira] Resolved: (DERBY-966) creating a preparedStatement outside of a Global tran using a ClientXADatasource will result in an "SqlException: Cannot set holdability" if the statement is used in a

2006-03-01 Thread Andrew McIntyre
On 3/1/06, Daniel John Debrunner (JIRA) wrote: > > svn commit #380278 resolved this issue. Had a typo in the issue number > in the svm commit comment, entered DERBY-996 instead of 966. > You can edit the contents of svn commit messages after the fact, with the --revprop option: svn propedi

Regression Test Failure! - TinderBox_Derby 382204 - Sun DBTG

2006-03-01 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 382204/2006-03-02 01:32:41 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1640639 0 102.35% SunOS-5.10_i86pc-i386 Details in http://www.multi

[jira] Resolved: (DERBY-966) creating a preparedStatement outside of a Global tran using a ClientXADatasource will result in an "SqlException: Cannot set holdability" if the statement is used in a

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-966?page=all ] Daniel John Debrunner resolved DERBY-966: - Fix Version: 10.2.0.0 Resolution: Fixed svn commit #380278 resolved this issue. Had a typo in the issue number in the svm commi

[jira] Resolved: (DERBY-1005) getHoldability does not return CLOSE_CURSORS_AT_COMMIT in a global transaction

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1005?page=all ] Daniel John Debrunner resolved DERBY-1005: -- Fix Version: 10.2.0.0 Resolution: Fixed Changes & tests committed > getHoldability does not return CLOSE_CURSORS_AT_COMMIT in a g

[jira] Updated: (DERBY-1024) Client's XAResource.start throws XAException with XAER_RMFAIL when local transaction is active

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1024?page=all ] Daniel John Debrunner updated DERBY-1024: - Fix Version: 10.2.0.0 > Client's XAResource.start throws XAException with XAER_RMFAIL when local > transaction is active > --

[jira] Resolved: (DERBY-1024) Client's XAResource.start throws XAException with XAER_RMFAIL when local transaction is active

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1024?page=all ] Daniel John Debrunner resolved DERBY-1024: -- Resolution: Fixed CHanges committed > Client's XAResource.start throws XAException with XAER_RMFAIL when local > transaction is activ

[jira] Resolved: (DERBY-1006) Client allows setHoldability to HOLD_CURSORS_OVER_COMMIT on both connection and statement in a global transaction

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1006?page=all ] Daniel John Debrunner resolved DERBY-1006: -- Fix Version: 10.2.0.0 Resolution: Fixed Changes submitted and tests added to XATest.java > Client allows setHoldability to HOLD_C

Re: help/advice needed on reference chasing

2006-03-01 Thread Bryan Pendleton
Is there any tooling builtin to the JVM to show reference chains, so I can see at shutdown who is holding onto the generated plan? Perhaps this can help? https://hat.dev.java.net/doc/README.html bryan

[jira] Updated: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

2006-03-01 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-627?page=all ] Jean T. Anderson updated DERBY-627: --- Other Info: (was: [Patch available]) Patch was committed so am marking it unavailable to aid Jira searches. > Documentation needs to be updated with cor

[jira] Resolved: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

2006-03-01 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-627?page=all ] Jean T. Anderson resolved DERBY-627: Fix Version: 10.2.0.0 Resolution: Fixed Assign To: Jeff Levitt Committed patch derby627.diff, revision 382282. Modified files: $ svn comm

[jira] Updated: (DERBY-629) Update documentation with correct default values for network server properties

2006-03-01 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-629?page=all ] Jean T. Anderson updated DERBY-629: --- Other Info: (was: [Patch available]) Patch was applied, so marking unavailable to aid Jira searches. > Update documentation with correct default values

[jira] Resolved: (DERBY-629) Update documentation with correct default values for network server properties

2006-03-01 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-629?page=all ] Jean T. Anderson resolved DERBY-629: Fix Version: 10.2.0.0 Resolution: Fixed Assign To: Jeff Levitt Committed patch derby629.diff, revision 382278. Modified files: $ svn comm

Re: [jira] Commented: (DERBY-629) Update documentation with correct default values for network server properties

2006-03-01 Thread Jean T. Anderson
Hi, Jeff, There's a minor problem with this patch -- it has full paths for the C drive on your PC: Index: C:/derby/work/trunk/src/adminguide/radmindrdamaxthreads.dita Instead of relative path, as for the DERBY-678 patch: Index: src/devguide/cdevconcepts842385.dita I'll edit this patch to c

Re: Regression Test Failure! - TinderBox_Derby 382140 - Sun DBTG

2006-03-01 Thread Sunitha Kambhampati
[EMAIL PROTECTED] wrote: [Auto-generated mail] *TinderBox_Derby* 382140/2006-03-01 21:02:22 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 15640625 095.12% SunOS-5.10_i86pc-i386 Detail

[jira] Updated: (DERBY-210) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed

2006-03-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-210?page=all ] Deepa Remesh updated DERBY-210: --- Attachment: derby-210-patch5-v1.diff derby-210-patch5-v1.status Attaching a patch 'derby-210-patch5-v1.diff' which removes the actual memory leaks

help/advice needed on reference chasing

2006-03-01 Thread Daniel John Debrunner
For DERBY-538 I have code to use a class loader, for the application jars installed in a database, based upon the standard Java URLClassLoader. The advantages to this are the standard security features of URLClassLoader are picked up such as signature checking and Jar sealing. However, I hit a cou

[jira] Updated: (DERBY-1061) SqlException while fetching message results in recursive calls between SqlException.getSQLException and Sqlca.getJDBCMessage

2006-03-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1061?page=all ] Rick Hillegas updated DERBY-1061: - Attachment: derbyall_report.txt Hi Anurag, I applied this patch and ran derbyall. I saw 35 failed tests. Most of these are message formatting problems and s

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Andrew McIntyre
On 3/1/06, Stanley Bradbury <[EMAIL PROTECTED]> wrote: > > Having all the jars start with 'derby' has the advantage of making them > easy to search for and they will short together in an alphabetical > listing like is produced by most directory listings. Having them sort > together when listing ou

Re: 10.2 release contents

2006-03-01 Thread Andrew McIntyre
On 3/1/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: > Thanks, Andrew. What new items are we likely to see inside the > distributions? Well, if I get my way, goderby.jar (or whatever it ends up being named - DERBY-1063) and new scripts in a bin directory in the -bin distribution (DERBY-1032). There

[jira] Commented: (DERBY-965) DatabaseMetadata method supportsResultSetConcurrency returns wrong result on network client

2006-03-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-965?page=comments#action_12368416 ] Dag H. Wanvik commented on DERBY-965: - Note: I did not get any answer to my question on the phaseTester canon, as far as I can see. > DatabaseMetadata method supportsResu

[jira] Commented: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

2006-03-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-627?page=comments#action_12368415 ] Deepa Remesh commented on DERBY-627: Thanks for making the changes. I took a look at the attached html files and they cover what I describe. Patch looks good to me. > Docu

Re: 10.2 release contents

2006-03-01 Thread Rick Hillegas
Thanks, Andrew. What new items are we likely to see inside the distributions? Cheers, -Rick Andrew McIntyre wrote: On 3/1/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: Hi Andrew, I heard a vague rumor that the 10.2 distributions would look different than the 10.1 distributions available a

[jira] Commented: (DERBY-1070) add tests for holdable SUR

2006-03-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1070?page=comments#action_12368412 ] Dag H. Wanvik commented on DERBY-1070: -- The name HoldabilityTest.junit may be too general if you only plan to include tests for scrollable result sets in it. I also think

[jira] Commented: (DERBY-629) Update documentation with correct default values for network server properties

2006-03-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-629?page=comments#action_12368413 ] Deepa Remesh commented on DERBY-629: Thanks for making the changes. I took a look at the attached html files and the changes cover what I describe. Patch looks good to me.

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Stanley Bradbury
Andrew McIntyre wrote: On 3/1/06, Kathey Marsden <[EMAIL PROTECTED]> wrote: How about *goderby.jar* Only 7 letters and documents itself as a vehicle to get you on your way. I like this. I also like the fact that it starts with g instead of d. It will stand out in the list of jars:

[jira] Commented: (DERBY-629) Update documentation with correct default values for network server properties

2006-03-01 Thread Jeff Levitt (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-629?page=comments#action_12368407 ] Jeff Levitt commented on DERBY-629: --- Could someone please review this patch? Thanks in advance! > Update documentation with correct default values for network server propert

[jira] Commented: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

2006-03-01 Thread Jeff Levitt (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-627?page=comments#action_12368406 ] Jeff Levitt commented on DERBY-627: --- Could someone possibly review this patch please? > Documentation needs to be updated with correct return type for COUNT functions > -

[jira] Commented: (DERBY-916) documentation to address Derby-239: online backup

2006-03-01 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-916?page=comments#action_12368405 ] Suresh Thalamati commented on DERBY-916: Thanks very much for documenting online backup. changes looks good except for one minor error in SYSCS_UTIL.SYSCS_DISABLE_LO

Re: 10.2 release contents

2006-03-01 Thread Andrew McIntyre
On 3/1/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: > Hi Andrew, > > I heard a vague rumor that the 10.2 distributions would look different > than the 10.1 distributions available at > http://db.apache.org/derby/releases/release-10.1.2.1.cgi. Have you heard > this rumor and if so can you elaborate?

[jira] Commented: (DERBY-571) Virtual Table Mapping for no argument Diagnostic tables

2006-03-01 Thread Jeff Levitt (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-571?page=comments#action_12368401 ] Jeff Levitt commented on DERBY-571: --- Eric recently asked if there are any tables to doc for this. I second that motion. Could someone please provide information so that thi

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Andrew McIntyre
On 3/1/06, Kathey Marsden <[EMAIL PROTECTED]> wrote: > > How about *goderby.jar* > > Only 7 letters and documents itself as a vehicle to get you on your way. I like this. I also like the fact that it starts with g instead of d. It will stand out in the list of jars: "one of these things is not

Regression Test Failure! - TinderBox_Derby 382140 - Sun DBTG

2006-03-01 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 382140/2006-03-01 21:02:22 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 15640625 095.12% SunOS-5.10_i86pc-i386 Details in http://www.mult

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Øystein Grøvlen
Daniel John Debrunner (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12367999 ] Daniel John Debrunner commented on DERBY-690: - Andreas wrote: --- quote True. This would also be the situation if: * The Result

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Dag H. Wanvik
Hi, Daniel John Debrunner <[EMAIL PROTECTED]> writes: >>> JDBC says you might see it, due to the "as the rows are retrieved". > Here's an example of what I'm saying. [snipped: Dan's example of sensitivity resulting from not all rows in result set being materialized at once] > allows the driv

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Daniel John Debrunner
Fernanda Pizzorno (JIRA) wrote: > Dan wrote: > >>[...] Hence, like Oracle, Derby should perform the equivalent of a >>refreshRow. > > > Do you mean that we should also, like Oracle, allow users to use the > refreshRow() method to get an updated row, or should it still be a > no-op when it i

[jira] Commented: (DERBY-997) ClassCastException when executing queries with aggregates in app servers

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-997?page=comments#action_12368394 ] Daniel John Debrunner commented on DERBY-997: - Chris Newell wrote: (on derby-user) > I seem to have resolved my own issue as I was preparing a message to > this li

[jira] Assigned: (DERBY-997) ClassCastException when executing queries with aggregates in app servers

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-997?page=all ] Daniel John Debrunner reassigned DERBY-997: --- Assign To: Daniel John Debrunner > ClassCastException when executing queries with aggregates in app servers > -

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Dag H. Wanvik
I suggest you upload v2 including the implicit refresh for updateRow. I don't suggest we change the no-op of refreshRow, unless Dan changes his mind and insists, because even he concedes that is inviolation of the JDBC spec. I still feel the refresh isnt right, but we dont want to get bogged down

Re: Re: Is there any means to get the size of a log record?

2006-03-01 Thread Raymond Raymond
If I can know the size of log file which is needed to be scaned during ecovery, I can caculate the speed of recovery in X KB/second. I got an idea to estimate the size of log which is needed to be scaned during recovery. But I am not sure whither it is correct or not. As far as I know, derby will

[jira] Resolved: (DERBY-1010) setTransactionIsolation can cause ava.sql.SQLException: Invalid operation: statement closed in some contexts with xa

2006-03-01 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1010?page=all ] Kathey Marsden resolved DERBY-1010: --- Fix Version: 10.2.0.0 Resolution: Fixed Date: Wed Mar 1 15:18:01 2006 New Revision: 382195 URL: http://svn.apache.org/viewcvs?rev=382195&view=

[WWD] Revised Proposal and Outline/Topic list for review

2006-03-01 Thread Stanley Bradbury
A revised proposal and complete topic outline for the Working With Derby document has been posted to Derby-913. This can be downloaded via the URL below. You are invited to review the v1.1 proposal plus topic list and let me know if you see anything amiss (a nonessential topic or a missing es

[jira] Updated: (DERBY-1072) Misleading/wrong error message while dropping a view

2006-03-01 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1072?page=all ] Satheesh Bandaram updated DERBY-1072: - Component: Newcomer SQL Description: while dropping a view which does not really exist on a database , the error message throw

[jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Fernanda Pizzorno (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12368384 ] Fernanda Pizzorno commented on DERBY-690: - Dag wrote: > In our implementation, a positioned UPDATE (for the same result set) > is considered an "own" change, cf. the wr

Re: Another question on grant/revoke functional spec

2006-03-01 Thread Satheesh Bandaram
Mamta Satoor wrote: Hi Satheesh, The difference in behavior is seen because in one case you are doing "select * from mamta.t1" and in another you have "select count(*) from mamta.t1". If you change the second one to "select * from mamta.t1", you should see the same error. Now, we have a

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Kathey Marsden
Andrew McIntyre wrote: >On 3/1/06, Kathey Marsden <[EMAIL PROTECTED]> wrote: > > >>Bryan Pendleton wrote: >> >> >> >>>Then, the "new user" tools and examples could just tell users >>>to run things like >>> >>> java -jar derbyall.jar ij >>> java -jar derbyall.jar NetworkServerControl star

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Stanley Bradbury
Daniel John Debrunner wrote: Bryan Pendleton wrote: Here's a thought for a totally different approach to solving the original problem, which I will unfairly summarize as: Make it easier for brand new users to run Derby in trial situations without having to learn a lot about scripts and C

[jira] Updated: (DERBY-805) Push join predicates into union and other set operations. DERBY-649 implemented scalar (single table) predicate pushdown. Adding join predicate push down could improve perf

2006-03-01 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-805?page=all ] A B updated DERBY-805: -- Attachment: d805_phase3_v1.patch d805_phase3_v1.stat Attaching a "Phase 3" patch, d805_phase3_v1.patch, to implement the changes described in steps 2, 3, 4 and 6 of

[jira] Closed: (DERBY-834) i18n/urlLocale.sql test fails on Windows XP

2006-03-01 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-834?page=all ] Myrna van Lunteren closed DERBY-834: > i18n/urlLocale.sql test fails on Windows XP > --- > > Key: DERBY-834 > URL: http://issues.ap

[jira] Commented: (DERBY-594) Some rawStoreDaemon threads are not stopped

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-594?page=comments#action_12368363 ] Daniel John Debrunner commented on DERBY-594: - Confirmed that this is not an issue for DERBY-538, the raw store daemon thread stops correctly in the situation I'm s

Performance difference while running the same query though ij and java pgm

2006-03-01 Thread Manjula G Kutty
hi, I have 2 tables with around 100,000 rows and I was running the following query. select mtb1.col5 from mytable1 mtb1 inner join mytable2 mtb2 on mtb1.col5=mtb2.col5 where mtb1.col1>0 AND mtb1.col4='tab1_col4' AND (mtb1.col1>0 OR mtb2.col1>0); This query should return 0 rows. When I run

Another question on grant/revoke functional spec

2006-03-01 Thread Mamta Satoor
Hi Satheesh,   Pardon me if I keep asking questions on areas that are work in progress. But I just want to be clear on things as I do my work on EXTERNAL SECURITY.   I am copying following from the spec start of text from functional spec CREATE PROCEDURE SALES.TOTAL_REVENUE(IN

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Lance J. Andersen
believe me i know the feeling. I am not quite sure why the methods below are not mentioned for the update and insert section. I will cover this with the EG and discuss possibly clarifying the other wording u suggested i think that covers it yes? Daniel John Debrunner wrote: Lance J. Ande

[jira] Resolved: (DERBY-834) i18n/urlLocale.sql test fails on Windows XP

2006-03-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-834?page=all ] Andrew McIntyre resolved DERBY-834: --- Fix Version: 10.2.0.0 Resolution: Fixed Committed revision 382138. > i18n/urlLocale.sql test fails on Windows XP > -

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Daniel John Debrunner
Lance J. Andersen wrote: > maybe i am blind today, but i only see the wording in 14.2.4.2 not > 14.2.4.3 WRT othersXXXAreVisible method that u refer to below Sorry my mistake, looked at so many things this morning. Maybe the issue is 14.2.4.3 does not refer other inserts are visible. Dan.

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Lance J. Andersen
maybe i am blind today, but i only see the wording in 14.2.4.2 not 14.2.4.3  WRT othersXXXAreVisible method that u refer to below Daniel John Debrunner wrote: Lance J. Andersen wrote: The wording in chapter 14 of JDBC 3 in sections 14.2.4.1 Updating a Row, 14.2.4.2 Deleting a Row,

[jira] Updated: (DERBY-1071) Make UserAuthenticator javadoc mention clearly about what is passed in userName in authenticateUser

2006-03-01 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1071?page=all ] Sunitha Kambhampati updated DERBY-1071: --- Attachment: Derby1071.diff.txt UserAuthenticator.html I am attaching patch Derby1071.diff.txt to fix the javadoc for UserAuthenti

[jira] Updated: (DERBY-1063) Add new jar file to execute tools/network server with java -jar

2006-03-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1063?page=all ] Andrew McIntyre updated DERBY-1063: --- Summary: Add new jar file to execute tools/network server with java -jar (was: Add derby.jar/derbyclient.jar to manifest Class-Path attribute in der

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Andrew McIntyre
On 3/1/06, Kathey Marsden <[EMAIL PROTECTED]> wrote: > Bryan Pendleton wrote: > > > Then, the "new user" tools and examples could just tell users > > to run things like > > > >java -jar derbyall.jar ij > >java -jar derbyall.jar NetworkServerControl start > > +1 > > I like it! This is certa

[jira] Updated: (DERBY-1063) Add derby.jar/derbyclient.jar to manifest Class-Path attribute in derbytools.jar

2006-03-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1063?page=all ] Andrew McIntyre updated DERBY-1063: --- Attachment: derby1063_v2.diff Updated patch that moves the java -jar functionality to a new jar called derbycmd.jar, and now includes NetworkServerContro

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Bernt M. Johnsen
Daniel John Debrunner wrote (2006-03-01 06:58:39): > Bernt M. Johnsen wrote: > > > > We should also strive to make "insensitivity" as close to the SQL > > defintion as possible (SQL 2003 p. 96): > > > >A change to SQL-data is said to be independent of a cursor CR if > >and o

10.2 release contents

2006-03-01 Thread Rick Hillegas
Hi Andrew, I heard a vague rumor that the 10.2 distributions would look different than the 10.1 distributions available at http://db.apache.org/derby/releases/release-10.1.2.1.cgi. Have you heard this rumor and if so can you elaborate? Thanks, -Rick

Re: A question about dirty pages.

2006-03-01 Thread Mike Matrigali
For those new developers asking questions about the code, it would be interesting to know what parts of the code they looked at and could not find the info they needed. I realize with the derby layout it is often hard to find the info since at least in store there is often a protocol description

Regression Test Failure! - TinderBox_Derby 382021 - Sun DBTG

2006-03-01 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 382021/2006-03-01 15:02:25 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1640639 0 102.29% SunOS-5.10_i86pc-i386 Details in http://www.multi

Re: [jira] Created: (DERBY-1069) Client should unwrap exceptions thrown in privilege blocks rather than throwing the java.security.PrivilegedActionException

2006-03-01 Thread Daniel John Debrunner
Kristian Waagan wrote: > Daniel John Debrunner (JIRA) wrote: > >> Client should unwrap exceptions thrown in privilege blocks rather than >> throwing the java.security.PrivilegedActionException >> -

Re: conflict detection strategies

2006-03-01 Thread Mike Matrigali
That is what I was worried about. The truncate is the one that will possibly cause reuse of RowLocations. Defragment moves rows around, with new rows getting new row locations. I am still ok with the direction you propose, but some code work is going to be necessary to get there. Store could c

[jira] Created: (DERBY-1072) Misleading/wrong error message while dropping a view

2006-03-01 Thread Manjula Kutty (JIRA)
Misleading/wrong error message while dropping a view Key: DERBY-1072 URL: http://issues.apache.org/jira/browse/DERBY-1072 Project: Derby Type: Bug Versions: 10.1.2.2 Environment: windows xp , jdk1.5 Re

Re: A question about dirty pages.

2006-03-01 Thread Mike Matrigali
Yes, you are right. It does not really need to be written, but in the current implementation it doesn't cost very much to write it since we sync the entire file at the end. I tried to add some more descriptive comments about this in: BaseDataFileFactory.java!checkpoint The actual loop is in th

[jira] Created: (DERBY-1071) Make UserAuthenticator javadoc mention clearly about what is passed in userName in authenticateUser

2006-03-01 Thread Sunitha Kambhampati (JIRA)
Make UserAuthenticator javadoc mention clearly about what is passed in userName in authenticateUser Key: DERBY-1071 URL: http://issues.apache.org/jira/browse/DERBY-1071 Pro

Re: [jira] Created: (DERBY-1069) Client should unwrap exceptions thrown in privilege blocks rather than throwing the java.security.PrivilegedActionException

2006-03-01 Thread Kristian Waagan
Daniel John Debrunner (JIRA) wrote: Client should unwrap exceptions thrown in privilege blocks rather than throwing the java.security.PrivilegedActionException --- Ke

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Daniel John Debrunner
Andreas Korneliussen wrote: > Daniel John Debrunner wrote: > >> Bernt M. Johnsen wrote: >> >> >> >>> We should also strive to make "insensitivity" as close to the SQL >>> defintion as possible (SQL 2003 p. 96): >>> >>> A change to SQL-data is said to be independent of a cursor CR if >>> and o

[jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12368322 ] Dag H. Wanvik commented on DERBY-690: - Dan said: > I think one difference is I don't see the argument for triggered > actions being "other changes" Triggered actions are at

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Kathey Marsden
Bryan Pendleton wrote: > Here's a thought for a totally different approach to solving > the original problem, which I will unfairly summarize as: > > Make it easier for brand new users to run Derby in trial > situations without having to learn a lot about scripts and > CLASSPATH settings. >

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Daniel John Debrunner
Bryan Pendleton wrote: > Here's a thought for a totally different approach to solving > the original problem, which I will unfairly summarize as: > > Make it easier for brand new users to run Derby in trial > situations without having to learn a lot about scripts and > CLASSPATH settings. >

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Bryan Pendleton
Here's a thought for a totally different approach to solving the original problem, which I will unfairly summarize as: Make it easier for brand new users to run Derby in trial situations without having to learn a lot about scripts and CLASSPATH settings. What if we shipped two configuratio

[jira] Commented: (DERBY-948) Miscellaneous ResultSet methods added by JDBC 4

2006-03-01 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-948?page=comments#action_12368319 ] Knut Anders Hatlen commented on DERBY-948: -- Just realized there might be one issue with my implementation of ResultSet.getHoldability() in the embedded driver. To find

[jira] Commented: (DERBY-1059) call to stored procedure with out params fails in embedded driver

2006-03-01 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1059?page=comments#action_12368316 ] Rick Hillegas commented on DERBY-1059: -- Thanks, Anurag, this looks like an improvement. However, lots of useful javadoc has disappeared. Could you add appropriate javadoc

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Daniel John Debrunner
Lance J. Andersen wrote: > The wording in chapter 14 of JDBC 3 in sections 14.2.4.1 Updating a Row, > 14.2.4.2 Deleting a Row, 14.2.4.3 Inserting a Row > > The wording was carried unmodified forward to JDBC 4 There are two bugs in the spec (both 3.0 and 4.0) in this area: (JDBC 3.0 section numbe

[jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12368311 ] Daniel John Debrunner commented on DERBY-690: - I think one difference is I don't see the argument for triggered actions being "other changes" Triggered actions are

[jira] Commented: (DERBY-618) Make the client driver connection URL work when spaces are in the URL.

2006-03-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-618?page=comments#action_12368310 ] Deepa Remesh commented on DERBY-618: Thanks for pointing this out. I think I can add a test to jdbcapi/checkDriver.java for an url with spaces in the database name. I had

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Lance J. Andersen
The wording in chapter 14 of JDBC 3 in sections 14.2.4.1 Updating a Row, 14.2.4.2 Deleting a Row, 14.2.4.3 Inserting a Row The wording was carried unmodified forward to JDBC 4 Andreas Korneliussen (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_123

[jira] Updated: (DERBY-1007) Optimizer can return incorrect "best cost" estimates with nested subqueries, which leads to generation of sub-optimal plans.

2006-03-01 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1007?page=all ] A B updated DERBY-1007: --- Other Info: [Patch available] > Optimizer can return incorrect "best cost" estimates with nested subqueries, > which leads to generation of sub-optimal plans. >

[jira] Commented: (DERBY-965) DatabaseMetadata method supportsResultSetConcurrency returns wrong result on network client

2006-03-01 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-965?page=comments#action_12368307 ] Knut Anders Hatlen commented on DERBY-965: -- It seems like Dag has addressed the concerns of the reviewers. I'm planning to commit this patch tomorrow, so please scream

[jira] Commented: (DERBY-809) Incorrect documentation for 'NetworkServerControl.logConnections(boolean)'

2006-03-01 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-809?page=comments#action_12368306 ] Kristian Waagan commented on DERBY-809: --- I have checked that the documentation change happens in the latest alpha manuals. They do not in the 10.1 manuals (or 10.0 manual

[jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12368299 ] Dag H. Wanvik commented on DERBY-690: - Dan> I need to think a little more about why you think oracle's Dan> behaviour is not JDBC compliant (excluding supporting refreshRow

[jira] Updated: (DERBY-924) new JDBC4 metadata API getFunctions() needs to be implemented

2006-03-01 Thread Dyre Tjeldvoll (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-924?page=all ] Dyre Tjeldvoll updated DERBY-924: - Other Info: [Patch available] I'm checking the 'Patch available' box to signal that a new, as of yet unreviewed, patch has been uploaded to this issue. If tha

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Andreas Korneliussen
Daniel John Debrunner wrote: Bernt M. Johnsen wrote: We should also strive to make "insensitivity" as close to the SQL defintion as possible (SQL 2003 p. 96): A change to SQL-data is said to be independent of a cursor CR if and only if it is not made by an or a that is positioned on

Re: [jira] Assigned: (DERBY-1060) ResultSet methods should throw exception when the ResultSet is closed

2006-03-01 Thread Lance J. Andersen
Calling ResultSet.close() a second time will be a no-op and this will be updated for the PFD of JDBC 4 -lance Knut Anders Hatlen (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1060?page=all ] Knut Anders Hatlen reassigned DERBY-1060: --

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Daniel John Debrunner
Bernt M. Johnsen wrote: > We should also strive to make "insensitivity" as close to the SQL > defintion as possible (SQL 2003 p. 96): > >A change to SQL-data is said to be independent of a cursor CR if >and only if it is not made by an or a > that is positioned on CR. > >A chan

Re: derbytools.jar loading derbyclient.jar

2006-03-01 Thread Kathey Marsden
Daniel John Debrunner wrote: >I think the difference to shared code, is that mixed jars in a simple >shared code model could break each other, or reduce functionality, that >doesn't happen here. > > I will differ to others to do the proper due diligence on behalf of the user community with rega

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Lance J. Andersen
Well, this is handled differently by a variety of vendors.  For example Oracle and the IBM DB2 drivers currently throw an exception for every case except ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE Some other vendors only follow the guidelines in the javadocs as to when they th

[jira] Updated: (DERBY-924) new JDBC4 metadata API getFunctions() needs to be implemented

2006-03-01 Thread Dyre Tjeldvoll (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-924?page=all ] Dyre Tjeldvoll updated DERBY-924: - Attachment: derby-924.v1.diff derby-924.v1.stat derbyall_report.v1.txt Patch (derby-924.v1.*). Ran derbyall (1.5) verify that t

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Bernt M. Johnsen
Daniel John Debrunner wrote (2006-03-01 06:31:05): > Bernt M. Johnsen wrote: > > > We should also strive to make "insensitivity" as close to the SQL > > defintion as possible (SQL 2003 p. 96): > > but not when it comes to being updateable apparently :-) Yes. During this debate it ha

[jira] Resolved: (DERBY-928) Add ability to network server to accept connections with a certain security mechanism.

2006-03-01 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-928?page=all ] Kathey Marsden resolved DERBY-928: -- Resolution: Fixed Checked this into the trunk Date: Wed Mar 1 05:55:05 2006 New Revision: 382019 URL: http://svn.apache.org/viewcvs?rev=382019&view=re

Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Daniel John Debrunner
Bernt M. Johnsen wrote: > We should also strive to make "insensitivity" as close to the SQL > defintion as possible (SQL 2003 p. 96): but not when it comes to being updateable apparently :-) Dan.

[jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12368286 ] Andreas Korneliussen commented on DERBY-690: I found the following in the JDBC 2.1 spec: " 5.8.3 A result set s own changes We have pointed out that the visibility o

[jira] Commented: (DERBY-1017) locking issue with a select statement using an order by clause

2006-03-01 Thread Mark H. Kaplan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1017?page=comments#action_12368285 ] Mark H. Kaplan commented on DERBY-1017: --- This issue is also reproducible with the embedded version of Derby. On another note, if you take the ORDER BY clause away, the f

[jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12368284 ] Dag H. Wanvik commented on DERBY-690: - (reposting a mail comment by Bernt. -Dag) Dag H. Wanvik (JIRA) wrote (2006-02-27 15:44:44): > [ > http://issues.apa

[jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets

2006-03-01 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12368283 ] Dag H. Wanvik commented on DERBY-690: - (reposting a mail comment by Dan here. -Dag) Øystein Grøvlen wrote: > Daniel John Debrunner (JIRA) wrote: > >> Agreed, it's the sam

[jira] Updated: (DERBY-1070) add tests for holdable SUR

2006-03-01 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1070?page=all ] Andreas Korneliussen updated DERBY-1070: Other Info: [Patch available] Description: Environment: > add tests for holdable SUR > -- > > Key: D

  1   2   >