Same query, from DBVisualizer:
select * from where uid=werner
Marc Boorshtein wrote:
Well, I don't see any code that involves the jdbc-ldap bridge. can you try the query outside of a JSP page?
------------------------------------------------------------------------ --------------------------
Marc Boorshtein
Sr. Software Engineer, Octet String
marc.boorshtein@octetstring.com
On Aug 25, 2004, at 3:40 PM, Nic Werner wrote:
This is what I receive, the logs don't change from this error, this is just the dump I get back.
Note the index numbers change depending on the number of results I *should* get back, which shows to me it is a successful query.
- Nic. ----------
org.apache.jasper.JasperException: select * from ou=People,o=company,o=edu where uid=werner
: Index: 33, Size: 33
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.j ava:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: 295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic ationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil terChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal ve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal ve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato rBase.java:551)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.j ava:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav a:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV alve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav a:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve .java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java: 199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process Connection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java: 584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo l.java:683)
at java.lang.Thread.run(Thread.java:534)
*root cause*
javax.servlet.ServletException: select * from ou=People,o=company,o=edu where uid=werner
: Index: 33, Size: 33
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageConte xtImpl.java:531)
at org.apache.jsp.ldap_jsp._jspService(ldap_jsp.java:83)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.j ava:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java: 295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applic ationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFil terChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVal ve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextVal ve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticato rBase.java:551)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.j ava:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java: 2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.jav a:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherV alve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.jav a:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve .java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java: 199)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process Connection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java: 584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPoo l.java:683)
at java.lang.Thread.run(Thread.java:534)
Marc Boorshtein wrote:
try the logs directory. might be in catalina.out
---------------------------------------------------------------------- -- --------------------------
Marc Boorshtein
Sr. Software Engineer, Octet String
marc.boorshtein@octetstring.com
On Aug 24, 2004, at 4:35 PM, Nic Werner wrote:
I'm not sure how I would get a stack trace from Tomcat, is this just the output I receive from the error? It shows where the file had problems etc....if not I'll poke around harder..
- Nic.
Marc Boorshtein wrote:
is there a stack trace?
-------------------------------------------------------------------- -- -- --------------------------
Marc Boorshtein
Sr. Software Engineer, Octet String
marc.boorshtein@octetstring.com
On Aug 10, 2004, at 10:42 AM, Nic Werner wrote:
Greetings,
Whenever I do a query w/the Octet bridge, I get this error response back:
org.apache.jasper.JasperException: select cn from where uid=werner : Index: 1, Size: 1
The Index number is always the number of the results that are returned I've noticed, but no data.
I have my base specified in the connection url, so leaving the 'table' blank works, putting the base in as the 'table' as well gives me an LDAP 32: No object error.
If I leave my base blank in the connection URL and do:
select cn from ou=People,o=company,o=com where uid=werner
I still get the Index:1 Size:1 errror.
Any thoughts on this? Anyone is welcome to point out my obvious mistake(s)!
- Nic