Use Mybatis get sequence not follow squences

Asked Oct 13 '16 at 03:47

Active Dec 15 '17 at 16:12

Viewed 595 times

I use Mybatis get postgreDB sequences

The import_order_seq set

"Increment By" 1

"Max value" 9999

"Min valu" 1

"Cache Value" 20

the Mybatis xml

<select id="getSequence" resultType = "java.lang.String">
   select import_order_seq.nextval from dual 
</select>

The java code

String x = xxxx.getSequence()

The problem is when I execute the java code x is 21 ,41,61,81.....,
not 1,2,3,4.... How can I let x is 1,2,3,4....??

asked Oct 13 '16 at 03:47

Brian

Set the useCache=true for select statement. I am not sure how you are managing the database connection. Hope it is managed by Spring with connection pooling. – notionquest Oct 13 '16 at 08:17
@Brian you can identify easily it is taking cache value....each time +20 to previous value. – Prasanna Kumar H A Oct 13 '16 at 09:07

0 Answers0