db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Per-Olof Norén <pe...@alma.nu>
Subject [PATCH] SequenceManagerNextValImpl support for very large sequence numbers
Date Tue, 18 Feb 2003 17:01:30 GMT
Hi all,
I´m new to this list, so please correct me if this list isn´t the 
correct place for the diff-file.

Problem:
When using an Oracle (8.1.7) sequence for generating keys for a 
"NUMERIC(14,0)" field, an SQLException claiming number spill is thrown 
from the oracle jdbc driver when rs.getInt is called. This is because 14 
digit numbers are too large for java datatype int.
Looking at PostgreSQL´s sequences (which is similar  to Oracle´s) one 
finds that sequences returns bigint, or the like.

Solution:
This patch makes the SequenceManagerNextVal read the sequence as long 
and handle all calls as long internally.
This patch has been tested on Oracle 8.1.7.

Please let me know if there is other requirements that  must be met to 
get this patch applied.

Regards,

Per-Olof Norén
Curalia AB
Stockholm, Sweden

Mime
View raw message