[jira] Commented: (DERBY-2060) SET CURRENT ISOLATION in ref.man refers java.sql.Connection.setTransactionLevel instead of java.sql.Connection.setTransactionIsolation

2006-12-12 Thread Bernt M. Johnsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2060?page=comments#action_12457643 ] Bernt M. Johnsen commented on DERBY-2060: - Seems ok to me. +1 to commit. I don't have a working doc working set for the moment, so if some other committer

[jira] Created: (DERBY-2167) Slightly misleading error message for UNIQUE constraint without NUT NULL constraint

2006-12-12 Thread Bernt M. Johnsen (JIRA)
Slightly misleading error message for UNIQUE constraint without NUT NULL constraint --- Key: DERBY-2167 URL: http://issues.apache.org/jira/browse/DERBY-2167 Project:

[jira] Updated: (DERBY-2167) Slightly misleading error message for UNIQUE constraint without NOT NULL constraint

2006-12-12 Thread Bernt M. Johnsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2167?page=all ] Bernt M. Johnsen updated DERBY-2167: Summary: Slightly misleading error message for UNIQUE constraint without NOT NULL constraint (was: Slightly misleading error message for UNIQUE

Re: Releasing latches when waiting for locks. When and why?

2006-12-12 Thread Knut Anders Hatlen
Anders Morken [EMAIL PROTECTED] writes: While I'm not an expert on the subject matter, I can't help myself but chime in and share my thoughts on this... =) During the course of our project on analyzing Derby's SMP scalability properties, we've investigated Derby's locking and latching pretty

Re: Releasing latches when waiting for locks. When and why?

2006-12-12 Thread Knut Anders Hatlen
Suresh Thalamati [EMAIL PROTECTED] writes: If we are removing Latching out of LockManager for perfromance reasons, my preference also would be to handle at the page level, instead of having yet another indirection. As Mike mentioned , it would be nice to have a VTI that will show the

Re: Releasing latches when waiting for locks. When and why?

2006-12-12 Thread Knut Anders Hatlen
Olav Sandstaa [EMAIL PROTECTED] writes: Knut Anders Hatlen wrote: [...] This is impressive, and much higher than what I would have expected by just moving the latching out of the lock manager. I would guess that the improvement is mainly caused by a) Less contention on the lock table

[jira] Updated: (DERBY-2144) Meta-data for Container could not be accessed when execute a SQL (select statement) for a View with 322 sub tables and views

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2144?page=all ] Rick Hillegas updated DERBY-2144: - Urgency: Normal (was: Blocker) Priority: Major (was: Blocker) Adjusting priority and urgency to the usual values. Meta-data for Container could not

[jira] Updated: (DERBY-1471) Implement layer B streaming for new methods defined in JDBC4.0

2006-12-12 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1471?page=all ] Tomohito Nakayama updated DERBY-1471: - Attachment: DERBY-1471_4.patch DERBY-1471_4.stat * Description of the patch * This patch implements Layer B streaming for new

Re: Derby JDBC 4.0 implementation -- any discrepancies with the final?

2006-12-12 Thread Rick Hillegas
Hi Jean, The Derby JDBC 4 drivers conform to the final version of Java SE 6 which sent out the door yesterday. So, yes, that disclaimer should be scrubbed from the user guide. Thanks, -Rick Jean T. Anderson wrote: How close is the Derby JDBC 4.0 implementation to what actually left the

Re: Some questions about FormatableBitSet

2006-12-12 Thread Knut Anders Hatlen
[EMAIL PROTECTED] writes: There are a couple of things in the implementation of this class that I just don't understand: - The doc for the method grow() says: ASSUMPTIONS: that all extra bits in the last byte are zero. But in other methods (or() and()...) great care is taken mask out

Re: Should be a statement with error allowed to do a rollback of the active transaction

2006-12-12 Thread Knut Anders Hatlen
Julius Stroffek [EMAIL PROTECTED] writes: Knut Anders Hatlen wrote: Bryan Pendleton [EMAIL PROTECTED] writes: The key question is whether the statement with error should (or could) rollback the active transaction? Does this same situation arise with an embedded configuration? If

[jira] Subscription: Derby: JIRA issues with patch available

2006-12-12 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (12 issues) Subscriber: derby-dev Key Summary DERBY-1471 Implement layer B streaming for new methods defined in JDBC4.0 http://issues.apache.org/jira/browse/DERBY-1471 DERBY-2060 SET CURRENT ISOLATION in

[jira] Closed: (DERBY-2083) Shutting down a database loaded from a jar leaves an open file reference to the jar file containing the database.

2006-12-12 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2083?page=all ] Daniel John Debrunner closed DERBY-2083. Resolution: Fixed Revision 484672 fixes the backup problem introduced with the first set of changes. Shutting down a database loaded from a

Re: Derby JDBC 4.0 implementation -- any discrepancies with the final?

2006-12-12 Thread Jean T. Anderson
Rick Hillegas wrote: Hi Jean, The Derby JDBC 4 drivers conform to the final version of Java SE 6 which sent out the door yesterday. So, yes, that disclaimer should be scrubbed from the user guide. Thanks, Rick, I also removed the disclaimer from the trunk, revision 486210. -jean

[jira] Updated: (DERBY-2130) Optimizer performance slowdown from 10.1 to 10.2

2006-12-12 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2130?page=all ] A B updated DERBY-2130: --- Attachment: jumpReset.patch That is, once I saw 500 seconds for the prepare on database 6, but I reran DB 6 and saw 168 seconds. [...] I don't think that the non- determinism

Re: [jira] Updated: (DERBY-2130) Optimizer performance slowdown from 10.1 to 10.2

2006-12-12 Thread Bryan Pendleton
can you apply jumpReset.patch to your codeline and run your tests again? You bet! This sounds like a very interesting theory to pursue. thanks, bryan

Regression Test Report - Daily 485752 - Sun DBTG

2006-12-12 Thread Henri . Vandescheur
[Auto-generated mail] *Daily* 485752/2006-12-11 18:00:25 MET Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin 0517517 0 100.29% derbyall 064786478 0 153.43% suitesAll sol 0

Re: Question about FetchDescriptor.materialized_cols

2006-12-12 Thread Mike Matrigali
as with most RESOLVES and TODO still in the code, it has been a long time since anything has happened on them. FetchDescriptor came about from a profiling/performance pass on the code. An array was chosen so that no routine and/or math would be needed to set/clear the info. Int's were chosen

Re: Some questions about FormatableBitSet

2006-12-12 Thread Olav Sandstaa
Daniel John Debrunner wrote: [EMAIL PROTECTED] wrote: - A minor nit: This class appears to do a lot of division and remainder calculations with powers of 2 (frequently 8). Is it not generally preferably to do this with shifts and bitwise ANDs? I prefer the approach that leads to code

Re: Question about FetchDescriptor.materialized_cols

2006-12-12 Thread Mike Matrigali
Mike Matrigali wrote: The more interesting issue is the general cost of getting to a column, let me start a separate thread on that. I just filed a derby issue about the issues with the current row format and determining offset to a given column. DERBY-2168

Re: Some questions about FormatableBitSet

2006-12-12 Thread Mike Matrigali
Given the test run I would be ok with a class that is obviously in the business of manipulating bits to do tricks with shift. Please when changing the code increase the comments around the shifts and maybe include your reasoning (ie. perf results) so that someone else doesn't change it because

Re: [jira] Commented: (DERBY-2109) System privileges

2006-12-12 Thread Rick Hillegas
Daniel John Debrunner wrote: Rick Hillegas (JIRA) wrote: Dan, could you say something more about how you think we should sand-down the plugin privilege: I did: http://mail-archives.apache.org/mod_mbox/db-derby-dev/200611.mbox/[EMAIL PROTECTED] Thanks, Dan. I did not see this mail

[jira] Commented: (DERBY-2143) Updated localized messages for Derby 10.2

2006-12-12 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2143?page=comments#action_12457884 ] Myrna van Lunteren commented on DERBY-2143: --- iepnegativetests_ES was failing for j9_foundation in 10.2 and trunk because the master(canon) file

[jira] Commented: (DERBY-2109) System privileges

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2109?page=comments#action_12457903 ] Rick Hillegas commented on DERBY-2109: -- Dan, here are some responses to your last set of questions yesterday: 1) Why doAsPrivileged() rather than doAs(): The

[jira] Updated: (DERBY-2142) NullPointerException while using XAConnection/PooledConnection in a heavily contended multithreaded scenario

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2142?page=all ] Rick Hillegas updated DERBY-2142: - Urgency: Normal (was: Urgent) Priority: Major (was: Critical) Adjusting urgency and priority to the standard levels. NullPointerException while

[jira] Updated: (DERBY-1567) generateClientMessageTest.sh is broken

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1567?page=all ] Rick Hillegas updated DERBY-1567: - Affects Version/s: (was: 10.2.1.6) Unknown release vehicle. generateClientMessageTest.sh is broken --

[jira] Updated: (DERBY-1517) Derby Network Client to handle list of SECMEC(s) returned by existing/released DRDA Derby Network Servers

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1517?page=all ] Rick Hillegas updated DERBY-1517: - Fix Version/s: (was: 10.2.2.0) Unknown release vehicle. Derby Network Client to handle list of SECMEC(s) returned by existing/released DRDA Derby

[jira] Updated: (DERBY-1458) Add MessageBundleTest to build script to verify that there are no orphaned message ids

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1458?page=all ] Rick Hillegas updated DERBY-1458: - Fix Version/s: (was: 10.2.2.0) Unknown release vehicle. Add MessageBundleTest to build script to verify that there are no orphaned message ids

[jira] Updated: (DERBY-1433) Client driver does not handle string literals containing where current of correctly

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1433?page=all ] Rick Hillegas updated DERBY-1433: - Fix Version/s: (was: 10.2.2.0) Unknown release vehicle. Client driver does not handle string literals containing where current of correctly

[jira] Updated: (DERBY-1341) LOB setBytes method(s) are currently no supported, but part of the Java 1.4 JDBC interface

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1341?page=all ] Rick Hillegas updated DERBY-1341: - Fix Version/s: (was: 10.2.2.0) Unknown release vehicle. LOB setBytes method(s) are currently no supported, but part of the Java 1.4 JDBC interface

[jira] Updated: (DERBY-790) SQLException used by the networked interface to Derby is not serializable

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-790?page=all ] Rick Hillegas updated DERBY-790: Fix Version/s: (was: 10.2.2.0) Unknown release vehicle. SQLException used by the networked interface to Derby is not serializable

[jira] Updated: (DERBY-2125) Getting Started with Derby - Installing Derby

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2125?page=all ] Rick Hillegas updated DERBY-2125: - Fix Version/s: (was: 10.2.2.0) Unknown release vehicle. Getting Started with Derby - Installing Derby -

[jira] Updated: (DERBY-1650) derbytools.jar needs org.apache.derby.iapi.reference.Attribute even though that class contains only interface Strings

2006-12-12 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1650?page=all ] Rick Hillegas updated DERBY-1650: - Fix Version/s: (was: 10.2.2.0) Unknown release vehicle. derbytools.jar needs org.apache.derby.iapi.reference.Attribute even though that class

[jira] Commented: (DERBY-1716) Revoking select privilege from a user times out when that user still have a cursor open.

2006-12-12 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1716?page=comments#action_12457926 ] Myrna van Lunteren commented on DERBY-1716: --- updated the 10.2 j9_foundation canon with revision 486380. Revoking select privilege from a user times out

[jira] Commented: (DERBY-2109) System privileges

2006-12-12 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-2109?page=comments#action_12457941 ] Daniel John Debrunner commented on DERBY-2109: -- doAsPrivileged() vs. doAs() Thanks for the link to the JAAS reference, I think a better technical

Re: [VOTE] 10.2.2.0 release

2006-12-12 Thread Army
Rick Hillegas wrote: Please download and test-drive the 10.2.2.0 candidate, then vote on whether to accept it as a Derby release. For posterity I ran a set of ODBC tests against Derby Network Server - 10.2.2.0 - (485682) using the DB2 Runtime Client (v8) and all tests ran as expected. I