Hello Rafal,
make sure there is mysql-get-generated-keys entity-command in
standardjbosscmp-jdbc.xml.
What version are you using, BTW?
alex
Monday, July 07, 2003, 2:52:20 PM, Rafal Kedziorski wrote:
RK> hi,
RK> I'm porting our sql script from PostgreSQL to MySQL. This works. But I get
RK> an error deploying one entity bean:
RK> 13:46:54,603 ERROR [EntityContainer] Starting failed
RK> org.jboss.deployment.DeploymentException: Couldn't create entity command: ;
RK> - nested throwable: (java.lang.NullPointerEx
RK> ception)
RK> at
RK>
org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createCreateEntityCommand(JDBCCommandFactory.java:136)
RK> at
RK>
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:481)
RK> at
RK> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:410)
RK> at
RK> org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:170)
RK> at
RK> org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340)
RK> at
RK> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
RK> at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at
RK> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
RK> at $Proxy11.start(Unknown Source)
RK> at
RK> org.jboss.system.ServiceController.start(ServiceController.java:392)
RK> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy32.start(Unknown Source)
RK> at org.jboss.ejb.EjbModule.startService(EjbModule.java:329)
RK> at
RK> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
RK> at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at
RK> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
RK> at $Proxy11.start(Unknown Source)
RK> at
RK> org.jboss.system.ServiceController.start(ServiceController.java:392)
RK> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy22.start(Unknown Source)
RK> at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:540)
RK> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:822)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:630)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:603)
RK> at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy7.deploy(Unknown Source)
RK> at
RK>
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
RK> at
RK>
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
RK> at
RK>
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:20
RK> 0)
RK> at
RK>
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:273)
RK> at
RK> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
RK> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
RK> at
RK> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at
RK> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
RK> at $Proxy0.start(Unknown Source)
RK> at
RK> org.jboss.system.ServiceController.start(ServiceController.java:392)
RK> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy5.start(Unknown Source)
RK> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
RK> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:822)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:630)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:603)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:587)
RK> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
RK> at
RK> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy6.deploy(Unknown Source)
RK> at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:365)
RK> at org.jboss.system.server.ServerImpl.start(ServerImpl.java:272)
RK> at org.jboss.Main.boot(Main.java:150)
RK> at org.jboss.Main$1.run(Main.java:388)
RK> at java.lang.Thread.run(Thread.java:534)
RK> Caused by: java.lang.NullPointerException
RK> 13:46:55,196 WARN [ServiceController] Problem starting service
RK> jboss.j2ee:jndiName=access/Users_2_GroupsBean,service=EJ
RK> B
RK> org.jboss.deployment.DeploymentException: Couldn't create entity command: ;
RK> - nested throwable: (java.lang.NullPointerEx
RK> ception)
RK> at
RK>
org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createCreateEntityCommand(JDBCCommandFactory.java:136)
RK> at
RK>
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:481)
RK> at
RK> org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:410)
RK> at
RK> org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:170)
RK> at
RK> org.jboss.ejb.EntityContainer.startService(EntityContainer.java:340)
RK> at
RK> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
RK> at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at
RK> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
RK> at $Proxy11.start(Unknown Source)
RK> at
RK> org.jboss.system.ServiceController.start(ServiceController.java:392)
RK> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy32.start(Unknown Source)
RK> at org.jboss.ejb.EjbModule.startService(EjbModule.java:329)
RK> at
RK> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
RK> at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at
RK> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
RK> at $Proxy11.start(Unknown Source)
RK> at
RK> org.jboss.system.ServiceController.start(ServiceController.java:392)
RK> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy22.start(Unknown Source)
RK> at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:540)
RK> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:822)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:630)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:603)
RK> at sun.reflect.GeneratedMethodAccessor15.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy7.deploy(Unknown Source)
RK> at
RK>
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:302)
RK> at
RK>
org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:476)
RK> at
RK>
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:20
RK> 0)
RK> at
RK>
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:273)
RK> at
RK> org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:192)
RK> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
RK> at
RK> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at
RK> org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:966)
RK> at $Proxy0.start(Unknown Source)
RK> at
RK> org.jboss.system.ServiceController.start(ServiceController.java:392)
RK> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy5.start(Unknown Source)
RK> at org.jboss.deployment.SARDeployer.start(SARDeployer.java:226)
RK> at org.jboss.deployment.MainDeployer.start(MainDeployer.java:822)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:630)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:603)
RK> at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:587)
RK> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
RK> at
RK> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
RK> at
RK>
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
RK> at java.lang.reflect.Method.invoke(Method.java:324)
RK> at
RK>
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
RK> at
RK> org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:549)
RK> at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:177)
RK> at $Proxy6.deploy(Unknown Source)
RK> at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:365)
RK> at org.jboss.system.server.ServerImpl.start(ServerImpl.java:272)
RK> at org.jboss.Main.boot(Main.java:150)
RK> at org.jboss.Main$1.run(Main.java:388)
RK> at java.lang.Thread.run(Thread.java:534)
RK> Caused by: java.lang.NullPointerException
RK> ...
RK> 13:47:21,103 ERROR [URLDeploymentScanner] MBeanException: Exception in
RK> MBean operation 'checkIncompleteDeployments()'
RK> Cause: Incomplete Deployment listing:
RK> Packages waiting for a deployer:
RK> <none>
RK> Incompletely deployed packages:
RK> <none>
RK> MBeans waiting for classes:
RK> <none>
RK> MBeans waiting for other MBeans:
RK> [ObjectName: jboss.j2ee:jndiName=access/Users_2_GroupsBean,service=EJB
RK> state: FAILED
RK> I Depend On:
RK> Depends On Me: org.jboss.deployment.DeploymentException: Couldn't create
RK> entity command: ; - nested throwable: (java.la
RK> ng.NullPointerException)]
RK> and here is the part from jbosscmp-jdbc.xml:
RK> <entity>
RK> <ejb-name>Users_2_GroupsBean</ejb-name>
RK> <read-ahead>
RK> <strategy>on-load</strategy>
RK> <page-size>4</page-size>
RK> <eager-load-group>*</eager-load-group>
RK> </read-ahead>
RK> <list-cache-max>1000</list-cache-max>
RK> <table-name>users_2_groups</table-name>
RK> <cmp-field>
RK> <field-name>users_2_groups_id</field-name>
RK> <column-name>users_2_groups_id</column-name>
RK> <auto-increment/>
RK> </cmp-field>
RK> <cmp-field>
RK> <field-name>users_id</field-name>
RK> <column-name>users_id</column-name>
RK> </cmp-field>
RK> <cmp-field>
RK> <field-name>groups_id</field-name>
RK> <column-name>groups_id</column-name>
RK> </cmp-field>
RK> <cmp-field>
RK> <field-name>valid_from</field-name>
RK> <column-name>valid_from</column-name>
RK> </cmp-field>
RK> <cmp-field>
RK> <field-name>expired</field-name>
RK> <column-name>expired</column-name>
RK> </cmp-field>
RK> <!-- <entity-command name="pk-sql">
RK> <attribute name="pk-sql">SELECT
RK> nextval('users_2_groups_seq')</attribute>
RK> </entity-command> -->
RK> <entity-command name="mysql-get-generated-keys"/>
RK> this looks the same like all other entity beans.
RK> any idea?
RK> Regards,
RK> Rafal
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
