[ic] testing latest install against oracle

[Dan Browning]

At 10:04 PM 4/1/2003 -0800, you wrote:
>I am testing the mar-31 nightly build trying to get it running on RedHat 
>Linux and Oracle 9i. configure and makecat appear to work fine outside of 
>the small fixable problem with vlink.c not compiling automatically.
>
>The real problem I run into is trying to startup interchange and make it 
>through the database create scripts. I noticed that the oracle config 
>files are different than the mysql config files. Is this because mysql is 
>under more active development?

Yes.  The config files for all the databases are probably a little out of 
date, but the Oracle ones are the least developed.

>I found the following problems at startup.
>
>1. creating indexes on the options table. The oracle configs ask for 
>indexes and columns that the mysql file does not. Limiting the indexes to 
>the indexes specified in the mysql file fixes the problem for oracle.

Great.

>2. importing data to options table, 'inserted value too large for column'

You can enable logging to find out which INSERT statement has the too-large 
value, then update the data type in the definition.

>2. variants table fails, 'default username feature not supported'

Hmmm.  It would be great if you wanted to whip up some patches for the 
adjustments that you make.

-Dan

--
/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies,      <dan.browning@kavod.com> |
| 6700 NE 162nd Ave, Suite 210, Vancouver, WA (360) 843-4074 x217 |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
Talk sense to a fool and he calls you foolish.
                 -- Euripides