[ic] interchange foundation demo not working with Oracle

Jonathan Lee interchange-users@interchange.redhat.com
Tue Jan 29 19:05:01 2002


I also have this issue. But after I login, it's fine.

--- Richard Chen <chenri@snet.net> wrote:
> This fixed the pulldown menu problem for
> State/Province.
> However, the Shipping method pull down still only
> shows
> blank entries, just like State/Province before the
> fix.
> 
> Any ideas on what caused that?
> 
> Thanks
> 
> Richard
> 
> On Tue, Jan 29, 2002 at 11:08:18AM -0800, Jonathan
> Lee wrote:
> > State not show up is because of the bug in
> state.ora
> > file.
> > Add the following line to your state.ora file:
> > Database  state  UPPERCASE    1
> > 
> > --- Richard Chen <chenri@snet.net> wrote:
> > > Hi,
> > > 	I just tried interchange foundation demo. The
> > > regular DBM database worked. But when I tried
> using
> > > Oracle, there are problems upon starting
> > > interchange:
> > > 
> > > Configuring catalog foundation...Using Oracle,
> > > DSN=dbi:Oracle:...table
> > > country created: create table country (
> > > code VARCHAR2(3) PRIMARY KEY,
> > > sorder VARCHAR2(128),
> > > region VARCHAR2(128),
> > > selector VARCHAR2(3),
> > > shipmodes VARCHAR2(64),
> > > name VARCHAR2(32) DEFAULT '',
> > > iso CHAR(3) DEFAULT '' NOT NULL,
> > > isonum CHAR(3) DEFAULT '' NOT NULL,
> > > tax VARCHAR2(128)
> > > )
> > > 
> > > table 'country' failed: country import failed:
> > > ORA-01400: cannot insert
> > > NULL into ("INTERCHANGE"."COUNTRY"."ISO") (DBD
> > > ERROR: OCIStmtExecute)
> > > 
> > > Apparently there are data records with iso and
> > > isonum having no values.
> > > 
> > > I had tried removing the 'NOT NULL' restriction
> from
> > > foundation/dbconf/oracle/country.ora. But the
> > > resulting
> > > checkout page does not have the correct pull
> down
> > > menu for
> > > State/Provice entry. No state/province were
> listed.
> > > All entries
> > > in the pull down are blank.
> > > 
> > > Also, the shipping method pull down on checkout
> page
> > > is blank.
> > > 
> > > This means that the demo allows buying stuff but
> no
> > > checkout :-(
> > > 
> > > Anyone got a workaround for this? Do I have to
> > > remove the entries
> > > with iso and isonum blank from the datafile?
> > > 
> > > Thanks for any info.
> > > 
> > > Richard
> > > _______________________________________________
> > > interchange-users mailing list
> > > interchange-users@interchange.redhat.com
> > >
> >
>
http://interchange.redhat.com/mailman/listinfo/interchange-users
> > 
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Great stuff seeking new owners in Yahoo! Auctions!
> 
> > http://auctions.yahoo.com
> > _______________________________________________
> > interchange-users mailing list
> > interchange-users@interchange.redhat.com
> >
>
http://interchange.redhat.com/mailman/listinfo/interchange-users
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
>
http://interchange.redhat.com/mailman/listinfo/interchange-users


__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions! 
http://auctions.yahoo.com