Cocoon 2.0.3 ESQL PreparedStatment: maybe not working?
Hi, I have cocoon 2.0.3 installed and I want to use esql. In the documentation is written that esql _also supports_ prepared statment. So I have written a small db-access-page to insert something into my db. But if i try to insert something with an ' in it, it doesnt work. I get an error-message that the sql-statment isnt correct. I would say, that esql:query isnt transformed into an perparedstamtent... May Question: How can I activate in cocoon that esql is using preparedstatment? cu, Christian - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
How do i change the Encoding of the produced files by the TextSerializer
Hi,
i want to create csv-Files by using the TextSerializer. My problem
is, that i have to encode the produzed csv-file in ISO-8859-1.
I am using:
* java 1.4.0_01
* tomcat 4.0.4
* xml-cocoon2_20020712041726.tar.gz
I tried to set in my main-sitemap the encoding:
map:serializer logger=sitemap.serializer.text
mime-type=text/text name=text
src=org.apache.cocoon.serialization.TextSerializer
encodingISO-8859-1/encoding
/map:serializer
But it didnt help. The produced file is UTF-8 encoded.
So i tried to set in my subsitemap the encoding:
map:serializer logger=sitemap.serializer.text
mime-type=text/text name=text
src=org.apache.cocoon.serialization.TextSerializer
encodingISO-8859-1/encoding
/map:serializer
But it didnt help.
So i tried to set the encoding in my pipeline:
map:match pattern=**.csv
map:generate type=serverpages src={1}.xml/
map:transform src={1}2csv.xsl/
map:serialize type=text
encodingISO-8859-1/encoding
/map:serialize
/map:match
But it didnt help.
The file is alway in UTF-8 encoded.
Where must i change the encoding, so that i get ISO-8859-1 encoded
files?
cu,
Christian
-
Please check that your question has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.html
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
One mircale of cocoon - or - How to use sessionmanagment of cocoon
Hi cocoon-masters,
i have a little problem.
I have modified the protected-example a little bit...added three new
parameters:
My auth.xml:
auth-descriptor
connectiondb-sts-dc/connection
table name=sts_user
select dbcol=pk_Kennung request-param=username
to-session=username/
select dbcol=Passwort request-param=password to-session=password/
select dbcol=fk_Isdh to-session=department_id type=string/
select dbcol=fk_Prodl to-session=prodl/
select dbcol=fk_Isdh to-session=isdh/
/table
/auth-descriptor
Now i have changed my param.xml like this:
parameters-descriptor
parameter name=username type=string nullable=no/
parameter name=password type=string nullable=yes/
parameter name=prodl type=string nullable=yes default=PRODL/
parameter name=isdh type=string nullable=yes default=ISDH/
!-- parameter name=xxxdepartment_id type=string nullable=yes
default=xxx0/ --
!-- parameter name=xxxtheme type=string nullable=yes
default=xxxsimple/ --
/parameters-descriptor
Now i want to get a output of this datas:
I use this .xsp:
page
motd
logininfos
paraLogin: session:get-attribute name=username//para
paraPassword: session:get-attribute name=password/ ... wird spaeter
ausgeblendet/para
paraProdl-Zugriff: (department_id) :::session:get-attribute
name=department_id/:::/para
paraProdl-Zugriff: (prodl) :::session:get-attribute
name=prodl/:::/para
paraIsdh-Zugriff: (isdh) :::session:get-attribute
name=isdh/:::/para
xsp:logic
java.util.List m_Liste=XSPRequestHelper.getSessionAttributeNames(objectModel);
java.util.Iterator i=m_Liste.iterator();
while (i.hasNext())
{
String tmp=(String)i.next();
/xsp:logic
paraxsp:exprtmp/xsp:expr/para
xsp:logic
}
/xsp:logic
/logininfos
Now the miracles begin:
In former days I tryed fill the deparment_id with values of pk_Prodl. And -
as I expected - it worked. But now about 1 week later (i was on vacation),
new login, changed sourcefiles (more then once and - of course - saved),
restarted tomcat over and over again, deparment_id still offers the values of
pk_Prodl freshly distributed out of the database. Even if i delete (not only
commented out in the sourcefiles!) all traces of department_id in all xml,
xsl, xsp files i could find...the html--page always shows the values of
pk_Prodl in the department_id. Whatever i do i cant get ride of this...but
unfortunatly i cant get any other parameters then password, department_id or
username (as you can see i listed all parameters the session knows). After
one day of work, i managed to get ride of theme-parameter...the second
mystical parameter alway containing simple...but do not ask why it suddenly
disapeared.
Only password, as new parameter, work...and again...dont ask why...
So now:
Can someone tell my what i must change, delete or what ever do to access the
parameters i want to read out of my database in my xsp-files while using
authentification offered by cocoon?
cu,
Christian
PS: By the way: Protection (Login, logoff) of all pages works...
--
Schröter, Christian
Siemens Business Services GmbH Co. OHG
SBS D BS ECS 3
Tel.: +49 911 654 2355
Fax: +49 911 654 2108
Mobil: +49 160 97843762
eMail: [EMAIL PROTECTED]
-
Please check that your question has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faqs.html
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Question to the example protected, Error: java.sql.SQLException: No suitable driver
Hi, I want to use this login-function which is offered in the protected-Subdirectory of cocoon. I want to store/read the logininformations in a database. I created a jdbc-connection in the cocoon.xconf File, which i can use successfully with esql in xsp-pages. Now i rewrite the auth.xml like this: auth-descriptor connectiondb-test/connection table name=test_user select dbcol=pk_Kennung request-param=username to-session=username/ select dbcol=fk_woanders to-session=department_id type=long/ /table /auth-descriptor Unfortunatly it do not want to work. In core.logs i get this errormessage: java.sql.SQLException: No suitable driver And then, i am redirected to login. I do not understand why i cant the same connectionpool here as i successfully use in the xsp-pages. Can somebody tell me what i must change, so that it will work? cu, Christian - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Example protected
Hi, i got a cvs snapshoot of cocoon from today (2002-04-26). The i wanted to test the protected example, but i get this errormessage: Type 'wildcard' is not defined for 'match' at file:/home/stsdc/Jakarta/jakarta-tomcat-4.0.1/webapps/cocoon/protected/ sitemap.xmap:43:29 If i replace in the subsitemap map:matchers default=wildcard/ with: map:matchers default=wildcard map:matcher logger=sitemap.matcher.wildcard name=wildcard src=org.apache.cocoon.matching.WildcardURIMatcher/ /map:matchers i get the next error: Type 'file' is not defined for 'generate' at file:/home/stsdc/Jakarta/jakarta-tomcat-4.0.1/webapps/cocoon/protected/ sitemap.xmap:51:45 Well i think that the subsitemap do not inharit the defenitions of its parentsitemap...also if i try to access any other subsite (eg sub/) it also wount work. What do i have to do to change this...beside to add all map:components to every subsitemap...? Cu, Christian -- Schröter, Christian Siemens Business Services GmbH Co. OHG SBS D BS ECS 3 Tel.: +49 911 654 2355 Fax: +49 911 654 2108 Mobil: +49 160 97843762 eMail: [EMAIL PROTECTED] - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
