Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Oystein Grovlen - Sun Norway
Daniel John Debrunner wrote: CREATE SCHEMA - only create schema matching user's name - good for now, forwards compatible with the future where permission to create any schema could be granted explicitly. Does this mean that we will only allow one schema per user? That seems

[jira] Commented: (DERBY-800) derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout

2006-02-21 Thread JIRA
[ http://issues.apache.org/jira/browse/DERBY-800?page=comments#action_12367164 ] Øystein Grøvlen commented on DERBY-800: --- What I have done with this issue is that I have run the test with some tracing to see what caused the lock timeouts. I have not

[jira] Updated: (DERBY-800) derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout

2006-02-21 Thread JIRA
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ] Øystein Grøvlen updated DERBY-800: -- Attachment: derby-800.diff Attached derby-800.diff which removes lang/ConcurrentImplicitCreateSchema.java from derbyall. Files that are changed: M

[jira] Updated: (DERBY-800) derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout

2006-02-21 Thread JIRA
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ] Øystein Grøvlen updated DERBY-800: -- Other Info: [Patch available] derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout

Regression Test Failure! - Derby 379197 - Sun DBTG

2006-02-21 Thread Ole . Solberg
[Auto-generated mail] *Derby* 379197/2006-02-20 19:45:57 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 4637633 0 101.24% CYGWIN_NT-5.1_i686-unknown 3637634 0 104.34%

Re: [jira] Commented: (DERBY-273) The derbynet/dataSourcePermissions_net.java test fails intermittently

2006-02-21 Thread TomohitoNakayama
Hello Kathey. Kathey Marsden (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-273?page=comments#action_12367073 ] Kathey Marsden commented on DERBY-273: -- I don't think for this test any of the console output needs to go to System.out.

Re: [jira] Commented: (DERBY-273) The derbynet/dataSourcePermissions_net.java test fails intermittently

2006-02-21 Thread TomohitoNakayama
Hello . A little unhappy news ... I call begin method of NetworkServer with PrintWriter for file and execute until ShutdownException was found. Almost all shutdown message was printed only to PrintWriter , however, next part was printed to System.out. The part which was printed to

Re: [jira] Updated: (DERBY-800) derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout

2006-02-21 Thread Bernt M. Johnsen
I'll review, testa nd commit this one. Øystein Grøvlen (JIRA) wrote (2006-02-21 10:09:25): [ http://issues.apache.org/jira/browse/DERBY-800?page=all ] Øystein Grøvlen updated DERBY-800: -- Other Info: [Patch available]

[jira] Commented: (DERBY-796) jdbc 4.0 specific Blob and Clob method support

2006-02-21 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-796?page=comments#action_12367183 ] Knut Anders Hatlen commented on DERBY-796: -- Thanks for the improved patch, Narayanan! You have addressed most of my concerns, but there is still one issue:

[jira] Commented: (DERBY-482) GENERATED BY DEFAULT option should be documented in Derby Tools and Utilities guide under Importing into tables with identity columns section.

2006-02-21 Thread John H. Embretsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-482?page=comments#action_12367187 ] John H. Embretsen commented on DERBY-482: - Hmm, I did a quick check myself, and found that I got roughly the same error as Mamta when trying to view the HTML document

[jira] Commented: (DERBY-960) Client xa prepare returns XA_OK instead of XA_RDONLY for a read only transaction

2006-02-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-960?page=comments#action_12367188 ] Kathey Marsden commented on DERBY-960: -- Suresh pointed out to me that this change caused the following new failures testing derbynetclientmats with 10.1 client and 10.2

[jira] Created: (DERBY-1014) Make tests less sensitive to pre-fetching

2006-02-21 Thread Knut Anders Hatlen (JIRA)
Make tests less sensitive to pre-fetching - Key: DERBY-1014 URL: http://issues.apache.org/jira/browse/DERBY-1014 Project: Derby Type: Sub-task Components: Test Reporter: Knut Anders Hatlen Assigned to: Knut Anders

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

2006-02-21 Thread John Embretsen
Deepa Remesh wrote: Thanks John. I'll also try to see if I can get a machine to setup DOTS after I finish my current iteration of the patch. Good. By the way, I am planning to create a small proof of concept app - independent from, but inspired by, the infamous DOTS test case. This way we

[web] Request for website updates for nightly builds and javadoc

2006-02-21 Thread Kathey Marsden
I think it would be good from the download page to point to the nightly builds that Ole posts for users to try out if they want to be daring: 10.2 - http://www.multinet.no/~solberg/public/Apache/Derby/builds/ 10.1 - http://www.multinet.no/~solberg/public/Apache/Derby-10.1/builds/ I also think

Re: [web] Request for website updates for nightly builds and javadoc

2006-02-21 Thread Kathey Marsden
Kathey Marsden wrote: I also think it would be good for the public API javadoc to be linked from the Manuals page. I know it is linked from the Papers page, but I don't think users would tend to go there. Actually the API is linked, I was just being blind. The only request is for the builds.

Re: RowLocation validation, for holdable SUR

2006-02-21 Thread Andreas Korneliussen
I will modify the suggestion somewhat. I think first, that offline compress is not a problem, even for the holdable SUR. Since offline compress moves the records to another container, the SUR cursors should detect that container they use is no longer valid, when renavigating to the row. If

Re: [web] Request for website updates for nightly builds and javadoc

2006-02-21 Thread Jean T. Anderson
Kathey Marsden wrote: I think it would be good from the download page to point to the nightly builds that Ole posts for users to try out if they want to be daring: 10.2 - http://www.multinet.no/~solberg/public/Apache/Derby/builds/ 10.1 -

Re: [web] Request for website updates for nightly builds and javadoc

2006-02-21 Thread Kathey Marsden
Jean T. Anderson wrote: Kathey Marsden wrote: I think it would be good from the download page to point to the nightly builds that Ole posts for users to try out if they want to be daring: 10.2 - http://www.multinet.no/~solberg/public/Apache/Derby/builds/ 10.1 -

[jira] Commented: (DERBY-870) Update documentation on setting up LDAP user authentication.

2006-02-21 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-870?page=comments#action_12367230 ] Sunitha Kambhampati commented on DERBY-870: --- I tried with 'no' additional jars and I could get LDAP authentication to work with derby with ibm142,jdk142,jdk15 But

[jira] Created: (DERBY-1015) Define interface between network server and engine through Java interfaces.

2006-02-21 Thread Daniel John Debrunner (JIRA)
Define interface between network server and engine through Java interfaces. --- Key: DERBY-1015 URL: http://issues.apache.org/jira/browse/DERBY-1015 Project: Derby Type: Improvement

[jira] Commented: (DERBY-482) GENERATED BY DEFAULT option should be documented in Derby Tools and Utilities guide under Importing into tables with identity columns section.

2006-02-21 Thread Jeff Levitt (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-482?page=comments#action_12367232 ] Jeff Levitt commented on DERBY-482: --- Thats so strange. It did it to me too, and I looked at the original copy on my local machine and it looked fine. Mamtam when you try

[jira] Commented: (DERBY-515) Network Server should log server start and shutdown time to derby.log

2006-02-21 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-515?page=comments#action_12367233 ] Deepa Remesh commented on DERBY-515: Suresh pointed out to me that this change caused the following failure in derbynetclientmats with 10.1 client and 10.2 server:

Re: [web] Request for website updates for nightly builds and javadoc

2006-02-21 Thread Ole Solberg
Kathey Marsden wrote: Jean T. Anderson wrote: Kathey Marsden wrote: I think it would be good from the download page to point to the nightly builds that Ole posts for users to try out if they want to be daring: 10.2 - http://www.multinet.no/~solberg/public/Apache/Derby/builds/ 10.1 -

Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Daniel John Debrunner
Satheesh Bandaram wrote: Oystein Grovlen - Sun Norway wrote: Daniel John Debrunner wrote: CREATE SCHEMA - only create schema matching user's name - good for now, forwards compatible with the future where permission to create any schema could be granted explicitly. Does

Re: RowLocation validation, for holdable SUR

2006-02-21 Thread Mike Matrigali
The SUR should not know anything about the underlying implementation of the access method getting the row, so having it read a timestamp from page does not work. If the timestamp is not in the rowlocation, we could add a get a timestamp for row at this rowlocation, but forcing two trips to the

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

2006-02-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-210?page=comments#action_12367235 ] Kathey Marsden commented on DERBY-210: -- There was a separate thread on this issue on the list where concerns were voiced about doing the result set cleanup work in

[jira] Updated: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

2006-02-21 Thread Anurag Shekhar (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-819?page=all ] Anurag Shekhar updated DERBY-819: - Attachment: derby-819_3.diff Main changed I have made in this patch since the last submission I have moved back the exception methods of Utils.

[jira] Created: (DERBY-1016) javax.transaction.xa.forget (Xid) raises XAER_NOTA exception instead of XA_PROTO on a prepared transaction

2006-02-21 Thread Kathey Marsden (JIRA)
javax.transaction.xa.forget (Xid) raises XAER_NOTA exception instead of XA_PROTO on a prepared transaction -- Key: DERBY-1016 URL:

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

2006-02-21 Thread Fernanda Pizzorno (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=all ] Fernanda Pizzorno updated DERBY-690: Attachment: DERBY-690-v1.diff DERBY-690-v1.stat This is a first cut at a patch for SUR. It corresponds to the description uploaded

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

2006-02-21 Thread Fernanda Pizzorno (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-690?page=all ] Fernanda Pizzorno updated DERBY-690: Other Info: [Patch available] Add scrollable, updatable, insensitive result sets -- Key:

Re: [web] Request for website updates for nightly builds and javadoc

2006-02-21 Thread Jean T. Anderson
Ole Solberg wrote: Kathey Marsden wrote: Jean T. Anderson wrote: Kathey Marsden wrote: I think it would be good from the download page to point to the nightly builds that Ole posts for users to try out if they want to be daring: 10.2 -

Re: [web] Request for website updates for nightly builds and javadoc

2006-02-21 Thread Daniel John Debrunner
Jean T. Anderson wrote: How about this wording for a new Nightly Builds section on http://db.apache.org/derby/derby_downloads.html . Unofficial nightly builds are available from the links below: * 10.1 : http://www.multinet.no/~solberg/public/Apache/Derby-10.1/builds/ *

[jira] Commented: (DERBY-482) GENERATED BY DEFAULT option should be documented in Derby Tools and Utilities guide under Importing into tables with identity columns section.

2006-02-21 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-482?page=comments#action_12367241 ] Mamta A. Satoor commented on DERBY-482: --- Jeff, I looked through the html file and have couple comments. 1)I don't understand the line in the first paragraph You can

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

2006-02-21 Thread Mark H. Kaplan (JIRA)
locking issue with a select statement using an order by clause -- Key: DERBY-1017 URL: http://issues.apache.org/jira/browse/DERBY-1017 Project: Derby Type: Bug Components: Network Server Versions:

[jira] Created: (DERBY-1018) Client xa Statement.getConnection and DatabaseMetadata.getConnection returns underlying NetXAConnection instead of Logical connection

2006-02-21 Thread Kathey Marsden (JIRA)
Client xa Statement.getConnection and DatabaseMetadata.getConnection returns underlying NetXAConnection instead of Logical connection -- Key: DERBY-1018

[jira] Updated: (DERBY-992) A corner case bug and missing optimization in ScrollInsensitiveResultSet

2006-02-21 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-992?page=all ] Dag H. Wanvik updated DERBY-992: Attachment: derby-992-1.diff derby-992-1.stat derby-992-1.{stat,diff} contains a patch for this issue. I have added a test for the case

[jira] Updated: (DERBY-992) A corner case bug and missing optimization in ScrollInsensitiveResultSet

2006-02-21 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-992?page=all ] Dag H. Wanvik updated DERBY-992: Other Info: [Patch available] A corner case bug and missing optimization in ScrollInsensitiveResultSet

[jira] Assigned: (DERBY-992) A corner case bug and missing optimization in ScrollInsensitiveResultSet

2006-02-21 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-992?page=all ] Dag H. Wanvik reassigned DERBY-992: --- Assign To: Dag H. Wanvik A corner case bug and missing optimization in ScrollInsensitiveResultSet

Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Satheesh Bandaram
Daniel John Debrunner wrote: Satheesh Bandaram wrote: Until these system privileges are ready, current proposal limits accesses that would cause forward compatibility issues. Except that it doesn't, I believe we need additional restrictions on table and routine

New Main class for derbytools.jar

2006-02-21 Thread Andrew McIntyre
Following Dan's suggestion to be able to run ij with the -jar command, I thought why not have derbytools.jar itself be runnable with the -jar command, and have it switch on the tools, and pass the remaining arguments to the specific tool. Attached is the patch. If there are no objections, I'll

Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Francois Orsini
On 2/21/06, Satheesh Bandaram [EMAIL PROTECTED] wrote: Oystein Grovlen - Sun Norway wrote: Daniel John Debrunner wrote: CREATE SCHEMA - only create schema matching user's name - good for now, forwards compatible with the future where permission to create any schema

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

2006-02-21 Thread Stan Bradbury (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1017?page=comments#action_12367245 ] Stan Bradbury commented on DERBY-1017: -- Original issue reported to the Cloudscape forum at:

Grant/Revoke subtask - EXTERNAL SECURITY DEFINER | EXTERNAL SECURITY INVOKER

2006-02-21 Thread Mamta Satoor
Hi, Satheesh has added the parser support for EXTERNAL SECURITY DEFINER | EXTERNAL SECURITY INVOKER on a routine (function or procedure). eg from lang/grantRevoke.sql test CREATE PROCEDURE AUTH_TEST.addUserUtility(IN userName VARCHAR(50), IN permission VARCHAR(22)) LANGUAGE JAVA PARAMETER STYLE

Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Francois Orsini
On 2/21/06, Satheesh Bandaram [EMAIL PROTECTED] wrote: Daniel John Debrunner wrote: Satheesh Bandaram wrote: Until these system privileges are ready, current proposal limits accesses that would cause forward compatibility issues. Except that it doesn't, I believe we need additional

Re: New Main class for derbytools.jar

2006-02-21 Thread Daniel John Debrunner
Andrew McIntyre wrote: Dan, expanding on your previous idea, what if we add a class to derbytools.jar as it's default run class that just switches on the available tools, then you can do: java -jar lib/derbytools.jar ij java -jar lib/derbytools.jar sysinfo java -jar lib/derbytools.jar

Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Daniel John Debrunner
Satheesh Bandaram wrote: Daniel John Debrunner wrote: Satheesh Bandaram wrote: Until these system privileges are ready, current proposal limits accesses that would cause forward compatibility issues. Except that it doesn't, I believe we need additional restrictions on table and

Re: New Main class for derbytools.jar

2006-02-21 Thread Andrew McIntyre
On 2/21/06, Daniel John Debrunner [EMAIL PROTECTED] wrote: Andrew McIntyre wrote: Dan, expanding on your previous idea, what if we add a class to derbytools.jar as it's default run class that just switches on the available tools, then you can do: java -jar lib/derbytools.jar ij java

[jira] Created: (DERBY-1019) Add a main class to derbytools.jar so the tools can be run with java -jar

2006-02-21 Thread Andrew McIntyre (JIRA)
Add a main class to derbytools.jar so the tools can be run with java -jar - Key: DERBY-1019 URL: http://issues.apache.org/jira/browse/DERBY-1019 Project: Derby Type: Improvement Components:

[jira] Updated: (DERBY-1019) Add a main class to derbytools.jar so the tools can be run with java -jar

2006-02-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1019?page=all ] Andrew McIntyre updated DERBY-1019: --- Attachment: toolsrun.diff Add a main class to derbytools.jar so the tools can be run with java -jar

[jira] Updated: (DERBY-1019) Add a main class to derbytools.jar so the tools can be run with java -jar

2006-02-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1019?page=all ] Andrew McIntyre updated DERBY-1019: --- Attachment: toolsrun.stat Add a main class to derbytools.jar so the tools can be run with java -jar

[jira] Resolved: (DERBY-960) Client xa prepare returns XA_OK instead of XA_RDONLY for a read only transaction

2006-02-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-960?page=all ] Kathey Marsden resolved DERBY-960: -- Resolution: Fixed Checked in fix to 10.1 Author: kmarsden Date: Tue Feb 21 08:19:30 2006 New Revision: 379513 URL:

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

2006-02-21 Thread Mark H. Kaplan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1017?page=all ] Mark H. Kaplan updated DERBY-1017: -- Attachment: derbyLocking.zip attached is the source code for this issue. Ignore all of the commented lines locking issue with a select statement using

Re: New Main class for derbytools.jar

2006-02-21 Thread Myrna van Lunteren
On 2/21/06, Andrew McIntyre [EMAIL PROTECTED] wrote: On 2/21/06, Daniel John Debrunner [EMAIL PROTECTED] wrote: Andrew McIntyre wrote: Dan, expanding on your previous idea, what if we add a class to derbytools.jar as it's default run class that just switches on the available tools, then you

[jira] Closed: (DERBY-985) i18nTest fails with ''java.sql.SQLException: wrong locale' was thrown while evaluating an expression.' on Win2003

2006-02-21 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-985?page=all ] Myrna van Lunteren closed DERBY-985: Resolution: Duplicate Duplicate of https://issues.apache.org/jira/browse/DERBY-834 i18nTest fails with ''java.sql.SQLException: wrong locale'

Re: New Main class for derbytools.jar

2006-02-21 Thread Andrew McIntyre
On 2/21/06, Myrna van Lunteren [EMAIL PROTECTED] wrote: I'm assuming the lib in (eg) lib/derbytools.jar is referring to the default location thus optional? Correct. Should also make implementing (a reworded) DERBY-667 - (test) more feasible (before it was hard to think of a way of making

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

2006-02-21 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-834?page=comments#action_12367254 ] Myrna van Lunteren commented on DERBY-834: -- This behavior is completely intended whenever the test is run on a machine that does not have the en_US lcoale set.

Global Jira filters for regression test failures and patch available?

2006-02-21 Thread Kathey Marsden
Would it make sense to have global Jira filters for: - Derby regression test failures unresolved Regression Test Failure issues - Derby patches available unresolved patch available issues ? Is there anyway to have a direct link to one of the global filters? I remember playing with

[jira] Commented: (DERBY-464) Enhance Derby by adding grant/revoke support. Grant/Revoke provide finner level of privileges than currently provided by Derby that is especially useful in network config

2006-02-21 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-464?page=comments#action_12367255 ] Satheesh Bandaram commented on DERBY-464: - Dan asked: Another quote from the spec quote A table may only be created or dropped by the owner of the table's

[jira] Created: (DERBY-1020) Network Server treats errors on cleanup of connections as an unexpected error after intentional shutdown of the database/server

2006-02-21 Thread Kathey Marsden (JIRA)
Network Server treats errors on cleanup of connections as an unexpected error after intentional shutdown of the database/server --- Key: DERBY-1020 URL:

[jira] Updated: (DERBY-803) derbynet/DerbyNetAutoStart.java test fails intermittently with org.apache.derby.iapi.services.context.ShutdownException

2006-02-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-803?page=all ] Kathey Marsden updated DERBY-803: - Component: Regression Test Failure Description: DerbyNetAutoStart fails intermittently with the following diff: This issue is likely related to

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

2006-02-21 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-834?page=all ] Myrna van Lunteren updated DERBY-834: - Comment: was deleted i18n/urlLocale.sql test fails on Windows XP --- Key: DERBY-834

[jira] Commented: (DERBY-479) Passing the return of a RETURN NULL ON NULL INPUT function to another function call throws linkage error.

2006-02-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-479?page=comments#action_12367261 ] Daniel John Debrunner commented on DERBY-479: - The comment you added/modified in MethodCallNode is: + ** If the parameter is a SQL ValueNode,

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

2006-02-21 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-834?page=comments#action_12367263 ] Myrna van Lunteren commented on DERBY-834: -- This behavior is to be expected when the test is run on a machine that does not have the en_US locale set. observe this

Re: Performance regressions

2006-02-21 Thread Olav.Sandstaa
Mike Matrigali [EMAIL PROTECTED] wrote: ok, I was hoping that for single user testing it wouldn't be a big change. The single user commit per update is a problem when comparing derby to other db's which don't do real transaction guarantees. It would be great if someone reading the derby web

Regression Test Failure! - TinderBox_Derby 379532 - Sun DBTG

2006-02-21 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 379532/2006-02-21 18:02:33 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 7637630 099.47% SunOS-5.10_i86pc-i386 Details in

Re: Global Jira filters for regression test failures and patch available?

2006-02-21 Thread Satheesh Bandaram
I have created a global filter, Derby: Regression Test Failures. It currently shows three rows. http://issues.apache.org/jira/secure/IssueNavigator.jspa?mode=hiderequestId=12310744 Key Summary Assignee Reporter Pr Status

Re: Performance regressions

2006-02-21 Thread Mike Matrigali
Olav.Sandstaa wrote: Mike Matrigali [EMAIL PROTECTED] wrote: ok, I was hoping that for single user testing it wouldn't be a big change. The single user commit per update is a problem when comparing derby to other db's which don't do real transaction guarantees. It would be great if someone

Re: Performance regressions

2006-02-21 Thread Mike Matrigali
For multi user tests I would not worry about batching the tests as much. It would be better if we can demonstrate that as more users are added throughput increases. If we are using 6% of the cpu I could see it taking more than 17 threads running unblocks to drive the group commit log fast

Re: Grant/Revoke subtask - EXTERNAL SECURITY DEFINER | EXTERNAL SECURITY INVOKER

2006-02-21 Thread Satheesh Bandaram
Thanks for picking this up. A sub-task under DERBY-464 sounds good. Satheesh Mamta Satoor wrote: Hi, Satheesh has added the parser support for EXTERNAL SECURITY DEFINER | EXTERNAL SECURITY INVOKER on a routine (function or procedure). eg from lang/grantRevoke.sql test CREATE PROCEDURE

[jira] Created: (DERBY-1021) Perform cleanup actions which require synchronization outside the finalizer

2006-02-21 Thread Deepa Remesh (JIRA)
Perform cleanup actions which require synchronization outside the finalizer --- Key: DERBY-1021 URL: http://issues.apache.org/jira/browse/DERBY-1021 Project: Derby Type: Bug Components:

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

2006-02-21 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-965?page=all ] Dag H. Wanvik reassigned DERBY-965: --- Assign To: Dag H. Wanvik DatabaseMetadata method supportsResultSetConcurrency returns wrong result on network client

[jira] Created: (DERBY-1022) syscat.sql test failing due to change in size of a system table's column from VARCHAR(30) to VARCHAR(128)

2006-02-21 Thread Daniel John Debrunner (JIRA)
syscat.sql test failing due to change in size of a system table's column from VARCHAR(30) to VARCHAR(128) - Key: DERBY-1022 URL:

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

2006-02-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1006?page=all ] Daniel John Debrunner reassigned DERBY-1006: Assign To: Daniel John Debrunner Client allows setHoldability to HOLD_CURSORS_OVER_COMMIT on both connection and statement in a

Re: Global Jira filters for regression test failures and patch available?

2006-02-21 Thread Kristian Waagan
Myrna van Lunteren wrote: Hi, that link gave me an error (and subsequently my windoze OS got a page fault :-/ ) I couldn't find it under filters, do I need special permission to access that filter? But I'm wondering what you have in there, because e.g. DERBY-988 should show up for

[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-02-21 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-805?page=all ] A B updated DERBY-805: -- Other Info: (was: [Patch available]) While working with other changes for this issue, I came to realize that d805_phase1_v2 has one small problem. That patch assumes that an

Re: Global Jira filters for regression test failures and patch available?

2006-02-21 Thread Jean T. Anderson
Kristian Waagan wrote: ... Hi, I can't find the filter either. But JIRA is acting strange on me again... Somebody reported Jira problems to infrastructure about 5 minutes ago. -jean

[jira] Updated: (DERBY-304) If by mistake you give he location for the db backup as the db itself , then windows created directories recursively until windows crashes!

2006-02-21 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-304?page=all ] Mike Matrigali updated DERBY-304: - Description: If by mistake you give he location for the db backup as the db itself , then windows created directories recursively until it crashes! Repro:

[jira] Updated: (DERBY-1003) store/bootLock.java fails with J2ME/CDC/FP

2006-02-21 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1003?page=all ] Mike Matrigali updated DERBY-1003: -- Component: Regression Test Failure store/bootLock.java fails with J2ME/CDC/FP -- Key: DERBY-1003

[jira] Created: (DERBY-1023) Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER support for routines(functions or procedures)

2006-02-21 Thread Mamta A. Satoor (JIRA)
Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER support for routines(functions or procedures) -- Key: DERBY-1023 URL:

[jira] Assigned: (DERBY-1023) Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER support for routines(functions or procedures)

2006-02-21 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1023?page=all ] Mamta A. Satoor reassigned DERBY-1023: -- Assign To: Mamta A. Satoor Add EXTERNAL SECURITY DEFINER and EXTERNAL SECURITY INVOKER support for routines(functions or procedures)

[jira] Resolved: (DERBY-1013) jdbc4 test suite test classes are using Util.notImplemented

2006-02-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1013?page=all ] Rick Hillegas resolved DERBY-1013: -- Resolution: Fixed Good step forward. Patch touches only jdbc 4 tests. They run cleanly. Committed with subversion revision 379634. jdbc4 test suite

[jira] Updated: (DERBY-1019) Add a main class to derbytools.jar so the tools can be run with java -jar

2006-02-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1019?page=all ] Andrew McIntyre updated DERBY-1019: --- Attachment: toolsrun_v2.diff Hi Dan, thanks for the feedback. I agree that this should not be part of the public api. I've moved the run class into iapi

[jira] Updated: (DERBY-1019) Add a main class to derbytools.jar so the tools can be run with java -jar

2006-02-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1019?page=all ] Andrew McIntyre updated DERBY-1019: --- Attachment: (was: toolsrun_v2.diff) Add a main class to derbytools.jar so the tools can be run with java -jar

[jira] Updated: (DERBY-1019) Add a main class to derbytools.jar so the tools can be run with java -jar

2006-02-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1019?page=all ] Andrew McIntyre updated DERBY-1019: --- Attachment: toolsrun_v2.diff Add a main class to derbytools.jar so the tools can be run with java -jar

[jira] Resolved: (DERBY-903) Remove use of String(byte[]) and String(byte[], int, int) constructors in testing leading to non-portable behaviour

2006-02-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-903?page=all ] Andrew McIntyre resolved DERBY-903: --- Resolution: Fixed Committed followup patch with revision 379643. Remove use of String(byte[]) and String(byte[], int, int) constructors in

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

2006-02-21 Thread Daniel John Debrunner (JIRA)
Client's XAResource.start throws XAException with XAER_RMFAIL when local transaction is active -- Key: DERBY-1024 URL: http://issues.apache.org/jira/browse/DERBY-1024 Project: Derby

NetXAResource - duplicate constants?

2006-02-21 Thread Daniel John Debrunner
Anyone have any idea why the client's NetXAResource has its own version of XA return value constants, that seem to have the same value as the constants in javax.transaction.xa.XAException? Thanks, Dan. org.apache.derby.client.net.NetXAResource // xaretval defines public static final int

[jira] Closed: (DERBY-903) Remove use of String(byte[]) and String(byte[], int, int) constructors in testing leading to non-portable behaviour

2006-02-21 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-903?page=all ] Myrna van Lunteren closed DERBY-903: Remove use of String(byte[]) and String(byte[], int, int) constructors in testing leading to non-portable behaviour

[jira] Created: (DERBY-1025) XAResource.start() does not commit an active local transaction when auto commit is true

2006-02-21 Thread Daniel John Debrunner (JIRA)
XAResource.start() does not commit an active local transaction when auto commit is true --- Key: DERBY-1025 URL: http://issues.apache.org/jira/browse/DERBY-1025 Project: Derby Type:

[jira] Resolved: (DERBY-575) test blobclob4BLOB fails on OS 390

2006-02-21 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-575?page=all ] Myrna van Lunteren resolved DERBY-575: -- Resolution: Fixed This has now been fixed with DERBY-903, revision 379643 test blobclob4BLOB fails on OS 390

Regression Test Failure! - TinderBox_Derby 379593 - Sun DBTG

2006-02-21 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 379593/2006-02-21 22:32:49 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 7637630 0 101.89% SunOS-5.10_i86pc-i386 Details in

Re: [jira] Created: (DERBY-1022) syscat.sql test failing due to change in size of a system table's column from VARCHAR(30) to VARCHAR(128)

2006-02-21 Thread Satheesh Bandaram
Ouch... I will fix this. Satheesh Daniel John Debrunner (JIRA) wrote: syscat.sql test failing due to change in size of a system table's column from VARCHAR(30) to VARCHAR(128) -

Re: Global Jira filters for regression test failures and patch available?

2006-02-21 Thread Satheesh Bandaram
Kristian Waagan wrote: Myrna van Lunteren wrote: Hi, that link gave me an error (and subsequently my windoze OS got a page fault :-/ ) I couldn't find it under filters, do I need special permission to access that filter? But I'm wondering what you have in there,

[jira] Assigned: (DERBY-1022) syscat.sql test failing due to change in size of a system table's column from VARCHAR(30) to VARCHAR(128)

2006-02-21 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1022?page=all ] Satheesh Bandaram reassigned DERBY-1022: Assign To: Satheesh Bandaram syscat.sql test failing due to change in size of a system table's column from VARCHAR(30) to VARCHAR(128)

[jira] Created: (DERBY-1026) LDAP with caching DNs in derby.user.userName as database property does not work

2006-02-21 Thread Sunitha Kambhampati (JIRA)
LDAP with caching DNs in derby.user.userName as database property does not work --- Key: DERBY-1026 URL: http://issues.apache.org/jira/browse/DERBY-1026 Project: Derby Type: Bug

Re: [jira] Created: (DERBY-1022) syscat.sql test failing due to change in size of a system table's column from VARCHAR(30) to VARCHAR(128)

2006-02-21 Thread Satheesh Bandaram
Both are fixed now. Satheesh Myrna van Lunteren wrote: Satheesh, do you perhaps know anything about the failure in grantrevoke.sql also? From ole's mail: http://www.multinet.no/~solberg/public/Apache/TinderBox_Derby/testlog/SunOS-5.10_i86pc-i386/379593-derbyall_diff.txt Myrna

Re: Global Jira filters for regression test failures and patch available?

2006-02-21 Thread Satheesh Bandaram
Try the filter now... Can you find it? Does it show right results? I had the filter show only issues marked for 10.2. Many don't have fix version. I think unassigned issues need to be assigned by finding the change that caused the failure (on standard platforms) or found a volunteer for

Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Satheesh Bandaram
Francois Orsini wrote: I'll be posting more information soon. Great... Do you see this work going into 10.2 release or later versions? I would like to know so that documentation changes can be made appropriately for my work on Grant and Revoke. Satheesh

Re: Grant -revoke (464) and future backwards compat

2006-02-21 Thread Satheesh Bandaram
Daniel John Debrunner wrote: I looked at some other databases (Oracle, DB2, Postgres) and the typical model is to require a database level privilege to create tables or call an external routine. Create table I could possibly go either way on, but if we followed the de-facto standard model of

Regression Test Failure! - TinderBox_Derby 379648 - Sun DBTG

2006-02-21 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 379648/2006-02-22 03:02:47 CET *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 7638631 0 101.32% SunOS-5.10_i86pc-i386 Details in

  1   2   >