1 Reply Latest reply on Jan 13, 2007 4:54 AM by jeya.louis

    What is the table structure for booking table in JBOSS booki

    jeya.louis

      I am trying to run the Booking example for Hibernate. I am able to register new user, But when i login i am getting an error message like "BOOKING0_"."USER_USERNAME": invalid identifier". I feel the relationship between the User table & booking is not correct.

      need some help for this.

        • 1. Re: What is the table structure for booking table in JBOSS b
          jeya.louis

          Problem solved, The table structure is

          CREATE TABLE BOOKING
          (
          ID INTEGER NOT NULL,
          USER_USERNAME VARCHAR2(255 BYTE),
          HOTEL_ID INTEGER NOT NULL,
          CHECKINDATE DATE,
          CHECKOUTDATE DATE,
          CREDITCARD VARCHAR2(255 BYTE) NOT NULL,
          CREDITCARDNAME VARCHAR2(255 BYTE) NOT NULL,
          CREDITCARDEXPIRYMONTH NUMBER,
          CREDITCARDEXPIRYYEAR NUMBER,
          SMOKING CHAR(1 BYTE),
          BEDS INTEGER
          )