Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-651

Re-enable the storing of java objects in the database

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 10.6.1.0
    • SQL
    • None
    • Patch Available

    Description

      Islay Symonette, in an email thread called "Storing Java Objects in a table" on October 26, 2005 requests the ability to store java objects in the database.

      Old releases of Cloudscape allow users to declare a column's type to be a Serializable class. This feature was removed from Derby because the syntax was non-standard. However, most of the machinery to support objects serialized to columns is still in Derby and is even used in system tables. We need to agree on some standard syntax here and re-expose this useful feature. Some subset of the ANSI adt syntax, cumbersome as it is, would do.

      Attachments

        1. UserDefinedTypes.html
          43 kB
          Richard N. Hillegas
        2. UserDefinedTypes.html
          47 kB
          Richard N. Hillegas
        3. UserDefinedTypes.html
          53 kB
          Richard N. Hillegas
        4. UserDefinedTypes.html
          52 kB
          Richard N. Hillegas
        5. UserDefinedTypes.html
          53 kB
          Richard N. Hillegas
        6. derby-651-15-aa-testSQLData.diff
          6 kB
          Richard N. Hillegas
        7. derby-651-14-aa-testBigUDTs.diff
          14 kB
          Richard N. Hillegas
        8. derby-651-13-aa-tableFunctionColumns.diff
          10 kB
          Richard N. Hillegas
        9. derby-651-12-ab-metadata.diff
          15 kB
          Richard N. Hillegas
        10. derby-651-11-aa-dropSchema.diff
          6 kB
          Richard N. Hillegas
        11. derby-651-10-aa-usageTriggers.diff
          15 kB
          Richard N. Hillegas
        12. derby-651-09-ac-usagePrivilege.diff
          88 kB
          Richard N. Hillegas
        13. derby-651-08-aa-dependencyRoutines.diff
          20 kB
          Richard N. Hillegas
        14. derby-651-07-aa-dependencyView.diff
          6 kB
          Richard N. Hillegas
        15. derby-651-06-aa-dropTable.diff
          7 kB
          Richard N. Hillegas
        16. derby-651-05-ac-dependencyTable.diff
          31 kB
          Richard N. Hillegas
        17. derby-651-04-aa-javadoc.diff
          4 kB
          Richard N. Hillegas
        18. derby-651-03-aa-udttestInstability.diff
          2 kB
          Richard N. Hillegas
        19. derby-651-02-af-udtColumnsRetvalsParams.diff
          43 kB
          Richard N. Hillegas
        20. derby-651-01-aa-basicCreateDropType.diff
          25 kB
          Richard N. Hillegas

        Issue Links

          incorporates

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4469 Fix the CASTing behavior of UDTs

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4470 Forbid ordering operations on UDTs

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4499 Compiler error when preparing a procedure call with an output parameter of user defined type.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4484 Add import/export support for UDTs.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-4485 Add dblook support for UDTs.

          • Major - Major loss of function.
          • Closed
          is depended upon by

          Task - A task that needs to be done. DERBY-4572 Documentation needed for user-defined types

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4491 The network client changes UDTs into Strings and returns their type as LONGVARBINARY.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4580 Cannot use dblook on soft-upgraded database: Table/View 'SYS.SYSSEQUENCES' does not exist.

          • Major - Major loss of function.
          • Closed

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: