Title: Configure EJB 2.x Container-Managed Persistence Describe the issue: /subsystem=cmp/hilo-keygenerator=DB_KEYS/:add(create-table=false,data-source=java:jboss/datasources/ExampleDS,drop-table=false,id-column=cmp_key_ids,select-hi-ddl=select max(cmp_key_ids) from cmp_key_seq,sequence-column=cmp_key_seq,table-name=cmp-keys)) Two errors: - The SQL string in select-hi-ddl parameter must be in quotes. If it is not, EAP will accept the command, but the string will get deformed. - There is an extra bracket in the end, which causes the command's syntax to be rejected Suggestions for improvement: /subsystem=cmp/hilo-keygenerator=DB_KEYS/:add(create-table=false,data-source=java:jboss/datasources/ExampleDS,drop-table=false,id-column=cmp_key_ids,select-hi-ddl="select max(cmp_key_ids) from cmp_key_seq",sequence-column=cmp_key_seq,table-name=cmp-keys)
Moving to ON_QA. The changes should be available for review on the documentation stage within an hour or so from this comment. http://documentation-devel.engineering.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/
Sorry I forgot one more minor mistake :/ sequence-name is a required argument, so it should be included too. My final suggestion is: /subsystem=cmp/hilo-keygenerator=DB_KEYS/:add(create-table=false,data-source=java:jboss/datasources/ExampleDS,drop-table=false,id-column=cmp_key_ids,select-hi-ddl="select max(cmp_key_ids) from cmp_key_seq",sequence-column=cmp_key_seq,table-name=cmp-keys, sequence-name=my-sequence) This should work correctly.
Modified command to that recommended in comment #5
This can be verified here: http://documentation-devel.engineering.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/6.3/html-single/Administration_and_Configuration_Guide/index.html#Configure_EJB_2.x_Container-Managed_Persistence
Verified, thanks.