Hallo ich bekomme Fehler in der Console angezeigt sobald ich mein Projekt auf den JBoss deployen will.

In meinem EntityBean habe ich einen Finder hinzugefügt, welcher wie folgt aussieht:

Code :

1 2 3

* @ejb.finder signature = "Mitarbeiter findSatzbyId(java.lang.Integer id)"  *             description = "Find Satz by Id" query = "SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id ASC LIMIT 1"  *

Zur Sicherheit habe ich den SQL auch schon mal mit dem SQL-Browser ausgeführt und ich komme zu dem Ergebnis, welches ich haben möchte.

Wenn ich das "LIMIT 1" in der Finder weg lasse funktioniert das Deployen auch ohne Probleme nur nicht, wenn ich es wieder in die Finder einbinde.

Wenn ich dann deploye bekomme ich folgene Fehlermeldung:

Code :

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204

11:05:45,156 INFO  [ProxyFactory] Unbind EJB Home 'MitarbeiterSession' from jndi 'MitarbeiterSession' 11:05:45,218 INFO  [EjbModule] Undeployed MitarbeiterSession 11:05:45,218 INFO  [ProxyFactory] Unbind EJB Home 'AnredeEntity' from jndi 'AnredeEntity' 11:05:45,218 INFO  [EjbModule] Undeployed AnredeEntity 11:05:45,218 INFO  [ProxyFactory] Unbind EJB Home 'MitarbeiterEntity' from jndi 'MitarbeiterEntity' 11:05:45,218 INFO  [EjbModule] Undeployed MitarbeiterEntity 11:05:45,484 INFO  [EjbModule] Deploying MitarbeiterEntity 11:05:45,500 INFO  [EjbModule] Deploying AnredeEntity 11:05:45,515 INFO  [EjbModule] Deploying MitarbeiterSession 11:05:45,953 ERROR [MitarbeiterEntity#findSatzbyId] Encountered "LIMIT" at line 1, column 75. Was expecting one of:     <EOF>     "," ...     org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "LIMIT" at line 1, column 75. Was expecting one of:     <EOF>     "," ...         at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java:4360)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4237)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLParser.java:190)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:65)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.java:168)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:58)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:75)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:286)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:505)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)     at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)     at org.jboss.ejb.EjbModule.startService(EjbModule.java:414)     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)     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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)     at $Proxy0.start(Unknown Source)     at org.jboss.system.ServiceController.start(ServiceController.java:417)     at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy31.start(Unknown Source)     at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:662)     at sun.reflect.GeneratedMethodAccessor121.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)     at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)     at org.jboss.ws.integration.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:93)     at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)     at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy32.start(Unknown Source)     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)     at sun.reflect.GeneratedMethodAccessor18.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy9.deploy(Unknown Source)     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:610)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225) 11:05:45,953 WARN  [ServiceController] Problem starting service jboss.j2ee:service=EjbModule,module=MyEJB2Project.jar org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement for EJB 'MitarbeiterEntity': SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id ASC LIMIT 1,5; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "LIMIT" at line 1, column 75. Was expecting one of:     <EOF>     "," ...     )     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:67)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:75)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:286)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:505)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)     at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)     at org.jboss.ejb.EjbModule.startService(EjbModule.java:414)     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)     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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)     at $Proxy0.start(Unknown Source)     at org.jboss.system.ServiceController.start(ServiceController.java:417)     at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy31.start(Unknown Source)     at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:662)     at sun.reflect.GeneratedMethodAccessor121.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)     at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)     at org.jboss.ws.integration.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:93)     at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)     at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy32.start(Unknown Source)     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)     at sun.reflect.GeneratedMethodAccessor18.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy9.deploy(Unknown Source)     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:610)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225) Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "LIMIT" at line 1, column 75. Was expecting one of:     <EOF>     "," ...         at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java:4360)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4237)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLParser.java:190)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:65)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.java:168)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:58)     ... 70 more 11:05:45,953 INFO  [EJBDeployer] Deployed: file:/C:/Programme/jboss-4.2.1.GA/server/default/deploy/MyEJB2Project.jar 11:05:46,031 ERROR [URLDeploymentScanner] Incomplete Deployment listing:   --- MBeans waiting for other MBeans --- ObjectName: jboss.j2ee:service=EjbModule,module=MyEJB2Project.jar   State: FAILED   Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement for EJB 'MitarbeiterEntity': SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id ASC LIMIT 1,5; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "LIMIT" at line 1, column 75. Was expecting one of:     <EOF>     "," ...     )   --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss.j2ee:service=EjbModule,module=MyEJB2Project.jar   State: FAILED   Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement for EJB 'MitarbeiterEntity': SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id ASC LIMIT 1,5; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "LIMIT" at line 1, column 75. Was expecting one of:     <EOF>     "," ...     )

Ich habe da jetzt schon ewig dran rumgebastelt aber ich bekomme es einfach nicht hin.
Vielleicht kann mir ja einer von Euch weiter helfen.
Würde mich freuen...

MfG

Hallo,

LIMIT ist AFAIK nicht in Standard EJB-QL möglich. Einiger Hersteller haben hier jedoch entsprechende Erweiterungen in ihre CMP Persistence Engines eingebaut, so auch JBoss. Ich glaub LIMIT funktioniert in diesem Zusammenhang nur wenn man ein entsprechendes OFFSET angibt.

In jbosscmp-jdbc.xml:
(JBoss-)EJBQL:

Code xml:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

<entity>          <ejb-name>BubuEntity</ejb-name>          <datasource>java:DefaultDS</datasource>          <datasource-mapping>Oracle9</datasource-mapping>          <create-table>false</create-table>          <remove-table>false</remove-table>          <table-name>Bubu</table-name>            <cmp-field>             <field-name>field1</field-name>           </cmp-field>          <cmp-field>             <field-name>field2</field-name>           </cmp-field>          <cmp-field>             <field-name>field3</field-name>           </cmp-field>          <cmp-field>             <field-name>field4</field-name>           </cmp-field>          <cmp-field>             <field-name>field5</field-name>           </cmp-field>            <query>             <query-method>                <method-name>findMyContacts</method-name>                <method-params>                   <method-param>java.lang.String</method-param>                   <method-param>int</method-param>                   <method-param>int</method-param>                   <method-param>java.lang.String</method-param>                </method-params>             </query-method>             <jboss-ql><![CDATA[SELECT OBJECT(o) FROM BubuEntity o WHERE ((o.field1 LIKE ?1) OR (o.field2 LIKE ?4)) ORDER BY o.field2 OFFSET ?3 LIMIT ?2]]></jboss-ql>          </query> ...

Gruß Tom

Danke erstmal für die schnelle Antwort

Also ich habe den Finder nun um den OFFSET erweitert:

Code :

1 2	* @ejb.finder signature = "Mitarbeiter findSatzbyId(java.lang.Integer id, java.lang.Integer offset, java.lang.Integer limit)"  *             description = "Find Satz by Id" query = "SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id OFFSET ?2 LIMIT ?3"

jedoch bekomme ich nun fast das gleiche, nur dass er nun nicht am LIMIT meckert sondern am OFFSET.

Code :

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216

14:59:39,717 INFO  [ProxyFactory] Unbind EJB Home 'MitarbeiterSession' from jndi 'MitarbeiterSession' 14:59:39,748 INFO  [EjbModule] Undeployed MitarbeiterSession 14:59:39,748 INFO  [ProxyFactory] Unbind EJB Home 'AnredeEntity' from jndi 'AnredeEntity' 14:59:39,764 INFO  [EjbModule] Undeployed AnredeEntity 14:59:39,764 INFO  [ProxyFactory] Unbind EJB Home 'MitarbeiterEntity' from jndi 'MitarbeiterEntity' 14:59:39,764 INFO  [EjbModule] Undeployed MitarbeiterEntity 14:59:39,920 INFO  [EjbModule] Deploying MitarbeiterEntity 14:59:39,936 INFO  [EjbModule] Deploying AnredeEntity 14:59:39,951 INFO  [EjbModule] Deploying MitarbeiterSession 14:59:40,139 ERROR [MitarbeiterEntity#findSatzbyId] Encountered "OFFSET" at line 1, column 71. Was expecting one of:     <EOF>     "ASC" ...     "DESC" ...     "," ...     org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "OFFSET" at line 1, column 71. Was expecting one of:     <EOF>     "ASC" ...     "DESC" ...     "," ...         at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java:4360)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4237)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLParser.java:190)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:65)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.java:168)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:58)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:75)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:286)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:505)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)     at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)     at org.jboss.ejb.EjbModule.startService(EjbModule.java:414)     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)     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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)     at $Proxy0.start(Unknown Source)     at org.jboss.system.ServiceController.start(ServiceController.java:417)     at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy31.start(Unknown Source)     at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:662)     at sun.reflect.GeneratedMethodAccessor121.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)     at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)     at org.jboss.ws.integration.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:93)     at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)     at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy32.start(Unknown Source)     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)     at sun.reflect.GeneratedMethodAccessor18.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy9.deploy(Unknown Source)     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:610)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225) 14:59:40,139 WARN  [ServiceController] Problem starting service jboss.j2ee:service=EjbModule,module=MyEJB2Project.jar org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement for EJB 'MitarbeiterEntity': SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id OFFSET ?2 LIMIT ?3; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "OFFSET" at line 1, column 71. Was expecting one of:     <EOF>     "ASC" ...     "DESC" ...     "," ...     )     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:67)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.createEJBQLQuery(JDBCCommandFactory.java:75)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCQueryManager.start(JDBCQueryManager.java:286)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:505)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)     at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)     at org.jboss.ejb.EjbModule.startService(EjbModule.java:414)     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)     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.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)     at $Proxy0.start(Unknown Source)     at org.jboss.system.ServiceController.start(ServiceController.java:417)     at sun.reflect.GeneratedMethodAccessor9.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.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy31.start(Unknown Source)     at org.jboss.ejb.EJBDeployer.start(EJBDeployer.java:662)     at sun.reflect.GeneratedMethodAccessor121.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)     at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)     at org.jboss.ws.integration.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:93)     at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)     at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy32.start(Unknown Source)     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)     at sun.reflect.GeneratedMethodAccessor18.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.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)     at $Proxy9.deploy(Unknown Source)     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:610)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225) Caused by: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "OFFSET" at line 1, column 71. Was expecting one of:     <EOF>     "ASC" ...     "DESC" ...     "," ...         at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.generateParseException(EJBQLParser.java:4360)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.jj_consume_token(EJBQLParser.java:4237)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.EJBQL(EJBQLParser.java:190)     at org.jboss.ejb.plugins.cmp.ejbql.EJBQLParser.parse(EJBQLParser.java:65)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLCompiler.compileEJBQL(JDBCEJBQLCompiler.java:168)     at org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.<init>(JDBCEJBQLQuery.java:58)     ... 70 more 14:59:40,139 INFO  [EJBDeployer] Deployed: file:/C:/Programme/jboss-4.2.1.GA/server/default/deploy/MyEJB2Project.jar 14:59:40,186 ERROR [URLDeploymentScanner] Incomplete Deployment listing:   --- MBeans waiting for other MBeans --- ObjectName: jboss.j2ee:service=EjbModule,module=MyEJB2Project.jar   State: FAILED   Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement for EJB 'MitarbeiterEntity': SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id OFFSET ?2 LIMIT ?3; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "OFFSET" at line 1, column 71. Was expecting one of:     <EOF>     "ASC" ...     "DESC" ...     "," ...     )   --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss.j2ee:service=EjbModule,module=MyEJB2Project.jar   State: FAILED   Reason: org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement for EJB 'MitarbeiterEntity': SELECT OBJECT(p) FROM TabMitarbeiter AS p WHERE p.id>?1 ORDER BY p.id OFFSET ?2 LIMIT ?3; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "OFFSET" at line 1, column 71. Was expecting one of:     <EOF>     "ASC" ...     "DESC" ...     "," ...     )

Dann mal noch ne Frage zur "jbosscmp-jdbc.xml".... uhmm.... diese Datei habe ich gar nicht. Bei mir existiert nur die "ejb-jar.xml"...
Schaut so aus als wurde bei mir irgendwie nicht generiert....
Ist die denn unbedingt nötig?