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

          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: