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

2006-07-12 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-253?page=comments#action_12420797 ] Knut Anders Hatlen commented on DERBY-253: -- The patch looks good. I will run some tests and commit it. > Client should throw not implemented exception for depricated

[jira] Updated: (DERBY-836) ResultSetMetaData.getColumnDisplaySize sometimes returns wrong values for DECIMAL columns

2006-07-12 Thread Mayuresh Nirhali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-836?page=all ] Mayuresh Nirhali updated DERBY-836: --- Attachment: derby836-v6.diff Thanks Dan for pointing out the error. I have now added diffs for the master files which were failing due to this change and

Re: prioritized 10.2 bug list

2006-07-12 Thread Kathey Marsden
Andrew McIntyre wrote: On 7/12/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: People have targetted bugs for fixing in 10.2 but haven't assigned the bugs to themselves. What does this mean? It could mean any of the following: [snip many different things it may or may not mean] I think

[jira] Commented: (DERBY-1453) jdbcapi/blobclob4BLOB.java fails with 10.1 client and 10.2 server

2006-07-12 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1453?page=comments#action_12420767 ] Kathey Marsden commented on DERBY-1453: --- Thanks for investigatting this issue Rajesh. I agree that the priority can be lowered from Critical to even Lowest or even Won'

[jira] Created: (DERBY-1509) blobclob4BLOB expected test ouput prints "FAIL -- unexpected exception" for exceptions that are expected

2006-07-12 Thread Kathey Marsden (JIRA)
blobclob4BLOB expected test ouput prints "FAIL -- unexpected exception" for exceptions that are expected - Key: DERBY-1509 URL: http://issues.apache.org/jira/browse/DERBY-150

[jira] Commented: (DERBY-1395) Change the client SQLState to match that of embedded for the exception thrown on a closed statement whose connection is also closed

2006-07-12 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1395?page=comments#action_12420761 ] David Van Couvering commented on DERBY-1395: When the connection is closed, I think it's more informative on the client side, where it tells you that the connectio

[jira] Commented: (DERBY-1453) jdbcapi/blobclob4BLOB.java fails with 10.1 client and 10.2 server

2006-07-12 Thread Rajesh Kartha (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1453?page=comments#action_12420757 ] Rajesh Kartha commented on DERBY-1453: -- I did some investigation on this. So there are two separate issues: A) Lock while updating an int col Scenario: 1) Open connect

[jira] Closed: (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 closed DERBY-1507: -- > lang/xmlBinding.java fails with Security Expression > --- > > Key: DERBY-1507 > URL: http://issues.apache.org/j

[jira] Resolved: (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 resolved DERBY-1507: Fix Version: 10.2.0.0 Resolution: Fixed Derby Info: (was: [Patch Available]) Verified fix by running lang/xmlBinding.java after the commit. Thanks Andrew. >

[jira] Resolved: (DERBY-1419) derbyall/i18nTest/MessageBundleTest.diff test failed in nightly run, jdk15

2006-07-12 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1419?page=all ] David Van Couvering resolved DERBY-1419: Resolution: Fixed Fixed, removed from derbyall. > derbyall/i18nTest/MessageBundleTest.diff test failed in nightly run, jdk15 > --

[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_12420750 ] David Van Couvering commented on DERBY-1015: I will take care of committing the second patch as well. David > Define interface between network server and engine t

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

2006-07-12 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1015?page=all ] Sunitha Kambhampati reopened DERBY-1015: Thanks David for the review and commit. The # 421435 revision number only took care of the derby1015.diff.txt . That commit missed adding t

Re: svn commit: r421435 - in /db/derby/code/trunk/java: drda/org/apache/derby/impl/drda/ engine/org/apache/derby/iapi/jdbc/ engine/org/apache/derby/impl/jdbc/

2006-07-12 Thread David Van Couvering
Thanks for catching that, Sunitha, I added them. David Sunitha Kambhampati wrote: Thanks David for the commit. I think you forgot to add the engine interfaces. maybe missed a svn add ? Thanks Sunitha. [EMAIL PROTECTED] wrote: Author: davidvc Date: Wed Jul 12 15:05:50 2006 New Revision: 42

Re: Re: prioritized 10.2 bug list

2006-07-12 Thread Andrew McIntyre
On 7/12/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: People have targetted bugs for fixing in 10.2 but haven't assigned the bugs to themselves. What does this mean? It could mean any of the following: 1) These bugs are stretch goals which the reporters hope someone will address before we cut the

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

2006-07-12 Thread Satheesh Bandaram
I will start to review these patches with the goal of committing them. If anyone has comments or suggestions, please share with the group... Satheesh Army wrote: > 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

[jira] Commented: (DERBY-533) Re-enable national character datatypes

2006-07-12 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-533?page=comments#action_12420746 ] Satheesh Bandaram commented on DERBY-533: - I earlier had some interest in enabling national characters for 10.2, but after dates for 10.2 became clearer, I decided it w

Re: svn commit: r421435 - in /db/derby/code/trunk/java: drda/org/apache/derby/impl/drda/ engine/org/apache/derby/iapi/jdbc/ engine/org/apache/derby/impl/jdbc/

2006-07-12 Thread Sunitha Kambhampati
Thanks David for the commit. I think you forgot to add the engine interfaces. maybe missed a svn add ? Thanks Sunitha. [EMAIL PROTECTED] wrote: Author: davidvc Date: Wed Jul 12 15:05:50 2006 New Revision: 421435 URL: http://svn.apache.org/viewvc?rev=421435&view=rev Log: DERBY-1015: Define i

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

2006-07-12 Thread Satheesh Bandaram
Jean T. Anderson wrote: >One thing to consider is DdlUtils is database agnostic. For example, >adding support for "create view" doesn't mean just adding it for Derby, >but also adding it for every database supported (see the list at >http://db.apache.org/ddlutils/database-support.html ). > > Thi

[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_12420744 ] Andrew McIntyre commented on DERBY-1507: Committed d1507_v2.patch with revision 421448. Please resolve and close this issue if there is no further work to be done. >

[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: --- Derby Info: [Patch Available] > lang/xmlBinding.java fails with Security Expression > --- > > Key: DERBY-1507 >

[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_v2.patch Attaching a second version of the patch (d1507_v2.patch) that creates a test-specific policy file instead of turning security manager off. Thanks to

Re: prioritized 10.2 bug list

2006-07-12 Thread Rick Hillegas
Hi Kathey, This is a good topic to discuss. Thank you for raising it. There are a lot of seemingly independent variables in a JIRA and I don't think that the community fills in these variables consistently. Maybe that's inevitable since we don't enforce any consistency rules when updating a J

[jira] Resolved: (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=all ] David Van Couvering resolved DERBY-1015: Resolution: Fixed Derby Info: (was: [Patch Available]) Committed revision 421435. Passes derbynetclientmats on JDK 1.5 > Define int

[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: --- Derby Info: (was: [Patch Available]) Thanks for the suggestion Andrew; I overlooked the test-specific policy file option. I'll try that and post another patch. > lang/xmlBin

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

2006-07-12 Thread Myrna van Lunteren
On 7/12/06, A B (JIRA) wrote: [ 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,

[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: --- Derby Info: [Patch Available] > lang/xmlBinding.java fails with Security Expression > --- > > Key: DERBY-1507 >

[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

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] 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

[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

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] 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

[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,

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] 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

[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] 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: -- 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-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

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] 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

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

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

[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: 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

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: 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

[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

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

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

[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

[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] 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. > ---

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-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. >

[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-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-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] 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] 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 > --

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-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

[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] 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] 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-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

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

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: 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: 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: 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

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

[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

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

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

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

[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

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

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

[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: 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

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

[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: 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-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

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] 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

[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

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] 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

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: MeasureMemoryUsageOfNetworkServer.java This program start NetworkServer and print memory usage information to System.out for each millise

[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

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

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

[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

[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-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

[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

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

  1   2   >