Rick,

Please explain some details. Where should I provide data source ? Now I
have <resource> in context.xml and <resource-ref>
in web.xml? Did you mean another layout? The short example would be
great. :-)

Thank you for your patience

Andrew

Rick Fincher wrote:

>Hi Andrew,
>
>One possibility is to set up firebirdsql as a named data source independent
>of your web app and put the data source info in your WEB-INF/web.xml for
>your app to use.
>
>This also has the advantage that you can move, rename, or otherwise change
>your database and you don't have to change your web app. You just update
>Tomcat's server.xml file and restart the app.
>
>If you do it that way, you can also use the DBCP pooling mechanism to pool
>your connections and improve performance.
>
>The parameters to your data sources don't change very often but applications
>usually change quite frequently, so separating data sources and apps makes
>sense.
>
>Rick
>----- Original Message -----
>
>
>
>>Hi all,
>>
>>As I know FB database connection parameters accepted only if specified
>>right in resource URL. The parameters must be separated by '&'
>>symbol. That symbol causes xml parser error and should be replaced by
>>'&', like below:
>>
>> <parameter>
>> <name>url</name>
>>
>>
>>
>>
><value>jdbc:firebirdsql:127.0.0.1/3050:/data/db?lc_ctype=WIN1251&sql_rol
>e_name=robot</value>
>
>
>> </parameter>
>>
>>It works fine till I want deploy my application using Tomcat manager.
>>The deployment works fine, but when Tomcat manager inserts context of
>>the application into server.xml, it translates '&' to '&' again.
>>That is why Tomcat fails at next start.
>>
>>How to work it around? I'd like to provide parameters as a normal
>><parameter></parameter>, but it does not work.
>>
>>Thanks ahead.
>>
>>Andrew
>>
>>