Skip to main content
V
VasiliyRepecki1-Visitor
1-Visitor
January 9, 2014
Question

Using SequenceGenerator in code

  • January 9, 2014
  • 1 reply
  • 2697 views

Hi, all.

I need to use SequenceGenerator for WTPart in java code.

I have tried setNumber(SequenceGenerator.generateValue("WTPARTID_seq")) but result was not i expected to see.

Now i am trying setNumber(SequenceGenerator.generateValue("{GEN:wt.enterprise.SequenceGenerator:WTPARTID_seq:10:0}")) but it throws SQLServerException: Index 1 out of range.

Can anyone give me working sample?

Thanks.

    1 reply

    K
    KD_0112-Amethyst
    12-Amethyst
    January 10, 2014

    Hi,

    Try this PersistenceHelper.manager.getNextSequence("WTPARTID_seq");

    or this

    EnterpriseHelper.getNumber(new Object[]{"{GEN:wt.enterprise.SequenceGenerator:WTPARTID_seq:10:0}"});

    Thanks,

    Kaushik

      S
      sravi1-Visitor
      1-Visitor
      February 1, 2015

      Hi Kaushik,

      Since the getNextSequence(String str) method is deprecated, is it safe to use this API method?

      Thanks

      Srini

      K
      KD_0112-Amethyst
      12-Amethyst
      February 3, 2015

      Hi Srinivas,

      Yes the API you mentioned it's deprecated.

      But the other one which I mentioned

      EnterpriseHelper.getNumber(new Object[]{"{GEN:wt.enterprise.SequenceGenerator:WTPARTID_seq:10:0}"});

      is not deprecated so you can use that.

      The OOTB code internally using getNextSequence so it may b safe.

      Thanks,

      Kaushik

        Terms & ConditionsAccessibility statement