[ic] Catalog is not valid...after using database

[Vincent Lee]

Where does the <table>.sql file go typically? Is this in my dbconf directory
or in the products directory?

-----Original Message-----
From: interchange-users-admin@icdevgroup.org
[mailto:interchange-users-admin@icdevgroup.org]On Behalf Of James P.
Kinney III
Sent: Tuesday, May 27, 2003 12:40 PM
To: Interchange development group
Subject: Re: [ic] Catalog is not valid...after using database


On Tue, 2003-05-27 at 11:50, Vincent Lee wrote:
> I think I've finally figured the problem with using DB2 and will be
> documenting it soon.
>
> When I restart the interchange server, isn't the server supposed to create
> the tables upon restart into the database?

Only if the catalog.conf file specs to use a database AND there is no
<table>.sql file will a restart generate a database table. There must
also be a table template file that holds the commands and table
formating that is callable by the startup procedure. I don't know the
full details on that, but it looks like the template directory is called
by the database type listed in the catalog.conf file.

> I don't get any errors from
> interchange but when I look in my database I don't see any tables created.

No template to build from so ne error was generated.
>
> Further, I get an error that the products database does not exist...Anyone
> with any thoughts?

IC _must_ have a products table. Since it wasn't built (see above) IC
will error on startup.
>
>
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
--
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney@localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7