Any FIXED(x,y) data type maps to a BigDecimal having a scale
of y. (That means, getObject will return an instance of BigDecimal).

Thus, for a long, use a fixed type that has enough digits. You can
use a domain to make your database more fussy about the range (as
FIXED is a decimal number, but a long is base 2, the domains of 
a FIXED(5), for instance is much larger that of a 16 bit integer.)

You can see here how to create such a domain:

http://www.sapdb.org/7.4/htmhelp/6d/117c23d14811d2a97400a0c9449261/content.htm

Regards
Alexander Schr�der
SAP Labs Berlin


> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 02, 2002 5:50 PM
> To: [EMAIL PROTECTED]
> Subject: Long vs fixed and bigint
> 
> 
> We are trying to use Jakarta OJB in conjunction with SAPDB. I 
> am wondering
> how to map a Java type "long" to the sapdb.
> The Type "bigint" which is defined as the JDBC equivalent for 
> long (see
> http://jakarta.apache.org/ojb/jdbc-types.html) is apparently
> not supported by SAPDB.
> 
> There is a type called fixed which might be usable here. 
> Maybe fixed(20.0)
> since fixed (10.0) corresponds to int ???
> If so, how does this fixed type map to a JDBC type, which 
> type is it ??
> 
> Thanks for any help
> 
> Ruediger Weiss
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
> 
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to