Use the links below to download a distribution of Apache Derby. You should always verify the integrity of distribution files downloaded from a mirror.

There are four different distributions:

bin distribution - contains the documentation, javadoc, and jar files for Derby.
lib distribution - contains only the jar files for Derby.
lib-debug distribution - contains jar files for Derby with source line numbers.
src distribution - contains the Derby source tree at the point which the binaries were built.

-db-derby-10.5.1.1-bin.zip [PGP] [MD5]
-db-derby-10.5.1.1-bin.tar.gz [PGP] [MD5]

-db-derby-10.5.1.1-lib.zip [PGP] [MD5]
-db-derby-10.5.1.1-lib.tar.gz [PGP] [MD5]

-db-derby-10.5.1.1-lib-debug.zip [PGP] [MD5]
-db-derby-10.5.1.1-lib-debug.tar.gz [PGP] [MD5]

-db-derby-10.5.1.1-src.zip [PGP] [MD5]
-db-derby-10.5.1.1-src.tar.gz [PGP] [MD5] (Note that, due to long filenames, you will need gnu tar to unravel this tarball.)

There are two separate Eclipse plugins for Derby:

derby_core_plugin - provides the Derby jar files to other plugins in Eclipse.
derby_ui_plugin - provides an Apache Derby Nature in Eclipse for easy database application development.

-derby_core_plugin_10.5.1.764942.zip [PGP] [MD5]
-derby_ui_doc_plugin_1.1.2.zip [PGP] [MD5]

Please note: both plugins must be installed for full functionality. For information on installing and using the Derby plugins for Eclipse, please see the Using the 10 Core and 1.1 UI Derby plug-ins page.

- -

Release Notes for Derby 10.5.1.1

These notes describe the difference between Derby release 10.5.1.1 and the preceding release 10.4.2.0.

- -

Overview

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

Derby functionality includes:

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

- -

New Features

This is a feature release. The following features were added.

-SQL Roles - SQL roles (as described in SQL 2003 and errata) are useful for administering privileges for groups of users. Administering roles is generally less error-prone than administering privileges for individual users. SQL Roles are defined in Feature T331 "Basic roles" and Feature T332 "Extended roles". Derby 10.5 implements a subset of T331, plus support for CURRENT_ROLE, which is a part of T332.
-Generated Columns - Generated Columns is a feature which instructs Derby to fill a column with an expression built out of other columns in the row. Derby constructs these column values at INSERT and UPDATE time. The user declares indexes on these columns. This in turn improves SELECT performance since it lets users declare indexes on pre-computed pieces of the WHERE clause. This feature satisfies support for SQL Feature T175.
-LOB Improvements - There were many performance and usability improvements for BLOBs and CLOBs.
-Replication of encrypted databases - With 10.5 it is possible to replicate encrypted databases.
-OFFSET/FETCH FIRST - SQL 2008 has added new syntax to support a direct way to limit the returned set of rows in a result set, through the fetch first and offset clauses.
-In-memory back end - Initial implementation of a storage engine for Derby where all data is kept in memory. There is no documentation for this feature. This functionality itself is not yet fully implemented, but users are welcome to experiment with it. For details, see the Primer for In-memory Back Ends.
-Standard ALTER COLUMN syntax - Allow standard SQL "SET" keyword in ALTER COLUMN syntax, like so: "ALTER TABLE ALTER COLUMN columnname SET DEFAULT default-value"
-SYSCS_UTIL.SYSCS_UPDATE_STATISTICS - New system procedure that updates cardinality statistics (or creates them if they do not exist) for a table's index or for all the indexes on a table, allowing a user to ensure that a query plan based on the most recent state of the table can be created.

- -

Bug Fixes

The following issues are addressed by Derby release 10.5.1.1. These issues are not addressed in the preceding 10.4.2.0 release.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - [... 2858 lines stripped ...]

Issue Id	Description
DERBY-4148	NullPointerException in system.sttest run with 10.5.1.0
DERBY-4146	Cannot insert row when a generated column references an identity column
DERBY-4145	NullPointerException on CREATE TABLE when generated column depends on another generated column
DERBY-4141	XAExceptions thrown by Derby can have errorCode 0
DERBY-4135	Failure in BlobClob4BlobTest due to wrong results being returned
DERBY-4128	Failure in ServerPropertiesTest due to java.security.AccessControlException on the server side, in 10.4 to 10.5.1. soft upgrade mode
DERBY-4127	ArrayIndexOutOfBoundsException in DatabaseMetaDataTest when run in Soft Upgrade mode
DERBY-4126	You can't invoke a table function which is stored in a jar file inside the database
DERBY-4125	The in-memory storage back end doesn't work on Windows
DERBY-4122	ClassCastException in SQLClob when running in soft upgrade mode (10.4.2.0 -> 10.5.1.0)
DERBY-4121	Documentation: more UPDATE_STATISTICS fixes needed for Reference Manual and Tuning Derby
DERBY-4119	Compress on a large table fails with IllegalArgumentException - Illegal Capacity
DERBY-4117	dblook script fails when URL contains special characters
DERBY-4116	SYSCS_UTIL.SYSCS_UPDATE_STATISTICS should update the store estimated row count for the table
DERBY-4104	Documentation: update documentation files to 10.5
DERBY-4103	Allow unlimited growth for in-memory conglomerates
DERBY-4096	'testRunTimeStatistics(org.apache.derbyTesting.functionTests.tests.lang.OffsetFetchNextTest)junit.framework.AssertionFailedError' on Windows
DERBY-4095	Trigger fails with ERROR 38000: The exception 'java.sql.SQLException: ResultSet not open during VTIResultSet.getNextRowCore()
DERBY-4094	Enforce absolute paths in the in-memory back end internal storage structure
DERBY-4093	Improve handling of the database temporary directory
DERBY-4088	DDMReader readBytes ArrayIndexOutOfBoundsException
DERBY-4084	Determine the subSubProtocol name for the in-memory back end
DERBY-4079	Add support for SQL:2008 <result offset clause> and <fetch first clause> to limit result set cardinality
DERBY-4078	Document the SQL Standard routine matching rules which Derby now supports
DERBY-4073	Creation/configuration of ClientXDataSource fails because of two setSsl methods
DERBY-4072	shutdown with incorrect permission on log files shows java.lang.NullPointerException at org.apache.derby.impl.store.raw.log.LogToFile.flush(LogToFile.java:3964). Should give bettter message.
DERBY-4071	AssertFailure when selecting rows from a table with CHARACTER and VARCHAR columns
DERBY-4063	Constraint causes wrong query result when using exists
DERBY-4061	InputStream returned from Blob.getBinaryStream(long, long) terminates the stream by returning 0, should return -1
DERBY-4060	Blob.getBinaryStream(long,long) is off by one for the pos+len check
DERBY-4059	If space reclamation cannot obtain container lock it will not retry getting the lock
DERBY-4050	Multithreaded clob update causes growth in table that does not get reclaimed
DERBY-4049	SELECT statement topic in Reference Manual should reflect current WHERE clause behavior
DERBY-4048	Update Statistics code in AlterTableConstantAction should use execute transaction rather than compile transaction
DERBY-4042	org.apache.derby.impl.load.Import needs to escape single quotes
DERBY-4040	SQLChar.getLength returns wrong length for some data values
DERBY-4028	two rows can be inserted with the same value in a column that a unique constraint on that column should prevent
DERBY-4027	An attempt was made to access an out of range slot on a page
DERBY-4025	CHAR data type documentation fails to describe the maximum allowed length
DERBY-4024	Replace felix.jar file with the felix sources
DERBY-4022	Remove dependency of junit targets on deprecated jdk16 variable
DERBY-4017	Removed deprecated jdk16 variable from the machinery which builds javadoc
DERBY-4016	Document syntax change for ALTER TABLE in Reference Manual
DERBY-4014	Update Derby Jira Report XML VTI to access more fields
DERBY-4013	Allow standard SQL syntax: ALTER TABLE ALTER COLUMN <col> SET DEFAULT <default>
DERBY-4012	'largedata/LobLimits.java' fails with "EXPECTED SQL Exception: (XJ001) Java exception: 'A truncation error was encountered trying to shrink CLOB 'XXXX' to length 104857600.: org.apache.derby.iapi.services.io.DerbyIOException'."
DERBY-4010	PassThroughException should not reimplement initCause()/getCause()
DERBY-4008	Only send RDBNAM on ACCSEC if EBCDIC conversion is possible
DERBY-4006	ALTER COLUMN ... WITH DEFAULT NULL does not change the default
DERBY-4004	Remove required RDBNAM from ACCSEC. Use SECCHK RDBNAM if none is provided on ACCSEC
DERBY-3997	ORDER BY causes column to be returned
DERBY-3996	Change eol style to native on jsr169 stubs
DERBY-3990	ResultSetStreamTest fails on case sensitive file systems, and isn't run as part of any suite
DERBY-3989	Set the Java 5 compilation path based on the Java 6 compilation path if a Java 5 environment can't be found but a Java 6 environment can be
DERBY-3988	Set the Java 6 complilation path based on the Java 5 compilation path so that the JDBC4 support is always built
DERBY-3985	Replace BUILDING.txt with a simlified up-to-date BUILDING.html
DERBY-3984	Separate out the small number of build targets which really require JDK1.4 features from the bulk of the targets which ought to compile cleanly against small device libraries
DERBY-3983	User Guide documentation on the limitations of small-device support is stale
DERBY-3982	Add a facility to override the default set of old versions to be tested in the upgrade tests.
DERBY-3981	Improve distribution of hash codes in SQLBinary and SQLChar
DERBY-3978	Clob.truncate(long) in the client driver doesn't update the cached Clob length
DERBY-3977	Clob.truncate with a value greater than the Clob length raises different exceptions in embedded and client driver
DERBY-3975	SELECT DISTINCT may return duplicates with territory-based collation
DERBY-3972	Update test harness to run with DesktopEE JRE
DERBY-3970	PositionedStoreStream doesn't initialize itself properly
DERBY-3969	NPE if you declare a constraint on a generated column and omit the datatype
DERBY-3966	Do not require JRE 1.4 libraries at compile time since SUN's JDK 1.4 went out of support and can be used on JRE 1.4 without any problem
DERBY-3964	NullPointerException when re-evaluating generated column during ON DELETE SET NULL referential action
DERBY-3959	Reference Manual needs information on generated columns
DERBY-3958	ImportExportProcedures imports ./testData/ImportExport/position_info.del using US-ASCII but the file contains non-ascii characters
DERBY-3956	Remove method TemplateRow.checkPartialColumnTypes
DERBY-3950	You should get an error if you try to override a generated column via an INSERT driven by an inner ResultSet
DERBY-3948	Don't allow references to generated columns in the NEW transition variables of triggered actions of BEFORE triggers
DERBY-3945	Generation clauses which mention user-coded functions may produce different resuls depending on who performs the triggering INSERT/UPDATE
DERBY-3943	testReplication_Local_3_p2_StateTests_smallInsert_immediateStopMaster_DISABLED() causes hang in teardown()
DERBY-3938	Document that you can change the length of varbinary as well as varchar columns
DERBY-3936	Add CharacterStreamDescriptor
DERBY-3935	Introduce interface for a position aware stream
DERBY-3934	Improve performance of reading modified Clobs
DERBY-3932	Add tests of generated columns when sql authorization is turned on
DERBY-3931	GeneratedColumnsTest fails with "'F_MINUS' is not recognized as a function or procedure." on cvm/phoneME
DERBY-3930	SQL roles: Add VTI for CONTAINED_ROLES
DERBY-3923	Make the datatype optional when declaring columns with generation clauses
DERBY-3922	Enable the adding of generated columns via ALTER TABLE
DERBY-3917	RolesConferredPrivilegesTest fails with 'java.lang.NoClassDefFoundError: java.sql.DriverManager' with weme 6.1
DERBY-3911	BTreeController.reclaim_deleted_rows() may hide exceptions
DERBY-3909	Race condition in NetXAResource.removeXaresFromSameRMchain()
DERBY-3907	Save useful length information for Clobs in store
DERBY-3905	Failed tests should save the database off to the fail directory
DERBY-3904	NPE on left join with aggregate
DERBY-3903	'The class 'org.apache.derby.diag.EnabledRoles' does not exist or is inaccessible.' in new roles tests (DERBY-3886)
DERBY-3902	some messages are referenced but never used - MessageBundleTest output
DERBY-3901	SQL roles: Move upgrade logic from 10.4 to 10.5
DERBY-3897	SQLSessionContext not correctly initialized in some non-method call nested contexts
DERBY-3895	Needs update of master for 'derbyall/derbynetmats/DerbyNet/derbynetmats/holdCursorJDBC30'?
DERBY-3894	Reference Manual: supported functions should be listed in JDBC escape syntax topic
DERBY-3890	Replication: NPE for startSlave of encrypted database
DERBY-3889	LOBStreamControl.truncate() doesn't delete temporary files
DERBY-3886	SQL roles: ij show enabled and settable roles
DERBY-3883	LOBStreamControl.replaceBytes() leaves temporary files open
DERBY-3880	NPE on a query with having clause involving a join
DERBY-3879	Getting Started Guide has typo and version problems
DERBY-3878	Replication: stopSlave does not close serversocket when master has crashed.
DERBY-3877	SQL roles: build support for dblook
DERBY-3875	Derby cannot replace a database after encountering corruption
DERBY-3874	Document numeric function ATAN2(float1,float2)
DERBY-3872	NullPoinerException thrown when INTEGER function used as a predicate in a WHERE clause of a SELECT .. GROUP BY .. HAVING statement
DERBY-3871	EmbedBlob.setBytes returns incorrect insertion count
DERBY-3869	intermittent hang pinging server on Linux
DERBY-3865	NPE in testSemantics(.....lang.RolesTest) on JavaME / CVM
DERBY-3864	Remove utility class PrivilegedFileOps
DERBY-3863	improve test importExportIJ.sql
DERBY-3859	Reset the current role when EmbedPooledConnection creates a new logical connection
DERBY-3855	The Tuning guide should mention that LIKE transformations/optimizations are disabled when using territory-based collations
DERBY-3850	Remove unneeded workarounds for DERBY-177 and DERBY-3693
DERBY-3847	Tuning Guide lacks information on turning off Derby property settings
DERBY-3845	Problems running org.apache.derbyTesting.system.optimizer.RunOptimizerTest
DERBY-3841	'testTimeSlice_*(NetworkServerControlApiTest.java)' fails on Jvm1.5/vista, Jvm1.4/SunOS 5.11
DERBY-3840	The test code executes java processes by just executing java instead of using a full path. This may cause the wrong java to be picked up.
DERBY-3837	need to test getting appropriate error message when os files are read-only
DERBY-3835	Convert derbynet/getCurrentProperties to JUnit
DERBY-3832	Convert derbynet/timeslice.java to Junit
DERBY-3831	RuntimeStatisticsParser can not distinguish names of table or index well and truly
DERBY-3828	Convert jdbcapi/SURTest_ij.sql to JUnit.
DERBY-3827	Add Apache 2.0 license headers to a number of files
DERBY-3826	Remove the update-with-jdbc4 script, which is dead code now
DERBY-3825	StoreStreamClob.getReader(charPos) performs poorly
DERBY-3818	client Insert/retrieval of 18MB Clob is extremely slow in MultiByteClobTest
DERBY-3816	Administration Guide topics on unsupported DB2 driver should be removed
DERBY-3813	Derby tests for the existance of BigDecimal methods toPlainString and bdPrecison but does not check if they were found before using them.
DERBY-3812	failure in testAttributeDrdaStreamOutBufferSize(org.apache.derbyTesting.functionTests.tests.management.NetworkServerMBeanTest)junit.framework.AssertionFailedError: expected:<0> but was:<131072>
DERBY-3810	Create a simple Clob performance regression test
DERBY-3807	traces of removed ij functionality of ij.unicodeEscape should be removed
DERBY-3805	Create a simple Blob performance regression test
DERBY-3803	'org.apache.derbyTesting.functionTests.tests.lang.XMLTypeAndOpsTest' failures on JVM 1.5 on trunk, 10.4 and 10.3
DERBY-3802	Convert "org.apache.derbyTesting.functionTests.tests.lang.optimizerOverrides.sql" to junit.
DERBY-3800	Convert derbynet/maxthreads to JUnit
DERBY-3799	NullPointerException when accessing a clob through a pooled connection
DERBY-3798	Remove unnecessary call to Hashtable.get() in TableScanResultSet.getNextRowCore()
DERBY-3797	Convert jdbcapi/metadataMultiConn to JUnit.
DERBY-3796	Convert derbynet/OutBufferedStream to JUnit
DERBY-3793	Remove unnecessary methods from InternalClob interface
DERBY-3791	Excessive memory usage when fetching small Clobs
DERBY-3787	Document the new system stored procedure SYSCS_UTIL.SYSCS_UPDATE_STATISTICS which was added as part of DERBY-269
DERBY-3786	Assert failure in CacheEntry.unkeepForRemove when running stress.multi
DERBY-3784	ImportExportTest doesn't detect lack of expected errors
DERBY-3783	LOBStreamControl shouldn't throw SQLException
DERBY-3782	Client Configuration.java imports engine class org.apache.derby.iapi.services.info.JVMInfo
DERBY-3781	PositionedStoreStream.reposition(pos) with pos greater than length leaves the stream object in an inconsistent state
DERBY-3780	Run junit tests with -Dfile.encoding="UTF-16" to expose encoding issues and analyze failures
DERBY-3779	Add client side JDBC statement pool documentation
DERBY-3777	SecureServerTest, SSLTest are failed on Zos with exit code 143 starting network server
DERBY-3776	testGetBytes under BlobClob4BlobTest failed on Zos with encoding issue
DERBY-3775	BlobStoredProcedureTest failed on Zos: AssertionFailedError: Error SYSIBM.BLOBGETPOSITIONFROMLOCATOR returns the wrong value for the position of the Blob expected:<8> but was:<-1>
DERBY-3774	jdbc4/ClobTest fails on Zos with AssertionFailedError: Streams differ at index 0 expected:<200> but was:<72>
DERBY-3773	ImportExportLobTest failed on Zos Clobs differ at index 1 expected:<99> but was:<196>
DERBY-3771	testClasspathChecker under SysinfoCPCheckTest failed on Zos
DERBY-3770	Create a utility class for skipping data in an InputStream
DERBY-3769	Make LOBStoredProcedure on the server side smarter about the read buffer size
DERBY-3768	Make EmbedBlob.length use skip instead of read
DERBY-3767	Convert "org.apache.derbyTesting.functionTests.tests.lang.nulls.sql" to junit.
DERBY-3766	EmbedBlob.setPosition is highly ineffective for streams
DERBY-3764	Union Query fail on Derby 10.4.1.3
DERBY-3763	Rename BaseJDBCTestCase.usingDerbyNet
DERBY-3762	Convert "org.apache.derbyTesting.functionTests.tests.lang.arithmetic.sql" to junit.
DERBY-3760	Convert "org.apache.derbyTesting.functionTests.tests.lang.miscerrors.sql" to junit.
DERBY-3759	Convert "org.apache.derbyTesting.functionTests.tests.lang.ungroupedAggregatesNegative.sql" to junit.
DERBY-3758	Convert "org.apache.derbyTesting.functionTests.tests.lang.precedence.sql" to junit
DERBY-3755	ij's help text lacks the optional HOLD \| NOHOLD syntax for GET CURSOR
DERBY-3754	Convert "org.apache.derbyTesting.functionTests.tests.lang.connect.sql" to junit
DERBY-3751	Convert case.sql to junit
DERBY-3750	Convert "org.apache.derbyTesting.functionTests.tests.lang.constant Expression.sql" to junit
DERBY-3745	Derby can leak classloaders in an app server environment
DERBY-3743	Revoking EXECUTE privilege on a function if used in a CHECK constraint: implementation problem
DERBY-3742	Move test code from CompressedNumber to a unit test
DERBY-3741	SQL LENGTH function materializes CLOB into memory
DERBY-3739	Skip and read methods in ArrayInputStream may overflow
DERBY-3738	Add more tests for legal/illegal commands in the different replication states
DERBY-3736	Revoking a column level privilege from a user, a prepared statement relying on that privilege can still be executed
DERBY-3735	Incorrect position calculation in PositionedStoreStream with read(bytearray,...)
DERBY-3734	Maximum value allowed for derby.storage.fileCacheSize (100) is too low for large system. Increase the maximum value and redocument the property.
DERBY-3732	SQL Length function materializes BLOB into memory
DERBY-3731	Improve calculation of refSize in ClassSize.java
DERBY-3730	Bundle-SymbolicName: needed in Derby manifest for OSGi 4 environment
DERBY-3728	Fix error handling in PrivilegedFileOpsForTests
DERBY-3726	Don't call RAFContainer.padFile() from instances of RAFContainer4
DERBY-3725	add more information to the XSDB1:ERROR XSDB1: Unknown page format at page error
DERBY-3723	Reset current schema to default (user name) when creating a new logical connection in the client driver
DERBY-3722	Add circularity check for the GRANT role statement
DERBY-3718	NPE when firing a trigger
DERBY-3717	convert derbynet/getCurrentProperties.java to junit
DERBY-3715	java/testing/README.htm refers to a non-existing test
DERBY-3711	convert store/aes.sql to junit test & add unrestricted test cases.
DERBY-3708	setting tracedirectory from the command line does not work
DERBY-3707	STATUS file changes June 2008
DERBY-3706	NetworkServer console messages should print a time stamp
DERBY-3705	In Net Client mode, negative values for stream length are accepted without an exception for PreparedStatement.setAsciiStream()
DERBY-3704	If an IOException is encountered during establishment of the connection, Network Server should print the root exception to the console instead of a generic message
DERBY-3703	Make it possible to build the JSR169 support with the jdk1.4 libraries
DERBY-3702	Remove xml-apis.jar because we no longer have to compile against jdk1.3
DERBY-3701	java.lang.Exception: DRDA_UnableToAccept.S:Unable to accept connections and client hang if tracing is turned on but traceDirectory does not exist
DERBY-3700	Get rid of tools/java/empty.jar
DERBY-3696	Delete superfluous test lang/longStringColumn.java
DERBY-3695	NullPointerException when invoking statement event listeners if one of the listeners is null
DERBY-3694	'Method resolution for signature java.lang.String.valueOf(int) was ambiguous. (No single maximally specific method.)' in 'testFunctionNullHandling(org.apache.derbyTesting.functionTests.tests.lang.RoutineTest)' on JavaME
DERBY-3693	Deadlocks accessing DB metadata
DERBY-3692	'javax.transaction.xa.XAException' ++ in 'J2EEDataSourceTest'
DERBY-3690	EmbedPooledConnection doesn't reset schema when creating a new logical connection
DERBY-3686	convert predicatePushdown.sql to JUnit
DERBY-3685	weme 6.1 Base connection pooling suitejunit.framework.AssertionFailedError: java.lang.NullPointerException
DERBY-3684	Wire the vti demo into the build.
DERBY-3682	SYSCS_BULK_INSERT doesn't quote identifiers or strings properly
DERBY-3681	When authenticating a user at connect time, verify that the user provided is not also a defined role name.
DERBY-3678	StackOverflowException in deadlock trace
DERBY-3674	'ALTER TABLE' is not allowed on the System table '"SYSCS_DIAG"."TRANSACTION_TABLE"' in derbyall - store/TransactionTable.sql
DERBY-3673	Add checks that a new role isn't already a user authorization id
DERBY-3668	Remove JDBC 3.0-specific topics from Reference Manual and merge implementation notes as needed
DERBY-3667	SQL roles: Make CURRENT_ROLE check that the role is still valid
DERBY-3666	Make role descriptor a dependency Provider
DERBY-3665	Master file for derbynet/testProperties.java needs update for 10.3.2.2 to 10.3.3.0 version change.
DERBY-3663	Convert store/streamingColumn to JUnit
DERBY-3661	Typo yields redundant test case in GrantRevokeTest
DERBY-3659	revive tests with ldap references to be runnable as junit tests
DERBY-3658	LOBStateTracker should not use SYSIBM.CLOBRELEASELOCATOR when the database is soft-upgraded from 10.2
DERBY-3657	Comment in template security policy incorrectly says that JMX is not enabled by default
DERBY-3655	errror in nightly regression test: LobStreamsTest:encryptedjunit.framework.AssertionFailedError: f:\jartest\JarResults.2008-04-29\ibm16_suites.All\system\singleUse\oneuse1e\tmp\lob6165.tmp
DERBY-3653	Convert datetime.sql to JUnit
DERBY-3652	Derby does not follow the SQL Standard when trying to map SQL routines to Java methods.
DERBY-3649	can't call a stored function with an aggregate argument without getting the following error: ERROR 42Y29
DERBY-3642	Update and rectify the Derby tutorial
DERBY-3640	Add an example for table function in Derby Reference Manual
DERBY-3638	java/testing/Readme.htm location of derbyTesting.jar
DERBY-3633	tools/derbyrunjartest.java fails with 'No command given.' (expecting 'No arguments given.')
DERBY-3631	UDF used with aggregate arguments results in error 30000
DERBY-3629	Tools Guide should document continuation marker for ij
DERBY-3625	XSDA3 error in concateTests in lang.LangHarnessJavaTest caused by bug in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE()
DERBY-3623	Convert deadlockMode.java to JUnit
DERBY-3622	SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE needs a better description in the reference manual
DERBY-3619	Implement more load types for org.apache.derbyTesting.perf.clients.Runner
DERBY-3618	Perform thread dump with ASSERTS with jdk 1.5 or higher
DERBY-3615	Making the instructions more clear in documentation(BUILDING.txt) regarding setting JRE lib path for a Windows system
DERBY-3613	SELECT DISTINCT field FROM TABLE_NAME GROUP BY field, field2
DERBY-3612	Developer's Guide needs correction on garbage collection
DERBY-3602	If derbytesting.jar is in a different directory than the derby jars SystemPrivilegesPermissionTest fails with java.security.AccessControlException
DERBY-3601	Optimize LOBStateTracker for non-locator servers
DERBY-3597	Incorporate DERBY-3310 and DERBY-3494 write-ups into NormalizeResultSetNode javadoc
DERBY-3596	Creation of logical connections from a pooled connection causes resource leak on the server
DERBY-3589	AllocPage.createPage() doesn't initialize minimumRecordSize correctly
DERBY-3588	suites.All fails to run on Jvm 1.5 when built with JDK 1.5 (Failed to invoke suite(): .jdbc4._Suite)
DERBY-3587	Convert jdbcapi/testRelative.java to JUnit
DERBY-3586	Remove am.Connection.reset(LogWriter,ClientBaseDataSource,boolean) and called methods
DERBY-3584	Replication tests shall not be run on Java ME
DERBY-3582	IndexOutOfBoundsError in ClockPolicy.moveHand
DERBY-3581	Changing certain properties on client DataSource objects causes existing connections to reflect the new values
DERBY-3580	Remove unused method Connection.resetConnection(LogWriter, String, Properties)
DERBY-3579	The Developer's Guide incorrectly describes the behavior of transactions inside procedures and functions
DERBY-3578	DrdaStreamOutBufferSize attribute of NetworkServerMBean should be of type int instead of String
DERBY-3576	Merge EngineBlob and EngineClob into a single interface
DERBY-3574	With client, attempting to get the lob length after commit or connection close if there was a call to length() before commit does not throw an exception
DERBY-3572	directory error in the file "java/testing/README.htm"
DERBY-3571	LOB locators are not released if the LOB columns are not accessed by the client
DERBY-3570	Implement DETERMINISTIC keyword for procedures and functions
DERBY-3568	Convert jdbcapi/savepointJdbc30_JSR169.java and jdbcapi/savepointJdbc30_XA.java to JUnit
DERBY-3567	AsynchronousLogShipper#forceFlush should time out
DERBY-3566	Alter column set data type not allowed in soft upgrade with unique constraint
DERBY-3562	Number of log files (and log dir size) on the slave increases continuously
DERBY-3561	testStartStopManagementFromApplication(org.apache.derbyTesting.functionTests.tests.management.ManagementMBeanTest)junit.framework.AssertionFailedError: expected:<2> but was:<5>
DERBY-3558	regression test failure in testDerbyJarAttributeAlpha - Security Exception
DERBY-3556	change derby.tests.trace property to print the name of the test before it runs it
DERBY-3554	Change Collation test to run DatabaseMetaDataTest, BatchUpdateTest,GroupByExpressionTest, and UpdateableResultSetTest for only one locale
DERBY-3551	Implement procedure SYSCS_UTIL.SYSCS_PREPARE_REPLICATION()
DERBY-3549	Unable to start slave mode after authentication failure on a previous startSlave attempt
DERBY-3548	NoClassDefFoundError failure in SystemPrivilegesPermissionTest for weme6.1
DERBY-3546	Failed to get database schemas of a JAR database
DERBY-3544	If NetworkServer fails to shutdown when run as a separate process by NetworkServerTestSetup, test run will hang
DERBY-3543	NetworkServerControl with options but no command does not give usage message
DERBY-3538	NullPointerException during execution for query with LEFT OUTER JOIN whose inner table selects all constants.
DERBY-3531	DatabasePermission uses a JDK 1.4 method that is not present in J2ME/CDC/Foundation.
DERBY-3527	The slave will not notice that a network cable is unplugged and will therefore reject failover/stopSlave commands
DERBY-3526	AsynchronousLogShipper#workToDo is blocked while the log shipper sends a log chunk
DERBY-3525	Remove unneeded code to get JDBC level in BrokeredConnection and BrokeredStatement classes
DERBY-3521	Functionality for skipping testsuites on certain platforms fails for the new management testsuite on phoneME advanced
DERBY-3520	convert views.sql to junit
DERBY-3515	23 timeouts encountered while running management junit suite as part of full nightly runs.
DERBY-3509	The replication log shipper is not notified when a new replication transmitter is instantiated in MC#handleException.
DERBY-3508	Log receiver thread fails with NPE at failover when master has died
DERBY-3506	Add JMX testing with a security manager and investigate testing with JMX authentication.
DERBY-3503	Change stress.multi to dump thread stacks before killing off testers with jdk 1.5 and higher
DERBY-3494	Move the setup of NormalizeResultSetNode into the NormalizeResultSetNode
DERBY-3489	Error message XRE04 does not include the right port number.
DERBY-3469	Clob.length() doesn't detect a closed underlying connection in a consistent way
DERBY-3462	Require new permissions in o.a.d.security.SystemPermission to allow control to Derby's JMX management and to ensure information is not leaked through JMX
DERBY-3447	Shutdown on a database without stopping replication hangs
DERBY-3446	Make ResultSet.getStatement return the correct statement when created by a logical statement
DERBY-3431	DatabaseMetaData.getConnection returns the wrong connection when using connection pooling
DERBY-3420	The -ca option should be removed from ij and from the ij command usage line
DERBY-3409	Remove JDBC 2.0-specific topics from Reference Manual and merge implementation notes as needed
DERBY-3408	Wrong message when using SHOW in ij.
DERBY-3401	Removing a ConnectionEventListener from a PooledConnection during its connectionClosed() callback causes other ConnectionEventListener callbacks to be missed
DERBY-3397	Derby 10.3.1.4 and 10.3.2.1 break scrollable result sets? Hibernate Query.setFirstResult and/or setMaxResults
DERBY-3390	SQLException thrown from user function kills network connection
DERBY-3385	Tests for JMX Management and Monitoring
DERBY-3381	"ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page...." in suites.All
DERBY-3379	"No Current connection" on PooledConnection.getConnection() if pooled connection is reused during connectionClosed processing
DERBY-3373	SQL "distinct" and "order by" needed together
DERBY-3360	Invalid method java.lang.Integer >> void <init>(short) because java.lang.NoSuchMethodException: java.lang.Integer.<init>(short)
DERBY-3354	Select from large lob table with embedded gives OutOfMemoryError
DERBY-3347	ERROR XSDB3: Container information cannot change once written
DERBY-3338	CancelQueryTask.forgetContext() could be simplified.
DERBY-3327	SQL roles: Implement authorization stack (and SQL session context to hold it)
DERBY-3320	Database creation and boot should fail if collation=TERRITORY_BASED and the selected locale is not supported
DERBY-3319	Logical connections do not check if a transaction is active on close
DERBY-3310	ASSERT in MergeSort.checkColumnTypes() disallow legal type conversions
DERBY-3307	NPE in PooledConnction event notification handling if a null listener is added
DERBY-3270	Delayed (on-demand) creation of current user schema makes select from view belonging to other schema fail.
DERBY-3266	Not possible for non-db-owner to create a temporary table. "Get ERROR 42507: User 'USERB' can not perform the operation in schema 'SESSION'."
DERBY-3227	Remove final from all getConnection() methods in EmbeddedDataSource
DERBY-3223	SQL roles: make use of privileges granted to roles in actual privilege checking