On 2002.09.30 04:55:26 -0400 fredlaub@... wrote:

> Environment:
>
> Tomcat(without JNDI) + Struts 1.1 + Firebird 1.0 on Linux Redhat 7.3 and
> W2000 SP2.
>
> I have following requirements:
>
> - Use of n connection pools (at least 2).
> - Those connection pools are specific to only one web-application.
> (=> the time-out parameter is different for each pool)
> - Each pool connects to the database with different usernames/passwords.
> (the programs will select the connection pool from which get the
> connection will be retrieved).
> - Unicode encoding and autocommit false for all connections.
>
> I read the release notes and I need some clarifications/advice.
>
> 1) Can I achieve what I need with JBird?

yes

> 2) As written in chapter 11, I need to get a connection directly from
> java.sql.DriverManager using the FBDriver.class => does that mean I can't
> use FBWrapingDataSource and the built-in connection pooling?

You can use FBWrappingDataSource. Without JNDI you will have to come up
with some other way for your apps to locate the datasources and some other
way to set them up.

> 3) Can't I write the following every time I get a connection:
> c.setAutocommit(false)
> and set the encoding to lc_ctype=UNICODE_FSS

Yes. You can set the lc_ctype on the datasource I think, but you will have
to set Autocommit each time you get a connection, since it is reset when
the connection is re-pooled.

> 4) Could you point me to the code example of chapter 19 that I need to
> implement or adapt?

The datasource example might be helpful, but it won't show you how to find
your datasources.

david jencks

>
> Your help will be appreciated.
> Frederic
>
> PS I can't find nor retrieve the response message to my mail of 26 Sept
> with subject:
> UNICODE_FSS as default charset ?
> Has this message been deleted from the newsgroup? I looked for a problem
> in my newgroup reader set-up and everything seems ok.

I don't know about the newsgroup.

>