WAS 6.1 DataSource 5 Char Problem

[Martin Lerchster]

Hi.

I have the following Problem with my Result i'm getting from the database.

I'm using WAS 6.1 a V5 DataSource from it, on the other end i have a Oracle 10g Database.

The Problem is that i'm executing a Query on a Table with a CHAR(20) column.

The Result of the Query if i execute it on a DB-Cleint looks: 'R'

In my SourceCode after executing the Query i get a String: 'R '.
So the complete length of the CHAR-Column is filled up with blanks.

I think this is done by the ResultSetProxy, the class which is used bye the DataSource is:
com.ibm.ws.rsadapter.jdbc.WSJdbcResultSet

The Problem occured on changing the DataSources from Version 4 to Version 5


If anybody have an idea how i can get solve this Problem without any Trims, thanks in advance.