are your credentials correct?
jdbc:ldap://ldaps.ldapserver.com?SECURE:=TRUE&SEARCH_SCOPE: =subTreeScope&CACHE_STATEMENT:=true
Marc Boorshtein wrote:
whats the url look like?
---------------------------------------------------------------------- -- --------------------------
Marc Boorshtein
Sr. Software Engineer, Octet String
marc.boorshtein@octetstring.com
On Aug 26, 2004, at 4:02 PM, Nic Werner wrote:
Same query, from DBVisualizer:
select * from where uid=werner
javax.naming.InvalidNameException: ldaps.ldapserver.com: [LDAP: error code 34 - invalid DN]; remaining name 'ldaps.ldapserver.com'
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2926)
at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2740)
at com.sun.jndi.ldap.LdapCtx.c_lookup(LdapCtx.java:998)
at com.sun.jndi.toolkit.ctx.ComponentContext.p_lookup(ComponentContext.j av a:526)
at com.sun.jndi.toolkit.ctx.PartialCompositeContext.lookup(PartialCompos it eContext.java:155)
at com.sun.jndi.toolkit.ctx.PartialCompositeContext.lookup(PartialCompos it eContext.java:144)
at javax.naming.InitialContext.lookup(InitialContext.java:347)
at com.octetstring.jdbcLdap.jndi.JndiLdapConnection.isClosed(JndiLdapCon ne ction.java:270)
at com.onseven.dbvis.sql.Database.isConnected(Unknown Source)
at com.onseven.dbvis.sql.Database.getCatalog(Unknown Source)
at com.onseven.dbvis.sql.Selector.setCurrentCatalog(Unknown Source)
at com.onseven.dbvis.sql.Selector.execute(Unknown Source)
at com.onseven.dbvis.sql.Selector.execute(Unknown Source)
at com.onseven.dbvis.executor.ExecutorHandler.execute(Unknown Source)
at com.onseven.dbvis.executor.ExecutorHandler.access$1000(Unknown Source)
at com.onseven.dbvis.executor.ExecutorHandler$ExecutorThread.construct(U nk nown Source)
at se.pureit.swing.util.SwingWorker$2.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
java.lang.IndexOutOfBoundsException: Index: 33, Size: 33
at java.util.LinkedList.entry(LinkedList.java:360)
at java.util.LinkedList.get(LinkedList.java:303)
at com.octetstring.jdbcLdap.sql.JdbcLdapMetaData.getCatalogName(JdbcLdap Me taData.java:41)
at com.octetstring.jdbcLdap.sql.JdbcLdapMetaData.getColumnName(JdbcLdapM et aData.java:62)
at com.onseven.dbvis.sql.ColumnInfo.<init>(Unknown Source)
at com.onseven.dbvis.sql.JDBCModel.setColumnsFromResultSet(Unknown Source)
at com.onseven.dbvis.sql.Selector.fetchData(Unknown Source)
at com.onseven.dbvis.sql.Selector.execute(Unknown Source)
at com.onseven.dbvis.sql.Selector.execute(Unknown Source)
at com.onseven.dbvis.executor.ExecutorHandler.execute(Unknown Source)
at com.onseven.dbvis.executor.ExecutorHandler.access$1000(Unknown Source)
at com.onseven.dbvis.executor.ExecutorHandler$ExecutorThread.construct(U nk nown Source)
at se.pureit.swing.util.SwingWorker$2.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
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(JspServletWrapp er .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(Ap pl ic ationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio nF il terChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrappe rV al ve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContex tV al ve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenti ca to rBase.java:551)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVal ve .j ava:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.jav a: 2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve .j av a:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatc he rV alve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve .j av a:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineV al ve .java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 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.ja va : 828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.pro ce ss Connection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.ja va : 584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Threa dP oo 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(PageC on te 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(JspServletWrapp er .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(Ap pl ic ationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicatio nF il terChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrappe rV al ve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContex tV al ve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenti ca to rBase.java:551)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVal ve .j ava:246)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.jav a: 2422)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve .j av a:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatc he rV alve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve .j av a:163)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java: 995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineV al ve .java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveCont ex t. invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.j av a: 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.ja va : 828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.pro ce ss Connection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.ja va : 584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Threa dP oo 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