light
  1. light
  2. LIGHT-23

DB tables creation script error.

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: current
    • Fix Version/s: milestone 1
    • Component/s: www
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

    • Issuezilla Id:
      23

      Description

      Hello,

      I have tried to deploy the last (1.41) portal version on Tomcat 6 and it worked
      fine with the default portal database configuration (hsqldb).
      I have changed the portal configuration to work with Oracle (10) database
      instead of the default one, but when the Tomcat starts I see some errors and
      portal cannot be accessed. Some tables created, I see it under the schema on the
      Oracle DB server, but something goes wrong. Can you see what's wrong from the log?

      Regards,
      Yuri

      alter table light_portlet_preferences drop constraint FKD2B1F8A893A9792
      drop table light_bookmark if exists
      drop table light_note if exists
      drop table light_note_ref if exists
      drop table light_portal if exists
      drop table light_portal_tab if exists
      drop table light_portlet if exists
      drop table light_portlet_preferences if exists
      drop table light_portlet_ref if exists
      drop table light_role if exists
      drop table light_todo if exists
      drop table light_user if exists
      drop table light_user_role if exists
      create table light_bookmark (
      ID integer not null,
      name varchar(255),
      url varchar(255),
      tagId varchar(255),
      tagName varchar(255),
      bookmarkDesc longvarchar,
      userId varchar(255),
      primary key (ID)
      )
      2008-03-20 16:21:48,310 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] -
      <Unsuccessful: create table light_bookmark (ID integer not null, name
      varchar(255), url varchar(255), tagId varchar(255), tagName varchar(255),
      bookmarkDesc longvarchar, userId varchar(255), primary key (ID))>
      2008-03-20 16:21:48,310 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] -
      <ORA-00902: invalid datatype
      >
      create table light_note (
      user_id varchar(255) not null,
      color varchar(255),
      bgColor varchar(255),
      content longvarchar,
      width varchar(255),
      height varchar(255),
      primary key (user_id)
      )
      2008-03-20 16:21:48,311 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] -
      <Unsuccessful: create table light_note (user_id varchar(255) not null, color
      varchar(255), bgColor varchar(255), content longvarchar, width varchar(255),
      height varchar(255), primary key (user_id))>
      2008-03-20 16:21:48,311 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] -
      <ORA-00902: invalid datatype
      >
      create table light_note_ref (
      ID integer not null,
      color varchar(255),
      bgColor varchar(255),
      content longvarchar,
      width varchar(255),
      height varchar(255),
      primary key (ID)
      )
      2008-03-20 16:21:48,313 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] -
      <Unsuccessful: create table light_note_ref (ID integer not null, color
      varchar(255), bgColor varchar(255), content longvarchar, width varchar(255),
      height varchar(255), primary key (ID))>
      2008-03-20 16:21:48,313 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] -
      <ORA-00902: invalid datatype
      >
      create table light_portal (
      USER_ID varchar(255) not null,
      title varchar(255),
      theme varchar(255),
      locale varchar(255),
      bgImage varchar(255),
      headerImage varchar(255),
      showLocaleBar integer,
      headerHeight integer,
      fontSize integer,
      count integer,
      createDate date,
      primary key (USER_ID)
      )
      create table light_portal_tab (
      ID integer not null,
      label varchar(255),
      url varchar(255),
      closeable integer,
      editable integer,
      moveable integer,
      allowAddContent integer,
      color varchar(255),
      defaulted integer,
      colBetween integer,
      widths varchar(255),
      portletWindowType varchar(255),
      userId varchar(255),
      primary key (ID)
      )
      create table light_portlet (
      portletId integer not null,
      columnNumber integer,
      rowNumber integer,
      label varchar(255),
      icon varchar(255),
      url varchar(255),
      name varchar(255),
      path varchar(255),
      closeable integer,
      refreshMode integer,
      editMode integer,
      helpMode integer,
      configMode integer,
      autoRefreshed integer,
      periodTime integer,
      showNumber integer,
      allowJS integer,
      pageRefreshed integer,
      clientCached integer,
      parameter varchar(255),
      portlet_status integer,
      portlet_mode integer,
      tabId integer,
      barBgColor varchar(255),
      barFontColor varchar(255),
      contentBgColor varchar(255),
      primary key (portletId)
      )
      create table light_portlet_preferences (
      preferencesId integer not null,
      name varchar(255),
      value varchar(255),
      status integer,
      portletId integer,
      primary key (preferencesId)
      )
      create table light_portlet_ref (
      name varchar(255) not null,
      label varchar(255),
      icon varchar(255),
      url varchar(255),
      path varchar(255),
      tag varchar(255),
      refreshMode integer,
      editMode integer,
      helpMode integer,
      configMode integer,
      autoRefreshed integer,
      clientCached integer,
      periodTime integer,
      showNumber integer,
      allowJS integer,
      pageRefreshed integer,
      parameter varchar(255),
      userId varchar(255),
      primary key (name)
      )
      create table light_role (
      roleId varchar(255) not null,
      allowLookAndFeel integer,
      allowLayout integer,
      allowAddTab integer,
      allowAddContent integer,
      allowSignIn integer,
      allowTurnOff integer,
      title varchar(255),
      theme varchar(255),
      primary key (roleId)
      )
      create table light_todo (
      ID integer not null,
      name varchar(255),
      description varchar(255),
      userId varchar(255),
      priority integer,
      status integer,
      primary key (ID)
      )
      create table light_user (
      userId varchar(255) not null,
      password varchar(255),
      firstName varchar(255),
      middleName varchar(255),
      lastName varchar(255),
      email varchar(255),
      primary key (userId)
      )
      create table light_user_role (
      ID integer not null,
      userId varchar(255),
      roleId varchar(255),
      primary key (ID)
      )
      alter table light_portlet_preferences add constraint FKD2B1F8A893A9792 foreign
      key (portletId) references light_portlet
      2008-03-20 16:21:51,336 WARN [org.hibernate.util.JDBCExceptionReporter] - <SQL
      Error: 942, SQLState: 42000>
      2008-03-20 16:21:51,337 ERROR [org.hibernate.util.JDBCExceptionReporter] -
      <ORA-00942: table or view does not exist

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            light-issues
            Reporter:
            ymikhel
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: