JSTL SQL Update tag problem

[Roman Kapshevich]

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]>