Here is the updated SAP DB schema file:
============================================================================================== <?xml version="1.0"?> <!DOCTYPE database-schema PUBLIC "-//Evermind//- Database schema" "http://www.orionserver.com/dtds/database-schema.dtd";> <database-schema name="SapDB" not-null="not null" null="null" primary-key="primary key" max-table-name-length="32"> <type-mapping type="boolean" name="boolean" /> <type-mapping type="byte" name="byte" /> <type-mapping type="char" name="char" /> <type-mapping type="double" name="double precision" /> <type-mapping type="float" name="float" /> <type-mapping type="int" name="integer" /> <type-mapping type="long" name="fixed(38)" /> <type-mapping type="short" name="smallint" /> <type-mapping type="java.lang.String" name="varchar(255)" /> <type-mapping type="java.math.BigDecimal" name="fixed(15,15)" /> <type-mapping type="byte[]" name="long byte" /> <type-mapping type="java.sql.Date" name="date" /> <type-mapping type="java.sql.Time" name="time" /> <type-mapping type="java.sql.Timestamp" name="timestamp" /> <type-mapping type="java.util.Date" name="timestamp" /> <type-mapping type="java.io.Serializable" name="long byte" /> <disallowed-field name="key" /> <disallowed-field name="date" /> <disallowed-field name="timestamp" /> <disallowed-field name="time" /> <disallowed-field name="username" /> <disallowed-field name="user" /> <disallowed-field name="password" /> <disallowed-field name="order" /> <disallowed-field name="table" /> <disallowed-field name="value" /> <disallowed-field name="name" /> <disallowed-field name="count" /> </database-schema> ============================================================================================== --- Ray Harrison <[EMAIL PROTECTED]> wrote: > The SAPDB schema in the database schema directory currently maps long to integer, it >should map > long to something like fixed(38). That fixes it. > > Cheers > Ray > > > --- Ray Harrison <[EMAIL PROTECTED]> wrote: > > Hi - > > Does anyone know off hand how the autoid is generated in 1.5.4? The value produced >chokes SAP > DB > > (it produces an invalid exponent error when trying to insert the row). Works fine >in Oracle. > > > > Thanks much > > Ray > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Sports - Coverage of the 2002 Olympic Games > > http://sports.yahoo.com > > > > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > __________________________________________________ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com
