• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PROCEDURE mysql.IDENTITY does not exist

 
Mike Thomson
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
From Sturts Action class, I am invoking a remote session bean, which in turn invokes Local Entity bean to insert a record in product table in MySql Db using JBoss 4.2.2 GA application server (EJB 2.0).

I want to generate the primary key for the product_id.

I have created the table product as below:


In my ProductBean local entity bean, I am using:


The jbosscmp-jdbc.xml is having following:


I am getting the following error while inserting the record in product table through entity bean. When I checked the table, the records got inserted, but I am getting the following error:



Can anyone help on this?
 
Mike Thomson
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have resolve this issue. The enetity command which I had used is for Hypersonic db. I have changed it to mysql and it's working.

<entity-command name="hsqldb-fetch-key" />
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic