Regression Test Failure! - TinderBox_Derby 421119 - Sun DBTG

2006-07-12 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 421119/2006-07-12 06:52:30 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1675674 2 117.01% SunOS-5.10_i86pc-i386 Details in http://www.mult

[jira] Resolved: (DERBY-1502) Non-deterministic behavior of lang/grantRevokeDDL.sql

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1502?page=all ] Knut Anders Hatlen resolved DERBY-1502: --- Resolution: Fixed Derby Info: (was: [Patch Available]) Thanks Mamta! Committed revision 421179. > Non-deterministic behavior of lang/g

[jira] Commented: (DERBY-1501) PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType is LONGVARBINARY in embedded mode

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1501?page=comments#action_12420542 ] Knut Anders Hatlen commented on DERBY-1501: --- The first issue (difference between embedded and client) is already logged as DERBY-1494. > PreparedStatement#setNull(i

[jira] Commented: (DERBY-1501) PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType is LONGVARBINARY in embedded mode

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1501?page=comments#action_12420549 ] Knut Anders Hatlen commented on DERBY-1501: --- Kristian wrote: > But what about the second issue? The embedded driver determines if > the type of the parameter is "com

[jira] Commented: (DERBY-1480) Crash with JVM 1.4.2_08-b03

2006-07-12 Thread Holger Tewis (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1480?page=comments#action_12420552 ] Holger Tewis commented on DERBY-1480: - It is not reliably reproducable. We had the problem twice, but it did not occur again although we did not change jvm or jvm settings

[jira] Commented: (DERBY-1480) Crash with JVM 1.4.2_08-b03

2006-07-12 Thread Holger Tewis (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1480?page=comments#action_12420554 ] Holger Tewis commented on DERBY-1480: - Oh, today we had the problem again. The setup is quite complex not something I could submit anywhere. I will post a bugreport at sun.

Regression Test Failure! - Derby 420933 - Sun DBTG

2006-07-12 Thread Ole . Solberg
[Auto-generated mail] *Derby* 420933/2006-07-11 19:46:13 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.6* 2717715 0 105.30% SunOS-5.10_i86pc-i386 Details in http://www.multinet.no/~s

Re: Google SOC:MySQL to Derby Migration tool design question

2006-07-12 Thread Martin van den Bemt
+1 on that (from a ddlutils committer, with way too little time on his hands..) :) Mvgr, Martin Bryan Pendleton wrote: The DdlUtils tool seems not be capable of migrating views, CHECK constraints, and stored procedures. I would like to know what do you think if DdlUtils tool can be reused for

[jira] Created: (DERBY-1503) Make jdbc4/StatementEventsTest.junit test callable statements

2006-07-12 Thread Knut Anders Hatlen (JIRA)
Make jdbc4/StatementEventsTest.junit test callable statements - Key: DERBY-1503 URL: http://issues.apache.org/jira/browse/DERBY-1503 Project: Derby Type: Improvement Components: JDBC, Test Versions:

[jira] Commented: (DERBY-1486) ERROR 40XD0 - When exracting Blob from a database

2006-07-12 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1486?page=comments#action_12420571 ] Andreas Korneliussen commented on DERBY-1486: - When executing a statement in autocommit mode, the transaction will be committed. You are using forward-only, hold

[jira] Updated: (DERBY-1503) Make jdbc4/StatementEventsTest.junit test callable statements

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1503?page=all ] Knut Anders Hatlen updated DERBY-1503: -- Attachment: derby-1503-v1.diff The attached patch changes StatementEventsTest the following way: 1) New methods setXA() and setCallable() which m

[jira] Closed: (DERBY-1503) Make jdbc4/StatementEventsTest.junit test callable statements

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1503?page=all ] Knut Anders Hatlen closed DERBY-1503: - Fix Version: 10.2.0.0 Resolution: Fixed Committed revision 421218. > Make jdbc4/StatementEventsTest.junit test callable statements > --

[jira] Commented: (DERBY-550) BLOB : java.lang.OutOfMemoryError with network JDBC driver (org.apache.derby.jdbc.ClientDriver)

2006-07-12 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-550?page=comments#action_12420591 ] Andreas Korneliussen commented on DERBY-550: Unless the streaming could be fixed for 10.2 so that we avoid OutOfMemoryError on the receiver side, I would propose th

[jira] Assigned: (DERBY-1493) EmbeddedDriver does not implement PreparedStatement.setNull(int, int, String)

2006-07-12 Thread V.Narayanan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1493?page=all ] V.Narayanan reassigned DERBY-1493: -- Assign To: V.Narayanan > EmbeddedDriver does not implement PreparedStatement.setNull(int, int, String) > ---

[jira] Commented: (DERBY-323) Locale problem in test of derby

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-323?page=comments#action_12420598 ] Knut Anders Hatlen commented on DERBY-323: -- The DERBY-1352 fix didn't completely fix this issue. When I ran derbyall with Japanese locale, the nist tests and some test

Re: [jira] Commented: (DERBY-550) BLOB : java.lang.OutOfMemoryError with network JDBC driver (org.apache.derby.jdbc.ClientDriver)

2006-07-12 Thread TomohitoNakayama
Hello. Regretfully I'm not sure whether I can fix this issue until 10.2 release because it is not clear where memory is used wastefully and how we can judge whether we could solve this issue. //Even if OutOfMemoryError happens, it would be not a problem in an environment with very small amount

[jira] Closed: (DERBY-1476) PreparedStatement.setNull(int,int) should throw SQLFeatureNotSupportedException for unsupported types

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1476?page=all ] Knut Anders Hatlen closed DERBY-1476: - Resolution: Fixed Derby Info: (was: [Patch Available]) Committed revision 421255. > PreparedStatement.setNull(int,int) should throw > SQL

[jira] Created: (DERBY-1504) Fix way to measure wasteful use of memory when LOB is communicated between network server and driver

2006-07-12 Thread Tomohito Nakayama (JIRA)
Fix way to measure wasteful use of memory when LOB is communicated between network server and driver Key: DERBY-1504 URL: http://issues.apache.org/jira/browse/DERBY-1504 Pro

[jira] Updated: (DERBY-253) Client should throw not implemented exception for depricated setUnicodeStream/getUnicodeStream

2006-07-12 Thread Olav Sandstaa (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-253?page=all ] Olav Sandstaa updated DERBY-253: Attachment: derby253.diff This patch replaces the existing implementation of setUnicodeStream and getUnicodeStream in the client driver to just throw a SQL exce

[jira] Updated: (DERBY-253) Client should throw not implemented exception for depricated setUnicodeStream/getUnicodeStream

2006-07-12 Thread Olav Sandstaa (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-253?page=all ] Olav Sandstaa updated DERBY-253: Derby Info: [Patch Available] > Client should throw not implemented exception for depricated > setUnicodeStream/getUnicodeStream > -

[jira] Commented: (DERBY-1486) ERROR 40XD0 - When exracting Blob from a database

2006-07-12 Thread David Heath (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1486?page=comments#action_12420608 ] David Heath commented on DERBY-1486: Please could someone validate my assumptions from the previous post? Firstly, from the previous post my understanding is the JDBS stan

Re: [jira] Updated: (DERBY-253) Client should throw not implemented exception for depricated setUnicodeStream/getUnicodeStream

2006-07-12 Thread Olav Sandstaa
Forgot to mention that I have run derbyall with no errors using JDK 1.5 on Solaris 10 x86. ..olav Olav Sandstaa (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-253?page=all ] Olav Sandstaa updated DERBY-253: Attachment: derby253.diff Thi

Re: Language based matching

2006-07-12 Thread Kathey Marsden
Rick Hillegas wrote: 3) The locale-sensitive meaning of <, =, and > affected the operation of all orderings of national strings, including sorts, indexes, unions, group-by's, like's, between's, and in's. At one point I was keen on re-enabling the national string types. Now I am leaning t

[jira] Commented: (DERBY-1486) ERROR 40XD0 - When exracting Blob from a database

2006-07-12 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1486?page=comments#action_12420614 ] Andreas Korneliussen commented on DERBY-1486: - Executing a new statement, will cause a commit on the current transaction, which is in line with the standard. The r

[jira] Commented: (DERBY-1501) PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType is LONGVARBINARY in embedded mode

2006-07-12 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1501?page=comments#action_12420620 ] Daniel John Debrunner commented on DERBY-1501: -- Knut Anders indicates setNull(int,int,String) - If a JDBC driver does not need the type code or type name infor

[jira] Commented: (DERBY-1486) ERROR 40XD0 - When exracting Blob from a database

2006-07-12 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1486?page=comments#action_12420618 ] Andreas Korneliussen commented on DERBY-1486: - To clarify: this applies only in autocommit: > Executing a new statement, will cause a commit on the current transact

Re: [jira] Commented: (DERBY-550) BLOB : java.lang.OutOfMemoryError with network JDBC driver (org.apache.derby.jdbc.ClientDriver)

2006-07-12 Thread Andreas Korneliussen
TomohitoNakayama wrote: Hello. Regretfully I'm not sure whether I can fix this issue until 10.2 release because it is not clear where memory is used wastefully and how we can judge whether we could solve this issue. Hi. I am not sure I could fix this for 10.2 either, therefore I suggested th

[jira] Updated: (DERBY-802) OutofMemory Error when reading large blob when statement type is ResultSet.TYPE_SCROLL_INSENSITIVE

2006-07-12 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-802?page=all ] Andreas Korneliussen updated DERBY-802: --- Attachment: derby-802v2.diff The attached diff (derby-802v2.diff) has one change compared to the first diff: * The logic for undoing the projection

[jira] Commented: (DERBY-1130) Client should not allow databaseName to be set with setConnectionAttributes

2006-07-12 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1130?page=comments#action_12420626 ] Deepa Remesh commented on DERBY-1130: - For Kathey's question: What is the exception for embedded if create=true is not specified? e.g. ds.setConnectionAttributes("databas

[PATCH] DERBY-551: Allow invoking java stored procedures from inside a trigger. Make CALL a valid statement in the trigger body.

2006-07-12 Thread Deepa Remesh
I have a patch (derby-551-patch1-v1.diff) for this issue pending review: http://issues.apache.org/jira/browse/DERBY-551#action_12420336 I would appreciate if someone can look at this patch. Thanks, Deepa

[jira] Commented: (DERBY-551) Allow invoking java stored procedures from inside a trigger. Make CALL a valid statement in the trigger body.

2006-07-12 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-551?page=comments#action_12420629 ] Daniel John Debrunner commented on DERBY-551: - Just to clarify, it seems that this patch does not disable MODIFIES SQL DATA procedures in a before trigger, only DDL

Re: [jira] Commented: (DERBY-550) BLOB : java.lang.OutOfMemoryError with network JDBC driver (org.apache.derby.jdbc.ClientDriver)

2006-07-12 Thread TomohitoNakayama
Hello Andreas. //Even if OutOfMemoryError happens, it would be not a problem in an environment with very small amount of memory I am not sure I understand why it would not be a problem in an environment with very small amount of memory. The side-effects of outofmemoryerror would be t

Maximum size of materialized LOB

2006-07-12 Thread Kristian Waagan
Hello, I have been playing around with the length less streaming overloads in JDBC4. In the discussion of DERBY-1471, it was suggested that we forgot about the layerB streaming in DRDA at the moment and instead implemented a much simpler approach. When we have what we need, we can improve the

[jira] Commented: (DERBY-551) Allow invoking java stored procedures from inside a trigger. Make CALL a valid statement in the trigger body.

2006-07-12 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-551?page=comments#action_12420633 ] Daniel John Debrunner commented on DERBY-551: - Patch derby-551-patch1-v1.diff committed revision 421281. Thanks Deepa > Allow invoking java stored procedures from i

[jira] Updated: (DERBY-1504) Fix way to measure wasteful use of memory when LOB is communicated between network server and driver

2006-07-12 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1504?page=all ] Tomohito Nakayama updated DERBY-1504: - Attachment: MeasureMemoryUsageOfNetworkServer.java This program start NetworkServer and print memory usage information to System.out for each millise

UnsupportedClassVersionError running xa suite under jdk1.3

2006-07-12 Thread Rick Hillegas
I'm seeing the following error when I run the xa suite under jdk1.3. This looks like an environmental problem to me. Would appreciate advice on the accepted way to fix my environment for running the tests under jdk1.3. The suite dies trying to load javax.transaction.xa.Xid. This is a class wh

[jira] Updated: (DERBY-1504) Fix way to measure wasteful use of memory when LOB is communicated between network server and driver

2006-07-12 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1504?page=all ] Tomohito Nakayama updated DERBY-1504: - Attachment: serverMemoryUsage.xls This workbook is created from log when BlobOutOfMem.java is executed. ( http://issues.apache.org/jira/secure/attachm

Re: Revoke REFERENCES privilege and drop foreign key constraint

2006-07-12 Thread Daniel John Debrunner
Mamta Satoor wrote: > Hi, > > I spent some time prototyping revoke privilege for foreign key constraint > based on my proposal earlier in this thread. > I added following code to ConstraintDescriptor.makeInvalid > > if (action == DependencyManager.REVOKE_PRIVILEGE) > { > PreparedStatement ps

[jira] Commented: (DERBY-1504) Fix way to measure wasteful use of memory when LOB is communicated between network server and driver

2006-07-12 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1504?page=comments#action_12420640 ] Tomohito Nakayama commented on DERBY-1504: -- I will measure server side memory usage using UsageOfNetworkServer.java (http://issues.apache.org/jira/secure/attachment/12

[jira] Commented: (DERBY-1504) Fix way to measure wasteful use of memory when LOB is communicated between network server and driver

2006-07-12 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1504?page=comments#action_12420641 ] Tomohito Nakayama commented on DERBY-1504: -- This WorkBook means serverMemoryUsage.xls ( http://issues.apache.org/jira/secure/attachment/12336743/serverMemoryUsage.xl

Optimizer patch reviews? (DERBY-781, DERBY-1357)

2006-07-12 Thread Army
I posted two patches for some optimizer changes a little over a week ago: one for DERBY-781 and one for DERBY-1357. Has anyone had a chance to review either of them, or is anyone planning to? I'm hoping to have these reviewed and committed sometime in the next few days so that I'm not forced

[jira] Updated: (DERBY-781) Materialize union subqueries in select list where possible to avoid creating invariant resultsets many times.

2006-07-12 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-781?page=all ] A B updated DERBY-781: -- Attachment: d781_v2.patch Attaching an updated patch, d781_v2.patch, that is synced with the latest codeline and that also has a small fix to the lang/subquery test (there was a t

Re: Revoke REFERENCES privilege and drop foreign key constraint

2006-07-12 Thread Mamta Satoor
Yes, that is what I had originally tried, which is to have the ConstraintDescriptor.makeInvalid call following when it receives REVOKE_PRIVILEGE action getDataDictionary().dropConstraintDescriptor(getTableDescriptor(), this, lcc.getTransactionExecute());  But looks like that is not sufficient to h

[jira] Updated: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-07-12 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=all ] Kristian Waagan updated DERBY-1417: --- Attachment: derby-1417-3a-embimpl-and-tests.diff derby-1417-3a-embimpl-and-tests.stat 'derby-1417-3a-embimpl-and-tests.diff' provides test

Re: UnsupportedClassVersionError running xa suite under jdk1.3

2006-07-12 Thread Myrna van Lunteren
On 7/12/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: I'm seeing the following error when I run the xa suite under jdk1.3. This looks like an environmental problem to me. Would appreciate advice on the accepted way to fix my environment for running the tests under jdk1.3. The suite dies trying to

Re: Google SOC:MySQL to Derby Migration tool design question

2006-07-12 Thread Ramin Moazeni
Hi Bryan, I am not sure this would be feasible given the amount of time I have to finish this project as well as my familiarity with DdlUtils code base. But if everybody agrees to it, I can start working on it. Thanks Ramin On 7/11/06, Bryan Pendleton <[EMAIL PROTECTED]> wrote: > The DdlUtils

[jira] Updated: (DERBY-551) Allow invoking java stored procedures from inside a trigger. Make CALL a valid statement in the trigger body.

2006-07-12 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-551?page=all ] Deepa Remesh updated DERBY-551: --- Attachment: derby-551-patch2-v1.diff Thanks Dan for committing patch1. Based on Dan's suggestion, I am working on adding a check to the parser for disallowing p

Re: Language based matching

2006-07-12 Thread Rick Hillegas
Hi Kathey, My gut feeling is that you are headed off into the tall weeds here. That said, let me walk with you part way into the swamp. Another feature you might want would be DERBY-481, computed columns. This would help you get better performance. So, for instance, you could declare your data

Re: Google SOC:MySQL to Derby Migration tool design question

2006-07-12 Thread Kathey Marsden
Ramin Moazeni wrote: Hi Bryan, I am not sure this would be feasible given the amount of time I have to finish this project as well as my familiarity with DdlUtils code base. But if everybody agrees to it, I can start working on it. Hi Ramin, I think that even if your project scope was reduce

[jira] Updated: (DERBY-1330) Provide runtime privilege checking for grant/revoke functionality

2006-07-12 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1330?page=all ] Mamta A. Satoor updated DERBY-1330: --- Attachment: Derby1330uuidIndexForPermsSystemTablesV6diff.txt Derby1330uuidIndexForPermsSystemTablesV6stat.txt As per Dan's suggestion, I h

DERBY-1015 patches for review.

2006-07-12 Thread Sunitha Kambhampati
Last week, I attached two small patches to DERBY-1015, and one of the patches solves the case for DERBY-1227. "Define interface between network server and engine through Java interfaces". http://issues.apache.org/jira/browse/DERBY-1015 Can someone please review these patches. Thanks much, Sun

Re: DERBY-1015 patches for review.

2006-07-12 Thread Daniel John Debrunner
Sunitha Kambhampati wrote: > Last week, I attached two small patches to DERBY-1015, and one of the > patches solves the case for DERBY-1227. "Define interface between > network server and engine through Java interfaces". > http://issues.apache.org/jira/browse/DERBY-1015 > > Can someone please rev

Re: Language based matching

2006-07-12 Thread Kathey Marsden
Rick Hillegas wrote: [ some interesting stuff about performance] LIKE is going to be a pile of work. I think your LOCALE_MATCHES function will have to duplicate a lot of the code in Derby. At the end of the day, you will replace LIKE with LOCALE_MATCHES and so lose the performance-enhancing q

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

2006-07-12 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1015?page=comments#action_12420677 ] David Van Couvering commented on DERBY-1015: I looked at the patches, and they look quite good, very simple and direct, and creating what I think is a very useful

Patch review and turnaround as 10.2 approaches

2006-07-12 Thread Kathey Marsden
In almost every feature release I have been involved in, folks start having trouble getting reviews in the final push as everyone scrambles to get their own work done. Add to that the fact that we do a generally horrible job in keeping up with patches especially for independent contributors

Re: Language based matching

2006-07-12 Thread Rick Hillegas
Kathey Marsden wrote: Rick Hillegas wrote: [ some interesting stuff about performance] LIKE is going to be a pile of work. I think your LOCALE_MATCHES function will have to duplicate a lot of the code in Derby. At the end of the day, you will replace LIKE with LOCALE_MATCHES and so lose the

Re: UnsupportedClassVersionError running xa suite under jdk1.3

2006-07-12 Thread Rick Hillegas
Thanks, Myrna, this does the trick! Cheers, -Rick Myrna van Lunteren wrote: On 7/12/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: I'm seeing the following error when I run the xa suite under jdk1.3. This looks like an environmental problem to me. Would appreciate advice on the accepted way to

Re: Removing an archived fix version from the fix version list of an issue

2006-07-12 Thread Kathey Marsden
Andrew McIntyre wrote: So, I think tracking snapshots while development is occurring, but merging them to the release version for searching purposes to keep things tidy is the way to go. Once there's an official release, we're not likely to see any bug reports against snapshots so I'm not sure

Re: Patch review and turnaround as 10.2 approaches

2006-07-12 Thread David Van Couvering
+1. If we aren't responsive to new contributor patches, then we won't have a lot of new contributors hanging around :). I for one will *try* to work on 2 patches a week -- it depends on whether the patches submitted fall within my range of expertise. David Kathey Marsden wrote: In almost ev

Re: Google SOC:MySQL to Derby Migration tool design question

2006-07-12 Thread Ramin Moazeni
Hi David I do not believe the split will be exposed to the normal user. However, in case of an error, the user might have to follow two different paths to fix the problem. For example, modifying xml files for ddlutils component and modifying sql statements for the DatabaseMetadata approach. I ho

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

2006-07-12 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1005?page=comments#action_12420697 ] Deepa Remesh commented on DERBY-1005: - This issue was not fixed in 10.1.2.3. There was one more patch for this issue which went in later (svn revision# 412258). Currently

[jira] Resolved: (DERBY-1480) Crash with JVM 1.4.2_08-b03

2006-07-12 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1480?page=all ] Andrew McIntyre resolved DERBY-1480: Resolution: Invalid > I will post a bugreport at sun. Great, thanks! Closing this bug as Invalid as I believe it to be a JVM issue. > Crash wit

[jira] Commented: (DERBY-1156) allow the encrypting of an existing unencrypted db and allow the re-encrypting of an existing encrypted db

2006-07-12 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1156?page=comments#action_12420699 ] Suresh Thalamati commented on DERBY-1156: - Committed reencrypt_3.diff patch to trunk with revision 416536 > allow the encrypting of an existing unencrypted db and all

[jira] Updated: (DERBY-1501) PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL Exception if given sqlType is LONGVARBINARY in embedded mode

2006-07-12 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1501?page=all ] Andrew McIntyre updated DERBY-1501: --- Component: JDBC > PreparedStatement#setNull(int parameterIndex, int sqlType) throws SQL > Exception if given sqlType is LONGVARBINARY in embedded mode >

[jira] Updated: (DERBY-1156) allow the encrypting of an existing unencrypted db and allow the re-encrypting of an existing encrypted db

2006-07-12 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1156?page=all ] Suresh Thalamati updated DERBY-1156: Attachment: reencrypt_4.diff DERBY -1156 (partial) This patch adds some code required to support reconfigure(rencryption) of an already existing encrypt

Re: Patch review and turnaround as 10.2 approaches

2006-07-12 Thread Kathey Marsden
David Van Couvering wrote: +1. If we aren't responsive to new contributor patches, then we won't have a lot of new contributors hanging around :). I for one will *try* to work on 2 patches a week -- it depends on whether the patches submitted fall within my range of expertise. That should

[jira] Updated: (DERBY-1500) PreparedStatement#setObject(int parameterIndex, Object x) throws SQL Exception when binding Short value in embedded mode

2006-07-12 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1500?page=all ] Andrew McIntyre updated DERBY-1500: --- Component: JDBC > PreparedStatement#setObject(int parameterIndex, Object x) throws SQL > Exception when binding Short value in embedded mode > --

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

2006-07-12 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1015?page=comments#action_12420702 ] Daniel John Debrunner commented on DERBY-1015: -- Since David is further ahead than me here I will defer to him for the commit > Define interface between network se

[jira] Closed: (DERBY-1045) forupdate.sql , holdCursorIJ.sql ..etc are failing when run with 10.1 client againest trunk

2006-07-12 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1045?page=all ] Suresh Thalamati closed DERBY-1045: --- > forupdate.sql , holdCursorIJ.sql ..etc are failing when run with 10.1 client > againest trunk > --

[jira] Closed: (DERBY-437) SYSCS_UTIL.SYSCS_COMPRESS_TABLE does not work on tables that are created with delimited identifier names.

2006-07-12 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-437?page=all ] Suresh Thalamati closed DERBY-437: -- > SYSCS_UTIL.SYSCS_COMPRESS_TABLE does not work on tables that are created > with delimited identifier names. > -

[jira] Closed: (DERBY-523) Non logged operation that starts before the log archive mode is enabled can not be recovered during rollforward recovery.

2006-07-12 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-523?page=all ] Suresh Thalamati closed DERBY-523: -- > Non logged operation that starts before the log archive mode is enabled can > not be recovered during rollforward recovery. > --

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

2006-07-12 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-239?page=all ] Suresh Thalamati closed DERBY-239: -- > Need a online backup feature that does not block update operations when > online backup is in progress. >

Re: Patch review and turnaround as 10.2 approaches

2006-07-12 Thread Daniel John Debrunner
Kathey Marsden wrote: > I would like to propose that every active developer registered in Jira > make efforts to reduce the patch backlog by trying to do something to > move along at least 2 patches outside of our personal 10.2 line items > each week.See: > http://wiki.apache.org/db-derby

[jira] Closed: (DERBY-758) CachedPage.readPage() can loop forever on insane builds if the read from the container keep failing with IO Exceptions.

2006-07-12 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-758?page=all ] Suresh Thalamati closed DERBY-758: -- > CachedPage.readPage() can loop forever on insane builds if the read from the > container keep failing with IO Exceptions. > ---

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-12 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12420707 ] Jean T. Anderson commented on DERBY-1377: - Minor note: due date moved from 1-August- 2006 to 1-September-2006; see http://mail-archives.apache.org/mod_mbox/www-legal-di

[jira] Updated: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-12 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=all ] Jean T. Anderson updated DERBY-1377: Description: A new copyright header policy will take effect for distributions released starting on Sep 1, 2006. Committers will receive notification, b

prioritized 10.2 bug list

2006-07-12 Thread Rick Hillegas
Thanks to everyone for helping clean up JIRA and clarify the issues we want to address in 10.2. It would be great if we could march in priority order through the issues listed in the Open 10.2 Issues report at http://wiki.apache.org/db-derby/TenTwoRelease#head-7cf194b6c7305a0e83d0c9c422f0632215f

CacheManager create() semantics

2006-07-12 Thread Gokul Soundararajan
Hi all, I'm implementing a new replacement algorithm (clock-pro) for the CacheManager. In this algorithm, there is a concept of a history item. Basically, after an eviction, the algorithm remembers the page id for some time. I was wondering on how this affects the semantics of create(). Just to r

[jira] Created: (DERBY-1505) Reference Manual - Limitations of triggered-SQL-statement do not match current behaviour

2006-07-12 Thread Deepa Remesh (JIRA)
Reference Manual - Limitations of triggered-SQL-statement do not match current behaviour Key: DERBY-1505 URL: http://issues.apache.org/jira/browse/DERBY-1505 Project: Derby Type

Re: Language based matching

2006-07-12 Thread Satheesh Bandaram
Rick Hillegas wrote: > At one point I was keen on re-enabling the national string types. Now > I am leaning toward implementing the ANSI collation language. I think > this is more powerful. In particular, it lets you support more than > one language-sensitive ordering in the same database. I also

Re: CacheManager create() semantics

2006-07-12 Thread Mike Matrigali
Gokul Soundararajan wrote: Hi all, I'm implementing a new replacement algorithm (clock-pro) for the CacheManager. In this algorithm, there is a concept of a history item. Basically, after an eviction, the algorithm remembers the page id for some time. I was wondering on how this affects the sem

Re: Patch review and turnaround as 10.2 approaches

2006-07-12 Thread Daniel John Debrunner
Kathey Marsden wrote: > I think > a big part of the problem is that there is a myth that a committer with > expertise in a certain area needs to be the *first* to look at a patch, > but they only need to be the last. Part of that is a "myth" as well, the last person to look at a patch needs to b

[jira] Reopened: (DERBY-630) create trigger fails with null pointer exception

2006-07-12 Thread Susan Cline (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-630?page=all ] Susan Cline reopened DERBY-630: --- DERBY-630 is listed as a duplicate of DERBY-85 and was marked fixed in release 10.1.3, however, I believe it is not a duplicate, and although DERBY-85 is fixed

Re: Google SOC:MySQL to Derby Migration tool design question

2006-07-12 Thread Jean T. Anderson
Ramin Moazeni wrote: > Hi Bryan, > > I am not sure this would be feasible given the amount of time I have > to finish this project as well as my familiarity with DdlUtils code > base. But if everybody agrees to it, I can start working on it. > One thing to consider is DdlUtils is database agnost

Derby Internals Wiki

2006-07-12 Thread Sanket Sharma
Hi, While reading Derby source code for my project, I thought It will be good to share my knowledge with other developers. Since my project is about adding JMX to Derby, it will interact with a lot of internal API calls. As I continue to read and understand code, I think will good if I can docume

[jira] Created: (DERBY-1506) full table scans of tables which don't use indexes, which have blobs, but don't reference blob data still read all pages of the table

2006-07-12 Thread Mike Matrigali (JIRA)
full table scans of tables which don't use indexes, which have blobs, but don't reference blob data still read all pages of the table - Key: DERBY-1506

Re: prioritized 10.2 bug list

2006-07-12 Thread Kathey Marsden
Rick Hillegas wrote: Thanks to everyone for helping clean up JIRA and clarify the issues we want to address in 10.2. It would be great if we could march in priority order through the issues listed in the Open 10.2 Issues report at http://wiki.apache.org/db-derby/TenTwoRelease#head-7cf194b6c73

[jira] Updated: (DERBY-1506) full table scans of tables which don't use indexes, which have blobs, but don't reference blob data still read all pages of the table

2006-07-12 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1506?page=all ] Mike Matrigali updated DERBY-1506: -- Description: A full table scan that does not use an index always reads every allocated page of the table through the cache. In two cases this means logic

[jira] Updated: (DERBY-1506) full table scans of tables which don't use indexes, which have blobs, but don't reference blob data still read all pages of the table

2006-07-12 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1506?page=all ] Mike Matrigali updated DERBY-1506: -- The following approach was suggested by [EMAIL PROTECTED] Maybe a simple fix would be to segment the pages in the container. Store the relational information i

[jira] Updated: (DERBY-1499) test run exits for _foundation run because unloadEmbeddedDriver uses driverManager, which isn't available.

2006-07-12 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1499?page=all ] Myrna van Lunteren updated DERBY-1499: -- Attachment: DERBY-1499_102_20060712.diff I rethought my earlier solution, so the newer patch - DERBY-1499_20060712.diff - changes RunList.java to c

[jira] Updated: (DERBY-1506) full table scans of tables which don't use indexes, which have blobs, but don't reference blob data still read all pages of the table

2006-07-12 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1506?page=all ] Mike Matrigali updated DERBY-1506: -- I haven't thought about this much, but the following approaches all would solve the problem, some easier than others, these address the long column issue (I d

[jira] Created: (DERBY-1507) lang/xmlBinding.java fails with Security Expression

2006-07-12 Thread A B (JIRA)
lang/xmlBinding.java fails with Security Expression --- Key: DERBY-1507 URL: http://issues.apache.org/jira/browse/DERBY-1507 Project: Derby Type: Bug Components: Test Versions: 10.2.0.0 Reporter: A B A

Re: Google SOC:MySQL to Derby Migration tool design question

2006-07-12 Thread Jean T. Anderson
Jean T. Anderson wrote: > Ramin Moazeni wrote: > >>Hi Bryan, >> >>I am not sure this would be feasible given the amount of time I have >>to finish this project as well as my familiarity with DdlUtils code >>base. But if everybody agrees to it, I can start working on it. >> > One thing to consider

[jira] Updated: (DERBY-1507) lang/xmlBinding.java fails with Security Expression

2006-07-12 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1507?page=all ] A B updated DERBY-1507: --- Attachment: d1507_v1.patch Attaching a simple patch to disable security manager for lang/xmlBinding.java. If anyone has any better alternatives, please let me know. Otherwise,

[jira] Commented: (DERBY-1483) Java Function defined with a BIGINT parameter invokes the method with a signature of method(long) rather than method(Long)

2006-07-12 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1483?page=comments#action_12420731 ] Kathey Marsden commented on DERBY-1483: --- Is this current doc reference sufficient? http://db.apache.org/derby/docs/10.1/ref/rrefjdbc75719.html > Java Function define

Re: Derby Internals Wiki

2006-07-12 Thread Jean T. Anderson
Sanket Sharma wrote: > Hi, > > While reading Derby source code for my project, I thought It will be > good to share my knowledge with other developers. Since my project is > about adding JMX to Derby, it will interact with a lot of internal API > calls. As I continue to read and understand code, I

[jira] Created: (DERBY-1508) improve store costing of fetch of single row where not all columns are fetched.

2006-07-12 Thread Mike Matrigali (JIRA)
improve store costing of fetch of single row where not all columns are fetched. --- Key: DERBY-1508 URL: http://issues.apache.org/jira/browse/DERBY-1508 Project: Derby Type: Improvement Co

[jira] Updated: (DERBY-1508) improve store costing of fetch of single row where not all columns are fetched.

2006-07-12 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1508?page=all ] Mike Matrigali updated DERBY-1508: -- One idea is to put part of the estimate back on the datatype. Have the store ask each datatype about it's size. When the costing work was originally done the

Re: Derby Internals Wiki

2006-07-12 Thread Daniel John Debrunner
Jean T. Anderson wrote: > Sanket Sharma wrote: > >>Hi, >> >>While reading Derby source code for my project, I thought It will be >>good to share my knowledge with other developers. Since my project is >>about adding JMX to Derby, it will interact with a lot of internal API >>calls. As I continue

[jira] Commented: (DERBY-1507) lang/xmlBinding.java fails with Security Expression

2006-07-12 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1507?page=comments#action_12420737 ] Andrew McIntyre commented on DERBY-1507: Instead of disabling the security manager, why not grant permission to read user.dir to all in a test-specific policy file for

  1   2   >