File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "WAS 6.1 DataSource 5 Char Problem" Watch "WAS 6.1 DataSource 5 Char Problem" New topic

WAS 6.1 DataSource 5 Char Problem

Martin Lerchster

Joined: Nov 29, 2004
Posts: 10

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:

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:
subject: WAS 6.1 DataSource 5 Char Problem
It's not a secret anymore!