[ic] interchange foundation demo not working with Oracle

[interchange-users@interchange.redhat.com (Jonathan Lee)]

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