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
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 &.

--
William L. Thomson Jr.