Tom, Have you worked it out?
Thanks. On 3/13/06, Jun Li <[EMAIL PROTECTED]> wrote: > > > > On 3/13/06, Thomas Dudziak <[EMAIL PROTECTED]> wrote: > > > > On 3/13/06, Jun Li <[EMAIL PROTECTED]> wrote: > > > > > I've reported this issue before, but I tried this with the latest > > source > > > just now, it hasn't been fixed from what I saw. > > > I'm using SQL Server 2000, trying to create databases from XML file. I > > tried > > > with SQL Server 2005 JDBC driver also, just hasn't get it right. > > > > > > Can you do something on this? > > > > Please send me the schema you tried to insert (off-the-list if you > > want) so that I can test it. > > > > Tom > > > > Thanks for response, here is a portion of the schema: > > <database name="build_test"> > <table name="Accrual"> > <column name="AccrualID" primaryKey="true" required="true" > type="NUMERIC" size="8" autoIncrement="true"/> > <column name="PeriodFK" primaryKey="false" required="true" > type="NUMERIC" size="8" autoIncrement="false"/> > <column name="FileNameChanged" primaryKey="false" required="true" > type="VARCHAR" size="80" autoIncrement="false"/> > <column name="AccruedOn" primaryKey="false" required="false" > type="TIMESTAMP" size="23" autoIncrement="false"/> > <foreign-key foreignTable="Period" name="FK_Accrual_Period"> > <reference local="PeriodFK" foreign="PeriodID"/> > </foreign-key> > <unique name="PK_Accrual"> > <unique-column name="AccrualID"/> > </unique> > <index name="IX_Accrual_Period"> > <index-column name="PeriodFK"/> > </index> > </table> > <table name="Period"> > <column name="PeriodID" primaryKey="true" required="true" > type="NUMERIC" size="8" autoIncrement="true"/> > <column name="PeriodDesc" primaryKey="false" required="true" > type="VARCHAR" size="50" autoIncrement="false"/> > <column name="StatementDate" primaryKey="false" required="false" > type="TIMESTAMP" size="23" autoIncrement="false"/> > <column name="LastChangedOn" primaryKey="false" required="false" > type="TIMESTAMP" size="23" autoIncrement="false"/> > <column name="PeriodMessage" primaryKey="false" required="false" > type="VARCHAR" size="1000" autoIncrement="false"/> > <unique name="PK_Period"> > <unique-column name="PeriodID"/> > </unique> > </table> > </database> > > > > > > -- > -------------- > Cheers, > Jun > -- -------------- Cheers, Jun
