Deploying EJBs

[Former Member]

<PRE>

Dear All,

When i am trying to deploy EAR (Which consists of EJB), i am getting the below exception

Please advice

Jun 12, 2010 12:37:40 PM /userOut/deploy (com.sap.ide.eclipse.sdm.threading.DeployThreadManager) [Thread[Deploy Thread,5,main]] ERROR:

[001]Deployment aborted

Settings

SDM host : evoepdevp

SDM port : 50018

URL to deploy : file:/C:/DOCUME_1/ADMINI1/LOCALS~1/Temp/temp30071PPSCostCenterEAR.ear

Result

=> deployment aborted : file:/C:/DOCUME_1/ADMINI1/LOCALS~1/Temp/temp30071PPSCostCenterEAR.ear

Aborted: development component 'PPSCostCenterEAR'/'sap.com'/'localhost'/'2010.06.12.12.37.13'/'0':Caught exception during application

deployment from SAP J2EE Engine's deploy service:java.rmi.RemoteException: Cannot deploy application sap.com/PPSCostCenterEAR.. Reason:

Incorrect QL query: , errors: line 1: expecting "select", found '<end-of-query>'line 1: expecting "from", found '<end-of-query>'.; nested

exception is: com.sap.engine.services.deploy.container.DeploymentException: <--Localization failed:

ResourceBundle='com.sap.engine.services.deploy.DeployResourceBundle',

ID='com.sap.engine.services.ejb.exceptions.deployment.EJBDeploymentException: Incorrect QL query: , errors: line 1: expecting "select", found

'<end-of-query>'line 1: expecting "from", found '<end-of-query>'. at

com.sap.engine.services.ejb.deploy.ejbql.QLTranslator.prepareQLContext(QLTranslator.java:191) at

com.sap.engine.services.ejb.deploy.ejbql.QLTranslator.translateQuery(QLTranslator.java:103) at

com.sap.engine.services.ejb.deploy.ejbql.QLTranslator.translateAllQueries(QLTranslator.java:171) at

com.sap.engine.services.ejb.deploy.DeployAdmin.translateQL(DeployAdmin.java:1271) at

com.sap.engine.services.ejb.deploy.DeltaDeployAdmin.makeUpdate(DeltaDeployAdmin.java:177) at

com.sap.engine.services.ejb.EJBAdmin.makeUpdate(EJBAdmin.java:558) at

com.sap.engine.services.deploy.server.application.UpdateTransaction.makeComponents(UpdateTransaction.java:400) at

com.sap.engine.services.deploy.server.application.DeployUtilTransaction.commonBegin(DeployUtilTransaction.java:321) at

com.sap.engine.services.deploy.server.application.UpdateTransaction.begin(UpdateTransaction.java:164) at

com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:292) at

com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhases(ApplicationTransaction.java:326) at

com.sap.engine.services.deploy.server.DeployServiceImpl.makeGlobalTransaction(DeployServiceImpl.java:3186) at

com.sap.engine.services.deploy.server.DeployServiceImpl.update(DeployServiceImpl.java:671) at

com.sap.engine.services.deploy.server.DeployServiceImplp4_Skel.dispatch(DeployServiceImplp4_Skel.java:1278) at

com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:319) at

com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:200) at

com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:136) at

com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at

com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at

java.security.AccessController.doPrivileged(AccessController.java:219) at

com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104) at

com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)', Arguments: []--> : Can't find resource for bundle

java.util.PropertyResourceBundle, key com.sap.engine.services.ejb.exceptions.deployment.EJBDeploymentException: Incorrect QL query: ,

errors: line 1: expecting "select", found '<end-of-query>'line 1: expecting "from", found '<end-of-query>'. at

com.sap.engine.services.ejb.deploy.ejbql.QLTranslator.prepareQLContext(QLTranslator.java:191) at

com.sap.engine.services.ejb.deploy.ejbql.QLTranslator.translateQuery(QLTranslator.java:103) at

com.sap.engine.services.ejb.deploy.ejbql.QLTranslator.translateAllQueries(QLTranslator.java:171) at

com.sap.engine.services.ejb.deploy.DeployAdmin.translateQL(DeployAdmin.java:1271) at

com.sap.engine.services.ejb.deploy.DeltaDeployAdmin.makeUpdate(DeltaDeployAdmin.java:177) at

com.sap.engine.services.ejb.EJBAdmin.makeUpdate(EJBAdmin.java:558) at

com.sap.engine.services.deploy.server.application.UpdateTransaction.makeComponents(UpdateTransaction.java:400) at

com.sap.engine.services.deploy.server.application.DeployUtilTransaction.commonBegin(DeployUtilTransaction.java:321) at

com.sap.engine.services.deploy.server.application.UpdateTransaction.begin(UpdateTransaction.java:164) at

com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:292) at

com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhases(ApplicationTransaction.java:326) at

com.sap.engine.services.deploy.server.DeployServiceImpl.makeGlobalTransaction(DeployServiceImpl.java:3186) at

com.sap.engine.services.deploy.server.DeployServiceImpl.update(DeployServiceImpl.java:671) at

com.sap.engine.services.deploy.server.DeployServiceImplp4_Skel.dispatch(DeployServiceImplp4_Skel.java:1278) at

com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:319) at

com.sap.engine.services.rmi_p4.DispatchImpl._run(DispatchImpl.java:200) at

com.sap.engine.services.rmi_p4.server.P4SessionProcessor.request(P4SessionProcessor.java:136) at

com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at

com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at

java.security.AccessController.doPrivileged(AccessController.java:219) at

com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104) at

com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176) (message ID:

com.sap.sdm.serverext.servertype.inqmy.extern.EngineApplOnlineDeployerImpl.performAction(DeploymentActionTypes).REMEXC)

Deployment exception : The deployment of at least one item aborted

</PRE>

[Former Member]

Even after making necessary changes to EJB/SQL QL as per your suggestion

I am still getting the same above exception. Please advice

[Former Member]

Hi Hari.

I don't know exactly what your problem is, but you could review the section: "11.2.6.9 Like Expressions" of the Enterprise JavaBeansTM Specification, Version 2.1 file. ([Link|http://jcp.org/aboutJava/communityprocess/final/jsr153/index.html]) .

May be you are not considering some rules when you create a LIKE expression.

Here an excerpt of this part.

cmp_path_expression [NOT] LIKE pattern_value [ESCAPE escape_character]

The pattern_value is a string literal or a string-valued input parameter in which an underscore (_) stands for any single character, a percent (%) characterstands for any sequence of characters (including the empty sequence), and all other characters stand forthemselves.

Examples are:

u2022 address.phone LIKE u201812%3u2019 is true for u2018123u2019 u201812993u2019 and false for u20181234u2019

u2022 asentence.word LIKE u2018l_seu2019 is true for u2018loseu2019 and false for u2018looseu2019

u2022 aword.underscored LIKE u2018\_%u2019 ESCAPE u2018\u2019 is true for u2018_foou2019 and false for u2018baru2019

u2022 address.phone NOT LIKE u201812%3u2019 is false for u2018123u2019 and u201812993u2019 and true for u20181234u2019

If the value of the cmp_path_expression or pattern_value is NULL or unknown, the value of the LIKE

expression is unknown. If the escape_character is specified and is NULL, the value of the LIKE expression

is unknown.

Have a great day.

Manuel Loayza Gahona

SCEA

[Former Member]

Intially i tried with EJB QL

EJB QL: SELECT object (b) FROM PPSCostCenter AS b WHERE b.circleID LIKE ?1

Later i changed it to SQL QL

SQL QL: SELECT * FROM TMP_PPSCOSTCENTER WHERE circleID LIKE ?

Still getting the same above exception.

Please advice

[snehal_kendre]

Hi

try to change EJB ql to

EJB QL: SELECT object (b) FROM PPSCostCenter b WHERE b.circleID LIKE ?1

i have removed 'AS' and i think 'PPSCostCenter' is name of your data bean. please check its exact name.

and if you want to use sql query

SQL QL: SELECT * FROM TMP_PPSCOSTCENTER WHERE TMP_PPSCOSTCENTER.circleID LIKE

[snehal_kendre]

Hi Hari,

Incorrect QL query: , errors: line 1: expecting "select", found ''line 1: expecting "from", found ''.;

May be there is a problem in your EJB ql?

Please post your EJB ql or sql QL you are using. it will be more helpful.