Re: [Solution] How is the autoid generated? Chokes SAP DB.

2002-02-21 Thread Ray Harrison

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




Re: [Updated sapdb.xml] [Solution] How is the autoid generated? Chokes SAP DB.

2002-02-21 Thread Ray Harrison

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=floatname=float /
type-mapping type=int  name=integer /
type-mapping type=long name=fixed(38) /
type-mapping type=shortname=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.Datename=date /
type-mapping type=java.sql.Timename=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




How is the autoid generated? Chokes SAP DB.

2002-02-20 Thread Ray Harrison

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