1 Reply Latest reply on Dec 1, 2003 1:21 PM by Juha Lindfors

    Automatic PK generation

    ravisdwivedi Newbie

      Hi All,
      Please note that I am working on porting my application from weblogic oracle combination to jboss mysql .

      In weblogic-oracle we were using automatic sequence no generation functionality of weblogic.
      The oracle sequence which were defined in the database were mapped like this in weblogic-cmp-rdbms.xml:

      <automatic-key-generation>
      <generator-type>ORACLE</generator-type>
      <generator-name>SEQUENCE_FOR_TABLE_A</generator-name>
      <key-cache-size>1</key-cache-size>
      </automatic-key-generation>


      Do Jboss has any such available tag ?

      I want to know if instead of defining any thing at application server(Jboss) level,If I define the related column i.e. PK column as AUTO_INCREMENT in mysql,then what may be after effects of this??I believe that this may work with out any problem but not sure.

      Please help me in clarifying above.

      Thanks in advance .

      -Ravi