cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: ESQL problem: Insert statement
Date Thu, 02 Nov 2000 18:40:55 GMT
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
> 
> 


Mime
View raw message