• letternumber
  • NEWBIE
  • 0 Points
  • Member since 2009

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 1
    Replies

I am trying to select records owned by a certain user but am getting an error:

 

 Cannot use a polymorphic key for outer field for semi join

 

here is my query:

 

SELECT Name, Id, OwnerId
FROM lead
WHERE OwnerId in (SELECT id FROM user WHERE Username like 'xxx@xxx.com')

My first attempts at logging in through java using the basic code from the quickstart section of the api worked fine.  When I run the code as a static method it logs in successfully.  When I put the code into my project and try to deploy it to an easerver it no longer connects to salesforce.

The first error I got was:  java.lang.ExceptionInInitializerError

I got rid of that error by changing commons-logging-1.0.4 to version 1.1.1 and got a new error:

 

java.lang.ClassCastException: org.apache.axis.attachments.AttachmentsImpl

 

I fixed that by updating to axis 1.4. now I am getting:

 

java.lang.NoClassDefFoundError

Mar 02 14:51:25 2009: java.lang.NoClassDefFoundError
Mar 02 14:51:25 2009:         at org.apache.axis.handlers.BasicHandler.<clinit>(BasicHandler.java:43)
Mar 02 14:51:25 2009:         at java.lang.Class.forName0(Native Method)
Mar 02 14:51:25 2009:         at java.lang.Class.forName(Class.java:242)
Mar 02 14:51:25 2009:         at org.apache.axis.utils.ClassUtils$2.run(ClassUtils.java:168)
Mar 02 14:51:25 2009:         at java.security.AccessController.doPrivileged(Native Method)
Mar 02 14:51:25 2009:         at org.apache.axis.utils.ClassUtils.loadClass(ClassUtils.java:160)
Mar 02 14:51:25 2009:         at org.apache.axis.utils.ClassUtils.forName(ClassUtils.java:100)
Mar 02 14:51:25 2009:         at org.apache.axis.deployment.wsdd.WSDDTargetedChain.makeNewInstance(WSDDTargetedChain.java:157)
Mar 02 14:51:25 2009:         at org.apache.axis.deployment.wsdd.WSDDDeployableItem.getNewInstance(WSDDDeployableItem.java:274)
Mar 02 14:51:25 2009:         at org.apache.axis.deployment.wsdd.WSDDDeployableItem.getInstance(WSDDDeployableItem.java:260)
Mar 02 14:51:25 2009:         at org.apache.axis.deployment.wsdd.WSDDDeployment.getTransport(WSDDDeployment.java:410)
Mar 02 14:51:25 2009:         at org.apache.axis.configuration.FileProvider.getTransport(FileProvider.java:257)
Mar 02 14:51:25 2009:         at org.apache.axis.AxisEngine.getTransport(AxisEngine.java:332)
Mar 02 14:51:25 2009:         at org.apache.axis.client.AxisClient.invoke(AxisClient.java:163)
Mar 02 14:51:25 2009:         at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
Mar 02 14:51:25 2009:         at org.apache.axis.client.Call.invoke(Call.java:2767)
Mar 02 14:51:25 2009:         at org.apache.axis.client.Call.invoke(Call.java:2443)
Mar 02 14:51:25 2009:         at org.apache.axis.client.Call.invoke(Call.java:2366)
Mar 02 14:51:25 2009:         at org.apache.axis.client.Call.invoke(Call.java:1812)
Mar 02 14:51:25 2009:         at com.sforce.soap.enterprise.SoapBindingStub.login(SoapBindingStub.java:3138)
Mar 02 14:51:25 2009:         at com.sybase.it.web.www.portal.valueobjects.SalesForceVO.login(SalesForceVO.java:135)
Mar 02 14:51:25 2009:         at com.sybase.it.web.www.portal.valueobjects.SalesForceVO.<init>(SalesForceVO.java:39)
Mar 02 14:51:25 2009:         at com.sybase.it.web.www.portal.valueobjects.PortletItemsVO.findByUserTypeAndParameters
(PortletItemsVO.java:61)
Mar 02 14:51:25 2009:         at com.sybase.it.web.www.portal.PortletLookupListener.getPortletItems(PortletLookupListener.java:63)
Mar 02 14:51:25 2009:         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Mar 02 14:51:25 2009:         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
Mar 02 14:51:25 2009:         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Mar 02 14:51:25 2009:         at java.lang.reflect.Method.invoke(Method.java:585)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.lang.jstl.ArraySuffix.evaluate(ArraySuffix.java:317)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.lang.jstl.ComplexValue.evaluate(ComplexValue.java:146)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:242)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.lang.jstl.ELEvaluator.evaluate(ELEvaluator.java:201)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:138)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.lang.jstl.Evaluator.evaluate(Evaluator.java:166)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.lang.support.ExpressionEvaluatorManager.evaluate(ExpressionEvaluatorManager.java:112)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.tag.el.core.ExpressionUtil.evalNotNull(ExpressionUtil.java:85)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.tag.el.core.SetTag.evaluateExpressions(SetTag.java:147)
Mar 02 14:51:25 2009:         at org.apache.taglibs.standard.tag.el.core.SetTag.doStartTag(SetTag.java:95)
Mar 02 14:51:25 2009:         at com.sybase.jsp.partnerportal_0005fajaxPortletLookupListener$jsp._jspService(partnerportal_0005fajaxPortletLookupListener$jsp.java:511)
Mar 02 14:51:25 2009:         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
Mar 02 14:51:25 2009:         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
Mar 02 14:51:25 2009:         at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:299)
Mar 02 14:51:25 2009:         at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:492)
Mar 02 14:51:25 2009:         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:584)
Mar 02 14:51:25 2009:         at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
Mar 02 14:51:25 2009:         at

com.sybase.jaguar.servlet.JagServlet.service(JagServlet.java:718)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet.JagRequestDispatcher.service(JagRequestDispatcher.java:971)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet.JagWebResource.service(JagWebResource.java:90)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet.JagFilterChain.doFilter(JagFilterChain.java:133)
Mar 02 14:51:25 2009:         at com.sybase.it.web.www.navigation.PartnerUrlFilter.doFilter(PartnerUrlFilter.java:204)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet.JagFilterChain.doFilter(JagFilterChain.java:107)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet.ServletEngine._service(ServletEngine.java:867)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet.ServletEngine.service(ServletEngine.java:365)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet.ServletServiceImpl.doService(ServletServiceImpl.java:58)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet._sk_JaguarServlet_ServletService.remoteInvoke(_sk_JaguarServlet_ServletService.java:218)
Mar 02 14:51:25 2009:         at com.sybase.jaguar.servlet._sk_JaguarServlet_ServletService.invoke(_sk_JaguarServlet_ServletService.java:125)

 

Any help would be greatly appreciated.

I'm trying to compile a project that pulls some information from salesforce but get an out of memory error during the compile.  If I put the code in a standalone project and run it in a static main it works fine.  If i add it to the existing project and call it I get the oom error when compiling the salesforce packages generated from the wsdl file.

 

I have increased my heap size: -vmargs -Xms512M -Xmx1024M  with no effect.

 

This is the error message I get in the console window of eclipse:

 

 [javac] C:\SourceControl\mysybase\web_mainline\partner_portal\webapp\src\com\sforce\soap\enterprise\SoapBindingStub.java:1096: warning: [unchecked] unchecked call to add(E) as a member of the raw type java.util.Vector
    [javac] cachedSerClasses.add(cls);
    [javac] ^
    [javac] The system is out of resources.
    [javac] Consult the following stack trace for details.
    [javac] java.lang.OutOfMemoryError: Java heap space

 

 

Any help would be greatly appreciated.

I am trying to select records owned by a certain user but am getting an error:

 

 Cannot use a polymorphic key for outer field for semi join

 

here is my query:

 

SELECT Name, Id, OwnerId
FROM lead
WHERE OwnerId in (SELECT id FROM user WHERE Username like 'xxx@xxx.com')