aspose file tools*
The moose likes JBoss/WildFly and the fly likes PROCEDURE mysql.IDENTITY does not exist Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "PROCEDURE mysql.IDENTITY does not exist" Watch "PROCEDURE mysql.IDENTITY does not exist" New topic
Author

PROCEDURE mysql.IDENTITY does not exist

Mike Thomson
Ranch Hand

Joined: Nov 07, 2007
Posts: 115
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

Joined: Nov 07, 2007
Posts: 115
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" />
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: PROCEDURE mysql.IDENTITY does not exist
 
Similar Threads
Entity Beans (CMP) with PostGis
Problem with CMP
Entity Bean Error - SQLException
finder method of CMP thows NULLPOINTER EXCEPTION
Proble with Relationship in Entity Bean