Subject Re: [Firebird-Java] urgend charset problem
Author Roman Rokytskyy
> I have a database with all "ISO8859_1" encoding. I use servlets to
> access these data. That all worked fine until two days ago.
> However, since I deployed jaybird 1.5.2/3, I get lots of "?" instead
> of german characters.

Should not happen... Is there a chance to get your web application together
with a database for analysis? If needed, I can sign an NDA that the code
will be used only for this purpose.

> I use the following to set the connection pool up:

> dataSource = new FBWrappingDataSource();
> dataSource.setDatabase( file );
> dataSource.setUserName( user );
> dataSource.setPassword( password );
> dataSource.setIdleTimeout( idleTimeout * 60 * 1000 );
> dataSource.setPooling( pooling );
> dataSource.setMinConnections( minSize );
> dataSource.setMaxConnections( maxSize );
> dataSource.setLoginTimeout( loginTimeout );
> dataSource.setNonStandardProperty( "sql_dialect",
> Integer.toString( dialect ) );
> dataSource.setEncoding( charset );

Try also adding

dataSource.setCharSet("ISO-8859-1");

> Is there something I am missing?

There was a change in 1.5.2 that allows specifying both "encoding" and
"charSet" properties, but the previous code should work without problems.

> By the way, some of these calls generate deprecated warnings. What
> are their replacements?

setMaxConnections -> setMaxPoolSize
setMinConnections -> setMinPoolSize

New names are simply JDBC specs conformant.

Roman