On 21-2-2017 01:09, 'William L. Thomson Jr.' wlt-ml@...
[Firebird-Java] wrote:

> On Monday, February 20, 2017 5:20:06 PM EST 'William L. Thomson Jr.' wlt-ml@o-
> sinc.com [Firebird-Java] wrote:
>>
>> Then when in a container, charSet becomes a value in the connection
>> properties, not in jdbc url like previous.
>>
>> Commons DBCP example
>>
>> <Resource auth="Container"
>> driverClassName="org.firebirdsql.jdbc.FBDriver"
>> factory="org.apache.commons.dbcp2.BasicDataSourceFactory"
>> logAbandoned="true"
>> maxTotal="5"
>> maxIdle="5"
>> name="jdbc/my_res"
>> charSet="ISO-8859-1"
>> username="username"
>> password="password"
>> url="jdbc:firebirdsql:my.domain.com/3050:/path/to/data.fdb?
>> lc_ctype=NONE" />
>
> Correction on this one charSet is incorrect, that should be
>
> connectionProperties="lc_ctype=NONE;"
> Or
> connectionProperties="charSet=ISO-8859-1;
> Or

or
connectionProperties="lc_ctype=NONE;charSet=ISO-8859-1;"

> url="jdbc:firebirdsql:my.domain.com/3050:/path/to/data.fdb?lc_ctype=NONE"
>
>
> charSet cannot be put in the URL or you get errors. Maybe the format ; vs &.

Yes it can, but you are using an XML configuration file, which means
that you need to XML escape the & to &:

url="jdbc:firebirdsql:my.domain.com/3050:/path/to/data.fdb?lc_ctype=NONE&charSet=ISO-8859-1"

Or just use the alternative semi-colon separator:

url="jdbc:firebirdsql:my.domain.com/3050:/path/to/data.fdb?lc_ctype=NONE;charSet=ISO-8859-1"


--
Mark Rotteveel