connection parameters

[Kris Barnhoorn]

Hi,

I was wondering if this is the correct way to add extra parameters to
the connection?


        <transactionManager type="JDBC">
                <dataSource type="DBCP">
                        <property name="JDBC.Driver" value="${driver}"
/>
                        <property name="JDBC.ConnectionURL"
value="${url}?characterEncoding=iso-8859-1;autoReconnect=true;useUnicode
=true" />
                        <property name="JDBC.Username"
value="${username}" />
                        <property name="JDBC.Password"
value="${password}" />
                        <property name="JDBC.DefaultAutoCommit"
value="false" />
                        <!-- The following are optional -->
                        <property name="Pool.MaximumActiveConnections"
value="10" />
                        <property name="Pool.MaximumIdleConnections"
value="5" />
                        <property name="Pool.MaximumWait" value="60000"
/>
                        <!-- Use of the validation query can be
problematic. If you have difficulty, try without it. -->
                        <property name="Pool.ValidationQuery"
                                value="select 1 from users" />
                        <property name="Pool.LogAbandoned" value="false"
/>
                        <property name="Pool.RemoveAbandoned"
value="false" />
                        <property name="Pool.RemoveAbandonedTimeout"
value="50000" />
                </dataSource>
        </transactionManager>

Code Works, but I have special characters to question marks issues....

Thanks.
Kris.