File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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.
 
 
subject: WAS 6.1 DataSource 5 Char Problem
 
Similar Threads
How can a TextField get focus?
Problem with executeQuery
How to query a value typed object
problem with accessing resultset from multiple tables
How to get a row count