[jira] Resolved: (DERBY-3568) Convert jdbcapi/savepointJdbc30_JSR169.java and jdbcapi/savepointJdbc30_XA.java to JUnit

2008-04-24 Thread Erlend Birkenes (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Erlend Birkenes resolved DERBY-3568. Resolution: Fixed Convert jdbcapi/savepointJdbc30_JSR169.java and

JIRA-issues without component set

2008-04-24 Thread Henri van de Scheur
I have defined a filter showing the number of Jira-issues lacking a component (see list below). The number of such issues has increased the last couple of weeks. Unfortunately I do not have the privilege to be able to categorize these and set the right component. I would like to ask the

[jira] Updated: (DERBY-3634) Cannot use row_number() in ORDERY BY clause

2008-04-24 Thread Thomas Nielsen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3634?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Nielsen updated DERBY-3634: -- Component/s: SQL Cannot use row_number() in ORDERY BY clause

[jira] Updated: (DERBY-3635) Cannot build SELECT LIST expressions involving row_number()

2008-04-24 Thread Thomas Nielsen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3635?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Nielsen updated DERBY-3635: -- Component/s: SQL Cannot build SELECT LIST expressions involving row_number()

[jira] Resolved: (DERBY-2105) Network Client - Column of type CHAR, VARCHAR or LONG VARCHAR contains wrong value after being updated using the updateObject() method with a clob as parameter.

2008-04-24 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden resolved DERBY-2105. --- Resolution: Invalid The wrong results seems to no longer be an issue. The case throws what

[jira] Updated: (DERBY-3500) Implement a DatabaseMBean for monitoring of a database

2008-04-24 Thread Bernt M. Johnsen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bernt M. Johnsen updated DERBY-3500: Attachment: DERBY-3500-v1.stat DERBY-3500-v1.diff Improved somewhat and

[jira] Commented: (DERBY-3613) SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2

2008-04-24 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12592080#action_12592080 ] Bryan Pendleton commented on DERBY-3613: Merged the trunk change to the 10.4 branch

Jira question

2008-04-24 Thread Bryan Pendleton
What is the FishEye link on the JIRA issue supposed to do? I tried clicking on it for a few random Derby issues, but got no commits found. Does anyone know what this link is supposed to do, and when I should be using it? thanks, bryan

Re: Jira question

2008-04-24 Thread Dyre . Tjeldvoll
Bryan Pendleton [EMAIL PROTECTED] writes: What is the FishEye link on the JIRA issue supposed to do? I tried clicking on it for a few random Derby issues, but got no commits found. Does anyone know what this link is supposed to do, and when I should be using it? Not sure but it is

[jira] Updated: (DERBY-3630) Odd assymetry in interaction of unique and not null constraints

2008-04-24 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-3630: - Component/s: SQL Odd assymetry in interaction of unique and not null constraints

Re: Jira question

2008-04-24 Thread Kristian Waagan
Bryan Pendleton wrote: What is the FishEye link on the JIRA issue supposed to do? I tried clicking on it for a few random Derby issues, but got no commits found. Does anyone know what this link is supposed to do, and when I should be using it? Hi Bryan, It's a tool developed by Atlassian

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

2008-04-24 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (5 issues) Subscriber: derby-dev Key Summary DERBY-3613 SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2 https://issues.apache.org/jira/browse/DERBY-3613 DERBY-1201 ResultSet.updateRow() in

Re: [RESULT] [VOTE] 10.4.1.3 release candidate

2008-04-24 Thread Mamta Satoor
Dyre, first of all, thanks for your hard work and patience with multiple RCs. I did some basic testing for Table Functions and didn't find anything major other than couple doc things. Based on my testing so far, +1. Will continue testing until Friday evening. If I find anything, I will follow it

Re: Problem with MBean user/ password example on Wiki page (non-JRMP server at remote endpoint)

2008-04-24 Thread John Embretsen
Kathey Marsden wrote: John H. Embretsen wrote: Hmm, I don't see anything obviously wrong. If it works with JConsole and the exact same server configuration, it is certainly strange. Perhaps some of the troubleshooting tips (JMX logging, security debug traces) described on the wiki might

Regression Test Report - Daily 650922 - Sun DBTG

2008-04-24 Thread Henri . Vandescheur
[Auto-generated mail] *Daily* 650922/2008-04-23 18:01:07 MEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin 0269269 081.25% derbyall 099149914 0 1326.49% suitesAll sles NA

Should I be able to select the same Blob column twice?

2008-04-24 Thread Kathey Marsden
I was looking at DERBY-2349, and am looking at the simpler case of just selecting the BLOB column twice and performing getBinaryStream() on both columns. The program below does just that and prints the first 10 bytes of the stream. With embedded the output is: 4 5 6 7 8 9 10 11 12 13 14 15

[jira] Created: (DERBY-3642) Update and rectify the Derby tutorial

2008-04-24 Thread Suran Jayathilaka (JIRA)
Update and rectify the Derby tutorial - Key: DERBY-3642 URL: https://issues.apache.org/jira/browse/DERBY-3642 Project: Derby Issue Type: Task Components: Documentation Reporter:

[jira] Closed: (DERBY-3087) NPE while running the SVT MailJdbc

2008-04-24 Thread Manjula Kutty (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Manjula Kutty closed DERBY-3087. NPE while running the SVT MailJdbc -- Key:

[jira] Resolved: (DERBY-3087) NPE while running the SVT MailJdbc

2008-04-24 Thread Manjula Kutty (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3087?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Manjula Kutty resolved DERBY-3087. -- Resolution: Duplicate NPE while running the SVT MailJdbc --

[jira] Updated: (DERBY-684) Improve performance of Clob objects (ClobOutputStream#write,ClobWriter#write) on the client

2008-04-24 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden updated DERBY-684: - Component/s: Newcomer Improve performance of Clob objects

[jira] Reopened: (DERBY-3563) Create eclipse doc and ui plgin for 10.4 release

2008-04-24 Thread Manjula Kutty (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Manjula Kutty reopened DERBY-3563: -- Need to create new plugins since the old one has the word beta on it Create eclipse doc and ui

[jira] Updated: (DERBY-3563) Create eclipse doc and ui plgin for 10.4 release

2008-04-24 Thread Manjula Kutty (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Manjula Kutty updated DERBY-3563: - Attachment: derby_doc_plugin_1.1.2.zip derby_ui_plugin_1.1.2.zip New plugins for

Re: [RESULT] [VOTE] 10.4.1.3 release candidate

2008-04-24 Thread Manjula Kutty
I have attached the new Eclipse plugin with the jira issue DERBY-3563 Thanks Manjula On 4/24/08, Mamta Satoor [EMAIL PROTECTED] wrote: Dyre, first of all, thanks for your hard work and patience with multiple RCs. I did some basic testing for Table Functions and didn't find anything major

Re: Developer's Guide : Example for table function creation has NO SQL clause but the Java method uses SQL

2008-04-24 Thread Rick Hillegas
Thanks for raising this issue, Mamta. I have changed the NO SQL to READS SQL DATA in the trunk (651322) and the 10.4 branch (651324). Regards, -Rick Mamta Satoor wrote: I should have been more clear in my earlier mail. In my test case, the method in Java class is issuing SQL against Derby

Table Function : Fixing the Java class while the database session is still on does not get reflected.......

2008-04-24 Thread Mamta Satoor
Hello, What I am experiencing might be an expected behavior and if not, the issue might be how user functions are implemented in Derby (ie both scalar and table functions) and not specific to table functions. I have defined a table function as follows CREATE FUNCTION testFunctionTable () RETURNS

[jira] Updated: (DERBY-2892) Closing a resultset after retrieving a large 32665 bytes value with Network Server does not release locks

2008-04-24 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden updated DERBY-2892: -- Derby Info: [Regression] (was: [Release Note Needed, Regression, Existing Application

[jira] Created: (DERBY-3643) store/bootLock.java fails on AIX with ibm16yes

2008-04-24 Thread Manjula Kutty (JIRA)
store/bootLock.java fails on AIX with ibm16yes -- Key: DERBY-3643 URL: https://issues.apache.org/jira/browse/DERBY-3643 Project: Derby Issue Type: Bug Reporter: Manjula Kutty --

[jira] Updated: (DERBY-3643) store/bootLock.java fails on AIX with ibm16yes

2008-04-24 Thread Manjula Kutty (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Manjula Kutty updated DERBY-3643: - Description: Here is the diff: Framework: embedded *** Start: bootLock jdk1.6.0 2008-04-24

[jira] Updated: (DERBY-3643) store/bootLock.java fails on AIX with ibm16

2008-04-24 Thread Manjula Kutty (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Manjula Kutty updated DERBY-3643: - Summary: store/bootLock.java fails on AIX with ibm16 (was: store/bootLock.java fails on AIX

Re: Should I be able to select the same Blob column twice?

2008-04-24 Thread Knut Anders Hatlen
Kathey Marsden [EMAIL PROTECTED] writes: I was looking at DERBY-2349, and am looking at the simpler case of just selecting the BLOB column twice and performing getBinaryStream() on both columns. The program below does just that and prints the first 10 bytes of the stream. With embedded

[jira] Updated: (DERBY-2892) Closing a resultset after retrieving a large 32665 bytes value with Network Server does not release locks

2008-04-24 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden updated DERBY-2892: -- Attachment: derby-2892_10.3_try1_diff.txt I attempted to merge this fix to 10.3 Attached is

[jira] Commented: (DERBY-2892) Closing a resultset after retrieving a large 32665 bytes value with Network Server does not release locks

2008-04-24 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12592172#action_12592172 ] Kathey Marsden commented on DERBY-2892: --- I found my problem. My client was way out of

[jira] Updated: (DERBY-3613) SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2

2008-04-24 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-3613: --- Attachment: tenThree.diff GroupByTest.java is quite different in 10.3, making it hard to do

Re: Table Function : Fixing the Java class while the database session is still on does not get reflected.......

2008-04-24 Thread Rick Hillegas
Hi Mamta, I see the same behavior with scalar functions. I ran the following experiment: 1) I compiled a scalar function which returned the constant 0. 2) I brought up the network server. 3) I invoked an ij script which ran the function, retrieving the value 0 as expected. 4) I

[jira] Updated: (DERBY-3594) socket reset failure causing 17 networkserver tests to fail on ibm iseries

2008-04-24 Thread Myrna van Lunteren (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Myrna van Lunteren updated DERBY-3594: -- Component/s: (was: Regression Test Failure) Test Derby Info:

Re: Should I be able to select the same Blob column twice?

2008-04-24 Thread Kathey Marsden
Knut Anders Hatlen wrote: Kathey Marsden [EMAIL PROTECTED] writes: It sounds reasonable to harmonize the two drivers. We could also disallow the second call to getBinaryStream() (or getBlob()) on both drivers, but that would possibly cause more compatibility problems than just closing and