You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Lars Martinsen <la...@syscon.no> on 2002/09/09 12:01:57 UTC
Connecting to MS SQL Server
Does anyone have a step-by-step on how to connect to a MS SQL Server and do
SQL commands on it? I have tried to do it by reading all the help and
how-tos that is bundeled with Cocoon, but I didn't manage.
.lars martinsen
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Connecting to MS SQL Server
Posted by Leszek Gawron <ou...@kompuart.pl>.
On Mon, Sep 09, 2002 at 12:01:57PM +0200, Lars Martinsen wrote:
> Does anyone have a step-by-step on how to connect to a MS SQL Server and do
> SQL commands on it? I have tried to do it by reading all the help and
> how-tos that is bundeled with Cocoon, but I didn't manage.
For my development I'm using two drviers: Izmado (an ADO wrapper from
www.infozoom.de - quite slow for larger queries) and InetOpta
(www.inetsoftware.de)
to install the mssql server datasource:
1. download one of the drivers and put them into cocoon's web-xml/lib directory
( for izmado you also have to copy a .dll file from driver zip file in to %WINDIR%/system32
2. in cocoon's web.xml file preload appropriate driver class:
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For IBM WebSphere:
com.ibm.servlet.classloader.Handler -->
<!-- For Database Driver: -->
org.hsqldb.jdbcDriver
com.inzoom.jdbcado.Driver
com.inet.tds.TdsDriver
<!-- For parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator
-->
</param-value>
</init-param>
3. Add a datasource:
3a. for izmado it is:
<jdbc name="cdn-izmado" logger="core.datasources.cdn-izmado">
<pool-controoller min="1" max="10"/>
<auto-commit>false</auto-commit>
<dburl>jdbc:izmado:Provider=MSDASQL;Driver={Sql Server};Server=OUZO\CDN_OPTIMA;Database=CDN_Full;USER ID=SA;</dburl>
<user>sa</user>
<password></password>
</jdbc>
3b. for opta it is:
<jdbc name="cdn" logger="core.datasources.cdn-opta">
<pool-controoller min="1" max="10"/>
<auto-commit>false</auto-commit>
<dburl>jdbc:inetdae7:localhost:1134?database=CDN_Full&charset=Cp1250</dburl>
<user>sa</user>
<password></password>
</jdbc>
tweak dburl for your needs and it will surely work
I advice to use Inet Opta, but you'll have to pay ( 50 redistributable driver
licenses cost 3200$)
you can get trial versions of both drivers (with time and connection limit)
ouzo
--
__
| / \ | Leszek Gawron // \\
\_\\ //_/ ouzo@vip.net.pl _\\()//_
.'/()\'. Phone: +48(600)341118 / // \\ \
\\ // recursive: adj; see recursive | \__/ |
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Connecting to MS SQL Server
Posted by David LAGARDERE <dl...@yahoo.fr>.
You first have to add your JDBC driver class in
the load-class section of your cocoon web.xml.
After that, add your JDBC source in cocoon.xconf like
the "personnel" datasource example which is given
as an example.
___________________________________________________________
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by Vaskin Kissoyan <vk...@lokion.com>.
Check TOMCAT / CATALINA / APP Server settings: for example:
CATALINA_OPTS=-Dfile.encoding=ISO8859_1
I'm not sure if this over-rides the settings, I would assume the xml
file or more specific config should over-ride, but you might want to
check what your App Server is configured /defaulted to.
J.Pietschmann wrote:
> Wolle wrote:
>
>> as soon as i try to get an output as txt-file (e.g. on a web-browser or
>> saving the content in a file) the german umlaut produced by the ue/oe
>> keys
>> are produced wrong (e.g. ue as A1/4). but all encodings in the xml/xsl
>> file are correct. even the settings of the webbrowser are correct.
>>
>> the aim is to produce a proper text-output for latex.
>>
>> is the text-ouput of cocoon broken?
>>
> No. It is probably outputting UTF-8. I think you can choose the
> output encoding for the text serializer, check the default, and
> try to get the encoding you need (like ISO-8859-1).
>
> J.Pietschmann
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
--
Vaskin Kissoyan
Lokion Interactive
vkissoyan@lokion.com
im (aol or yahoo): vkissoyan
voice: 301-588-0404
fax: 978-926-0515
http://www.lokion.com/
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: xsp:element root element bug?-> solved! Thanks Vadim.
Posted by Sanne de Roever <sa...@newfoundland.nl>.
Hi Vadim,
Thanks, that worked!
A already had an alternate solution using a fake <root>
element which was stripped by an xsl transformation.
This is better though!
Kind regards,
Sanne
----- Original Message -----
From: "Vadim Gritsenko" <va...@verizon.net>
To: <co...@xml.apache.org>
Sent: Thursday, September 12, 2002 4:02 PM
Subject: Re: xsp:element root element bug?
> Sanne de Roever wrote:
>
> >Hi,
> >
> >I've been using the xsp:element, and xsp:attribute tags with succes when
> >creating svg.
> >But now I would like to wrap the root element svg in such a tag, so I can
> >adjust the width and height.
> >The could/should be like this:
> >
> ><?xml version="1.0"?>
> ><xsp:page language="java"
> > xmlns:xsp="http://apache.org/xsp"
> > xmlns:xsp-request="http://apache.org/xsp/request/2.0"
> >
> >
> ><xsp:element name="svg">
> >
>
> Use <svg> here:
>
>
> <svg>
>
> > <xsp:attribute name="width">500</xsp:attribute>
> > <xsp:attribute name="height">500</xsp:attribute>
> > <xsp:element name="path">
> > <xsp:attribute name="fill">none</xsp:attribute>
> > <xsp:attribute name="d">M 100,200 z</xsp:attribute>
> > </xsp:element>
> > <xsp:element name="text">
> > <xsp:attribute name="transform">matrix(1 0 0 1 0 26)</xsp:attribute>
> > Hello world
> > </xsp:element>
> >
> </svg>
>
> ></xsp:page>
> >
>
> Vadim
>
>
>
> >My own svg is more complex, but the bottom line is that using an
xsp:element
> >tag for a root element doesn't work.
> >
> >Could this be a bug?
> >
> >Regards,
> >
> >Sanne
> >
> >
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: xsp:element root element bug?
Posted by Vadim Gritsenko <va...@verizon.net>.
Sanne de Roever wrote:
>Hi,
>
>I've been using the xsp:element, and xsp:attribute tags with succes when
>creating svg.
>But now I would like to wrap the root element svg in such a tag, so I can
>adjust the width and height.
>The could/should be like this:
>
><?xml version="1.0"?>
><xsp:page language="java"
> xmlns:xsp="http://apache.org/xsp"
> xmlns:xsp-request="http://apache.org/xsp/request/2.0"
>
>
><xsp:element name="svg">
>
Use <svg> here:
<svg>
> <xsp:attribute name="width">500</xsp:attribute>
> <xsp:attribute name="height">500</xsp:attribute>
> <xsp:element name="path">
> <xsp:attribute name="fill">none</xsp:attribute>
> <xsp:attribute name="d">M 100,200 z</xsp:attribute>
> </xsp:element>
> <xsp:element name="text">
> <xsp:attribute name="transform">matrix(1 0 0 1 0 26)</xsp:attribute>
> Hello world
> </xsp:element>
>
</svg>
></xsp:page>
>
Vadim
>My own svg is more complex, but the bottom line is that using an xsp:element
>tag for a root element doesn't work.
>
>Could this be a bug?
>
>Regards,
>
>Sanne
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
xsp:element root element bug?
Posted by Sanne de Roever <sa...@newfoundland.nl>.
Hi,
I've been using the xsp:element, and xsp:attribute tags with succes when
creating svg.
But now I would like to wrap the root element svg in such a tag, so I can
adjust the width and height.
The could/should be like this:
<?xml version="1.0"?>
<xsp:page language="java"
xmlns:xsp="http://apache.org/xsp"
xmlns:xsp-request="http://apache.org/xsp/request/2.0"
>
<xsp:element name="svg">
<xsp:attribute name="width">500</xsp:attribute>
<xsp:attribute name="height">500</xsp:attribute>
<xsp:element name="path">
<xsp:attribute name="fill">none</xsp:attribute>
<xsp:attribute name="d">M 100,200 z</xsp:attribute>
</xsp:element>
<xsp:element name="text">
<xsp:attribute name="transform">matrix(1 0 0 1 0 26)</xsp:attribute>
Hello world
</xsp:element>
</xsp:element>
</xsp:page>
My own svg is more complex, but the bottom line is that using an xsp:element
tag for a root element doesn't work.
Could this be a bug?
Regards,
Sanne
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by Vadim Gritsenko <va...@verizon.net>.
Wolle,
I was trying to reproduce your issue but failed. Can you put together
small test case with short XML file, sitemap snippet, actual text
output, and desired text output, and send this as an (zip) attachement?
Thanks,
Vadim
Wolle wrote:
>hi everybody!
>
>thank you very much for the help. but i still have the problem.
>the html and pdf output is ok. as soon as i produce text-output i get
>UTF-8 code although i forced cocoon to produce iso 8859-1 by using:
>
><map:serializer logger="sitemap.serializer.text" mime-type="text/text"
> name="text" src="org.apache.cocoon.serialization.TextSerializer">
> <encoding>iso-8859-1</encoding>
> </map:serializer>
>
>the saved text-file is indeed UTF-8 coded because the unix-command 'file'
>confirms the result.
>
>right now i am using a workaround by reencoding the saved file
>via: 'recode UTF-8 file.txt'
>
>
>i tested for quite a long time. this is a working solution without cocoon
>2.0.3.
>
>maybe there is more luck with cocoon 2.1.
>
>
>wolfgang weigel
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by Wolle <wg...@cip.physik.uni-wuerzburg.de>.
hi everybody!
thank you very much for the help. but i still have the problem.
the html and pdf output is ok. as soon as i produce text-output i get
UTF-8 code although i forced cocoon to produce iso 8859-1 by using:
<map:serializer logger="sitemap.serializer.text" mime-type="text/text"
name="text" src="org.apache.cocoon.serialization.TextSerializer">
<encoding>iso-8859-1</encoding>
</map:serializer>
the saved text-file is indeed UTF-8 coded because the unix-command 'file'
confirms the result.
right now i am using a workaround by reencoding the saved file
via: 'recode UTF-8 file.txt'
i tested for quite a long time. this is a working solution without cocoon
2.0.3.
maybe there is more luck with cocoon 2.1.
wolfgang weigel
*Wolle, please check this. Maybe it can help you ;)
*
*Antonio Gallardo
*
*
*I guess Carsten helped me finding this out first ;-)
*
*So thanks to every guru here :-)
*
*Cocoon rules ;-)
*----- Original Message -----
*From: "Antonio Gallardo Rivera" <ag...@agsoftware.dnsalias.com>
*To: <co...@xml.apache.org>
*Sent: Thursday, August 29, 2002 11:25 AM
*Subject: [SUMMARY] How to encode ISO-8859-1 characters into the Database?
*
*
*Barbara:
*
*Thank you Very much! It works fine now!
*
*Antonio Gallardo
*
**********************************************************************
*SOLUTION by Barbara Post :) :
*go to the sitemap and ensure that XML and HTML serializers have the
*following
*tag:
*
*<encoding>iso-8859-1</encoding>
*
**********************************************************************
*CAUSE by Barbara Post:
*Sitemap overrides XSP/XSL encoding....
*
**********************************************************************
*PROBLEM by me :(
*
*I create the Database now using the following string:
*
*createdb -E LATIN1 -e mydb
*
*Where,
*LATIN1 is the encoding used by the database
*mydb is the name of the database
*
*Now When I wrote: "Ol�"
*When I retrieve the values there are: "Olé"
*
*Also, I used at the beginning of the XSP pages the string:
*
*<?xml version="1.0" encoding="ISO-8859-1"?>
*
*What is wrong?
*
**********************************************************************
*The first request:
*
*PLATAFORM:
*Cocoon 2.0.3
*Tomcat 4.1.9
*PostgreSQL 7.2.1.
*
*PROBLEM:
*
*If I store a string value, like "Ol�" in the Database without using Cocoon.
*I
*retrieve it and see "Ol�". The same string.
*
*With Cocoon:
*I need to store values to the Database like "Ol�". I saw that the Cocoon
*manipulate the data like UTF-8 and not in the code ISO-8859-1. How I can
*change this feature to make Cocoon work in ISO-8859-1 code?
*
*I hope it will help anybody :) And thanks again Barbara :)
*
*Antonio Gallardo
*
*
*
*El Martes, 10 de Septiembre de 2002 04:13, Wolle escribi�:
*> hi!
*>
*> i tried to modify the sitemap.xmap in the following way:
*>
*>
*> <map:serializer logger="sitemap.serializer.text" mime-type="text/text"
*> name="text" src="org.apache.cocoon.serialization.TextSerializer">
*> <encoding>iso-8859-1</encoding>
*> </map:serializer>
*>
*> but the result was negativ. i wasn't able to find some other files for
*> changing the output to text-style. (i used grep for finding the string
*> UTF / iso)
*>
*> does anybody know another hint?
*>
*> wolfgang weigel
*>
*>
*> *Wolle wrote:
*> *> as soon as i try to get an output as txt-file (e.g. on a web-browser or
*> *> saving the content in a file) the german umlaut produced by the ue/oe
*> keys *> are produced wrong (e.g. ue as A1/4). but all encodings in the
*> xml/xsl *> file are correct. even the settings of the webbrowser are
*> correct. *>
*> *> the aim is to produce a proper text-output for latex.
*> *>
*> *> is the text-ouput of cocoon broken?
*> *>
*> *No. It is probably outputting UTF-8. I think you can choose the
*> *output encoding for the text serializer, check the default, and
*> *try to get the encoding you need (like ISO-8859-1).
*> *
*> *J.Pietschmann
*> *
*> *
*> *---------------------------------------------------------------------
*> *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: <co...@xml.apache.org>
*> *For additional commands, e-mail: <co...@xml.apache.org>
*> *
*>
*>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by Antonio Gallardo Rivera <ag...@agsoftware.dnsalias.com>.
Wolle, please check this. Maybe it can help you ;)
Antonio Gallardo
I guess Carsten helped me finding this out first ;-)
So thanks to every guru here :-)
Cocoon rules ;-)
----- Original Message -----
From: "Antonio Gallardo Rivera" <ag...@agsoftware.dnsalias.com>
To: <co...@xml.apache.org>
Sent: Thursday, August 29, 2002 11:25 AM
Subject: [SUMMARY] How to encode ISO-8859-1 characters into the Database?
Barbara:
Thank you Very much! It works fine now!
Antonio Gallardo
*********************************************************************
SOLUTION by Barbara Post :) :
go to the sitemap and ensure that XML and HTML serializers have the
following
tag:
<encoding>iso-8859-1</encoding>
*********************************************************************
CAUSE by Barbara Post:
Sitemap overrides XSP/XSL encoding....
*********************************************************************
PROBLEM by me :(
I create the Database now using the following string:
createdb -E LATIN1 -e mydb
Where,
LATIN1 is the encoding used by the database
mydb is the name of the database
Now When I wrote: "Olé"
When I retrieve the values there are: "Olé"
Also, I used at the beginning of the XSP pages the string:
<?xml version="1.0" encoding="ISO-8859-1"?>
What is wrong?
*********************************************************************
The first request:
PLATAFORM:
Cocoon 2.0.3
Tomcat 4.1.9
PostgreSQL 7.2.1.
PROBLEM:
If I store a string value, like "Olé" in the Database without using Cocoon.
I
retrieve it and see "Olé". The same string.
With Cocoon:
I need to store values to the Database like "Olé". I saw that the Cocoon
manipulate the data like UTF-8 and not in the code ISO-8859-1. How I can
change this feature to make Cocoon work in ISO-8859-1 code?
I hope it will help anybody :) And thanks again Barbara :)
Antonio Gallardo
El Martes, 10 de Septiembre de 2002 04:13, Wolle escribió:
> hi!
>
> i tried to modify the sitemap.xmap in the following way:
>
>
> <map:serializer logger="sitemap.serializer.text" mime-type="text/text"
> name="text" src="org.apache.cocoon.serialization.TextSerializer">
> <encoding>iso-8859-1</encoding>
> </map:serializer>
>
> but the result was negativ. i wasn't able to find some other files for
> changing the output to text-style. (i used grep for finding the string
> UTF / iso)
>
> does anybody know another hint?
>
> wolfgang weigel
>
>
> *Wolle wrote:
> *> as soon as i try to get an output as txt-file (e.g. on a web-browser or
> *> saving the content in a file) the german umlaut produced by the ue/oe
> keys *> are produced wrong (e.g. ue as A1/4). but all encodings in the
> xml/xsl *> file are correct. even the settings of the webbrowser are
> correct. *>
> *> the aim is to produce a proper text-output for latex.
> *>
> *> is the text-ouput of cocoon broken?
> *>
> *No. It is probably outputting UTF-8. I think you can choose the
> *output encoding for the text serializer, check the default, and
> *try to get the encoding you need (like ISO-8859-1).
> *
> *J.Pietschmann
> *
> *
> *---------------------------------------------------------------------
> *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: <co...@xml.apache.org>
> *For additional commands, e-mail: <co...@xml.apache.org>
> *
>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by Wolle <wg...@cip.physik.uni-wuerzburg.de>.
hi!
i tried to modify the sitemap.xmap in the following way:
<map:serializer logger="sitemap.serializer.text" mime-type="text/text"
name="text" src="org.apache.cocoon.serialization.TextSerializer">
<encoding>iso-8859-1</encoding>
</map:serializer>
but the result was negativ. i wasn't able to find some other files for
changing the output to text-style. (i used grep for finding the string
UTF / iso)
does anybody know another hint?
wolfgang weigel
*Wolle wrote:
*> as soon as i try to get an output as txt-file (e.g. on a web-browser or
*> saving the content in a file) the german umlaut produced by the ue/oe keys
*> are produced wrong (e.g. ue as A1/4). but all encodings in the xml/xsl
*> file are correct. even the settings of the webbrowser are correct.
*>
*> the aim is to produce a proper text-output for latex.
*>
*> is the text-ouput of cocoon broken?
*>
*No. It is probably outputting UTF-8. I think you can choose the
*output encoding for the text serializer, check the default, and
*try to get the encoding you need (like ISO-8859-1).
*
*J.Pietschmann
*
*
*---------------------------------------------------------------------
*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: <co...@xml.apache.org>
*For additional commands, e-mail: <co...@xml.apache.org>
*
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by "J.Pietschmann" <j3...@yahoo.de>.
Wolle wrote:
> as soon as i try to get an output as txt-file (e.g. on a web-browser or
> saving the content in a file) the german umlaut produced by the ue/oe keys
> are produced wrong (e.g. ue as A1/4). but all encodings in the xml/xsl
> file are correct. even the settings of the webbrowser are correct.
>
> the aim is to produce a proper text-output for latex.
>
> is the text-ouput of cocoon broken?
>
No. It is probably outputting UTF-8. I think you can choose the
output encoding for the text serializer, check the default, and
try to get the encoding you need (like ISO-8859-1).
J.Pietschmann
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by Wolle <wg...@cip.physik.uni-wuerzburg.de>.
hi!
thanks for the many suggestions.
i tried the following solution:
*
*4. Use a proper encoding declaration which matches the actual
* encoding of the file. For example, most platforms setup for
* a german language environment use ISO-8859-1, and usually
* editors use this as the default encoding. Placing
* <?xml version="1.0" encodign="ISO-8859-1"?>
* at the beginning of each XML file (XSLT is XML too) allows you
* to use native encoded umlauts.
this works great producing pdf.
but i still have a problem:
as soon as i try to get an output as txt-file (e.g. on a web-browser or
saving the content in a file) the german umlaut produced by the ue/oe keys
are produced wrong (e.g. ue as A1/4). but all encodings in the xml/xsl
file are correct. even the settings of the webbrowser are correct.
the aim is to produce a proper text-output for latex.
is the text-ouput of cocoon broken?
bye
wolfgang weigel
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: german umlaut!
Posted by "J.Pietschmann" <j3...@yahoo.de>.
Wolle wrote:
> has anybody a proper solution for involving german umlaute in a
> cocoon-framework?
You can read the XML spec for some hints, or check some other
publishing systems, like DocBook.
> i have some ideas like
>
> 1. writing the umlauts in unicode (so creating a pdf via fop will cause
> no problems)
> 2. writing them in tex-style like "u or "o an exchange them later in
> every xsl-file
> 3. using extra-markups like <uml></uml>
4. Use a proper encoding declaration which matches the actual
encoding of the file. For example, most platforms setup for
a german language environment use ISO-8859-1, and usually
editors use this as the default encoding. Placing
<?xml version="1.0" encodign="ISO-8859-1"?>
at the beginning of each XML file (XSLT is XML too) allows you
to use native encoded umlauts.
5. Use numerical character references, for example ” for ö.
You can place any unicode character in any XML file which has
an encoding which is a superset of ASCII.
The Unicode consortium has convenient tables for lookin up
characters online at
http://www.unicode.org/charts/charindex.html
6. Get a DTD with entity definitions for some characters, like
a stripped down DocBook, or the HTML definitions (from
http://www.w3.org/TR/html401/sgml/entities.html)
and use the aliases defined there, for example ö for ö.
J.Pietschmann
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
german umlaut!
Posted by Wolle <wg...@cip.physik.uni-wuerzburg.de>.
hi cocooners!
has anybody a proper solution for involving german umlaute in a
cocoon-framework?
i have some ideas like
1. writing the umlauts in unicode (so creating a pdf via fop will cause
no problems)
2. writing them in tex-style like "u or "o an exchange them later in
every xsl-file
3. using extra-markups like <uml></uml>
i don't know. are there any solutions which had been tested already?
does anybody know a comfortable solution?
Auf bald
Wolfgang Weigel
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: Connecting to MS SQL Server
Posted by Christopher Watson <c....@zen.co.uk>.
Lars
Assuming you're using the Microsoft 2000 JDBC driver,
1 Copy the three libraries from the unpacked distribution
msbase.jar
mssqlserver.jar
msutil.jar
to WEB-INF/lib
2 Add com.microsoft.jdbc.sqlserver.SQLServerDriver
to init-param in WEB-INF/web.xml, ending up with someting like ...
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For MySQL Driver: -->
<!-- org.gjt.mm.mysql.Driver replaced by -->
com.mysql.jdbc.Driver
<!-- For mssql2000 Driver: -->
com.microsoft.jdbc.sqlserver.SQLServerDriver
<!-- For parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator
-->
</param-value>
</init-param>
3 Declare the datasource in cocoon.xconf, thus
<jdbc name="mypool">
<pool-controller min="5" max="10"/>
<dburl>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb</dburl>
<user>myuser</user>
<password>mypassword</password>
</jdbc>
By the way, as far as I can gather, you CAN'T use windows authentication
with the JDBC driver,
so you must set the server to use mixed security. That might cause your
sysadmin to flutter!
Now you can use mypool as a pooled connection name, e.g. in esql as
<esql:pool>mypool</esql:pool>
As for what you can do with esql, that's another story !
Christopher
> -----Original Message-----
> From: Lars Martinsen [mailto:lars.martinsen@syscon.no]
> Sent: 09 September 2002 11:02
> To: 'cocoon-users@xml.apache.org'
> Subject: Connecting to MS SQL Server
>
>
> Does anyone have a step-by-step on how to connect to a MS SQL
> Server and do
> SQL commands on it? I have tried to do it by reading all the help and
> how-tos that is bundeled with Cocoon, but I didn't manage.
>
> .lars martinsen
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: Connecting to MS SQL Server
Posted by Upayavira <uv...@upaya.co.uk>.
Lars,
SQL Server 7 or 2000? To use SQL Server 7 you'll need to purchase a JDBC driver, as
there are no free ones that I'm aware of. If you're using SQL Server 2000, then there is a
JDBC driver supplied by Microsoft, that you can use. Once you've got your JDBC driver
set up, getting it to work with Cocoon will be the same as connecting to any other
database.
[note - haven't actually done the above, so I can't give you a more indepth howto].
Regards, Upayavira
> Does anyone have a step-by-step on how to connect to a MS SQL Server and do
> SQL commands on it? I have tried to do it by reading all the help and
> how-tos that is bundeled with Cocoon, but I didn't manage.
>
> .lars martinsen
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>