PROCEDURE mysql.IDENTITY does not exist

[Mike Thomson]

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:

create table product(product_id integer auto_increment, product_name varchar(256), primary key(product_id),index product_ind(product_id));

In my ProductBean local entity bean, I am using:

	public Integer ejbCreate(String name) throws CreateException {		
		setName(name);
		return null;
	}

The jbosscmp-jdbc.xml is having following:

<defaults>
	<datasource>java:/MySqlDS</datasource>
	<datasource-mapping>mySQL</datasource-mapping>
	<create-table>false</create-table>
	<remove-table>false</remove-table>
</defaults>

<enterprise-beans>
	<entity>
		<ejb-name>ProductEJB</ejb-name>
		<pk-constraint>false</pk-constraint>
		<table-name>Product</table-name>

		<cmp-field>
			<field-name>name</field-name>
			<column-name>product_name</column-name>
		</cmp-field>

		<!-- unknown-pk>
			<unknown-pk-class>java.lang.Integer</unknown-pk-class>
			<field-name>id</field-name>
			<column-name>product_id</column-name>
			<jdbc-type>INTEGER</jdbc-type>
			<sql-type>INTEGER</sql-type>
			<auto-increment/>
		</unknown-pk-->

		<cmp-field>
			<field-name>id</field-name>
			<column-name>product_id</column-name>
			<auto-increment/>
			</cmp-field>

		<entity-command name="hsqldb-fetch-key" />

	</entity>
<enterprise-beans>

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:

12:25:17,400 ERROR [LogInterceptor] TransactionRolledbackLocalException in method: public abstract com.example.ejb.product.ProductLocal com.example.ejb.product.ProductHomeLocal.create(java.lang.String) throws javax.ejb.CreateException,javax.ejb.EJBException, causedBy:
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: PROCEDURE mysql.IDENTITY does not exist
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
	at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
	at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232)
	at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCIdentityColumnCreateCommand.executeInsert(JDBCIdentityColumnCreateCommand.java:71)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:321)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:151)
	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:587)
	at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:237)
	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:225)
	at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:625)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
	at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1126)
	at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105)
	at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:203)
	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:189)
	at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105)
	at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:136)
	at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:76)
	at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:45)
	at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:56)
	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:125)
	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
	at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:161)
	at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:145)
	at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:132)
	at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:107)
	at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:521)
	at org.jboss.ejb.Container.invoke(Container.java:981)
	at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:359)
	at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:133)
	at $Proxy98.create(Unknown Source)
	at com.example.ejb.productmanager.ProductManagerBean.addProduct(ProductManagerBean.java:41)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
	at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
	at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
	at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
	at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
	at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
	at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
	at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
	at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
	at org.jboss.ejb.Container.invoke(Container.java:960)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
	at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
	at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
	at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
	at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
	at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
	at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
	at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
	at $Proxy101.addProduct(Unknown Source)
	at com.example.web.action.ProductAction.execute(ProductAction.java:68)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
	at java.lang.Thread.run(Unknown Source)
12:25:17,634 ERROR [STDERR] javax.ejb.TransactionRolledbackLocalException: Error extracting generated key
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:262)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:161)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:145)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:132)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:107)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:521)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.Container.invoke(Container.java:981)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:359)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:133)
12:25:17,634 ERROR [STDERR] 	at $Proxy98.create(Unknown Source)
12:25:17,634 ERROR [STDERR] 	at com.example.ejb.productmanager.ProductManagerBean.addProduct(ProductManagerBean.java:41)
12:25:17,634 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:25:17,634 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
12:25:17,634 ERROR [STDERR] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
12:25:17,634 ERROR [STDERR] 	at java.lang.reflect.Method.invoke(Unknown Source)
12:25:17,634 ERROR [STDERR] 	at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
12:25:17,634 ERROR [STDERR] 	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
12:25:17,634 ERROR [STDERR] 	at org.jboss.ejb.Container.invoke(Container.java:960)
12:25:17,634 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:25:17,634 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
12:25:17,634 ERROR [STDERR] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
12:25:17,634 ERROR [STDERR] 	at java.lang.reflect.Method.invoke(Unknown Source)
12:25:17,634 ERROR [STDERR] 	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
12:25:17,634 ERROR [STDERR] 	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
12:25:17,634 ERROR [STDERR] 	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
12:25:17,634 ERROR [STDERR] 	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
12:25:17,650 ERROR [STDERR] 	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
12:25:17,650 ERROR [STDERR] 	at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
12:25:17,650 ERROR [STDERR] 	at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
12:25:17,650 ERROR [STDERR] 	at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
12:25:17,650 ERROR [STDERR] 	at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
12:25:17,650 ERROR [STDERR] 	at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
12:25:17,650 ERROR [STDERR] 	at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
12:25:17,650 ERROR [STDERR] 	at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
12:25:17,650 ERROR [STDERR] 	at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
12:25:17,650 ERROR [STDERR] 	at $Proxy101.addProduct(Unknown Source)
12:25:17,650 ERROR [STDERR] 	at com.example.web.action.ProductAction.execute(ProductAction.java:68)
12:25:17,650 ERROR [STDERR] 	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
12:25:17,650 ERROR [STDERR] 	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
12:25:17,650 ERROR [STDERR] 	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
12:25:17,650 ERROR [STDERR] 	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
12:25:17,650 ERROR [STDERR] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
12:25:17,650 ERROR [STDERR] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
12:25:17,650 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
12:25:17,650 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:25:17,650 ERROR [STDERR] 	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
12:25:17,650 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
12:25:17,650 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
12:25:17,650 ERROR [STDERR] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
12:25:17,650 ERROR [STDERR] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
12:25:17,650 ERROR [STDERR] 	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
12:25:17,650 ERROR [STDERR] 	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
12:25:17,665 ERROR [STDERR] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
12:25:17,665 ERROR [STDERR] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
12:25:17,665 ERROR [STDERR] 	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
12:25:17,665 ERROR [STDERR] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
12:25:17,665 ERROR [STDERR] 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
12:25:17,665 ERROR [STDERR] 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
12:25:17,665 ERROR [STDERR] 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
12:25:17,665 ERROR [STDERR] 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
12:25:17,665 ERROR [STDERR] 	at java.lang.Thread.run(Unknown Source)
12:25:17,665 ERROR [STDERR] Caused by: javax.ejb.EJBException: Error extracting generated key
12:25:17,665 ERROR [STDERR] 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCIdentityColumnCreateCommand.executeInsert(JDBCIdentityColumnCreateCommand.java:80)
12:25:17,665 ERROR [STDERR] 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:321)
12:25:17,665 ERROR [STDERR] 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:151)
12:25:17,665 ERROR [STDERR] 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:587)
12:25:17,665 ERROR [STDERR] 	at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:237)
12:25:17,665 ERROR [STDERR] 	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:225)
12:25:17,665 ERROR [STDERR] 	at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:625)
12:25:17,665 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
12:25:17,665 ERROR [STDERR] 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
12:25:17,665 ERROR [STDERR] 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
12:25:17,665 ERROR [STDERR] 	at java.lang.reflect.Method.invoke(Unknown Source)
12:25:17,665 ERROR [STDERR] 	at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
12:25:17,665 ERROR [STDERR] 	at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1126)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:203)
12:25:17,681 ERROR [STDERR] 	at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:189)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:136)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:76)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:45)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:56)
12:25:17,681 ERROR [STDERR] 	at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:125)
12:25:17,681 ERROR [STDERR] 	... 71 more
12:25:17,681 ERROR [STDERR] Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: PROCEDURE mysql.IDENTITY does not exist
12:25:17,681 ERROR [STDERR] 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
12:25:17,681 ERROR [STDERR] 	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
12:25:17,681 ERROR [STDERR] 	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
12:25:17,681 ERROR [STDERR] 	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
12:25:17,681 ERROR [STDERR] 	at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
12:25:17,696 ERROR [STDERR] 	at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
12:25:17,696 ERROR [STDERR] 	at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232)
12:25:17,696 ERROR [STDERR] 	at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171)
12:25:17,696 ERROR [STDERR] 	at org.jboss.ejb.plugins.cmp.jdbc.JDBCIdentityColumnCreateCommand.executeInsert(JDBCIdentityColumnCreateCommand.java:71)
12:25:17,712 ERROR [STDERR] 	... 92 more

Can anyone help on this?

[Mike Thomson]

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" />