Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 10021 invoked from network); 2 Jul 2005 05:28:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Jul 2005 05:28:10 -0000 Received: (qmail 16991 invoked by uid 500); 2 Jul 2005 05:28:09 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 16760 invoked by uid 500); 2 Jul 2005 05:28:08 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 16744 invoked by uid 99); 2 Jul 2005 05:28:08 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Jul 2005 22:28:08 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: 68.142.198.202 is neither permitted nor denied by domain of mcintyre.a@gmail.com) Received: from [68.142.198.202] (HELO smtp103.sbc.mail.mud.yahoo.com) (68.142.198.202) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 01 Jul 2005 22:28:08 -0700 Received: (qmail 87143 invoked from network); 2 Jul 2005 05:28:02 -0000 Received: from unknown (HELO ?192.168.0.5?) (fuzzylogic@sbcglobal.net@68.122.73.211 with plain) by smtp103.sbc.mail.mud.yahoo.com with SMTP; 2 Jul 2005 05:28:00 -0000 Mime-Version: 1.0 (Apple Message framework v730) To: Derby Development Message-Id: Content-Type: multipart/mixed; boundary=Apple-Mail-2-240958759 From: Andrew McIntyre Subject: [VOTE] 10.1.1.0 release Date: Fri, 1 Jul 2005 22:27:59 -0700 X-Mailer: Apple Mail (2.730) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N --Apple-Mail-2-240958759 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Hello derby-dev, I have posted final release candidate distributions on my public_html: http://people.apache.org/~fuzzylogic/derby_10.1/ Please review the distributions and vote with your approval/ disapproval. Voting closes at noon on Friday, July 8. If the proposed distributions are approved, I will then request the Incubator for permission to post them as an incubating release. I will prepare release notes and post them on Tuesday. The format will be the same as is currently linked off of the downloads page for the 10.0.2.1 release. I have attached a draft, but it is missing a few items in the open/closed bug lists and the lists of tests run (and by whom) has not been completed. Also, I intended to have a page with instructions on how to create a release, along with ant targets to drive the mechanics of the release, ready at this point. I still intend to deliver this sometime next week, but I wanted to get the distributions up as soon as possible. That document and the ant targets that go along with it will need careful review to make sure that nothing has been omitted, and I will submit it for review as soon as it is ready. And, of course, my vote: +1 andrew --Apple-Mail-2-240958759 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; x-unix-mode=0750; name="release-10.1.1.0.html" Content-Disposition: attachment; filename=release-10.1.1.0.html =0D =0D =0D =0D= =0D =0D =0D Apache Derby 10.1.1.0 Release=0D =0D= =0D =0D =0D= =0D =0D =0D =0D =0D
=0D =0D
=0D apache > incubator=0D
=0D =0D
=0D =0D
=0D 3D""=0D
=0D =0D =0D
=0D 3D"Derby"=0D
=0D =0D =0D
=0D
=0D   =0D =0D
=0D
=0D =0D =0D =0D =0D
=0D
=0D
=0D
=0D =0D
=0D =0D =0D
=0D =0D
=0D =0D  =0D
=0D =0D =0D
=0D
Derby
=0D
=0D
=0D Welcome=0D
=0D
=0D License=0D
=0D
=0D Proposal=0D
=0D
=0D FAQs=0D
=0D
=0D Downloads=0D
=0D
=0D Javadoc=0D
=0D
=0D
Community
=0D
=0D
=0D Get Involved!=0D
=0D
=0D Mailing Lists=0D
=0D
=0D BUGS=0D
=0D
=0D Tests=0D
=0D
=0D To-Do=0D
=0D
=0D Logo Contest=0D
=0D
=0D
About
=0D
=0D
=0D Index=0D
=0D
=0D Derby Web Site=0D
=0D
=0D
Derby Engine
=0D
=0D
=0D Javadoc=0D
=0D
=0D Architecture=0D
=0D
=0D Disk Page Format=0D=
=0D
=0D How Things Work=0D
=0D
=0D Intersect & = Except=0D
=0D
=0D JDBC=0D
=0D
=0D Log Format=0D
=0D
=0D Logging & = Recovery=0D
=0D
=0D Optimizer=0D
=0D
=0D Type = System=0D
=0D
=0D Versioning=0D
=0D
=0D
Derby Network Client
=0D
=0D
=0D Functional = Spec=0D
=0D
=0D
Presentations
=0D
=0D
=0D Colorado = 2004=0D
=0D
=0D ApacheCon US '04=0D=
=0D
=0D
Instruction
=0D =0D
Integration
=0D
=0D
=0D Index=0D
=0D
=0D Summary=0D
=0D
=0D C-JDBC = (PDF)=0D
=0D
=0D C-JDBC = (SXW)=0D
=0D
=0D DOTS Derby=0D
=0D
=0D DOTS = System=0D
=0D
=0D EMMA= =0D
=0D
=0D iBATIS = JPetStore=0D
=0D
=0D JOnAS = (PDF)=0D
=0D
=0D
Eclipse Plug-ins
=0D
=0D
=0D 10.0 Core=0D
=0D
=0D 1.0 UI = Functional Spec=0D
=0D
=0D 10.1 Core and 1.0 = UI=0D
=0D
=0D 10.1 Core and 1.0 = UI Slides and Lab=0D
=0D
10.1 Core and 1.0 UI = Documentation
=0D
=0D
=0D Getting = Started=0D
=0D
=0D Creating= an Eclipse Project=0D
=0D
Derby Nature
=0D =0D
Network Server
=0D =0D
=0D Derby = Properties=0D
=0D
ij
=0D
=0D
=0D Using ij=0D=
=0D
=0D SQL commands=0D=
=0D
=0D SQL scripts=0D=
=0D
=0D
=0D Building = a Java App=0D
=0D
=0D Running = sysinfo=0D
=0D
=0D Derby = Manuals=0D
=0D
=0D
=0D
Manuals
=0D
=0D
=0D About=0D
=0D
10.0 Manuals
=0D
=0D
=0D All docs: = zip=0D
=0D
=0D All = docs: tar.gz=0D
=0D
=0D Getting Started=0D
=0D
=0D Reference Manual=0D
=0D
=0D Developer's Guide=0D
=0D
=0D Tuning Derby=0D
=0D
=0D Server & Admin Guide=0D
=0D
=0D Tools & Utility Guide=0D
=0D
=0D
10.1 Alpha Manuals
=0D
=0D
=0D DITA Source=0D
=0D
Getting Started
=0D
=0D
=0D PDF=0D
=0D
=0D HTML Book=0D
=0D
=0D HTML Files=0D=
=0D
=0D
Reference
=0D
=0D
=0D PDF=0D=
=0D
=0D HTML = Book=0D
=0D
=0D HTML = Files=0D
=0D
=0D
Developer's Guide
=0D
=0D
=0D PDF<= /a>=0D
=0D
=0D HTML Book=0D
=0D
=0D HTML Files=0D=
=0D
=0D
Tuning Derby
=0D
=0D
=0D PDF= =0D
=0D
=0D HTML = Book=0D
=0D
=0D HTML= Files=0D
=0D
=0D
Server & Admin
=0D=
=0D
=0D = PDF=0D
=0D
=0D HTML Book=0D
=0D
=0D HTML = Files=0D
=0D
=0D
Tools & Utility = Guide
=0D
=0D
=0D PDF=0D
=0D
=0D HT= ML Book=0D
=0D
=0D HTML = Files=0D
=0D
=0D
=0D
=0D
=0D
=0D 3D""
=0D= =0D
=0D =0D =0D
=0D
=0D
=0D Font size: =0D   =0D  =0D  =0D
=0D

Apache Derby 10.1.1.0 Release

=0D
=0D =0D
=0D =0D =0D

Release Overview

=0D
=0D

Derby is a pure Java relational database engine using standard SQL = and=0D JDBC as its APIs.

=0D

What's new in 10.1.1.0:

=0D
    =0D =0D
  • New open source Derby network client driver
    • =0D =0D
  • Support for J2ME/CDC/Foundation with JSR-169 JDBC subset
    • =0D =0D
  • Online compress functionality for reclaiming disk space during = operation
    • =0D =0D
  • XA support for Network Server
    • =0D =0D
  • Increased identifier lengths to 128 characters for all = identifiers
    • =0D =0D
  • Added SQL: INTERSECT and EXCEPT
    • =0D =0D
  • Added SQL: SYNONYM
    • =0D =0D
  • JDBC Updatable Result Sets
    • =0D =0D
  • ORDER by expressions
    • =0D =0D
  • Allow insertions into an identity column
    • =0D =0D
  • Support for explicit Java method signature in function and procedure = defintions
    • =0D =0D
=0D

For a comprehensive list of changes, consult the CHANGES file in your = distribution.

=0D

10.1.1.0 functionality includes:

=0D
    =0D =0D
  • Embedded engine with JDBC driver
    • =0D =0D
  • Network Server
    • =0D =0D
  • Network client JDBC driver
    • =0D =0D
  • Command line tools: ij (SQL scripting), dblook (schema dump) and = sysinfo (system info)
    • =0D =0D
=0D

SQL support:

=0D
    =0D =0D
  • Schemas, tables, tempoaray tables, views, triggers, indexes, = savepoints
    • =0D =0D
  • Java procedures and functions
    • =0D =0D
  • Standard datatypes including BLOB and CLOB
    • =0D =0D
  • Sub-queries and joins
    • =0D =0D
  • Primary key, foreign key, unique and check constraints
    • =0D =0D
  • Referential actions
    • =0D =0D
=0D

Other features:

=0D
    =0D =0D
  • Full ACID transaction support with all four isolation levels
    • =0D =0D
  • Row and table level locking
    • =0D =0D
  • Configurable authentication including LDAP support
    • =0D =0D
  • Import/Export
    • =0D =0D
  • On-line backup and recovery support
    • =0D =0D
  • Optional on-disk encryption
    • =0D =0D
  • Platform independent database format
    • =0D =0D
  • Full support for Java 2 Security Manager
    • =0D =0D
=0D

JDK/JDBC support:

=0D
    =0D =0D
  • JDK 1.3, 1.4, 1.5, and J2ME support
    • =0D =0D
  • JSR-169, JDBC 2.1, and JDBC 3.0 support
    • =0D =0D
=0D
=0D =0D =0D =0D

Release Notes

=0D
=0D

Derby version 10.1.1.0

=0D

This is the second incubator release for Derby. The build number of = this release is 208786.=0D For information on getting started using Derby, refer to the Gettin= g Started manual.

=0D

The IBM Universal JDBC Driver is no longer required to use the Derby = Network Server. A new Derby network=0D client driver, packaged as derbyclient.jar, is now provided for = remote network access to the Derby Network=0D Server. For more information on using the Derby network client = driver, see the Derb= y Server and Administration Guide.

=0D

A detailed list of changes can be found in the CHANGES file in each = of the distributions listed below.

=0D

This release fixes the following reported JIRA issues since the = 10.0.2.1 release:

=0D =0D =0D =0D =0D =0D =0D =0D Provide XA Support for Network Server=0D= =0D =0D =0D NPE when trying to create a database at a = directory that is not allowed=0D =0D =0D =0D Derby documentation mentions script and = batch files that don't exist=0D =0D =0D =0D NsSample sample program refered to in = documentation is missing=0D =0D =0D =0D dblook options doco incorrect=0D =0D =0D =0D TableName not serializable=0D =0D =0D =0D Derby does not support open cursor across = commits for XA transactions and hence = DatabaseMetaData.supportsOpenCursorsAcrossCommit should return = false.=0D =0D =0D =0D Add documentation for property - = derby.language.logQueryPlan=0D =0D =0D =0D org.apache.derby.database.UserUtility.add = does not exist but is documented=0D =0D =0D =0D XA .sql tests fail with jar files=0D =0D =0D =0D Cannot connect to Derby using DB2 = Universal Driver=0D =0D =0D =0D partial log record writes that occur = because of out-of order writes need to be handled by recovery.=0D =0D =0D =0D Support J2ME/CDC/Foundation with JSR169 = JDBC subset=0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D= =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D= =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D= =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D
KeySummary
DERBY-10
DERBY-19
DERBY-55
DERBY-56
DERBY-58
DERBY-62
DERBY-66
DERBY-82
DERBY-87
DERBY-91
DERBY-92
DERBY-96
DERBY-97
DERBY-101Limit on Number of log that can be = created should be increased (current limit is 4194303)
DERBY-102can not insert more than 32270 = charakters in long varchar, clob
DERBY-104Get rid of the Max lenght of 18 for = constraint names
DERBY-106HashJoinStrategy leads to = java.lang.OutOfMemoryError
DERBY-107Add Support for ODBC Metadata Calls to = Derby
DERBY-114Buildworld target refers to non-existent = jars target
DERBY-115BEFORE triggers missing from CREATE = TRIGGER documentation
DERBY-116Content comment for = SYSTRIGGERS.TRIGGERDEFINITION is misleading
DERBY-121Network Server reading blob/clob data = size
DERBY-122Suite jdk14 is skipped incorrectly with = J2SE 5.0
DERBY-123Derby incorrectly rounds double values = down during insert into NUMERIC
DERBY-124Result type for CONCAT operator with = blobs appears to be incorrect.
DERBY-126Documentation bug. Doc says column = default can be edited - it looks like it cannot
DERBY-127Aliased Columns not recognized after = "group by... order by" combination
DERBY-130IDENTITY_VAL_LOCAL not reset when new = Connection returned from PooledConnection
DERBY-132in place table/index compress which = returns space to OS
DERBY-134Sorted string columns are sorted in a = case sensitive way
DERBY-139LOCAL as a reserved keyword does not = match other databases
DERBY-153Bad Eclipse plugin version = specification
DERBY-155Add DISTINCT keyword support to = INTERSECT and EXCEPT
DERBY-158PRIMARY KEY does not imply NOT NULL
DERBY-161DATE function as documented in the = manuals does not support integer arguments. i.e. DATE(1232) does not = work although the manual specifies that this format will return a date = field that is "x" number of days since day 0.
DERBY-164unicodeEscape command in ij doesn't = work
DERBY-168Can't ALTER a column to have a new = DEFAULT value.
DERBY-173For the concurrency of ResultSet, = Network Server should not send the concurrency of Statement.
DERBY-174setNull does not work with = java.sql.Types.TIMESTAMP
DERBY-175setNull does not work with = java.sql.Types.BLOB when batching is turned on
DERBY-180XCL47 SQLState duplicated in = messages_en.properties?
DERBY-181Function/Procedure specific name = documented but not supported
DERBY-182BUILDING.txt 3.4.6 refers to a readme = file for testing that does not exist
DERBY-186isFirst() returns true when relative(x) = goes beyond result set
DERBY-189ResultSetMetaData.getSchemaName and = ResultSetMetaData.isWritable donot return correct values
DERBY-194getPrecision() on TIME and TIMESTAMP is = zero
DERBY-198Add Support for network Server USRIDONL = security
DERBY-199Derby does not support array of column = names or column indexes to execute or executeUpdate. Document = incorrectly implies that Derby supports this functionality
DERBY-214Remove System.exit() calls from the = DB2jServerImpl.java
DERBY-217issue with BLOBs and batch updates in = 10.1.0.0
DERBY-218Add Relaxed Durability option
DERBY-219EXCEPT/INTERSECT fails in views
DERBY-220Javadoc build should include a timestamp = and/or the svn revision number in a visible location.
DERBY-225insert of decimal value larger than max = succeeds with jdk15
DERBY-227Reference manual has incorrect = information for supported resultset types for prepareCall JDBC api
DERBY-228need some OSGI related changes to = MANIFEST.MF
DERBY-229Column names on ResultSet.updateXXX and = getXXX methods are handled incorrectly
DERBY-230"Schema already exists" when creating a = table
DERBY-235unable to create a database using a = different storage factory than the one provided by default with the = engine
DERBY-236Sane Mode and in our test environment, = bootPassword gets written out in plain text to service.properties
DERBY-237Boot errors from store must not lose = error messages/stack traces in between.
DERBY-242DatabaseMetaData.supportsGetGeneratedKeys = needs to return FALSE, since Derby only has limited support.
DERBY-243connection toString should uniquely = identify the connection
DERBY-246XA end() fails with Connection is closed = error
DERBY-247Network Server demo program should = support Derby network client driver
DERBY-248Network Server frameworks scripts should = support Derby network client driver
DERBY-249Builds fail during splitmessages step if = path contains spaces
DERBY-250With client setObject( parameterIndex, = x, java.sql.DOUBLE) throws conversion exception if the object passed is = a BigDecimal with more than 31 digits
DERBY-251DISTINCT query is returning duplicate = rows
DERBY-255Closing a resultset after retrieving a = large > 32K value with Network Server does not release locks
DERBY-258Incorrect method resolution with = explicit method signature
DERBY-265In Network Server retrieving BLOB values = with autocommit off causes NullPointerException in INSANE build / = AssertFailure in in BaseContainerHandle.getTransaction in SANE = Build
DERBY-266test tools/dblook_test.java fails if run = in a directory having "*derby/*" in its path
DERBY-279Tagging in DITA docs causes Derby builds = to fail.
DERBY-287Return value of IDENTITY_VAL_LOCAL for = different connections is not related.
DERBY-288JDBC 2.0 Connection Methods Supported = table in displays correctly in html but not in pdf form of Reference = manual
DERBY-302Takes over 3 minutes to insert a 500kb = String into CLOB
DERBY-309Regression: store/backupRestore1.java = fails
DERBY-313testing/README.htm property = descriptions: testSpecialProps wrongly named; useprocess omitted
DERBY-314eclipse plugin needs improved network = server process handling
DERBY-318SYS.SYSCOLUMN problem with "GENERATED BY = DEFAULT" column w/ Network Server
DERBY-319Derby returns incorrect values for = "LENGTH" column of DatabaseMetaData.getProcedureColumns() result = set.
DERBY-320Failed test: = derbyall/derbynetclientmats/derbynetmats.fail:lang/updatableResultSet.java=
DERBY-322Remove resultSetHoldability property = from ClientDataSource
DERBY-325Database cannot be started due to = recovery failure
DERBY-334Add initial SQL support for XML = datatype/functions in Derby, based on SQL/XML specs.
DERBY-335Enhance Derby by adding SYNONYM support. = A synonym is an alternate name for a view or a table.
DERBY-337dblook doesn't generate SQL statements = for SQL functions.
DERBY-339Network client XA should only keep XA = state for transaction branch association, to track whether to send = commit in autocommit mode. All other state and state related decisions = should be deferred to the server.
DERBY-344NPE while performing a 'select distinct = ' on a database in softupgrademode with 10.1
DERBY-373Documentation errors in "Server/Admin" = Guide.
DERBY-374Invalid URL with Derby Client when = connecting to Network Server causes protocol exception.
DERBY-375Specification of incomplete server = properties on command line causes NPE with NetworkServerControl when = starting the server.
DERBY-377There is no information available in = the manuals on how to upgrade a database from 10.0 to 10.1 = version.
=0D

Below is a list of open code issues documented in the JIRA bug = tracking system=0D for the project at the time of the release:

=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D May get a non-uniue conglomerate id in a = very unlikely XA edge case=0D =0D =0D =0D Network Server Needs to generate CRRTKN on = ACCRDB if client does not send it=0D =0D =0D =0D LIKE handles strings with control = characters incorrectly.=0D =0D =0D =0D Exception XCL16 incorrectly raised for = ResultSet of method return after nested commit.=0D =0D =0D =0D just booting jdbc driver and shutting down = seem to leak memory=0D =0D =0D =0D Dropping a nested trigger and rerunning = the querry causes NullPointerException=0D =0D =0D =0D UCASE/LCASE function should change case = according to database locale, but uppercases according to the JVM = locale.=0D =0D =0D =0D Execute Statement of a SYSIBM sps gives = java linkage error and class not found exception.=0D =0D =0D =0D Strange error in JOIN ON clause=0D =0D =0D =0D A connection request that has a default = schema that is being created by another transaction will fail to = connect=0D =0D =0D =0D Incorrect documentation about class = loading from installed jar files.=0D =0D =0D =0D Cannot connect to Derby using DB2 = Universal Driver=0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D= =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D= =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D =0D = =0D =0D =0D
KeySummary
DERBY-1Can't create a new db on OS X
DERBY-5Network Server Protocol error when select = fails and "order by" is specified
DERBY-7Bug in NULLIF Function
DERBY-15
DERBY-17
DERBY-20
DERBY-22
DERBY-23
DERBY-26
DERBY-27
DERBY-28
DERBY-39
DERBY-48
DERBY-70
DERBY-92
DERBY-105drop table statement shows wrong message = after dropping table
DERBY-129Derby should throw a truncation error or = warning when CASTing a parameter/constant to char or char for bit = datatypes and the data is too large for the datatype.
DERBY-131AVG precision is INTEGER instead of = DOUBLE
DERBY-138Public javadoc should include the = org.apache.derby.diag package to show usage of LockTable and other = public VTI's
DERBY-148N/w server needs 2 jvm properties to be = set to start on IPv6/IPv4 dual stack windows machines
DERBY-151Thread termination -> XSDG after = operation is 'complete'
DERBY-154Does Network Server support scroll = sensitive read-only and updatable resultsets?
DERBY-160Foreign key constraint failure closes = the cursors in embedded mode but not in Network Server mode
DERBY-162Date format documentation = incomplete.
DERBY-163Timestamp formatting
DERBY-166NULL is not a valid constraint type
DERBY-172Trigger activation
DERBY-176Derby throws ERROR XBCM1: Java linkage = error thrown during load of generated class = org.apache.derby.exe.aced07c066x0102xca87x3319x00004aa5686e1 during = execution of large query
DERBY-177Unnecessary waiting within = EmbedDatabaseMetaData.getIndexInfo()
DERBY-179Hibernate bad support
DERBY-183Parameter names required in CREATE = FUNCTION
DERBY-195isSearchable() returns true for a = calculated field
DERBY-204Derby javadoc has lots of warnings
DERBY-211Network Server returns no result sets = for a procedure call that returns no result
DERBY-215Correlation name not allowed for = updatable columns in updatable cursors
DERBY-238Testharness: testEncryptionAlgorithm = property is not being picked up correctly for some encryption = suites
DERBY-240loading special locale fails with jdk131 = and jars
DERBY-241Encrypted run of stress.multi test = failed once with a boot error with ibm142
DERBY-244with linux, depending on env setting = $LANG and console encoding, some i18n tests fail
DERBY-283On IPv6/Ipv4 dual stack windows = machines, the network server needs the following jvm properties to be = prefixed while starting the server
DERBY-299NetworkServerControlImpl should not have = Hard coded message for Unexpected expections
DERBY-300Creation of SQLWarning on a = getConnection causes hang on 131 vms when server and client are in same = vm.
DERBY-301test harness does not work correctly = when colons or spaces are in the directory name
DERBY-304If by mistake you give he location for = the db backup as the db itself , then windows created directories = recursively until windows crashes!
DERBY-310Document and/or change Derby client code = to match behavior with Embedded driver where possible.
DERBY-315jdbcapi/rsgetXXXcolumNames fails with = DerbyNet framework
DERBY-321ASSERT FAILED invalid space required = 10012 newDataToWrite.getUsed() 10012 nextRecordOffset 189 ... on a = database recoverty.
DERBY-328Derby doesn't build properly in turkish = locale
DERBY-331create table fails when a constraint = defintion follows a column default
DERBY-333Malformed if statement in = org.apache.derby.impl.drda.Database.getDRDAStatement()
DERBY-341Client should disallow XAConnection = getConnection() when a global transaction has been started and a logical = connection has already been obtained
DERBY-345Need to add a property to = startNetworkServer.* to specify be able to set the derby.system.home = property
DERBY-348example.html file for the SimpleApp does = not describe the arguments accepted by the program
DERBY-349setByte() with executeBatch causes hang = with client if mapping is invalid, e.g. setByte to DATE
DERBY-352Clobs on insert using streams should not = instantiate into memory
DERBY-353It is desirable to have = IDENTITY_VAL_LOCAL() function return last recent user specified value or = system generated value for BY DEFAULT identity columns.
DERBY-361Unknown page format error while doing = recovery after a a crash while doing in place compress.
DERBY-365inplace compress on synonym throws an = assert failure. (may be it should not be allowed).
DERBY-374Invalid URL with Derby Client when = connecting to Network Server causes protocol exception.
DERBY-375Specification of incomplete server = properties on command line causes NPE with NetworkServerControl when = starting the server.
DERBY-377There is no information available in the = manuals on how to upgrade a database from 10.0 to 10.1 version.
DERBY-385servlet Back to Main Page link points to = csnet instead of derbynet
DERBY-387SimpleNetworkClientSample.java network = server example has an error which causes it to fail
DERBY-389With Network Server Database hangs after = some time with many connections executing prepareStatement()
DERBY-390Import/export fails with table names = that are quoted in SQL like import to table "Order"
DERBY-392Disable creating indexes on long varchar = for bit data. Long varchar column doesn't allow creating indexes = already.
DERBY-395Server-side "trace on" and "trace off" = commands do not appear to be working correctly.
=0D
=0D =0D =0D =0D

Distributions

=0D
=0D

There are three different distributions:

=0D
    =0D =0D
  • bin distribution - contains the documentation, javadoc, and jar = files for Derby.
    • =0D =0D
  • lib distribution - contains only the jar files for Derby.
    • =0D =0D
  • src distribution - contains the Derby source tree at the point which = the binaries were built.
    • =0D =0D
=0D

=0D incubating-derby-10.1.1.0-bin.zip [PGP] [MD5]
=0D =0D incubating-derby-10.1.1.0-bin.tar.gz [PGP] [MD5]

=0D

=0D

=0D incubating-derby-10.1.1.0-lib.zip [PGP] [MD5]
=0D =0D incubating-derby-10.1.1.0-lib.tar.gz [PGP] [MD5]

=0D

=0D

=0D incubating-derby-10.1.1.0-src.zip [PGP] [MD5]
=0D =0D incubating-derby-10.1.1.0-src.tar.gz [PGP] [MD5]

=0D
=0D =0D =0D =0D

Testing

=0D
=0D

Tests were run on the following platforms. Results are listed = separately for each platform.

=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D =0D
Type testplatform, jvm versionby.:
=0D

Tests for a specific platform can be run using the corresponding = derbyTesting.jar file that can be found here: derbyTesting.jar=0D

=0D

Instructions on how to run the tests can be found in the testing README.

=0D
=0D =0D
=0D =0D
 
=0D
=0D
=0D =0D
=0D =0D
=0D
=0D Copyright © 2004-2005 Apache Software Foundation
=0D
=0D Send feedback about the website to:=0D derby-dev@db.apache.org=0D
=0D =0D
=0D =0D =0D --Apple-Mail-2-240958759--