Hello! We use JSTL 1.0 and have the following problem with sql update tag:
When SQL executes correctly all works fine, but when error occupier in SQL then any sql tags begins throwing the following exception: javax.servlet.jsp.JspException: SELECT TO_CHAR(dt, 'FXFMDD-MON-YYYY') news_date,headline,short_body,full_body,news_id FROM news WHERE news_type = 1 AND shop_id = 1 ORDER BY dt DESC : Closed Statement at org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTag Support.java:252) at jrun__templates__panels__panel22ejsp1c._jspService(jrun__templates__panels__ panel22ejsp1c.java:903) at jrun.jsp.runtime.HttpJSPServlet.service(HttpJSPServlet.java:43) at jrun.jsp.JSPServlet.service(JSPServlet.java:106) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:414 ) at jrun.servlet.JRunRequestDispatcher.include(JRunRequestDispatcher.java:348) at jrun.jsp.runtime.JRunPageContext.include(JRunPageContext.java:352) at org.apache.struts.taglib.tiles.InsertTag$InsertHandler.doEndTag(InsertTag.ja va:757) at org.apache.struts.taglib.tiles.InsertTag.doEndTag(InsertTag.java:369) Only restart of the server helps. App Server: JRun 4.0 Database driver: Oracle 8.17 think JDBC type 4 driver exmp of use: <sql:update var="delold" dataSource="${ds}"> INSERT INTO Users_Answers (quest_id, answer_id, anket_id, user_id, dt, answer) VALUES (?,?,?,?,SYSDATE,?) <sql:param value="1128"/> <sql:param value="cccc"/> <sql:param value="2"/> <sql:param value="202020"/> <sql:param value="Err"/> </sql:update> Datasource ds is set up using the following code: <% javax.naming.Context ctx = new javax.naming.InitialContext(); javax.sql.DataSource ds = (javax.sql.DataSource)ctx.lookup("ectaco"); application.setAttribute("ds",ds); %> Do Everyone know any solution to this problem? Thank you in advance. Best regards, Roman Kapshevich ICQ 2032093 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>