glassfish
  1. glassfish
  2. GLASSFISH-8859

tutorial.sql and delete.sql are not complete

    Details

    • Issuezilla Id:
      8,859

      Description

      As stated in my post I couldn't create the example db using "ant create-tables".
      The server logs the following:
      table/view 'EJB_ORDER_SEQUENCE_GENERATOR' does not exist

      Looking at the tutorial.sql I see there is an insert but no create statement for
      the table. Comparing this file with the file from the JEE 5 tutorial I can also
      see there are much more sql statements missing.

      In the first place I tried to remove the insert statement and the creation
      works. But trying to get the bookstore1 example running I ran into another
      problem with this server.log:

      Table/View 'WEB_BOOKSTORE_BOOKS' does not exist.

      So what I did is as described here:
      http://forums.java.net/jive/message.jspa?messageID=357337#357337

      I replace the whole tutorial.sql and delete.sql using the JEE5 files. And
      re-created the example db again. After that the bookstore1 example is working.

      HTH Tai Truong

        Activity

        Hide
        Paul Davies added a comment -

        Reassigned to user jendrock.

        Show
        Paul Davies added a comment - Reassigned to user jendrock.
        Hide
        jendrock added a comment -

        Reassigned to Ian Evans.

        Show
        jendrock added a comment - Reassigned to Ian Evans.
        Hide
        Ian Evans added a comment -

        Should be fixed in update to Java EE 6 Tutorial in v3 Preview update center.

        Show
        Ian Evans added a comment - Should be fixed in update to Java EE 6 Tutorial in v3 Preview update center.

          People

          • Assignee:
            Ian Evans
            Reporter:
            taitruong
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: