Liferay 6.2 how to use an existing oracle sequence in a service builder

[John LrUser, modificado 8 Anos atrás.]

Hello guys,

I am trying to use the Nextval sequence number from an existing Oracle Sequence through my Liferay service builder.
I do not want to use the counterLocal, but the real Oracle sequence function.

Do you know any possibility to do this ?

Thanks for any input!

[Harish Kumar, modificado 8 Anos atrás.]

Hi

You can have a look at service builder dtd

The fourth implementation uses a sequence to generate a primary key.

For example:

<column
name="id"
type="Integer"
primary="true"
id-type="sequence"
id-param="id_sequence"
/>

In this implementation, a create sequence SQL statement is created based on
the id-param value (stored in /sql/sequences.sql). This sequence is then
accessed to generate a unique identifier whenever an insert occurs. This
implementation is only supported by DB2, Oracle, PostgreSQL, and SAP DB.

Regards

[John LrUser, modificado 8 Anos atrás.]

Hi,
Thanks for your answer, but what I am trying is to use a Sequence that is already declared and existing in an Oracle database. I do not want to create a sequence.
I found no way to do this.

[Harish Kumar, modificado 8 Anos atrás.]

Hi

did you try by providing the existing sequence as id-param="<<your existing sequence>>" and build the service.

[John LrUser, modificado 8 Anos atrás.]

Hi,
Yes I did, it seemed to work but the ID started at 1 whereas the real Sequence has another number, and was not increased.