Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.9.3, 1.0
    • Fix Version/s: 1.0
    • Component/s: Analysis, Database
    • Labels:
      None
    • Similar issues:
      KULRICE-1191Implement a new DB development and management process
      KULRICE-11529Consolidate and simplify ID generation logic
      KULRICE-2434Clean up the old bootstrap DDL and scripts
      KULRICE-5323Dataset Consolidation
      KULRICE-8611validate, consolidate, and test DB upgrade scripts
      KULRICE-6321Database script consolidation for release
      KULRICE-2027Get Rice working with MySQL and provide DDL and bootstrapping data
      KULRICE-8424Consolidate database scripts for release
      KULRICE-276consolidate rice web content under common root or other permanent solution
      KULRICE-1031Consolidate and document ServiceLocators and ResourceLoaders
    • Rice Module:
      Rice Core

      Description

      Determine the appropriate toolset for bootstrapping Rice applications with both startup DDL and startup data. KFS currently uses Torque but this only works for data and a fresh schema (which is generated from a base Oracle KFS install). Hibernate, which would be an obvious choice since it is the leading JPA candidate, can generate DDL from JPA annotation but I'm not sure about default data loading. It would be great to consolidate down to one tool.

        Issue Links

          Activity

          Hide
          Nate Johnson (Inactive) added a comment -

          One of Chi's tasks is to look in to the KFS approach. For now, I've use Hibernate to generate DDL for MySQL combined with the "fake" sequences and the old bootstrap data that we used in Oracle, converted to MySQL where needed. This is definitely not the best approach, but there is something for MySQL users to start with until we determine the best solution. Also, I believe it was decided that we would most likely not use JPA/Hibernate schema generation in the future. Moving this to 0.9.4.

          Show
          Nate Johnson (Inactive) added a comment - One of Chi's tasks is to look in to the KFS approach. For now, I've use Hibernate to generate DDL for MySQL combined with the "fake" sequences and the old bootstrap data that we used in Oracle, converted to MySQL where needed. This is definitely not the best approach, but there is something for MySQL users to start with until we determine the best solution. Also, I believe it was decided that we would most likely not use JPA/Hibernate schema generation in the future. Moving this to 0.9.4.
          Hide
          Nate Johnson (Inactive) added a comment -

          Moving to 0.9.4 since we have a temporary solution for Oracle and MySQL for Rice.

          https://test.kuali.org/confluence/x/LYD_AQ

          Show
          Nate Johnson (Inactive) added a comment - Moving to 0.9.4 since we have a temporary solution for Oracle and MySQL for Rice. https://test.kuali.org/confluence/x/LYD_AQ
          Hide
          Ailish Byrne added a comment -

          just to make sure it's clear, both kfs and kra are using the db import/export tool

          Show
          Ailish Byrne added a comment - just to make sure it's clear, both kfs and kra are using the db import/export tool
          Hide
          Nate Johnson (Inactive) added a comment -

          Thanks. We plan on getting there, just haven't had the time yet.

          Show
          Nate Johnson (Inactive) added a comment - Thanks. We plan on getting there, just haven't had the time yet.
          Hide
          Ken Geis added a comment -

          Take a look at LiquiBase.

          "LiquiBase is an open source (LGPL), database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control."

          http://www.liquibase.org/
          http://en.wikipedia.org/wiki/LiquiBase

          Show
          Ken Geis added a comment - Take a look at LiquiBase. "LiquiBase is an open source (LGPL), database-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control." http://www.liquibase.org/ http://en.wikipedia.org/wiki/LiquiBase
          Hide
          Eric Westfall added a comment -

          we are using the impex tool now. Resolving this issue.

          Show
          Eric Westfall added a comment - we are using the impex tool now. Resolving this issue.
          Hide
          Eric Westfall added a comment -

          Bulk change of all Rice 1.0 issues to closed after public release.

          Show
          Eric Westfall added a comment - Bulk change of all Rice 1.0 issues to closed after public release.

            People

            • Assignee:
              Eric Westfall
              Reporter:
              Nate Johnson (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel