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?
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?
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
4) Could you point me to the code example of chapter 19 that I need to implement or adapt?

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.

__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/