Subject Re: Pools and Tomcat Data Sources
Author Roman Rokytskyy
> But what about character sets?
> cri.setProperty( ISCConstants.isc_dpb_lc_ctype, charset ); ??

it is called "encoding", see Wiki.

> But there is no setMaxPoolSize(), there is only setMaxConnections().
> So there is no way to use the correct ones now, right?

They are already in CVS, you can build a post-RC3 version. Or wait for
RC4.

> I have seen this before, but there are two major informatios
> missing:
> - How to get this inside my Servlet?

The same way you get other JDBC connections into your servlet, check
Tomcat examples, but I suspect it would be like this:

import javax.naming.*;

....

InitialContext ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/dbTest");
Connection connection = ds.getConnection();
try {
...
} finally {
connection.close();
}

> - How can I set any property? exspecially encoding and dialect.

Encoding - the same way as other properties:

<parameter>
<name>encoding</name>
<value>ISO8859-1</value>
</parameter>

Setting non-standard properties is not yet published on the Wiki:

<parameter>
<name>nonStandardProperty</name>
<value>sql_dialect=3</value>
</parameter>

Roman