Hello:
I have a sequence that jumps 19 values when used the first time after
a database restart.
Normally it works fine, until a Db restart, then jumps 19 values.
Basically there is a transaction that executes:
1.- select seq_corresp.nextval corresp_id from dual
2.- insert into TABLE (....) values (seq_corresp.CURRVAL,.....)
I am using latest MAXDB (KERNEL 7.6.00 BUILD 027-123-124-939)
with correspoding JDBC driver. This instance was updated from
7.6.0.16.
After the first jump it works normal again.
jdbc trace below:
---- Thread 5d50e1d9 tcpConnection-80-3 Timestamp: 2006-07-04 01:34:53.562
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] (false)
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (select
seq_corresp.nextval corresp_id from dual
)
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> 1
[EMAIL PROTECTED] (1)
=> CORRESP_ID
[EMAIL PROTECTED] (1)
=> FIXED
[EMAIL PROTECTED] (1)
=> 3
[EMAIL PROTECTED] ()
=> true
[EMAIL PROTECTED] (1)
=> CORRESP_ID
[EMAIL PROTECTED] (1)
=> 1201
[EMAIL PROTECTED] ()
=> false
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] (insert into CORRESP
(
corresp_id,
nro_doc,
fec_doc,
remitente,
asunto,
destino,
fec_creacion,
fec_actualiza,
user_creacion,
user_actualiza,
hora_creacion,
hora_actualiza,
fec_recep,
instruccion,
status
)
values
(
seq_corresp.CURRVAL,
'65445',
{d '2006-07-04'},
'Martín Córdova',
'sdasd',
'asdasd',
{d '2006-07-04'},
{d '2006-07-04'},
'mcordova',
'mcordova',
'01:34:53',
'01:34:53',
{d '2006-07-04'},
NULL,
NULL
)
)
=> 1
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
[EMAIL PROTECTED] ()
=> [EMAIL PROTECTED]
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> KERNEL 7.6.00 BUILD 027-123-124-939
[EMAIL PROTECTED] ()
=> SAP DB
[EMAIL PROTECTED] ()
=> package com.sap.dbtech.jdbc, MaxDB JDBC Driver, MySQL MaxDB, 7.6.0
Build 024-000-005-241
[EMAIL PROTECTED] ()
=> false
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] ()
[EMAIL PROTECTED] (true)
[EMAIL PROTECTED] ()
Any help will be appreciated.
Regards,
Martin
--
Dinamica - RADical J2EE framework
open source, easy and powerful
http://www.martincordova.com
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
