You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by Miroslav Nachev <mi...@space-comm.com> on 2006/11/08 14:03:03 UTC
How to pass more parameters to DbURL ?
Hi,
I would like the used database to support Unicode. That's why I need to
add more parameters like that:
<dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
Unfortunately I have the following error when I add these extra parameters:
org.xml.sax.SAXParseException: The reference to entity "useUnicode"
must end with the ';' delimiter.
How can I put more parameters to JDBC Driver?
Regards,
Miro.
Re: How to pass more parameters to DbURL ?
Posted by Stefano Bagnara <ap...@bago.org>.
Bernd Fondermann wrote:
> Stefano, I think we should start to use pessimistic locking when
> replying to user to avoid inconsistencies :-))
>
> Bernd
LOL, I was just thinking the same thing!
And Norman is not around, otherwise we could have 3 replies per question
Stefano
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: How to pass more parameters to DbURL ?
Posted by Norman Maurer <nm...@byteaction.de>.
Stefano Bagnara schrieb:
> Bernd Fondermann wrote:
>> Stefano, I think we should start to use pessimistic locking when
>> replying to user to avoid inconsistencies :-))
>>
>> Bernd
>
> LOL, I was just thinking the same thing!
> And Norman is not around, otherwise we could have 3 replies per question
>
> Stefano
Tomorrow im back.. so maybe we can get it managed tomorrow :-P
bye
Norman
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: How to pass more parameters to DbURL ?
Posted by Bernd Fondermann <be...@googlemail.com>.
Stefano, I think we should start to use pessimistic locking when
replying to user to avoid inconsistencies :-))
Bernd
On 11/8/06, Stefano Bagnara <ap...@bago.org> wrote:
> First of all please use the server-user list for similar questions.
>
> Then try with:
> <dburl><![CDATA[jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8]]></dburl>
> or
> <dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
>
> Stefano
>
> Miroslav Nachev wrote:
> > Hi,
> >
> > I would like the used database to support Unicode. That's why I need to
> > add more parameters like that:
> >
> >
> > <dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
> >
> >
> > Unfortunately I have the following error when I add these extra parameters:
> > org.xml.sax.SAXParseException: The reference to entity "useUnicode"
> > must end with the ';' delimiter.
> >
> > How can I put more parameters to JDBC Driver?
> >
> >
> > Regards,
> > Miro.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: How to pass more parameters to DbURL ?
Posted by Miroslav Nachev <mi...@space-comm.com>.
Hi,
Thank you. Both variants works.
Regards,
Miro.
Stefano Bagnara wrote:
> First of all please use the server-user list for similar questions.
>
> Then try with:
> <dburl><![CDATA[jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8]]></dburl>
>
> or
> <dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
>
>
> Stefano
>
> Miroslav Nachev wrote:
>> Hi,
>>
>> I would like the used database to support Unicode. That's why I need
>> to add more parameters like that:
>>
>>
>> <dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
>>
>>
>> Unfortunately I have the following error when I add these extra
>> parameters:
>> org.xml.sax.SAXParseException: The reference to entity "useUnicode"
>> must end with the ';' delimiter.
>>
>> How can I put more parameters to JDBC Driver?
>>
>>
>> Regards,
>> Miro.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
>
Re: How to pass more parameters to DbURL ?
Posted by Stefano Bagnara <ap...@bago.org>.
First of all please use the server-user list for similar questions.
Then try with:
<dburl><![CDATA[jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8]]></dburl>
or
<dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
Stefano
Miroslav Nachev wrote:
> Hi,
>
> I would like the used database to support Unicode. That's why I need to
> add more parameters like that:
>
>
> <dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
>
>
> Unfortunately I have the following error when I add these extra parameters:
> org.xml.sax.SAXParseException: The reference to entity "useUnicode"
> must end with the ';' delimiter.
>
> How can I put more parameters to JDBC Driver?
>
>
> Regards,
> Miro.
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: How to pass more parameters to DbURL ?
Posted by Bernd Fondermann <be...@googlemail.com>.
I think "&" is interpreted by the XML parser as the start of an XML
entity reference, like " is one, and &unicode; would be one, if
defined.
Please try to escape "&" to "&".
If this doesn't help, I am lost.
Bernd
On 11/8/06, Miroslav Nachev <mi...@space-comm.com> wrote:
> Hi,
>
> I would like the used database to support Unicode. That's why I need to
> add more parameters like that:
>
>
> <dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
>
> Unfortunately I have the following error when I add these extra parameters:
> org.xml.sax.SAXParseException: The reference to entity "useUnicode"
> must end with the ';' delimiter.
>
> How can I put more parameters to JDBC Driver?
>
>
> Regards,
> Miro.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: How to pass more parameters to DbURL ?
Posted by Norman Maurer <nm...@byteaction.de>.
What about to add this to wiki or better to FAQ ?
bye
Norman
Bernd Fondermann schrieb:
> I think "&" is interpreted by the XML parser as the start of an XML
> entity reference, like " is one, and &unicode; would be one, if
> defined.
> Please try to escape "&" to "&".
>
> If this doesn't help, I am lost.
>
> Bernd
>
> On 11/8/06, Miroslav Nachev <mi...@space-comm.com> wrote:
>> Hi,
>>
>> I would like the used database to support Unicode. That's why I need to
>> add more parameters like that:
>>
>>
>> <dburl>jdbc:mysql://127.0.0.1/jafax?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8</dburl>
>>
>>
>> Unfortunately I have the following error when I add these extra
>> parameters:
>> org.xml.sax.SAXParseException: The reference to entity "useUnicode"
>> must end with the ';' delimiter.
>>
>> How can I put more parameters to JDBC Driver?
>>
>>
>> Regards,
>> Miro.
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-dev-help@james.apache.org
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
> !EXCUBATOR:1,4551ddda53077358147113!
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org