[ic] interchange foundation demo not working with Oracle

[Richard Chen]

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