[jira] Updated: (DERBY-792) Intermittent java.security.PrivilegedActionException was happend in derbynet/runtimeinfo.java of derbynetclient

2006-01-03 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-792?page=all ] Tomohito Nakayama updated DERBY-792: Attachment: derbyall_fail.txt runtimeinfo.diff runtimeinfo.tmp These are log message files when this phenomena was found.

[jira] Created: (DERBY-792) Intermittent java.security.PrivilegedActionException was happend in derbynet/runtimeinfo.java of derbynetclient

2006-01-03 Thread Tomohito Nakayama (JIRA)
Intermittent java.security.PrivilegedActionException was happend in derbynet/runtimeinfo.java of derbynetclient --- Key: DERBY-792 URL: http://issues.apache.org/jira/brows

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

2006-01-03 Thread Jeff Lichtman (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-781?page=comments#action_12361709 ] Jeff Lichtman commented on DERBY-781: - I've been thinking about this enhancement request ever since it was reported. Something didn't seem quite right to me, but it wasn't

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

2006-01-03 Thread Army
Bryan Pendleton updated DERBY-125: -- Attachment: changes2.html svn-dec_28_2005.diff [ snip ] I think these changes are now fully ready for review. Please let me know your comments as I am very interested to hear what you think. I plan to

1st Draft Patch for DERBY-754 (pushing Join predicates down to subqueries)

2006-01-03 Thread Army
I have attached the first DRAFT of a patch for DERBY-754 to that Jira issue. I still have testing to do and I need to add appropriate tests to the derbyall suite, so this patch is *NOT* for commit. However, as the issue of pushing join predicates is rather complicated, I'm hoping people out th

[jira] Updated: (DERBY-754) Push ON clause predicates down when optimizing SELECT queries.

2006-01-03 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-754?page=all ] A B updated DERBY-754: -- Attachment: d754_draft.patch I'm attaching my first attempt at a patch for this issue. The patch is called "d754_draft.patch", and is labelled as "draft" because I still need to d

Re: [PATCH] (DERBY-746) NullPointerException when 'encryptionKey' length is an odd number, or it contains invalid chars

2006-01-03 Thread Daniel John Debrunner
Kristian Waagan wrote: > Hello, > > I just uploaded a patch for DERBY-746 > (http://issues.apache.org/jira/browse/DERBY-746). It would be nice if > someone could spare the time to review it so it can be committed soon. > Patch applied to trunk, thanks for contributing! Dan.

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

2006-01-03 Thread Mike Matrigali
sounds good to me. In place compress, at least currently is an ad-hoc infrequent operation, and unlikely to be going on when a backup is taking place. Suresh Thalamati (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-239?page=comments#action_12361686 ] Suresh Thalamati comment

Re: [jira] Closed: (DERBY-652) Documentation and demos have incubator references

2006-01-03 Thread Bryan Pendleton
Kristian Waagan closed DERBY-652: - Searched for incubator references in doc trunk. None found; issue closed. I believe there's still a reference to the incubator in trunk/README. Of course, this isn't in the doc tree, it's in the code tree. But still, it would

[jira] Closed: (DERBY-650) Hyperlinks in demo/demo.html are broken

2006-01-03 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-650?page=all ] Kristian Waagan closed DERBY-650: - Closed as "parent issue" is also closed. > Hyperlinks in demo/demo.html are broken > --- > > Key: DERBY-650 >

[jira] Closed: (DERBY-652) Documentation and demos have incubator references

2006-01-03 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-652?page=all ] Kristian Waagan closed DERBY-652: - Searched for incubator references in doc trunk. None found; issue closed. > Documentation and demos have incubator references > -

[jira] Closed: (DERBY-487) Getting Started Guide has reference to incubator URL

2006-01-03 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-487?page=all ] Kristian Waagan closed DERBY-487: - Verified URL in DITA source file. Closed. > Getting Started Guide has reference to incubator URL > > >

[jira] Closed: (DERBY-260) Derby is not stable on multiprocessor or Hyperthreating architectures.

2006-01-03 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-260?page=all ] Andrew McIntyre closed DERBY-260: - Resolution: Cannot Reproduce I've run the full set of functional tests on 2- and 4-way boxes on different architectures, as well as on hyperthreaded Inte

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

2006-01-03 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-239?page=comments#action_12361686 ] Suresh Thalamati commented on DERBY-239: inplace-compress with online backup problem: I was scanning through the code to find out any issues with online backup and in-

Re: Close DERBY-260?

2006-01-03 Thread Andrew McIntyre
On Jan 3, 2006, at 3:25 PM, Mike Matrigali wrote: fine with me, I never got any more info -- nothing I can do with the info provided. FWIW, I've run the full set of functional tests on 2- and 4-way boxes on different architectures, as well as on hyperthreaded Intel procs running several d

Re: Close DERBY-260?

2006-01-03 Thread Mike Matrigali
fine with me, I never got any more info -- nothing I can do with the info provided. Kristian Waagan wrote: Hello, Should we close DERBY-260 - Derby is not stable on multiprocessor or Hyperthreating architectures? No information has been added since Mike (Matrigali) paged the reporter in mid A

[jira] Closed: (DERBY-149) Server hang when invalid string is bound to datetime columns.

2006-01-03 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-149?page=all ] Kristian Waagan closed DERBY-149: - Verified the fix on 10.1.2.1 and trunk, and closed the issue. Also tested that the test program indeed did hang on 10.0.2.1 and 10.1.1.0. Output from test pr

Close DERBY-260?

2006-01-03 Thread Kristian Waagan
Hello, Should we close DERBY-260 - Derby is not stable on multiprocessor or Hyperthreating architectures? No information has been added since Mike (Matrigali) paged the reporter in mid August, and I can't seem to remember other reports on this issue. Please correct me if I'm wrong. I suggest

[jira] Created: (DERBY-791) Expose api for printing Abstract Syntax Trees in production (non-debug) servers

2006-01-03 Thread Rick Hillegas (JIRA)
Expose api for printing Abstract Syntax Trees in production (non-debug) servers --- Key: DERBY-791 URL: http://issues.apache.org/jira/browse/DERBY-791 Project: Derby Type: Improvement Rep

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

2006-01-03 Thread Francois Orsini (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-790?page=all ] Francois Orsini reassigned DERBY-790: - Assign To: Francois Orsini > SQLException used by the networked interface to Derby is not serializable > --

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

2006-01-03 Thread Francois Orsini (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-790?page=comments#action_12361673 ] Francois Orsini commented on DERBY-790: --- *Neither* of org.apache.derby.client.am.Sqlca (which NetSqlca extends) and org.apache.derby.client.net.NetSqlca are serializable

Re: When does a PreparedStatement become invalid in derby?

2006-01-03 Thread Daniel John Debrunner
V Narayanan wrote: > Hi, > I am working on StatementEventListeners as part of providing JDBC4.0 > support to derby. > >The driver calls the statementErrorOccurred method on all > StatementEventListeners registered on the connection when it detects > that a PreparedStatement is invalid. >

Re: [PATCH] Re: [jira] Commented: (DERBY-298) rollforward will not work correctly if the system happens to crash immediately after rollforward backup.

2006-01-03 Thread Mike Matrigali
I just got back. I'll look at committing this, but would like to wait for Suresh to review. Øystein Grøvlen wrote: I finally got back to this issue hat have been laying around for way too long. I have attached a new patch to JIRA that should address Suresh's review comments. Could someone ple

Re: The values for XA_OK and XA_RDONLY

2006-01-03 Thread Mike Matrigali
I think it is ok. The code should not count on them having the same values. As Francois points out the caller should do the mapping from XATransactionController constants to XAResource constants. Historically I believe the reason there is an "internal" and "external" set of constants is one pi

Re: Derby-SQL: Syntax Tree generator?

2006-01-03 Thread Satheesh Bandaram
I think it would be good to expose these to non-debug builds also. Would help as diagnostic tools. Satheesh Rick Hillegas wrote: > I apologize. I forgot to mention that you have to run with the debug > version of Derby. You need to build Derby with the following flags set > in the ant.properties

Re: [PATCH](DERBY-783) Enhance ALTER TABLE syntax to allow users to change the next value to be generated for an identity column

2006-01-03 Thread Mamta Satoor
Hi Bryan,   No, I don't do any checks on the value other than the fact that it should be an integer constant. Don't recall seeing anything in SQL spec about it either.   thanks, Mamta  On 1/3/06, Bryan Pendleton <[EMAIL PROTECTED]> wrote: > Changed sqlgrammar.jj to add parser support for ALTER TAB

Re: [PATCH](DERBY-783) Enhance ALTER TABLE syntax to allow users to change the next value to be generated for an identity column

2006-01-03 Thread Bryan Pendleton
Changed sqlgrammar.jj to add parser support for ALTER TABLE ALTER RESTART WITH integer-constant Is it legal to set RESTART WITH to a value which is less than or equal to a value which already exists in my table? That is, does Derby check to see that I am setting the new value to something whic

[jira] Closed: (DERBY-786) Casting to a CLOB value does not truncate.

2006-01-03 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-786?page=all ] Daniel John Debrunner closed DERBY-786: --- Resolution: Fixed > Casting to a CLOB value does not truncate. > -- > > Key: DERBY-786 >

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

2006-01-03 Thread David Cabelus (JIRA)
SQLException used by the networked interface to Derby is not serializable - Key: DERBY-790 URL: http://issues.apache.org/jira/browse/DERBY-790 Project: Derby Type: Bug Components: JDBC, Network

Re: Derby-SQL: Syntax Tree generator?

2006-01-03 Thread Rick Hillegas
Hi Ashwin, Some more responses follow. Regards, -Rick Ashwin Jayaprakash wrote: Rick, thanks for replying. Perhaps you meant "-Dderby.debug.DumpParseTree=true" instead of "-Dderby.debug.true=DumpParseTree"? But I tried that too and it didn't work. But anyway, I looked into the GenericStat

[jira] Updated: (DERBY-789) Usability issue: "Constraints have the same set of columns"

2006-01-03 Thread JIRA
[ http://issues.apache.org/jira/browse/DERBY-789?page=all ] Øystein Grøvlen updated DERBY-789: -- Description: Legolas Woodland reported on derby-user that derby return errors like : org.apache.derby.client.am.SqlException:Constraints

[jira] Created: (DERBY-789) Usability issue: "Constraints have the same set of columns"

2006-01-03 Thread JIRA
Usability issue: "Constraints have the same set of columns" -- Key: DERBY-789 URL: http://issues.apache.org/jira/browse/DERBY-789 Project: Derby Type: Improvement Components: SQL Reporter: Øystein

[PATCH] (DERBY-746) NullPointerException when 'encryptionKey' length is an odd number, or it contains invalid chars

2006-01-03 Thread Kristian Waagan
Hello, I just uploaded a patch for DERBY-746 (http://issues.apache.org/jira/browse/DERBY-746). It would be nice if someone could spare the time to review it so it can be committed soon. The patch fixes the problem of Derby failing with a NPE when the encryption key specified in the connectio

[jira] Updated: (DERBY-746) NullPointerException when 'encryptionKey' length is an odd number, or it contains invalid chars

2006-01-03 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-746?page=all ] Kristian Waagan updated DERBY-746: -- Attachment: derby-746.diff derby-746.stat Stat and diff for the patch (against revision 365637). No new files added. Derbyall ran without er

[jira] Created: (DERBY-788) 'store/encryptionKey.sql' fails on Solaris 10

2006-01-03 Thread Kristian Waagan (JIRA)
'store/encryptionKey.sql' fails on Solaris 10 - Key: DERBY-788 URL: http://issues.apache.org/jira/browse/DERBY-788 Project: Derby Type: Bug Components: Services, Test Versions: 10.0.2.1, 10.1.1.2, 10.1.2.1 Envi

When does a PreparedStatement become invalid in derby?

2006-01-03 Thread V Narayanan
Hi, I am working on StatementEventListeners as part of providing JDBC4.0 support to derby. The driver calls the statementErrorOccurred method on all StatementEventListeners registered on the connection when it detects that a PreparedStatement is invalid. One situation when this happ

Re: Re: Derby-SQL: Syntax Tree generator?

2006-01-03 Thread Ashwin Jayaprakash
Rick, thanks for replying. Perhaps you meant "-Dderby.debug.DumpParseTree=true" instead of  "-Dderby.debug.true=DumpParseTree"? But I tried that too and it didn't work. But anyway, I looked into the GenericStatement code where the Tree was being printed. I realised that was what I wanted to avoid

[PATCH](DERBY-783) Enhance ALTER TABLE syntax to allow users to change the next value to be generated for an identity column

2006-01-03 Thread Mamta Satoor
Hi,   I have attached a review package for this feature to the JIRA entry. Following is a brief description of the changes involved. Changed sqlgrammar.jj to add parser support for ALTER TABLE ALTER RESTART WITH integer-constantAlso, added another element to the array which keeps track of autoinc

[jira] Updated: (DERBY-783) Enhance ALTER TABLE syntax to allow users to change the next value to be generated for an identity column

2006-01-03 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-783?page=all ] Mamta A. Satoor updated DERBY-783: -- Attachment: Derby783AlterTableRestartWith010306.txt I have attached a review package for this feature to the JIRA entry. Following is a brief description of