cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tako Molanus <molan...@yahoo.com>
Subject Re: ESQL problem: Insert statement
Date Thu, 02 Nov 2000 07:18:10 GMT
Sure, see below. I also included the source of the xml
(test) file.

What I failed to mention in my original posting is
that the row is actually inserted. But I don't like
receiving the error message, especially since I want
to embed a second insert statement that makes use of
the Oracle sequence called in the first statement.
And the error will probably cause the script to ignore
the embedded statement (although I haven't actually
tried this yet).

Tako Molanus

> Hi there,
> 
> When I try to insert a row through into a table
> through ESQL I get an error message from my Oracle
> database:
> ORA-01007: variable not in select list 
> 
> This does not happen when I use SQL.

can you post a full stacktrace?

- donald


ORA-01007: variable not in select list
java.sql.SQLException: ORA-01007: variable not in
select list at
oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:181)
at
oracle.jdbc.ttc7.Odscrarr.receive(Odscrarr.java:241)
at
oracle.jdbc.ttc7.TTC7Protocol.describe(TTC7Protocol.java:467)
at
oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:2537)
at
oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:23)
at
oracle.jdbc.driver.OracleResultSet.getMetaData(OracleResultSet.java:506)
at
_C_._Apache._cocoon_1_8._cocoon_1_8._samples._Tako._ESQLtest_ins._esql_execute_query_N6025e7(_ESQLtest_ins.java:98)
at
_C_._Apache._cocoon_1_8._cocoon_1_8._samples._Tako._ESQLtest_ins.populateDocument(_ESQLtest_ins.java:258)
at
org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:96)
at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:494)
at org.apache.cocoon.Engine.handle(Engine.java:359) at
org.apache.cocoon.Cocoon.service(Cocoon.java:167) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:314)
at
org.apache.jserv.JServConnection.run(JServConnection.java:188)
at java.lang.Thread.run(Thread.java:484)



XML file:

<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?cocoon-process type="xslt"?>
<?xml-stylesheet href="esqltest.xsl" type="text/xsl"?>


<xsp:page
  language="java"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>

<page>
<test>fsdtt</test>
<esql:execute-query>
  <esql:use-connection>wpf</esql:use-connection>
  <esql:query>insert into esqltest (a) values
(8)</esql:query>
  <esql:results>
  </esql:results>
  <esql:no-results>
    <error>no results were found</error>
  </esql:no-results>
  <esql:error-results>
    <message><esql:get-message/></message>
    <stacktrace><esql:get-stacktrace/></stacktrace>
  </esql:error-results>
</esql:execute-query>

</page>

</xsp:page>


__________________________________________________
Do You Yahoo!?
Mime
View raw message