NumberFormatException for createSequence maxValue

General Discussion
1

Hi,

I’m liquifying our DDL oracle statements and I have to create sequences with a maxValue of 9999999999  (These are 10 nine’s)

       

I get a NumberFormatExecption since liquibase wants to parse this attribute as an integer which is according to the java spec too much.
The maximum I can specify in terms of nine’s is 999999999 (9 nine’s)

How can I create a sequence via liquibase with 10 nine’s ??

Do I need a modifySql step for this replacing the 9 nine’s with 10 nine’s ?

Regards, Bert.

2

What version of liquibase are you using?  The 2.0 RCs should be using BigInteger which will allow arbitrarily large numbers.

As a work-around, you could use modifySql, or you could just use the tag and list out the create sequence sql yourself.  Otherwise, maxValue is not required and should use the oracle default if not specified which may be what you are needing too.

Nathan

3
Originally posted by: Nathan
What version of liquibase are you using?  The 2.0 RCs should be using BigInteger which will allow arbitrarily large numbers.

As a work-around, you could use modifySql, or you could just use the tag and list out the create sequence sql yourself.  Otherwise, maxValue is not required and should use the oracle default if not specified which may be what you are needing too.

Nathan

I’m using 2.0 RC 5

4

I’m still not able to duplicate it.  Can you post the stacktrace you are getting?  You may need --logLevel=debug to see it.

Nathan