This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin in Action and have Dmitry Jemerov & Svetlana Isakova on-line!
See this thread for details.
Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

PROCEDURE mysql.IDENTITY does not exist  RSS feed

 
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
Boost this thread!