You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "Schwartz, David (CHR)" <Da...@pfizer.com> on 2003/06/04 21:51:28 UTC
RE: JSTL problem (was Oracle Type 4 Driver)
Now I have the taglib declaration working & get this...
org.apache.jasper.JasperException: java.sql.SQLException: invalid arguments
in call
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:2
54)
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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.StandardContext.invoke(StandardContext.java:2415)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.invok
eNext(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:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
at java.lang.Thread.run(Thread.java:536)
root cause
javax.servlet.ServletException: java.sql.SQLException: invalid arguments in
call
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:533)
at org.apache.jsp.oracle_jsp._jspService(oracle_jsp.java:223)
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.java:2
10)
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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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(StandardContextValve.ja
va:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.StandardContext.invoke(StandardContext.java:2415)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(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.invok
eNext(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:223)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
at java.lang.Thread.run(Thread.java:536)
when I run this...
<%@ page import="java.sql.*"%>
<%@ taglib prefix="sql" uri="/WEB-INF/taglibs-dbtags.tld" %>
<sql:connection id="conn1">
<sql:url>jdbc:oracle:thin:xxxxx:1521:yyyy</sql:url>
<sql:driver>oracle.jdbc.driver.OracleDriver</sql:driver>
</sql:connection>
<%-- open a database query --%>
<table>
<sql:statement id="stmt1" conn="conn1">
<sql:query>
select * from publication
</sql:query>
<%-- loop through the rows of your query --%>
<sql:resultSet id="rset2">
<tr>
<td><sql:getColumn position="1"/></td>
<td><sql:getColumn position="2"/></td>
<td><sql:getColumn position="3"/>
<sql:wasNull>[no description]</sql:wasNull></td>
</tr>
</sql:resultSet>
</sql:statement>
</table>
<%-- close a database connection --%>
<sql:closeConnection conn="conn1"/>
-----Original Message-----
From: David N. Foote [mailto:davidf@pervasent.com]
Sent: Friday, May 30, 2003 1:09 PM
To: Tomcat Users List
Subject: JSTL problem (was Oracle Type 4 Driver)
David,
I don't think I can help you without seeing some error message. Just
knowing that index.jhtml doesn't work isn't enough to go on.
David
----- Original Message -----
From: "Schwartz, David (CHR)" <Da...@pfizer.com>
To: "'Tomcat Users List'" <to...@jakarta.apache.org>
Sent: Friday, May 30, 2003 4:14 AM
Subject: RE: Oracle Type 4 Driver
> Thanks for the offer.
>
> Here's my web.xml...
>
> <?xml version="1.0" encoding="ISO-8859-1"?>
> <!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web
Application
> 2.3//EN"
> "http://java.sun.com/dtd/web-app_2_3.dtd">
>
> <web-app>
> <servlet>
> <servlet-name>HelloWorld</servlet-name>
> <servlet-class>HelloWorld</servlet-class>
> </servlet>
>
> <servlet-mapping>
> <servlet-name>HelloWorld</servlet-name>
> <url-pattern>/HelloWorld</url-pattern>
> </servlet-mapping>
>
>
> <servlet>
> <servlet-name>x</servlet-name>
> <servlet-class>x</servlet-class>
> </servlet>
>
> <servlet-mapping>
> <servlet-name>x</servlet-name>
> <url-pattern>/x</url-pattern>
> </servlet-mapping>
>
>
> <servlet>
> <servlet-name>HelloTest</servlet-name>
> <servlet-class>HelloTest</servlet-class>
> </servlet>
>
> <servlet-mapping>
> <servlet-name>HelloTest</servlet-name>
> <url-pattern>/HelloTest</url-pattern>
> </servlet-mapping>
>
> <servlet>
> <servlet-name>Params</servlet-name>
> <servlet-class>Params</servlet-class>
> </servlet>
>
> <servlet-mapping>
> <servlet-name>Params</servlet-name>
> <url-pattern>/Params</url-pattern>
> </servlet-mapping>
>
> <servlet>
> <servlet-name>ParamsShow</servlet-name>
> <servlet-class>ParamsShow</servlet-class>
> </servlet>
>
> <servlet-mapping>
> <servlet-name>ParamsShow</servlet-name>
> <url-pattern>/ParamsShow</url-pattern>
> </servlet-mapping>
>
> <servlet>
> <servlet-name>SimpleBean</servlet-name>
> <servlet-class>SimpleBean</servlet-class>
> </servlet>
>
> <servlet-mapping>
> <servlet-name>SimpleBean</servlet-name>
> <url-pattern>/SimpleBean</url-pattern>
> </servlet-mapping>
>
> <servlet>
> <servlet-name>Employee</servlet-name>
> <servlet-class>Employee</servlet-class>
> </servlet>
>
> <servlet-mapping>
> <servlet-name>Employee</servlet-name>
> <url-pattern>/Employee</url-pattern>
> </servlet-mapping>
>
>
> <taglib>
> <taglib-uri>http://java.sun.com/jstl/fmt</taglib-uri>
> <taglib-location>/WEB-INF/fmt.tld</taglib-location>
> </taglib>
>
> <taglib>
> <taglib-uri>http://java.sun.com/jstl/core</taglib-uri>
> <taglib-location>/WEB-INF/c.tld</taglib-location>
> </taglib>
>
> <taglib>
> <taglib-uri>http://java.sun.com/jstl/sql</taglib-uri>
> <taglib-location>/WEB-INF/sql.tld</taglib-location>
> </taglib>
>
> <taglib>
> <taglib-uri>http://java.sun.com/jstl/x</taglib-uri>
> <taglib-location>/WEB-INF/x.tld</taglib-location>
> </taglib>
>
> <taglib>
>
> <taglib-uri>http://jakarta.apache.org/taglibs/dbtags</taglib-uri>
> <taglib-location>/WEB-INF/dbtags.tld</taglib-location>
> </taglib>
>
> </web-app>
>
> when the taglib tags are there then tomcat does not work. Meaning I cant
> even run index.jsp.
> As soon as i remove the <taglib> tags tomcat works.
> Any ideas?
>
> -----Original Message-----
> From: David N. Foote [mailto:davidf@pervasent.com]
> Sent: Thursday, May 29, 2003 3:21 PM
> To: Tomcat Users List
> Subject: Re: Oracle Type 4 Driver
>
>
> David,
>
> I took a look at your web.xml and it looked good. The only other things I
> can think of that have to be there for this to work are as follows:
>
>
> Your WEB-INF/lib directory has to have these jars from the
> jakarta-taglibs\standard-1.0.3\lib directory:
>
> dom.jar jaxp-api.jar jstl.jar saxpath.jar xalan.jar
> jaxen-full.jar jdbc2_0-stdext.jar sax.jar standard.jar xercesImpl.jar
>
> and your WEB-INF directory has to have the tld's:
>
> c.tld fmt.tld sql.tld x.tld
>
> If you want to give more specific info about how Tomcat isn't working
(error
> message) I can take a stab.
>
> David
>
>
> ----- Original Message -----
> From: "Schwartz, David (CHR)" <Da...@pfizer.com>
> To: "'Tomcat Users List'" <to...@jakarta.apache.org>
> Sent: Thursday, May 29, 2003 11:47 AM
> Subject: RE: Oracle Type 4 Driver
>
>
> > David,
> > i have it as the last element, after all others.
> > Any other ideas? I'd love to get it up!
> >
> > -----Original Message-----
> > From: David N. Foote [mailto:davidf@pervasent.com]
> > Sent: Thursday, May 29, 2003 2:36 PM
> > To: Tomcat Users List
> > Subject: Re: Oracle Type 4 Driver
> >
> >
> > David,
> >
> > You might be having trouble with where you inserted the taglib tags in
> your
> > web.xml. The following fragment from web-app_2_3.dtd is key.
> >
> > <!ELEMENT web-app (icon?, display-name?, description?, distributable?,
> > context-param*, filter*, filter-mapping*, listener*, servlet*,
> > servlet-mapping*, session-config?, mime-mapping*, welcome-file-list?,
> > error-page*, taglib*, resource-env-ref*, resource-ref*,
> > security-constraint*, login-config?, security-role*, env-entry*,
ejb-ref*,
> > ejb-local-ref*)>
> > notice that taglib tags must occur within the web-app tag, after any
icon,
> > display-name, description, distributable, context-param, filter,
> > filter-mapping, listener, servlet, servlet-mapping, session-config,
> > mime-mapping, welcome-file-list, or error-page tags and before any
> > resource-env-ref, resource-ref, security-constraint, login-config,
> > security-role, env-entry, ejb-ref, ejb-local-ref tags.
> >
> > David
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ----- Original Message -----
> > From: "Schwartz, David (CHR)" <Da...@pfizer.com>
> > To: "'Tomcat Users List'" <to...@jakarta.apache.org>
> > Sent: Thursday, May 29, 2003 7:04 AM
> > Subject: RE: Oracle Type 4 Driver
> >
> >
> > > Yes.
> > > Also, very weird - when the <taglib> tag is in the web.xml file Tomcat
> > does
> > > NOT work properly.
> > >
> > >
> > > -----Original Message-----
> > > From: Jason Bainbridge [mailto:jason@jblinux.org]
> > > Sent: Thursday, May 29, 2003 10:01 AM
> > > To: Tomcat Users List
> > > Subject: Re: Oracle Type 4 Driver
> > >
> > >
> > > On Thu, 29 May 2003 21:32, Schwartz, David (CHR) wrote:
> > > > I added the <taglib> tags to web.xml (below) but still no go!
> > > >
> > > > <taglib>
> > > > <taglib-uri>http://java.sun.com/jstl/sql</taglib-uri>
> > > > <taglib-location>/WEB-INF/sql.tld</taglib-location>
> > > > </taglib>
> > >
> > > Do you have the sql.tld file in your WEB-INF directory?
> > >
> > > Regards,
> > > --
> > > Jason Bainbridge
> > > KDE Web Team - http://kde.org
> > > webmaster@kde.org
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> > >
> > > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org