[jira] Updated: (DERBY-799) Large response times during checkpointing on disk-bound systems

2006-01-09 Thread JIRA
[ http://issues.apache.org/jira/browse/DERBY-799?page=all ] Øystein Grøvlen updated DERBY-799: -- Description: We have observed that during checkpointing, transaction response times for small transactions may become very long. Extra trace output in the

[jira] Created: (DERBY-801) Allow parallel access to data files.

2006-01-09 Thread JIRA
Allow parallel access to data files. Key: DERBY-801 URL: http://issues.apache.org/jira/browse/DERBY-801 Project: Derby Type: Improvement Components: Performance, Store Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1,

Re: Application code inspecting Derby's embedded objects

2006-01-09 Thread Øystein Grøvlen
SB == Satheesh Bandaram [EMAIL PROTECTED] writes: SB Now I understand what you mean by this... after reading SB Oystein's question. Current proposal only has EXECUTE SB privilege to allow executing procedures and functions. Creator SB of the routine can define if that needs to be

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

2006-01-09 Thread JIRA
[ http://issues.apache.org/jira/browse/DERBY-800?page=all ] Øystein Grøvlen reassigned DERBY-800: - Assign To: Øystein Grøvlen derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout

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

2006-01-09 Thread Øystein Grøvlen
KM( == Kathey Marsden (JIRA) derby-dev@db.apache.org writes: KM( I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391 I have assigned myself to this since I created this test. From previous experience,

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

2006-01-09 Thread Øystein Grøvlen
Suresh, Thanks for considering my suggestions. A few responses below. -- Øystein ST == Suresh Thalamati [EMAIL PROTECTED] writes: * SYSCS_ONLINE_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE() - Same comment on ONLINE as above - Could not boolean parameters be used now?

Message round-trips between Derby client and server

2006-01-09 Thread Olav Sandstaa
We are looking into the network traffic between the Derby JDBC driver and the Network server and have compared this against MySQL and PostgreSQL. The main finding is that Derby sends more messages than the two other databases. For two simple transaction loads the following number of round-trips

[jira] Updated: (DERBY-212) Optimize some specific methods in Network Server to improve performance

2006-01-09 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-212?page=all ] Knut Anders Hatlen updated DERBY-212: - Attachment: (was: DERBY-212-parsePKGNAMCSN.diff) Optimize some specific methods in Network Server to improve performance

[jira] Updated: (DERBY-212) Optimize some specific methods in Network Server to improve performance

2006-01-09 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-212?page=all ] Knut Anders Hatlen updated DERBY-212: - Attachment: DERBY-212-parsePKGNAMCSN-2.diff I have uploaded a new patch (DERBY-212-parsePKGNAMCSN-2.diff) where I have tried to address Bryan's review

[jira] Commented: (DERBY-499) Expose BOOLEAN datatype to end users

2006-01-09 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-499?page=comments#action_12362216 ] Rick Hillegas commented on DERBY-499: - Hi Kathey: Thanks for finding this discrepancy. I think this is what's going on: I checked in new canons for these tests, which

Re: Application code inspecting Derby's embedded objects

2006-01-09 Thread Daniel John Debrunner
Øystein Grøvlen wrote: SB == Satheesh Bandaram [EMAIL PROTECTED] writes: SB Now I understand what you mean by this... after reading SB Oystein's question. Current proposal only has EXECUTE SB privilege to allow executing procedures and functions. Creator SB of the routine

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

2006-01-09 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-802?page=comments#action_12362225 ] Sunitha Kambhampati commented on DERBY-802: --- From list, Dan suggested the following workaround Change statement type to default ResultSet.TYPE_FORWARD_ONLY and

[jira] Updated: (DERBY-398) Exclude tests for J2ME/CDC/Foundation platform

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-398?page=all ] Deepa Remesh updated DERBY-398: --- Attachment: (was: jdk14_tests.diff) Exclude tests for J2ME/CDC/Foundation platform -- Key: DERBY-398

[jira] Commented: (DERBY-680) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

2006-01-09 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-680?page=comments#action_12362228 ] Daniel John Debrunner commented on DERBY-680: - I think it's ok to change these SQL statements to not use prepared statements and ij's using clause. The return

Re: Message round-trips between Derby client and server

2006-01-09 Thread Kathey Marsden
Olav Sandstaa wrote: We are looking into the network traffic between the Derby JDBC driver and the Network server and have compared this against MySQL and PostgreSQL. The main finding is that Derby sends more messages than the two other databases. For two simple transaction loads the following

[jira] Updated: (DERBY-398) Exclude tests for J2ME/CDC/Foundation platform

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-398?page=all ] Deepa Remesh updated DERBY-398: --- Attachment: jdk14_tests_2.diff Thanks Kathey for looking at the patches. I have attached 'jdk14_tests_2.diff' since the first patch had conflicts. With this

[VOTE] Rick Hillegas as a committer

2006-01-09 Thread David W. Van Couvering
This vote is for establishing Rick Hillegas as a committer for Derby. Please vote +1 if you approve of Rick as a committer. I am nominating Rick because he has been consistently contributing to the Derby project in the following ways: - He has contributed some very useful patches, working

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

2006-01-09 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-802?page=all ] Sunitha Kambhampati updated DERBY-802: -- Priority: Minor (was: Major) changing priority to minor as workaround exists. OutofMemory Error when reading large blob when statement type is

Re: [VOTE] Rick Hillegas as a committer

2006-01-09 Thread David W. Van Couvering
I forgot to mention, this vote will close at noon PST on Monday, January 16th. David David W. Van Couvering wrote: This vote is for establishing Rick Hillegas as a committer for Derby. Please vote +1 if you approve of Rick as a committer. I am nominating Rick because he has been

Re: [VOTE] Rick Hillegas as a committer

2006-01-09 Thread Jeffrey Lichtman
This vote is for establishing Rick Hillegas as a committer for Derby. Please vote +1 if you approve of Rick as a committer. +1 -Jeff Lichtman [EMAIL PROTECTED] Check out Swazoo Koolak's Web

Ignored exceptions in DerbyJUnitTest

2006-01-09 Thread Daniel John Debrunner
DerbyJUnitTest has many cases where the SQLException thrown by Derby (through JDBC) is ignored. To me, this seems very bad practice for test code. For example: // // Swallow uninteresting exceptions when disposing of jdbc objects. // protected static void

Re: [VOTE] Rick Hillegas as a committer

2006-01-09 Thread Francois Orsini
+1

[jira] Updated: (DERBY-680) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-680?page=all ] Deepa Remesh updated DERBY-680: --- Attachment: (was: derby-680.diff) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

[jira] Updated: (DERBY-680) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-680?page=all ] Deepa Remesh updated DERBY-680: --- Attachment: (was: derby-680.status) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

[jira] Updated: (DERBY-680) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-680?page=all ] Deepa Remesh updated DERBY-680: --- Attachment: derby-680_v2.diff derby-680_v2.status Attaching 'derby-680_v2.diff'. This patch changes the test lang/ejbql.sql as suggested by Dan.

[jira] Closed: (DERBY-793) 'trunk/README' should be rewritten to reflect graduation from incubation

2006-01-09 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-793?page=all ] Jean T. Anderson closed DERBY-793: -- Fix Version: 10.2.0.0 Resolution: Fixed Committed revision 367377 : Replaced the incubator disclaimer with current information about the derby

[jira] Updated: (DERBY-680) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-680?page=all ] Deepa Remesh updated DERBY-680: --- Attachment: (was: derby-680_v2.diff) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

[jira] Created: (DERBY-804) test lang/floattypes fails with jdk 1.3 based jvms

2006-01-09 Thread Myrna van Lunteren (JIRA)
test lang/floattypes fails with jdk 1.3 based jvms --- Key: DERBY-804 URL: http://issues.apache.org/jira/browse/DERBY-804 Project: Derby Type: Bug Versions: 10.1.2.0 Environment: failure occurs in 10.1

[jira] Updated: (DERBY-680) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-680?page=all ] Deepa Remesh updated DERBY-680: --- Attachment: (was: derby-680_v2.status) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

San Francisco Bay Area request for a speaker

2006-01-09 Thread Jean T. Anderson
BayLISA (www.baylisa.org) would like someone to give a 90 minute talk about Derby -- they'd like a combination introduction and security overview. I'm interested but am 600 miles too far south. Are there any takers in the Bay Area? If so, let me know and I'll hook you up with the BayLISA

[jira] Created: (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-01-09 Thread Satheesh Bandaram (JIRA)
Push join predicates into union and other set operations. DERBY-649 implemented scalar (single table) predicate pushdown. Adding join predicate push down could improve performance significantly.

Re: San Francisco Bay Area request for a speaker

2006-01-09 Thread David W. Van Couvering
I could do this, depending on the timing. I think it would make sense to talk about Derby in general but focus how you can embed Derby in a browser to give a very easy distribution model for database applications, allowing users to keep private data on their machine while running a web app,

Re: derby bay area lunch

2006-01-09 Thread David W. Van Couvering
I think this would be great! I'd like to attend. David Rick Hillegas wrote: I'd like to setup a lunch for those of us in the Bay Area who are working on Derby. I'm thinking of Wednesday February 1 in San Francisco. Any interest? Thanks, -Rick begin:vcard fn:David W Van Couvering n:Van

[jira] Updated: (DERBY-680) In ij, executing a prepared statement with numeric/decimal parameter fails with NullPointerException in J2ME/CDC/FP

2006-01-09 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-680?page=all ] Deepa Remesh updated DERBY-680: --- Attachment: derby-680_v2.diff derby-680_v2.status lang/cast.sql is failing in J2ME because of some recent additions to the test which require

[jira] Updated: (DERBY-804) test lang/floattypes fails with jdk 1.3 based jvms

2006-01-09 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-804?page=all ] Myrna van Lunteren updated DERBY-804: - Version: 10.2.0.0 Environment: jdk131, ibm131, wsdd5.6 (was: failure occurs in 10.1 branch, and on main branch.) test lang/floattypes fails

Re: San Francisco Bay Area request for a speaker

2006-01-09 Thread Jean T. Anderson
Thanks, David, I'll hook you up with the requestor to work the details out. -jean David W. Van Couvering wrote: I could do this, depending on the timing. I think it would make sense to talk about Derby in general but focus how you can embed Derby in a browser to give a very easy

Re: San Francisco Bay Area request for a speaker

2006-01-09 Thread Satheesh Bandaram
Hi David, I could help, if needed. I presented a talk about developing applications on Derby at DB2 information management conference sometime ago and have foils for that. We could expand that presentation to include parts of Jean's presentation/tutorial to cover the introduction part. Satheesh

Re: San Francisco Bay Area request for a speaker

2006-01-09 Thread David W. Van Couvering
Satheesh, that would be great. I'll get in touch with you once I hear from the requestor from BayLISA. David Satheesh Bandaram wrote: Hi David, I could help, if needed. I presented a talk about developing applications on Derby at DB2 information management conference sometime ago and have

Re: Submitting shared i18n/error code separate from classloader work

2006-01-09 Thread David W. Van Couvering
Hi, Dan. This looks very appealing. The one area I'm a little uncertain about is with the messages that are common across client and server. If the engine code doesn't use the shared mechanism to load messages (where the algorithm is look in the shared message bundle first, then look in

Re: [VOTE] Rick Hillegas as a committer

2006-01-09 Thread Craig L Russell
+1Rick a very-well qualified candidate for committer status on Derby. He is a significant contributor to the project and has a personal style worth emulating.CraigThis vote is for establishing Rick Hillegas as a committer for Derby. Please vote +1 if you approve of Rick as a committer.I am

Re: Message round-trips between Derby client and server

2006-01-09 Thread Olav Sandstå
On 1/9/06, Kathey Marsden [EMAIL PROTECTED] wrote: Are the additional round trips just on the first execution of a prepared statement? No, it is on every execute of the query/transaction. The numbers are average of several thousand transactions, thus the preparing of the initial statement

Re: [PATCH] catching up with j9 test masters

2006-01-09 Thread Deepa Remesh
Hi Myrna, I submitted a patch for the tests store/OnlineBackupTest1.java and store/OnlineBackupTest3.java which was committed couple of days back. So these tests now pass with j9_13. For unit/T_RawStoreFactory.unit, this test fails with j9_foundation too and I have opened a jira issue for this

[jira] Created: (DERBY-806) One each deleted or updated from a heap row a new RowPosition object is created.

2006-01-09 Thread Daniel John Debrunner (JIRA)
One each deleted or updated from a heap row a new RowPosition object is created. Key: DERBY-806 URL: http://issues.apache.org/jira/browse/DERBY-806 Project: Derby Type: Improvement

Re: [jira] Updated: (DERBY-125) Network Server can send DSS greater than 32K to client, which breaks DRDA protocol.

2006-01-09 Thread Bryan Pendleton
Army wrote: Well I'm a day late, but I've finished my review of the patch... Hi Army, Thank you very much for the careful review and the helpful suggestions. There were a number of points in your message, many of which I will address when I re-submit the patch proposal, but there were several