[CDBI] problem with loadinng data in a db2 database using class-dbi

noumene at cpsc.ucalgary.ca noumene at cpsc.ucalgary.ca
Tue Nov 1 01:21:50 GMT 2005


Hi,

 I am trying to load data in my db2 database using class-dbi in a
perl script.
I am blocked on the dbi set_up_table function called in my script:
Chado::Tableinfo->set_up_table('tableinfo');

This is the error i got:
Chado::Tableinfo has no primary key at
/usr/lib/perl5/site_perl/5.8.3/Chado/LoadDBI.pm line 5
Compilation failed in require at
/usr/lib/perl5/site_perl/5.8.3/Chado/LoadDBI.pm line 5.
BEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.8.3/Chado/LoadDBI.pm line 5.
Compilation failed in require at /usr/bin/gmod_load_ontology.pl line 7.
BEGIN failed--compilation aborted at /usr/bin/gmod_load_ontology.pl line 7.

My table has a primary key as you can see below.

create table tableinfo (
    tableinfo_id Integer Generated AS IDENTITY (NO CACHE) NOT NULL,
    name varchar(30) not null,
    primary_key_column varchar(30),
    is_view smallint not null default 0,
    view_on_table_id int,
    superclass_table_id int,
    is_updateable smallint not null default 1,
    modification_date date not null default CURRENT DATE,
    constraint tableinfo_c1 unique (name)
) IN general_tab
  INDEX IN general_idx
  LONG IN general_lrg;

CREATE UNIQUE INDEX PK_tableInfo
       ON tableinfo (tableinfo_id)
       ALLOW REVERSE SCANS;

ALTER TABLE tableinfo
       ADD CONSTRAINT PK_tableinfo PRIMARY KEY (tableinfo_id);

Any proposition?
thanks
etienne







More information about the ClassDBI mailing list