You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Tako Molanus <mo...@yahoo.com> on 2000/11/02 08:18:10 UTC
Re: ESQL problem: Insert statement
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!?
Re: ESQL problem: Insert statement
Posted by Donald Ball <ba...@webslingerZ.com>.
On Wed, 1 Nov 2000, Tako Molanus wrote:
> 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).
hmm... now, can you post the generated java source code?
- donald
> 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!?
> >From homework help to love advice, Yahoo! Experts has your answer.
> http://experts.yahoo.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
>