I'm using Tomcat 5.0, Java 1.4 and Interbase 6.0




My problem is that I would like to use the connection pooling and
need
to use javax.sql.DataSource. If I use a Driver.connection I can set
the character set in a Properties unit. My database uses win1252
encoding and I need to open a connection using the same encoding
othervise I can't INSERT any data.




How can I open a connection using the DataSource JDBC method AND
supply the correct character set?? I have been struggling with this
problem now for 3 days and learned a lot in the process but this
still
is a mystery.




ANY help would be appreciated.




Mats