Pages: 1

 

#1 2011-03-25 16:08:47

sronkane
New member
Registered: 2011-01-19
Posts: 1

setting auto increment start value?

Tags: [auto increment, eXist, MDM, schema]

I have tried find instructions how to set the start value of the auto increment attribute in the data model but no luck. can somebody help? I know how to use the auto incremet as id but want to change the value where it begins to increment. it's possible in mysql so I suppose its possible in talend mdm/exist?

cheers, samuli

Offline

 

#2 2011-03-25 16:14:55

muraliv
Member
Registered: 2010-12-01
Posts: 58

Re: setting auto increment start value?

yes its possible.
1. In TOS got to MDM section
2. go to Data Container|System|CONF
3. On the Entity Drop Down list, select Autoincrement and hit the search
4. Edit the search record returned, and go to Source section

Good luck.

Offline

 

#3 2011-03-25 16:18:57

csonnefraud
Talend Team
Registered: 2007-11-15
Posts: 322
Website

Re: setting auto increment start value?

Hi,

This value is stored in the system datacontainer called 'CONF'. You can edit the XML to set the value you need.

Code:

<AutoIncrement>
      <id>AutoIncrement</id>
      <entry>
         <key>["Version"]."Datacontainer"."Entity"."Pk"</key>
         <value>1</value>
      </entry>

Regards,

Cyril

Last edited by csonnefraud (2011-03-25 16:20:09)

Offline

 

#4 2011-03-25 17:53:40

dafonso
Member
Registered: 2010-10-20
Posts: 40

Re: setting auto increment start value?

sronkane,

It is possible indeed as muraliv and csonnefraud detailed.

But I'll let you one advice, as I've struggled multiple times resetting multiple counters... Id is just an identifier, so unless there is a really strong point to use a AUTO_INCREMENT type, you should use UUID instead. That way, you don't have to keep resetting Auto Increment start values every time you want to redo your tests.

If you are using AUTO_INCREMENT to keep track of creation order, you could deal with that in other ways:
- Create CreateDate and UpdateDate on the DataModel;
- Query Journal and see all the CRUD actions on every record, ordered in any way you want.

Best regards,
Diogo Afonso

Offline

 

 

Pages: 1

Board footer

Powered by FluxBB