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
