[jira] Updated: (DERBY-377) There is no information available in the manuals on how to upgrade a database from 10.0 to 10.1 version.

2005-07-01 Thread Jeff Levitt (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-377?page=all ] Jeff Levitt updated DERBY-377: -- Attachment: derby377addendum.diff Thanks for the catch Andrew. I guess I didnt svn add it the first time. The attached patch called derby377addendum.diff is an

[jira] Created: (DERBY-428) NetworkClient PreparedStatement.executeBatch() hangs if batch is too large (ArrayIndexOutOfBoundsException in Network Server)

2005-07-01 Thread Bernt M. Johnsen (JIRA)
NetworkClient PreparedStatement.executeBatch() hangs if batch is too large (ArrayIndexOutOfBoundsException in Network Server) - Key: DERBY-428 URL:

[jira] Created: (DERBY-429) Doc Review : Derby Tools and Utilities Guide

2005-07-01 Thread Mamta A. Satoor (JIRA)
Doc Review : Derby Tools and Utilities Guide Key: DERBY-429 URL: http://issues.apache.org/jira/browse/DERBY-429 Project: Derby Type: Improvement Components: Documentation Versions: 10.2.0.0 Reporter: Mamta

[jira] Created: (DERBY-430) It will be good to include synonyms on a table when dblook is run with -t tablename option

2005-07-01 Thread Mamta A. Satoor (JIRA)
It will be good to include synonyms on a table when dblook is run with -t tablename option -- Key: DERBY-430 URL: http://issues.apache.org/jira/browse/DERBY-430 Project: Derby

[jira] Updated: (DERBY-380) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Developer's Guide

2005-07-01 Thread Jeff Levitt (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-380?page=all ] Jeff Levitt updated DERBY-380: -- Attachment: derby380.diff The attached patch makes the changes requested in this doc review. I have created sample output on my own site: HTML files:

[jira] Resolved: (DERBY-380) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Developer's Guide

2005-07-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-380?page=all ] Andrew McIntyre resolved DERBY-380: --- Resolution: Fixed Committed, revision 208734. Additional comments should be attached to DERBY-425. Doc Review (CLOSED TO FURTHER COMMENTS): Derby

[jira] Commented: (DERBY-428) NetworkClient PreparedStatement.executeBatch() hangs if batch is too large (ArrayIndexOutOfBoundsException in Network Server)

2005-07-01 Thread Bernt M. Johnsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-428?page=comments#action_12314877 ] Bernt M. Johnsen commented on DERBY-428: BTW: When the BatchUpdateException is thrown, the connection is closed down (probably due to the

Derby 406, 409, 410 patch

2005-07-01 Thread Philip Wilder
At Kathey's suggestion I took a short break from staring at auto-commit code to turn my attention to some other issues. I change the following items in the client code with this patch: - Set password to a default value (defaultpassword) - Set user to default to APP - Set the default servername

[jira] Created: (DERBY-431) Tests needed for verifying proper functioning of ClientBaseDataSource.setConnectionAttributes() method

2005-07-01 Thread Philip Wilder (JIRA)
Tests needed for verifying proper functioning of ClientBaseDataSource.setConnectionAttributes() method -- Key: DERBY-431 URL: http://issues.apache.org/jira/browse/DERBY-431

Statement.setQueryTimeout() in client/server mode

2005-07-01 Thread Oyvind . Bakksjo
Currently, the Derby client contains a client-side implementation of setQueryTimeout; using a TimerTask to invoke Statement.cancel() on the client side. First of all, cancel() is not implemented, so this doesn't work. Furthermore, we should use the server-side mechanism we now have for

Re: Derby-213 Early Patch

2005-07-01 Thread Philip Wilder
It says in section 15.2.2 of the document says: next() — moves the cursor forward one row. Returns true if the cursor is now positioned on a row and false if the cursor is positioned after the last row. I guess the way to reconcile both this statement and the item in section 9.1 is for the

Re: [jira] Updated: (DERBY-390) Import/export fails with table names that are quoted in SQL like import to table Order

2005-07-01 Thread Mike Matrigali
I have committed this patch with svn 208770. Suresh Thalamati (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-390?page=all ] Suresh Thalamati updated DERBY-390: --- Attachment: derby390.diff patch to handle case-sensitive SQL identifiers

Re: JDBC auto-commit semantics challenge

2005-07-01 Thread Lance J. Andersen
I am just getting back from J1 and I have a quite a few emails to wade through. If/when you hace a cycle, if you can summarize the issues outstanding, i can look at it and discuss with the EG. There are sooo many emails from derby-dev, it is going to take me quite some time to digest it all.

[jira] Created: (DERBY-433) Minor code cleanup is needed in NetXAResource

2005-07-01 Thread Kathey Marsden (JIRA)
Minor code cleanup is needed in NetXAResource -- Key: DERBY-433 URL: http://issues.apache.org/jira/browse/DERBY-433 Project: Derby Type: Sub-task Components: Network Client Versions: 10.1.1.0, 10.2.0.0

[jira] Updated: (DERBY-432) Client XA could still use code cleanup and testing

2005-07-01 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-432?page=all ] Kathey Marsden updated DERBY-432: - Component: Network Client Client XA could still use code cleanup and testing - Key:

[jira] Created: (DERBY-434) add jdbcapi/xaMorph.sql jdbcapi/xaJNDI jdbcapi/xaAnotherTest.sql to client xa testing.

2005-07-01 Thread Kathey Marsden (JIRA)
add jdbcapi/xaMorph.sql jdbcapi/xaJNDI jdbcapi/xaAnotherTest.sql to client xa testing. --- Key: DERBY-434 URL: http://issues.apache.org/jira/browse/DERBY-434 Project: Derby Type:

[jira] Created: (DERBY-435) jdbcapi/checkDataSource.java and jdbapi/checkDataSource30.java to tests should be changed or extended to test client DataSources

2005-07-01 Thread Kathey Marsden (JIRA)
jdbcapi/checkDataSource.java and jdbapi/checkDataSource30.java to tests should be changed or extended to test client DataSources - Key: DERBY-435

[jira] Updated: (DERBY-406) Client DataSource should not require user property to be set

2005-07-01 Thread Philip Wilder (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-406?page=all ] Philip Wilder updated DERBY-406: Attachment: Derby406_409_410.patch A Combined patch for DERBY-406, DERBY-409 and DERBY-410 #Warning# When testing this patch there were locale (en_CA vs en_US)

Re: [jira] Updated: (DERBY-406) Client DataSource should not require user property to be set

2005-07-01 Thread Kathey Marsden
Philip Wilder (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-406?page=all ] Philip Wilder updated DERBY-406: Attachment: Derby406_409_410.patch A Combined patch for DERBY-406, DERBY-409 and DERBY-410 #Warning# When testing this patch there

[jira] Created: (DERBY-436) clean up imports and static field references in DRDA classes

2005-07-01 Thread Kathey Marsden (JIRA)
clean up imports and static field references in DRDA classes - Key: DERBY-436 URL: http://issues.apache.org/jira/browse/DERBY-436 Project: Derby Type: Task Components: Network Server Versions:

Re: Statement.setQueryTimeout() in client/server mode

2005-07-01 Thread Satheesh Bandaram
This would only support setQueryTimeout() mechanism, but not the cancel(), right? Wouldn't having support for cancel() be useful too, if applications like to cancel a long running query? (that didn't have timeout set) Also, I wonder if the protocol has support for cancel mechanism If so, using

Re: Statement.setQueryTimeout() in client/server mode

2005-07-01 Thread Daniel John Debrunner
[EMAIL PROTECTED] wrote: Currently, the Derby client contains a client-side implementation of setQueryTimeout; using a TimerTask to invoke Statement.cancel() on the client side. First of all, cancel() is not implemented, so this doesn't work. Furthermore, we should use the server-side

[jira] Commented: (DERBY-420) missing classes in published javadoc incorrect copyright date

2005-07-01 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-420?page=comments#action_12314908 ] Andrew McIntyre commented on DERBY-420: --- Merged to 10.1 branch with 208776 missing classes in published javadoc incorrect copyright date

10.1 bug list near zero - release candidate shortly

2005-07-01 Thread Andrew McIntyre
The 10.1.1.0 bug list has a single entry left, DERBY-420: http://issues.apache.org/jira/browse/DERBY-420 Dan, are there further javadoc modifications you would like to make? As soon as this bug is closed I am planning on putting together a release candidate for a vote. For reference,

Re: Derby 406, 409, 410 patch

2005-07-01 Thread Daniel John Debrunner
Philip Wilder wrote: Kathey managed to spot some areas in which my patch could be improved and some in which it was plain wrong. I'm still tidying up at the moment but should hopefully have the Kathey approved patch in the near future. Since this is open source it's useful to post the

Re: 10.1 bug list near zero - release candidate shortly

2005-07-01 Thread Daniel John Debrunner
Andrew McIntyre wrote: The 10.1.1.0 bug list has a single entry left, DERBY-420: http://issues.apache.org/jira/browse/DERBY-420 Dan, are there further javadoc modifications you would like to make? As soon as this bug is closed I am planning on putting together a release candidate for a

Re: [jira] Updated: (DERBY-406) Client DataSource should not require user property to be set

2005-07-01 Thread Daniel John Debrunner
Philip Wilder (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-406?page=all ] Philip Wilder updated DERBY-406: Attachment: Derby406_409_410.patch A Combined patch for DERBY-406, DERBY-409 and DERBY-410 So how is this patch different

[jira] Resolved: (DERBY-420) missing classes in published javadoc incorrect copyright date

2005-07-01 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-420?page=all ] Daniel John Debrunner resolved DERBY-420: - Fix Version: 10.2.0.0 Resolution: Fixed missing classes in published javadoc incorrect copyright date

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

2005-07-01 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-398?page=all ] Deepa Remesh updated DERBY-398: --- Attachment: derby-398_2.diff derby-398_2.status derbyall_report_2.txt Hi Dan, Thanks for looking into this patch. I have made the

Re: Derby 406, 409, 410 patch

2005-07-01 Thread Kathey Marsden
Daniel John Debrunner wrote: Since this is open source it's useful to post the feedback on patches to the derby-dev list. Hi Dan, My comments were - There should not be a default password set. Client should use USER_ONLY_SECURITY by default if the password is not set and

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

2005-07-01 Thread Suresh Thalamati (JIRA)
SYSCS_UTIL.SYSCS_COMPRESS_TABLE does not work on tables that are created with delimited identifier names. --- Key: DERBY-437 URL:

[jira] Commented: (DERBY-406) Client DataSource should not require user property to be set

2005-07-01 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-406?page=comments#action_12314924 ] Kathey Marsden commented on DERBY-406: -- I ran derbynetclientmatsand dataSourcePermissions_net.java under jcc for this patch and all passed. The patch looks good to me,

Re: [jira] Updated: (DERBY-397) Make it sure for the connection to be closed in drda.Database#close() even if Exception happens in conn.rollback().

2005-07-01 Thread Kathey Marsden
TomohitoNakayama wrote: I have found next implementation in org.apache.derby.impl.jdbc.EmbedConnection#close(). /* Throw error to match DB2/JDBC if a tran is pending in non-autocommit mode */ if (!autoCommit !transactionIsIdle()) { throw

[jira] Updated: (DERBY-438) Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s).

2005-07-01 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-438?page=all ] A B updated DERBY-438: -- Attachment: go.java Attaching a repro for the problem. To run, just do java go. Update triggers on tables with blob columns fail at execution time if the

[jira] Created: (DERBY-438) Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s).

2005-07-01 Thread A B (JIRA)
Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s). Key: DERBY-438 URL:

Re: [jira] Created: (DERBY-438) Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s).

2005-07-01 Thread Daniel John Debrunner
A B (JIRA) wrote: Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s). I'm suprised this is not documented, BLOB and CLOB columns do not work with triggers. This is because within the database engine, there is no

Re: JDBC auto-commit semantics challenge

2005-07-01 Thread Kathey Marsden
Lance J. Andersen wrote: I am just getting back from J1 and I have a quite a few emails to wade through. If/when you hace a cycle, if you can summarize the issues outstanding, i can look at it and discuss with the EG. There are sooo many emails from derby-dev, it is going to take me quite

Re: [jira] Created: (DERBY-438) Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s).

2005-07-01 Thread Army
Daniel John Debrunner wrote: I'm suprised this is not documented, BLOB and CLOB columns do not work with triggers. This is because within the database engine, there is no mechanism to create a java.sql.Blob object (or Clob) from a SQL BLOB (CLOB) datatype. The java.sql.Blob returned from a

Re: [jira] Created: (DERBY-438) Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s).

2005-07-01 Thread Daniel John Debrunner
Army wrote: Daniel John Debrunner wrote: I'm suprised this is not documented, BLOB and CLOB columns do not work with triggers. This is because within the database engine, there is no mechanism to create a java.sql.Blob object (or Clob) from a SQL BLOB (CLOB) datatype. The java.sql.Blob

Re: JDBC auto-commit semantics challenge

2005-07-01 Thread Daniel John Debrunner
Kathey Marsden wrote: Lance J. Andersen wrote: I am just getting back from J1 and I have a quite a few emails to wade through. If/when you hace a cycle, if you can summarize the issues outstanding, i can look at it and discuss with the EG. There are sooo many emails from derby-dev, it is

Re: [jira] Created: (DERBY-438) Update triggers on tables with blob columns fail at execution time if the triggered-SQL-statement references the blob column(s).

2005-07-01 Thread Army
Daniel John Debrunner wrote: Army wrote: 1) Does this mean that we don't support _any_ triggers that are defined on tables having lob columns? Or is there some qualifier to that? Sorry, I think the qualifier should have been: accessing LOB columns of the modified table by the action