3 Replies Latest reply on Jul 25, 2007 11:05 AM by peterj

    using Ingres database as PortalDS

    advaittrivedi

      Hi,
      I am trying to use Ingres 2006 database as portalDS for JBoss Portal 2.4. I have setup necessary datasource. But when I start the portal server and when hibernate tries to create tables, following errors are coming.
      -------------------------------------------
      CMS failing to start:
      org.apache.jackrabbit.core.fs.FileSystemException: failed to create folder entry: /
      Caused by: com.ingres.gcf.util.SqlEx: Invalid datatype conversion.

      Automatic creation of table JBP_OBJECT_NODE failing:
      20:27:04,904 ERROR [SchemaUpdate] Unsuccessful: create table JBP_OBJECT_NODE (PK bigint not null, PATH varchar(255) with null unique, NAME varchar(255) with null, PARENT_KEY bigint with null, primary key (PK))
      20:27:04,904 ERROR [SchemaUpdate] CREATE TABLE: A column in a UNIQUE constraint has been defined as WITH NULL (on table 'jbp_object_node').
      All columns in a UNIQUE constraint MUST be created as NOT NULL.

      20:26:44,810 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid bigint not null, jbp_name varchar(255) with null unique, jbp_displayname varchar(255) with null unique, primary key (jbp_rid))
      20:26:44,810 ERROR [SchemaExport] CREATE TABLE: A column in a UNIQUE constraint has been defined as WITH NULL (on table 'jbp_roles').
      All columns in a UNIQUE constraint MUST be created as NOT NULL.

      20:26:45,107 ERROR [SchemaExport] Unsuccessful: create table jbp_users (jbp_uid bigint not null, jbp_uname varchar(255) with null unique, jbp_givenname varchar(255) with null, jbp_familyname varchar(255) with null, jbp_password varchar(255) with null, jbp_realemail varchar(255) with null, jbp_fakeemail varchar(255) with null, jbp_regdate date with null, jbp_viewrealemail tinyint with null, jbp_enabled tinyint with null, primary key (jbp_uid))
      20:26:45,107 ERROR [SchemaExport] CREATE TABLE: A column in a UNIQUE constraint has been defined as WITH NULL (on table 'jbp_users').
      All columns in a UNIQUE constraint MUST be created as NOT NULL.

      20:27:04,904 ERROR [SchemaUpdate] Unsuccessful: create table JBP_OBJECT_NODE (PK bigint not null, PATH varchar(255) with
      null unique, NAME varchar(255) with null, PARENT_KEY bigint with null, primary key (PK))
      20:27:04,904 ERROR [SchemaUpdate] CREATE TABLE: A column in a UNIQUE constraint has been
      defined as WITH NULL (on table 'jbp_object_node').

      20:27:04,904 ERROR [SchemaUpdate] Unsuccessful: alter table JBP_OBJECT_NODE add constraint FKCE6C8F5B8083A928 foreign ke
      y (PARENT_KEY) references JBP_OBJECT_NODE

      20:27:04,920 ERROR [SchemaUpdate] Unsuccessful: alter table JBP_OBJECT_NODE_SEC add constraint FK9CBBD94DD209E280 foreig
      n key (NODE_KEY) references JBP_OBJECT_NODE

      20:27:04,920 ERROR [SchemaUpdate] Unsuccessful: alter table JBP_PORTAL_OBJECT add constraint FKC8EFEC8B8F1445D9 foreign
      key (PK) references JBP_OBJECT_NODE
      -------------------------------------------

      Almost all are related to: trying to create a table having a WITH NULL column definition and same column is part of UNIQUE constrain. What should be done? How does portal hibernate generate this CREATE TABLE commands? Is it from some mapping XML files?