• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Autogenerated field as String datatype

 
Mike Thomson
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have query regarding the primary key generation for entity bean (EJB 2.0) in JBoss Application server.
For Example:
I am having a table product with product_id and product_name as two columns with product_id as primary key.

I want the product_id to be autogenerated with the user specified format. For example, by defining product_id as auto_increment, it will increment the value with integer data type.
However, I want the primaty key to be String datatype. i want the auotgenerated number plus the string definition.
I want the primary as,
product1 (product+auto_incremented_number)
product2
product3
..
..

PLease help to throw some ligh on it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic