esql:get-string bug?

[Sascha Guscheh <sa...@irm.at>]

hi!

i'm using cocoon version cocoon-2.1.4 and an oracle database (xsp with esql)
and i encountered a strange behaviour:

<!-- snip -->
<esql:execute-query>
	<esql:query>
		SELECT
			doc_typ doc_typ,
		FROM DA
		WHERE id = <request:get-parameter name="id"/>
	</esql:query>
	<esql:results>
		<esql:row-results>
			<DOCUMENT_ARCHIVE>
				<DOC_TYP><esql:get-string column="doc_typ" /></DOC_TYP>
			</DOCUMENT_ARCHIVE>
		</esql:row-results>
	</esql:results>
	<esql:no-results>
		<DOCUMENT_ARCHIVE/>
	</esql:no-results>
</esql:execute-query>


and i always get this error:

org.apache.cocoon.ProcessingException: Language Exception:
org.apache.cocoon.components.language.LanguageException: Error compiling
contrarch_xml: ERROR 1 (org\apache\cocoon\www\archiver\contrarch_xml.java):
... XSPObjectHelper.xspExpr(contentHandler, // start error (lines 6424-6424)
"Syntax error on token ",", ")" expected" EsqlHelper.getAscii(,"doc_typ","")
// end error ); this.contentHandler.endElement( ... Line 6424, column 0:
Syntax error on token ",", ")" expected

the funny thing is .. it works when i use <esql:get-object column="doc_typ"
/> and it works when i use <esql:get-ascii column="doc_typ" />. when i check
with <esql:get-column-type-name column="1" /> it says it's of type VARCHAR2.

so my question is .. VARCHAR2 is not of type string?

kind regards, sascha


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org

Re: esql:get-string bug?

[Andreas Hartmann <an...@apache.org>]

Hi Sascha,

Sascha Guscheh schrieb:

[…]

> and i always get this error:
> 
> org.apache.cocoon.ProcessingException: Language Exception:
> org.apache.cocoon.components.language.LanguageException: Error compiling
> contrarch_xml: ERROR 1 (org\apache\cocoon\www\archiver\contrarch_xml.java):

you could take a look at the generated Java file (contrarch_xml.java). 
AFAIK it's located in the work directory of the servlet engine 
($TOMCAT_home/work/cocoon, /tmp/Jetty__8888__, etc.).

The generated code (lines 6424-6424) might give you a clue what's wrong.

-- Andreas

> ... XSPObjectHelper.xspExpr(contentHandler, // start error (lines 6424-6424)
> "Syntax error on token ",", ")" expected" EsqlHelper.getAscii(,"doc_typ","")
> // end error ); this.contentHandler.endElement( ... Line 6424, column 0:
> Syntax error on token ",", ")" expected
> 
> the funny thing is .. it works when i use <esql:get-object column="doc_typ"
> /> and it works when i use <esql:get-ascii column="doc_typ" />. when i check
> with <esql:get-column-type-name column="1" /> it says it's of type VARCHAR2.
> 
> so my question is .. VARCHAR2 is not of type string?
> 
> kind regards, sascha


-- 
Andreas Hartmann, CTO
BeCompany GmbH
http://www.becompany.ch
Tel.: +41 (0) 43 818 57 01


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org