Yikes I don't see anything wrong with your syntax, sorry! Thanks for the
terrific amount of detail. Has anyone else had this problem with ODBC?
- Morgan
On Tue, 19 Jun 2001, Emir Alikadic (ADNOC IS&T) wrote:
> Hiya all!
>
> I'm using JDBC taglib with MS SQL Server 6.5 and JDBC:ODBC bridge for our
> evaluation of J2EE. I'm able to retrieve data with no problem, but while
> attempting to insert data using preparedStatement, I constantly get the
> following error:
>
> -----
> Error: 500
> Location: /test/storedata.jsp
> Internal Servlet Error:
> javax.servlet.ServletException: java.sql.SQLException: General error
> at
> org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
> l.java:459)
> at
> _0002fstoredata_0002ejspstoredata_jsp_0._jspService(_0002fstoredata_0002ejsp
> storedata_jsp_0.java:1192)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
> va:177)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
> at org.apache.tomcat.core.Handler.service(Handler.java:286)
> at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
> 7)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> at
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
> (Ajp12ConnectionHandler.java:166)
> at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
> at java.lang.Thread.run(Thread.java:484)
> Root cause:
> javax.servlet.jsp.JspTagException: java.sql.SQLException: General error
> at
> org.apache.taglibs.jdbc.statement.ExecuteTag.doEndTag(ExecuteTag.java:111)
> at
> _0002fstoredata_0002ejspstoredata_jsp_0._jspService(_0002fstoredata_0002ejsp
> storedata_jsp_0.java:1132)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
> va:177)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
> at org.apache.tomcat.core.Handler.service(Handler.java:286)
> at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
> at
> org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79
> 7)
> at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
> at
> org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
> (Ajp12ConnectionHandler.java:166)
> at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
> at
> org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
> at java.lang.Thread.run(Thread.java:484)
> -----
>
> My web.xml contains necessary initParameters for DB connection details.
>
> The storedata.jsp is invoked by a form in dbentry.jsp. Here's complete code
> to storedata.jsp (actual table/parameter names changed for obvious reasons):
>
>
> <%@ page contentType="text/html; charset=iso-8859-1" %>
> <%@ taglib uri="http://jakarta.apache.org/taglibs/jdbc"; prefix="sql" %>
>
> <!DOCTYPE html public "-//W3C//DTD HTML 4.01 Transitional//EN">
> <HTML>
> <%@ include file="header.inc" %>
> <BODY>
>
> <sql:connection id="conn0">
> <sql:url initParameter="dbURL"/>
> <sql:driver initParameter="dbDriver"/>
> <sql:userId initParameter="dbUser"/>
> <sql:password initParameter="dbPasswd"/>
> </sql:connection>
>
> <sql:preparedStatement id="pstmt0" conn="conn0">
> <sql:query>
> INSERT INTO mytable VALUES (?, ?, ?)
> </sql:query>
> <sql:execute>
> <sql:setColumn position="1"><%= request.getParameter("param1")
> %></sql:setColumn>
> <sql:setColumn position="2"><%= request.getParameter("param2")
> %></sql:setColumn>
> <sql:setColumn position="3"><%= request.getParameter("param3")
> %></sql:setColumn>
> </sql:execute>
> </sql:preparedStatement>
>
> <sql:closeConnection conn="conn0"/>
>
> <P>Client info succefully stored!</P>
> <%@ include file="copyright.inc" %>
> </BODY>
> </HTML>
>
>
> I'd appreciate any help on this.
>
> Regards,
>
>
>
> Emir Alikadic
>
