aspose file tools*
The moose likes JDBC and the fly likes WAS 6.1 DataSource 5 Char Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "WAS 6.1 DataSource 5 Char Problem" Watch "WAS 6.1 DataSource 5 Char Problem" New topic
Author

WAS 6.1 DataSource 5 Char Problem

Martin Lerchster
Greenhorn

Joined: Nov 29, 2004
Posts: 10
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: WAS 6.1 DataSource 5 Char Problem